SUMMARY:

• 20+ years of experience in Business Intelligence Solution Design and Development.
• 18+ years of experience in Data Analysis and Business Analysis.
• 16+ years of experience in Software Industry and 4 years Insurance Industry.
• 9+ years Technical Lead and Project Management.
• 3 + years working in Cloud based environment.
• 2 + years hands on Agile Project experience.
• 2+ years of experience on End to End Digital Analytics & KPI Visualization.
• Knowledge of Big Data, Hadoop and Data Lake.
• Excellent Team Lead, Team Player, Problem Solving and Communication skills.

TECHNICAL SKILLS:

Languages: VB, Delphi, SQL, Shell, C/C++, VBScript, HTML, XML.

RDBMS: DB2, Oracle, Sybase, Confidential, Netezza.

Technical Environment: IBM InfoSphere DataStage and QualityStage. Data Archietect, Business Objects, Business Query and Doc Agent, Zabo, Metacube, Personify, Aginity, Cognos, Tableu, RapidSQL, ClearQuest, JIRA

Operating System: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Adv. Program Analyst & Tech Lead

Confidential, San Jose, CA

• Lead E2E Data Analysis and Development for Digital Analytics Dashboard KPIs.
• Lead the end to end requirement discovery and analysis.
• Analyze the source data to determine the feasible source system.
• Develop the Key Performance Indicator (KPI) data marts use DataStage.
• Perform the system and stress test on the existing data backend system.
• Lead the KPIs’ visualization data requirement discussion.
• Deploy to production and determine the schedule of the on - going refresh or update.
• Support and solve any data issues for the KPIs.
• Apply Agile methodology.
• Lead E2E Business Analysis and Visualization Solution Design for Marketplace Dashboard.
• Lead the business requirement discussion with the stakeholder before each Agile Sprint planning.
• Lead the end to end business analysis for Cloud Marketplace Dashboard.
• Investigate the root cause of the defects.
• Proof of concept development for the new requirements.
• Write the technical specification and guide the developers for the implementation.
• Lead User acceptance test.
• Write technical specification for the UI development.
• Code review and lead the testing before deployment.
• Coordinate with DBA, UI and source team for the deployment.
• Review/Demo the sprint result to the stakeholder.
• Train junior Developers and Analysts on the Customer and Client Projects.
• Document and gather the training docs for application overview and processes flow.
• Provide the 3 days detail walk through training remotely.
• Be the subject expert consultant role to help analysts and developers for the coming requirements.
• Provide Second Level Production Application support and Impact Analysis.
• Develop Decision Support System Application to Support and Develop Sales Opportunity and Propensity.
• Create Proof of Concept process for regional countries.
• Key developer to develop, test and deploy the project to increase sales productivity worldwide.
• Lead junior developer to enhance and automate the quarterly refresh process use DataStage.
• Enhance and deploy the application’s usage metrics.
• Lead and Prepare for the Critical Corporate Application Compliance Reviews and Audit.
• Teamwork to create compliance documents.
• Present at the compliance review meeting.
• Coordinate with teams and reviewers to complete the corrections as reviewer suggested.
• Lead the Development and Deployment of the Customer Right-time Feed.
• Teamwork with data architect to design the solution.
• Write technical specifications for developers to code.
• Code review and perform the system and stress test with the developers.
• Create project plan for the production deployment.
• Coordinate with teams’ resources for the successful deployment.
• Resolve application process and data issues.
• Enhance the application process associated with the source application changes.
• Coordinate the Customer and Client Related Refresh, Rollover and Acquisition Customer’s Integration.
• Migrated Existing Customer Processes from Confidential, Oracle, Sybase to DB2, Netezza.
• Supported Confidential Applications and Business Object Reporting.

Software Engineer

Confidential, Menlo Park, CA

• Supported Confidential Application and User Interface Use DataStage and Business Object.
• Developed the Extracts for Confidential Customer, Invoice, Revenue info. for Migrating to IBM.

Software Engineer

Confidential, San Francisco, CA

• Designed the interface of Confidential Revenue Data Mart and Data Warehouse in Business Object.
• Tested and Evaluated the Business Intelligence Reporting Tools: Metacube, Business Object.
• Created Demo for Web Traffic Data Analysis using Personify for Business Analysis and Data Mining.
• Provided Business Intelligence Consulting Service to the Client, Confidential

Data Modeling and Data Warehouse Engineer

Confidential, Madison, WI

• Team-Worked on Logical Model and Physical Model Design for the Risk Management Data Warehouse.
• Hands-on Risk Management and Customer Data Warehouse Design and Development.
• Designed Interface for Relational Database Management Application for Agent Profit Calculator.
• Deployed OLAP Application in VB and Business Query for Commercial Auto Discount Plan.
• Involved in Object Oriented Analysis and Design for Quoting System using Delphi.

Program Analyst

Confidential, Indianapolis, Indiana

• Programmed in Relational Database to Enhance the Existing System.
• Customized for Customer’s Requirement for Data Processing and Image Processing.
• Created Demo and Prototype for the New Customers.
• Developed and Executed the Test Cases for Software Quality Assurance.