SUMMARY:

• I have 14+ years of IT experience, primarily in designing/developing BI Datawarehouse, Data Integration/ETL, MDM, Scorecards & Dash boarding solutions. I have expertise in various BI tools like Informatica (ETL), Kalido BIM (Business Information Modeler), Kalido DIW (Data Warehouse Management), Kalido MDM, Cognos Metric Manager (Enterprise Performance Management), Oracle PLSQL, EDW (Enterprise Datawarehouse) etc.
• Architecting/Designing Datawarehouse/ETL solutions
• Datawarehouse DB Design (Data Modeling)
• Informatica Power Center, Decision Point, Oracle PLSQL (ETL Tools)
• Strong Oracle PLSQL, Performance Tuning and Oracle Database noledge
• Data Modeling using Kalido BIM (Business Information Modeler)
• Kalido DIW(Dynamic Information Warehouse) Development
• Master Data Management using Kalido MDM
• EDW (Enterprise Datawarehouse) and Enterprise Performance Management (EPM)
• Cognos Metric Manager as main EPM tool
• Cognos FM Model and Reporting
• Industry Experience of Manufacturing, Health Insurance, Shipping and GIS
• Design dimensional models for various manufacturing business functions like Dealer Management, Parts, Warranty, Sales, Inventory, Supply Chain, Quality, OM, GL, AR, AP, Procurement and health care business functions like Claims Processing, Member Enrollment, Provider Networks, Benefit Plans etc.
• Working as BI Technical Architect, Project Lead
• Execution/Managing the BI projects end to end
• Onsite Coordinator, managing a team working in off - shore/onsite model
• Providing technical directions/ mentorship to team members
• Experience wif Agile/Scrum methodologies
• Strong understanding of software development life cycle/ change management/ production support processes
• Writing Bids/Proposals, providing effort and resource estimates for new projects.
• Member of BI Architecture council, responsible for approving architecture/designs, developing strategy for future
• Has extensive experience in working at different geographies like US, UK, Australia & India for various clients.

TECHNICAL SKILLS:

Application Development Tools: Informatica Power Center 9.1.0 (Designer, Workflow Manager, Repository Manager), Kalido DIW 9, Kalido MDM 9, Kalido BIM(Business Information Modeler), Oracle PLSQL, Cognos 8.3 Metric Manager, Cognos Framework Manager, Cognos Reportnet, Cognos Report Studio, Decision Point, Oracle Workflow Manager

Databases / DB Tools: Oracle 11g/10g/9i/8i/, Oracle Exadata, Oracle Spatial, IBM DB2

Desktop Tools: Micro-soft Visio, Tidal, Control-M, Rational Clearquest, PL-SQL Developer, TOAD, Developer 2000, SQL Loader, Remedy User, AIX Clearcase, ALM

Hardware: UNIX (IBM AIX, Sun Solaris), Windows NT / 2000/ XP / 1998

Methodologies / Techniques: Data Modeling, Data Warehouse Design, ETL/Data Integration

Operating Systems: UNIX (IBM AIX, Sun Solaris), Windows NT / 2000/ XP / 1998

Programming Languages: Oracle PL/SQL, SQL, Unix Shell Scripts, Pro *C

PROFESSIONAL EXPERIENCE:

Confidential, Woodcliff Lake, NJ

BI Technical Architect

Responsibilities:

• Working as BI Technical Architect/Project Lead for Data warehouse/ETL/BI related projects.
• Designing ETL/DW solutions using Informatica/Oracle PLSQL/Unix etc.
• Datawarehouse Database Design (Data Modeling)
• Performance tuning, solving data warehouse load performance issues, load schedule optimizations
• Design dimensional models for various Manufacturing business functions like Dealer management, Sales, Marketing, Warranty, Parts etc.
• Designing reporting solutions in Cognos
• Managing a team in Onsite/Offshore model
• Execution/Managing the BI projects end to end
• Providing technical directions/mentorship to team members
• Creating Project Plans, System Design documentation
• Coordination of QA/UAT/Production deployment/release activities
• Proposing new solutions, writing Proposals/Bids documentation for new projects
• Providing Resource/Effort Estimates for new projects
• Creation of Best Practices, Process improvements etc.

Environment: Informatica Power Center 9.1.0, Cognos 9.0. Framework Manager, Reportnet, Transformer Models, Oracle PLSQL, Oracle 11g, Microsoft SQL Server, IBM DB2, Sun Solarix, Windows NT, Main Frame Scheduler.

Confidential, Buffalo NY

Technical Team Lead, Data warehouse/Kalido/ETL Lead Designer

Responsibilities:

• Working as kalido/ETL consultant to enhance and support Independent Health’s Enterprise Data Warehouse (EDW) solution environment.
• Design/Developing ETL solution in Informatica/Oracle PLSQL/Unix.
• Developing data warehouse solutions in Kalido DIW (Dynamic Information Warehouse)
• SQL performance tuning and solving data warehouse load performance issues.
• Building solutions in Kalido MDM (Master Data Management).
• Business/Datawarehouse Modeling using Kalido BIM(Business Information Modeler)
• Design dimensional models for various health care business functions like claims processing, member enrollment, provider networks, benefit plans etc.
• Working as technical lead, coordinating wif architects/business analyst’s to reach at the right solution design and getting the development done.
• Providing technical directions to team members and also providing s about MDM-EDW architecture to various stakeholders.
• Member of BI Architecture council, responsible for approving architecture and designs and developing strategy for future.
• Production Support, working on fixes/issues in the daily production schedule which also involves creating KIRs wif kalido support to get the kalido bugs fixed.
• As part of the code review team, responsible for reviewing and approving the changes done in kalido, Informatica, Oracle PLSQL, Unix/Windows batch scripts.
• Helping administrators to resolve kalido migration issues.
• Help the release team for production/QA release activities.

