Reporting Consultant/lead Developer Resume
SUMMARY:
- 18 years of professional experience in the field of Software System Design and Development.
- 12 years in Data Warehousing, ETL/SQL Projects in the capacity of Data Warehouse, Business Intelligence, ETL, OLAP - Analysis, Design, Data Modeling, Data Migration/Conversion and Development. Experience in dual-shore team environment.
- As DW consultant my role was to contribute to the end-to-end Data warehouse project life cycle to ensure development of high performance, easily maintainable ETL/Data warehouse/BI solutions.
- Experience with Data Modeling, Dimensional Modeling, OLAP design-Universe and creation of ad-hoc/canned reports in Business Objects 5.x, 6.x, XI r2/3.1/4.2; ETL using Informatica Power Center 6.x, 7.x, 8.x.9.x
- Overall Data Warehouse and BI project domains were in Bookings, Demand planning, Forecast, Sales, Healthcare, Dental Insurance and others.
TECHNICAL/FUNCTIONAL SKILLS:
Operating Systems: MS DOS, WINDOWS, XP, UNIX
Programming: SQL, PL/SQL, C/C++, Visual Basic, Java/JSDK
Databases: Oracle 7-11, SQLServer 7.x/2000, Sybase SQLServer/Adaptive Anywhere, Teradata 12.0, MySQL 5.2
BI & DW Technologies: SAP Data Services/BODS 4.2, Informatica PowerCenter 6.x, 7.x, 8.x; Informatica PowerExchange, MS DTS, BOBJ 5.x, 6.x, XI R2, 3.1; DecisionPoint Warehouse Admin 10.5.1, UMT, MDM Siperian
Web Technologies: JSP, Java Servlets, ASP, ColdFusion
Tools: Microsoft Tools - MS Project, MS Excel, MS PowerPoint, MS Visio; HP Tools - Kintana, QualityCenter; PVCS; Toad, Erwin, Job Scheduling - $U, Tidal; SFDC - Apex Explorer, Apex Data Loader, DataFlux 8.1, Jira, Tortoise SVN, Citrix.
PROFESSIONAL EXPERIENCE:
Confidential
Reporting Consultant/Lead Developer
Responsibilities:
- Business/Data Analysis
- Tuning the SQL queries to improve the performance
- Data fixes in Business Objects Report
- Coordination with Cross-functional and offshore team
- Deployment checklist and deployment to QA and Production environment
- Working in the Onsite/Offshore team model
- Handling Bugs and ticket issues
- Requirement gathering and business discussions with Business Analyst
- Preparing the Mapping Design
- Code Development, unit testing and offshore team coordination
Confidential, San Francisco, CA
Environment: SAP Confidential 4.2, Oracle 10g, Jira, Tortoise SVN, SAP Data Services/BODS 4.2, Citrix
MDM/ETL Lead
Responsibilities:
- Business Discussions and Requirement Analysis
- Design and mapping Discussions
- ETL Code Development using Informatica
- Coordination with onsite/offshore team
- Unit Testing and Data Validation
- Preparation for UAT and Business data verification
- Production deployment and process improvement
Confidential, Sunnyvale, CA
Environment: Informatica 9.5, Oracle 10g.
ETL Architect
Responsibilities:
- System and Data Analysis
- Design for Serial Number project
- Coordination with cross functional teams, onsite/offshore team
- Process Improvement
- Coordination and assessment of Informatica Cloud POC against SSIS Modern Platform (MDP)
Confidential
Environment: MS-SSIS 2014, NetSuite, Informatica Cloud, QlikView
ETL Consultant
Responsibilities:
- Business Discussions and requirement gathering
- System and Data Analysis
- Data Modeling for PJV (Finance Team)
- Development, Unit Testing, QA, UAT and Deployment in various subject areas
- Coordination with cross functional, onsite/offshore team and release teams n Wave Platform
- Data loads for Finance on Wave Platform
Confidential
Environment: Informatica 9.5, Oracle 10g, 11i, Tidal Scheduler, BO-DI, BOBJ XI R3.1, Salesforce Workbench
Functional Analyst
Responsibilities:
- Understanding the reporting requirements
- Development, Testing, Standard template verification
- Delivering the solution with the help of offshore development team users on the new reports
Confidential
Environment: SAP BusinessObjects WebIntelligence XI R3.1.
Data Modeler
Responsibilities:
- Business Discussions and requirement gathering
- Understanding the Operational System
- Building the efficient Data Model/Data Mart for BI Analytics through Pentaho
Confidential
Environment: MySQL 5.2, Pentaho 4.1
Performance Consultant
Responsibilities:
- Estimate and tune the performance bottlenecks in SQL/Business Objects reporting.
Confidential
Environment: Oracle 10g, Informatica 8.1.6
ETL Consultant
Responsibilities:
- ETL Development, Unit Testing
Confidential
Environment: Oracle 10g, Informatica 8.1
ETL Consultant and Data Analyst
Responsibilities:
- Translate requirements into ETL system
- Revise Product Hierarchy
Confidential
Environment: Oracle 10g, Informatica 8.6.1
Data Analyst
Responsibilities:
- Understanding the data from 3 sources CIC (TD), BI Café (TD), SOM (Oracle) for SSODM (Oracle) and putting together SDR for the LDM modeling.
Confidential
Environment: Oracle 10g, Teradata 12.0
ETL Consultant
Responsibilities:
- Analysis of existing ETL in DecisionPoint and performance improvement by incremental data loads
Confidential
Environment: Oracle 10g, DecisionPoint Warehouse Administrator
BI/Data Analyst
Responsibilities:
- Source System Analysis, Participation in Logical and Physical Data Modeling, ETL System Design
Confidential
Environment: Teradata 12.0, Oracle 10g, Informatica 8.6.1
Data Analyst
Responsibilities:
- To compare, validate and certify the data quality in Teradata environment.
Confidential
Environment: Teradata 12.0, Oracle 10g, DataFlux 8.1
ETL Consultant
Responsibilities:
- ETL Development using Informatica, Unit Testing
Confidential
Environment: Informatica PowerCenter 8.1.1, Oracle 9i
ETL Consultant
Responsibilities:
- ETL Design, ETL Development using Informatica, Unit Testing