OBJECTIVE

• To secure a position in a well - established organization to enhance my technical skills and knowledge to take the organization on high. I would like to take up challenging tasks, work hard and live up to the expectations.

SUMMARY

• Having 7+ years of experience in Data Warehousing and Oracle. This includes analysis and development of mappings incorporating needed transformations using Informatica.
• Experience in Data Modeling using Dimensional Data modeling,Star/Snowflake Schema modeling,FACTandDimensional tables,Physicalandlogical data modeling.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Extensively ImplementedError Handling Concepts, Testing, Debugging skillsand Performance tuningof targets, sources, transformation logics.
• Expertise in doing theRCA (Root Cause Analysis)and resolvingperformance bottlenecksand enhance for optimization of themappings, sessions and workflows.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs.
• Experienced in Oracle Database Design and ETL with Informatica.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Extensively worked on an eCMMS Enterprise Asset Management (EAM) IBM MAXIMO ASSET MANAGEMENT tool.
• Well-versed with configurations in Maximo v7.5 and in-depth expertise in all the versions of Maximo (v4.0.3, v4.1, v4.1.1, v5, v6, v7.1 and v7.5).
• In depth experience of the upgrade process of Maximo from Maximo v4.0.3 to Maximo v7.5.
• Excellent knowledge and in depth experience in Software Testing Life Cycle (STLC) in HPQC.
• 3.5 years+ of experience in Software Technical Design, Development, Implementation, Production support and Documentation of Client/Server, Internet/Web and Legacy Applications.
• Experience in both support and administration of Maximo 7.5/7.1/6.2/5.0 application deployed on WebLogic8.1/Websphere6.1 application servers which includes configuration and deployment of Maximo and Mobile Maximo applications.
• Worked on reporting tools like BIRT, COGNOS, and OBIEE. Developed reports based on pie-graph, bar-graph, summary reports, detailed reports, comparison reports etc.
• Very Good knowledge of Software Development life Cycle (SDLC). Ad-hoc Testing and Performance Testing. Emphasized on Performance tuning.
• Strong expertise and experience with Informatica Power Center v9
• Expertise with all the versions of Maximo which includes Maximo v4.0.3, v4.1, v4.1.1, v5, v6, v7.1 and v7.5.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows NT/2000, UNIX, Windows XP, Vista, Windows 7, Windows 8.

UPGRADE PROCESS: Expertise in execution of upgrade of Maximo from Maximo v4.0.3 to Maximo v7.5.

TOOLS: Informatica Power Center (v8.6.1, v9), eCMMS Tool (Enterprise Asset Management), HPQC, PL/SQL Developer, SQL*Plus, TOAD, Edit++, Editor, Microsoft Word, Excel, Powerpoint, Basics of Adobe Photoshop.

Scripting Languages: Ant Script, JavaScript, UNIX Shell Script GUI AWT/Swing, HTML and ML/XSLT.

RDBMS: MS-SQL Server, MS-Access, DB2 and ORACLE 11g/9i, PL/SQL Middle Ware Servlets 2.0, Web Services.

Programming GUI: SQL, PL/SQL, SQL Plus, Core Java, HTML, C, C++

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead / Sr. Developer

Environment: Upgrade Utility of Maximo, INFORMATICA v9, Maximo 6.2, Maximo Enterprise Adapter (MEA), Java 1.4, SQL, PL/SQL, J2EE, UNIX and Windows XP, Web Sphere, Oracle 9i/11g. SQL Server 2000, Windows 2003.

Responsibilities:

• ETL lead to coordinate requirements with Team and guide the team during Development and testing Phases.
• Create Informatica mappings to validate the data from different sources.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Designed mappings and transformation rules based on complex FRS (Functional Requirement Specification) and URS (User Requirement Specification).
• Used complex data transformations with more than 50 transformations for each mapping.
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Led an onsite / offshore model team of up to 8 onsite and 35 offshore resources.
• Preparing and reviewing all the deliverables being delivered from Offshore.
• Expertise in DATA PORTING to convert SQL SERVER 2000 database objects into ORACLE 11g.

Confidential

Informatics/Maximo Developer

Environment: Informatica Power Center v9, Maximo Integration Framework (Maximo v7.5), Maximo 6.2, Maximo Enterprise Adapter (MEA), SQL, PL/SQL, Windows XP, Web Sphere, Oracle 9i/11g, SQL Server 2000, HPQC 10.

Responsibilities:

• Create interface and technical solution design documents, including concept presentations, technical specifications, and interface control documents
• Designed Mappings, Mapplets, Sessions and workflows incorporating various transformations catering to business needs and requirements.
• Integrated Informatica Power Center v9.1 for data migration involving Maximo v4.0.3, v4.1, v4.1.1, v5.1, v6.2.8, v7.1 and v7.5
• Maximosoftware development including coding, storage, version control, testing, and re-use.
• Implementation of business logic using Informatica Power Center v9 to transform, migrate and merge 10 Maximo databases (including SQL Server 2000 and Oracle 11g) into a single Maximo Database (Oracle 11g).
• Designed Object Structures, External Systems, Enterprise Services, End Points and Publish Channels to migrate the Calibration data from legacy systems (Gage Insite and Pilgrim) into Maximo v7.5
• Conduct technical design meetings and collaborate with other team members on transforming system requirements to project deliverables.
• Create solutions based on utilizing IBM Maximo Integration Framework and Maximo Business Object customization.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data.
• Used flat file and Oracle as the source and the target is Oracle database.
• Most of the transformations were used like the Source qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.
• Used the Workflow Manager, to create the session, workflows.
• Used Mapping Parameters and session parameters in various projects the development.
• Developing and modifying changes in mappings according to business logic.
• Performing Unit Testing.

Confidential

ETL Developer

Responsibilities:

• Requirement capturing from Business analyst on the project and review them with technical team
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data for the projects.
• Used flat file and Oracle as the source and the target is Oracle database for project team.
• Used the Workflow Manager, to create the session, workflows.
• Documentation of AS-IS process of the functional flow and present back to project teams
• Used Mapping Parameters and session parameters in various projects the development.
• Developing and modifying changes in mappings according to business logic.
• Performing Unit and functional Testing of components developed by COE.
• Part of COE for medical devices and diagnostics