We provide IT Staff Augmentation Services!

Reporting Consultant/lead Developer Resume

3.00/5 (Submit Your Rating)

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

We'd love your feedback!