Programmer Analyst Senior Staff resume example with 19+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Professional Summary
Business Intelligence and Analytics Leader with 19 years of experience in developing and leading global technical teams and solving complex business problems with hands on experience in latest BI tools
Directly managed a cross functional global team and implemented enterprise business analytics to drive decision making through actionable insights in key business areas like Supply Chain, Finance, Sales Operations and Quality
Managed the organizational transition of the team from high cost region to low cost region without impacting the Business Service Level Agreements
Extensive data architecture experience for multi-terabyte data warehouse and data marts, DB design, performance tuning and Master Data Management
Experienced in Implementation of Full Development Lifecycle of Business Intelligence projects from Gathering Requirements to Design, Implementation, Testing and Support
Expertise utilizing ETL and Business Intelligence tools, Including Informatica Power Center, Informatica Cloud, QlikView, Tableau and Business Objects
Well versed with Qualcomm’s Semiconductor Manufacturing, Sales Operations, Supply Chain Management, Logistics, Procurement, Order Management, Finance and Quality business domains
Supervised and Orchestrated a team of 20 BI developers (including onsite & offshore) as well as hired and coached team members
Effectively led a 3-member San Diego based team by setting up goals, collecting third party feedback, providing career development, assessing performance, delivering annual performance reviews, and awarding merit and stock bonuses
Have strong Analytical, Problem Solving, Presentation, Mentoring, Interpersonal and Technical skills
Applied strong leadership talents and problem-solving skills to maintain team efficiency to meet any daily demand
Skills
Reporting Tools: QlikView 9/10/11/12, Tableau 9.x/2018.x,2019.3, SAP Business Objects 5.x/6.x/XI/3.x, 4.x, OBIEE 11.x/12c
ETL Tools: Informatica Power Center 5.x/6.x/8.x/, 9.x,10.4, Informatica Cloud
Managed and delivered end to end Business Intelligence projects in Qualcomm’s complex Supply Chain Management, Sales Operations and Finance verticals
Collaborated and Led the global teams in delivering Qualcomm’s Road Map projects in various verticals
Managed all aspects of projects including communications, team assignments, schedule planning, budget and risk management and reporting to project sponsors
Led sprint planning, reviews and retrospectives for successful delivery of the projects
Developed and maintained relationships with various QCT Business Leads and other OneIT partners
Delivered numerous complex and high Business Value projects such as
Qualcomm 5G Modules Manufacturing initiative, Control Tower, Supplier Material Visibility Metrics with AWS
Evaluated various cloud data warehouse solutions and implemented Snowflake data warehouse using Informatica Cloud
Apple Customer360 Dashboards for Sales Ops Executives
Average Unit Manufacturing Cost (AUMC) for QCT Finance
QCT Direct Spend Analytics, Supply Demand Analytics, Material In-transit reporting for QCT Supply Chain and Operations
Daily Demand waterfall, Customer Shipment/Backlog metrics and Forecast Preview Dashboard for QCT Sales Operations
Validation Metrics for QCT Master Data Management
Lot genealogy Model to track through Product Life Cycle from Wafer to Product Shipping for QCT Manufacturing
QCT capacity decision analytics solution, allowed business to re-balance across suppliers, analyze impacts and reroute supply; thereby reducing weekly planning cycle by 3 days and increasing capacity by approximately 20%
Role: Technical Architect/Solution Architect
Architected and managed the QCT Business Intelligence Team’s transition to new generation analytics of Qlikview and Tableau
Instrumental in enabling QCT Business with Self Service reporting capabilities using Tableau
Led the team in implementing high performance data base solutions such as Netezza and Snowflake Cloud data warehouse in QCT
Designed the integrated RF360 data from SAP ecosystem into Qualcomm’s Business Intelligence architecture
Subject Matter Expert for all QCT BI initiatives across Supply Chain Management, Sales Operations, Manufacturing, Finance and Quality Verticals
Developed efficient Data Warehouse Dimensional Models using standards and best practices
Worked effectively with cross-functional leads to create BI solutions for operational efficiencies and effective decision making
Role: ETL Developer
Analyzed Business Requirements, Performed Source System Analysis, Prepared Technical Design Document and Source to Target Data Mapping Document
Developed ETL Informatica Mappings using various transformations for populating the target tables in the data warehouse
Experienced in writing complex SQL queries, PL/SQL programs like functions and stored procedures
Extracted Data from Various Sources such as Oracle EBS, Rapid Response, Demantra, flat files and transferred data to the target Oracle Data Warehouse using Informatica ETL tool
Implemented Slowly Changing Dimensions (SCD Type-1 and SCD Type-2) as per the Business Requirements to capture the changes while maintaining the historic information
Developed several PL/SQL stored procedures, functions and database triggers
Used Informatica debugging techniques to debug the Mappings and used session log to trace the errors while loading the data into the Date Warehouse
Involved in troubleshooting Performance Issues in the Mappings and Optimized performance by tuning the Informatica Mappings
Defined Target Load Order Plan for loading data into different target tables
Developed the Unit and Integration test cases and executed in HP Quality Center
Provided the necessary post deployment support in production
Role: Report Developer
Involved in all the Phases of SDLC Including Requirements gathering, Analysis of the functional specifications, Development, Testing and Maintenance of the Applications
Developed several QlikView and Tableau Dashboards for various business users such as Supply Chain Management, Sales Operations, Manufacturing and Finance
Implemented the QlikView 3-tier architecture (Data Extract, Data Transform, Data model & Application) to develop various dashboards
Developed self-service Tableau data sources and dashboards for the users to be able to build their own ad-hoc reports
Developed several waterfall, comparative analysis and cycle time reports in Qlikview and Tableau
Extensively used Set Analysis and several aggregate functions available in QlikView to achieve the complex calculations to satisfy the business needs
Experience in implementing the data level security using Section Access and Db Objects
Experience in performance tuning the Tableau Data Sources and Qlik dashboards
Provided Production Support for Tableau/Qlik applications and conducted several workshops for business users to teach how to use the individual dashboards
Configured Row Level Security and Object Level Security as per the business requirement
05/2007 to 10/2008
Senior BI ConsultantLivongo Health, Inc. – Washington, DC,
Role: Business Intelligence Developer
Worked as Consultant for QCT Business Intelligence team
Designed and developed multiple complex Business Objects Universes and Web Intelligence reports in Quality and Procurement space
Designed and developed multiple Informatica Mappings/Sessions/workflows in Quality, Procurement and Master Data space
Created high level and low-level Technical specifications for Informatica and Business Objects Universes/Reports
Built Data Models in CA Erwin and developed various database objects using SQL/PLSQL
Scheduled the Data Loads through Control M Scheduler
Created and executed Unit and Integration Test Data & Test cases
12/2003 to 04/2007
Senior Software EngineerSofi – Sf, Wa,
Role: Senior Sotware Engineer
Worked for multiple clients in Insurance Domain
Involved in the full cycle of gathering requirements, defining, designing, developing, testing and deploying the application
Instrumental in converting 1800 BRIO reports to Business Objects for Xchanging Ins-Sure, UK
Acted as Team Leader for the Report Development in multiple projects, supervising the design and implementing the standards and best practices
Started as a developer and progressed to team leader within a year
Designed and developed multiple Business Objects Universes, Desktop Intelligence Reports and Web Intelligence reports in Insurance and Fleet Management for GE Fleet Services, MN
Designed and developed multiple Informatica Mappings/Sessions/workflows in Fleet Management space for GE Fleet Services, MN
Creation of the Unit and Integration Test Cases
05/2001 to 11/2003
Software EngineerTulsient Technologies Pvt Ltd – City, STATE,
Role: Software Engineer
Responsibilities:
Involved in designing and coding of Visual Basic functions and forms for Mail Order Management solution catered to Direct Marketing Industry. Modules include Business Strategy Systems, Customer Care, Sales Force Automation and Supply Chain Management
Involved in Unit & Process testing during the development phase
Generation of Reports for Business Strategy System, Customer care Module as per the client’s requirements using Seagate Crystal Reports
Continuous coordination with the On - site team during the Implementation phase of the Project
Education
Expected in 05/1999
Bachelor of Engineering: Mechanical Engineering Andhra University - Visakhapatnam, India, GPA:
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.