Programmer Analyst Senior Staff Resume Example

Programmer Analyst, Sr. StaffNov'2017 – Present

Programmer Analyst, StaffNov'2012 – Oct'2017

Programmer Analyst, SrNov'2008 – Oct'2012

Role: BI Delivery Owner/Lead

• 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