Environment: Informatica Power Center 9.1.0, Kalido BIM, Kalido DIW 9, Kalido MDM 9, Cognos 9.0. Framework Manager and Reportnet, Oracle PLSQL, Oracle 11g, Sun Solarix, Windows NT, Tidal.

Confidential

BI Consultant/ Technical Lead/Onsite Co-coordinator

Responsibilities:

• Responsible for designing the EDW datawarehouse model for any new business function like Sales, Order Management, Costing, General Ledger, Procurement etc.
• Creating new scorecards, metrics, defining their calculations, designing the security architecture for EPM Cognos metric manager application.
• ETL Solution designer, responsible for designing/Developing ETL solution using Informatica Power Center 8.6.1., Oracle PLSQL, Unix etc.
• Understanding the source system (Oracle ERP) business processes for designing the ETL solutions.
• Responsible for creating the MDM solution in Kalido MDM 8.4 for defining metrics, scorecards, strategies etc.
• Writing proposals, providing effort and resource estimates for new projects.
• Providing technical direction and allocation of work to the team.
• Writing Oracle PLSQL packages, procedures, Functions etc. for the ETL work.
• Solving Performance issues in ETL, Data warehouse Loads.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer
• Extensively worked wif Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Writing UNIX shell scripts for file handlings, automation and scheduling of the jobs.
• Scheduling the ETL Informatica, Kalido and Cognos metric manager build jobs through Control- M.
• Preparing documents like ETL/Datawarehosue design, Best Practices, ETL standards etc.
• Created the reports framework using Cognos Framework Manager which will use the EDW tables.

Environment: Kalido DIW 8.4, Kalido MDM 8.4, Informatica Power Center 8.6.1, Cognos 8.3 Metric Manager, Cognos 8.3 Framework Manager and Reportnet, Cognos Power Play Transformer, Oracle PLSQL, Oracle 11g, Sun Solarix, Control M.

Confidential

BI Consultant/ ETL Solution Designer

Responsibilities:

• Designed/Developed ETL Solution using Informatica Power Center 7.1.3.
• Designed the Data warehouse Model using Ralph Kimball Dimension Modeling approach for each of their business processes like Sales, Order Management, Costing, General Ledger, Procurement etc.
• Understanding the source system (Oracle ERP) business processes for designing the ETL solutions.
• Created complex mappings using reusable Mapplets, Mapping Parameters and Mapping Variables to use globally
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer
• Worked wif pmcmd command line program to talk wif the Informatica server
• Created the reports framework using Cognos Framework Manager which will use the EDW tables.
• Created interactive BI Reports using Cognos Reportnet.
• Designed/Developed the data warehouse, ETL solutions for their Remedy Call Support center.
• Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.
• Scheduling the ETL Informatica, Kalido and Cognos Cube build jobs through Control M.
• Involved in the preparation of documentation for ETL standards, procedures and naming conventions, wrote Shell scripts

Environment: Kalido DIW 8.0, Informatica Power Center 7.1.3, Decision Point, Cognos Framework Manager and Reportnet, Cognos Power Play Transformer, Oracle PLSQL, Oracle 10g, Sun Solarix, Control M.

Confidential

Senior ETL Developer

Responsibilities:

• Designed/Developed ETL Solution using Informatica Power Center 7.0.
• Designed the Data warehouse Model using Dimensional Modeling approach.
• Understanding their source systems, liaising wif their external business partners to understand the file formats, data quality.
• Writing PLSQL packages, procedures, functions to do the harmonization analysis and publish the data.
• Performance tuning for the various business processes.
• Extensively worked wif various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations
• Extensively worked wif various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input, and Mapplet Output transformations.
• Worked wif the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, and Full Outer Join.
• Worked wif Connected look up and un-connected lookup and configured the same for implementing complex logic.
• Worked wif various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows, and Session Tasks
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Monitor the workflow using workflow monitor and also used to stop, Abort and Pause the sessions while running.
• Extensively used mapping parameters, mapping variables and parameter files for implementing Incremental Loading
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Worked wif pmcmd command line program to talk wif the Informatica server
• Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.
• Involved in the preparation of documentation for ETL standards, procedures and naming conventions, wrote Shell scripts

Environment: Informatica Power Center 7.1.0, Oracle PLSQL, Oracle Spatial, Oracle 9i/10g, Sun Solarix, Rational Clear Quest.

Confidential

IT Analyst

Responsibilities:

• Part of BI Application Support Team which took care all the new change requests from the business and solving issues related to the current solution.
• Designed/Developed ETL Solution using Informatica Power Center 7.0.
• Module specialist for various business processes related to their document and revenue system like communication, Journey leg register, Slot capacity management etc.
• Solving daily basis tickets raised for the above modules.
• Analysing the problem and proving the fixes if required.
• Debugging, Coding and Testing of issues related to the assigned modules.
• Requirement Analysis, Coding and Testing of the change requests.
• Maintaining the data quality by writing PLSQL scripts which do the system health checks.
• Managing VIP problems for the faster solution.

Environment: Informatica Power Center 7.1.0, Oracle 10g/9i/8i, Oracle PL/SQL, Shell Scripting, Unix AIX Version 5, Forms 6i D2K, Pro*C.