SUMMARY

• 15+ years of experience in providing data warehousing solutions.
• Started as programming language instructor in 1996
• Worked as Research Engineer for Confidential for a year
• Worked as a consultant for Confidential providing data warehousing solutions and consulting for Confidential Power systems, Confidential Health care.
• Worked as BO consultant for client Confidential .
• Working as ETL Analyst for Confidential . A leading international supplier of On - Demand software and E-commerce services to the insurance, financial and healthcare industries.
• Worked in various OLAP and Business Intelligence reporting tools like Oracle Financial Analyzer, Oracle Sales Analyzer, Oracle Express Server, Cognos Finance and Business Objects.
• Maintained and supported OLAP tools used by 1400+users from North America, Asia and Europe.
• Has a good understanding of relational and dimensional data models and structures.
• Has experience of working independently and coordinate the reports development with other team as necessary for improvement for report accuracy and reliability
• Good Functional knowledge of sales, finance and Healthcare Insurance domain.
• Planned, designed and executed migration of OLAP tools to higher version from existing version.
• Worked on ETL tools like Informatica, GL Analyzer Setup for extracting data from OGL and loading into Datamart, Databus 3GL.
• Worked for Confidential as senior consultant in Host Analytics application.
• Worked for Confidential as Business Intelligence Analyst/BO Admin.
• Received “Management Review Award “from Confidential, for migrating the OFA 6.3.0 to 11i with no issues at client place Confidential Power Systems.

TECHNICAL SKILLS

OLAP Tools: Oracle Financial Analyzer, Oracle Sales Analyzer, Oracle Express Analyzer, Oracle Express Server, SAP Business Objects Universe design, BO WEBI,, Cognos Finance, Crystal reports.

ETL Tools: Informatica, DATABUS

OS: UNIX, Windows

RDBMS: Oracle, SQL Server Modeling Tool Erwin, Convert

PROFESSIONAL EXPERIENCE

ETL Consultant

Confidential

Responsibilities:

• Primarily responsible for creating/managing ETL jobs developed using DATABUS sourcing data from Claims/Benefits management software and populating relational databases based on Oracle
• Created a core DATABUS ETL program that was reused in upgrading 20 + Confidential clients from previous versions of Oracle to Oracle 11g. Responsible for modifying/testing/deploying hundreds of SQL queries to be compatible with Oracle 11G and DATABUS
• Supported upgrading of Confidential proprietary claims/benefits management software from LuminX V3r1 to V4r1. DATABUS Extraction server is used for ETL process. As part of this upgrade a full history load was done for all fact tables on Oracle databases.
• Created Monthly metrics report for Client AIG using Oracle Stored Procedures.

SAP BO Consultant

Confidential

Responsibilities:

• Created WEBI based scorecards and dashboards used by Business unit directors and CIO.
• Consolidated and Converted around 160 + Crystal reports to 6 Webi reports used for Scorecards and Dashboards that are used by business unit directors and CIO.
• Consolidated 30+ reports for each business unit into and migrated from crystal reports into Business Objects WEBI. Created publication’s to send one scorecard/dashboard reports to 30+ Technology sectors.
• Simplified date dimension formulas created in Crystal and Designed Calendar table, Holiday table on SQL server 2005 that can be used for custom date dimensions in Universe designer.
• Developed a new framework for a new BO universe, which involves combining three universes like Incident, Change management and Problem management to single universe.

Business Intelligence Analyst/Bo Admin

Confidential

Responsibilities:

• Gather report requirements from end users and decide the right reporting tool (Crystal or Webi)
• Perform impact analysis of user requirements on the reports, BO universe and physical data structure.
• Create and modify BO universe - Maintain the conceptual integrity of underlying data model represented by BO universe, Add and modify tables, classes to the Universe.
• Assist and advise WEBI report developer in creation or modification of WEBI reports.
• Migrate BO universe between DEV, QA and user acceptance testing environments for security Implementation project.
• Assist in troubleshooting discrepancies in reports andworked in CMC in scheduling WEBI/Crystal reports, maintaining all job servers.

Senior Consultant

Confidential

Responsibilities:

• Developed a cube with building segments, scenarios, budget templates, HR templates, loading Actuals, budget data, creating Budget and consolidated reports.
• Worked on implementing Cognos Finance application on Host Analytics. Includes Cognos Finance Software installation, building cubes.
• Upgraded Cognos Finance to 7.5 for clients Palms Casio, Seaboard Marine,DOTS.

Data warehouse Analyst/Consultant

Confidential

Responsibilities:

• Team Lead for a team of five members comprising of ETL developers, Cognos Finance developers, OFA developers, BO Universe designers and Report developers.
• Worked with Business Analysts, Business end users, analysts during requirements gathering, troubleshooting

Confidential, Milwaukee, WI

Responsibilities:

• Developed the framework for a new BO Universe that embodies the GL ledger & a hierarchical environment to increase capacity for entities and to accommodate future business growth.
• Supported and maintained Financial Planning and Analyst reporting processes using WEBI.
• Eliminated manual steps of structure modifications and data loads needed to complete quarter closing and generation of quarterly financial statements of Confidential Health care. This removed a crucial and error prone bottle neck impeding the generation of financial statements and also reduced the overall time and resources required for this task.
• Responsible for analyzing new versions of Cognos Finance and creating business justifications for Cognos version upgrades
• Responsible for leading and successfully completing Cognos Finance version upgrades from 5.1 to 6.1, 6.1 to 7.1, and 7.1 to 7.3. Migrated around 10 Cognos finance cubes.
• Responsible for migrating Cognos Finance from Oracle source and integrating Cognos with Teradata
• Worked on Estimates/Recast/OP
• Responsible for ETL jobs for loading into various other data marts from OGL.
• Redefinition of the ultrasound cube involves combining two submissions the Contribution Margin (CM) and Base Cost (BC) submission to one submission.

Confidential, Schenectady, NY

Responsibilities:

• Responsible for ETL jobs for loading data loading into Oracle Financial Analyzer used GL Analyzer Setup on OGL to extract OFA structure, Segments.
• Responsible for ETL jobs for loading into various other data marts from Oracle Financial Analyzer
• Supported migration of Oracle Financial Analyzer from version 6.3.0 to 11i
• Automating the OFA Load/Solve Process
• Consolidating all account hierarchies to single hierarchy.
• Developed, supported and maintained a Budget System and Estimate system for GEPS