LiveCareer-Resume

Programmer Analyst Senior Staff resume example with 19+ years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 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

ERP: Oracle E-Business Suite

Databases: Oracle 10g/11g/12, SQL Server, MYSQL, Netezza, Snowflake

Languages: SQL, PL/SQL, Python, VB 6.0

Data modelling tools: Erwin 7.2

Tools: TOAD 10.x/12.5, SQL Developer 3.x, Tibco Data Virtualization, Aginity Workbench

Work History
11/2008 to Current
Programmer Analyst Senior Staff Microstrategy Burlington, MA,

Programmer Analyst, Sr. Staff Nov’2017 – Present

Programmer Analyst, Staff Nov’2012 – Oct’2017

Programmer Analyst, Sr Nov’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
05/2007 to 10/2008
Senior BI Consultant Livongo 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 Engineer Sofi 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 Engineer Tulsient 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:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

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.

Resume Overview

School Attended

  • Andhra University

Job Titles Held:

  • Programmer Analyst Senior Staff
  • Senior BI Consultant
  • Senior Software Engineer
  • Software Engineer

Degrees

  • Bachelor of Engineering

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: