PROFILE:

• 10+Years of experience in Information Management and business Intelligence technology skillset (Data Integration, Data Cleansing and Data Transformation, Business Analytics and Reporting Solutions).
• 10+years of architecture, design, build, test and maintenance experience with Data Integration Software tools Informatica PowerCenter, Power Exchange, Analyst, Developer, B2B Data Exchange and Attunity.
• 10+ years of experience with managing database technologies Oracle, Db2 and Teradata. Ability to design and develop databases, data warehouses and multi - dimensional databases.
• 10+ Years of experience in Confidential 's Corporate Information Factory and Ralph Kimball Bus Architecture Designs.
• 10+ years of Data Architecture experience. Experience in designing logical, physical and canonical data model designs.
• Excellent Data warehouse tuning skills, including configurations, implementation and understanding of various Datawarehouse architecture designs.
• Strong understanding of Insurance Domain functionality.
• Ability to work as a collaborative team, mentoring and the client and other IBM staff on the various tools and techniques to build a complete analytics solution.
• Experience with online Analytics Processing (OLAP) software’s SAP Business Objects.
• Involve in multiple stages of SDLC (s/w development life cycle) including Analysis, Estimation, design, Coding, Unit Testing, User Acceptance Testing support for new/ongoing projects from ETL (Extract / Transform / Load) / DWH (Data warehousing) standpoint. Leverage superior knowledge of both database Technology as well as Informatica based ETL/DW technologies to perform effectively.
• Project Leadership skills including understanding, designing and implementing the technical solution as well as leading the entire technical team to ensure that they follow the approach and meet deadlines.
• Provide technical Leadership to offshore team. Perform work allocation, planning, delegate work to offshore, track tasks to completion, resolve offshore questions/issues and drive projects to successful completion.
• Experience in configuration management software SVN.
• Experience with Agile and Lean Methodology Framework.

TECHNICAL SKILLS:

Data Integration: Informatica Power CenterB2B Data Exchange, Power Exchange CDCB2B Data Transformation, AttunityInformatica Analyst, IDQ, IDE.

Data Quality: Informatica Data QualityInformatica Analyst, Business Glossary.

Databases: ORACLE 9i/11g,12c, Teradata DB2 LUW 9.5, 10.5SQL Server, IBM Dash DB, Big Data - Hadoop

Data Architecture: Information FactoryKimball’s Bus Architecture, ER Modelling and Dimensional Modelling.

Data Model Tools: Erwin Designer

Project Management: SDLC Waterfall model, Agile Framework and MS Project.

Schedulers: Crontab, Autosys scheduler.

Version Controls: MS VSS, PVCS, Subversion (SVN)

Programming Languages: Oracle SQL- PL SQL, DB2 SQL /PLSQLUNIX Shell scripting, Awk, Sed Pearl Scripting

PROFESSIONAL EXPERIENCE:

Senior Application Developer

Confidential

Responsibilities:

• Data Integration/ETL (Extraction, transaction and loading) applications - Group insurance Information Platform
• Database applications - Group insurance Datawarehouse (GIDW), Enterprise Data Hub (EDH), Datamarts housed on Db2, Oracle
• Enterprise Data Framework - Data Architecture and Data Quality Framework.
• Web applications - GEARS, BARRS
• Reporting applications - GIDWRS, IMBI Cognos, Business object reporting built using Cognos and Business Objects
• Creating Entity- Relationship (ER) and dimensional data models using Erwin Designer.
• Designing data marts Star and Snow-flake schemas.
• Design and Develop Data architecture framework.
• Design and Develop Data Integration framework (Real-time and Batch).
• Design and Develop Source to Target Data Mapping with data validation and cleansing rules.
• Developing Data Mappings using Informatica PowerCenter, Power Exchange CDC, B2B DataExchange, B2B Data Studio, DB2 and Attunity software.
• Perform data profiling on the source and target systems to assess data quality in EDH and GIDW using Data Quality and Analyst software.
• Fix data quality issues identified in profiling with Informatica Data Quality software.
• Writing packages and procedures in db2 and Oracle.
• Writing function, sequence and triggers in db2 and Oracle.
• Write various level of Unix scripts to perform business logic and executing database Sqls.
• Creating report using Unix scripting.
• Creating interactive reports in business Objects.
• Monitor the various production real-time and batch jobs of EDH and GIDW in Informatica, Attunity, Power Exchange CDC, B2B DataExchange, B2B Data Transformation, Unix, Db2, Oracle and Autosys and maintain the health of the application.
• Analyze and resolve the production issues in Informatica, Attunity, PowerExchange CDC, Db2, Oracle, Unix, Cognos and Business Objects within SLA.
• Small and medium enhancement and fixes are developed and deployed through change management process.
• Analyzing and fixing recurring problems in the application problem tickets.
• Ensuring the business-critical data loads and reports are delivered on schedule without failure

Sr. Informatica Developer

Confidential

Responsibilities:

• Worked in extract building project, to build new extracts and enhance existing extracts.
• Participated in design discussions with business users to extract requirements.
• Involved in Creating sessions and Workflows using Informatica Workflow Manager
• Created Pre and Post Session Scripts for checking file existence.
• Created, launched & scheduled tasks/sessions. Setting up tasks to schedule the loads at required frequency using Power Center. Configured email notifications.
• Scheduling ETL process on daily, weekly and monthly basis.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Wrote test cases and coordinated with testing team to carry out QA testing and provided support during User Acceptance and production deployment.
• Mentored junior members of the team and helped them understand the business.

Environment: Informatica 9.5, Oracle 10g, Unix (AIX), Tivoli.

Sr. Software Engr.

Confidential

Responsibilities:

• Involved in promoting Informatica Objects across different environments using different deployment techniques.
• Debugging the deployment and connectivity issues.
• Scheduling and monitoring the regular repository and domain backups.
• Creating users and user groups.
• Creating Informatica connections and assigning permissions to users/groups.
• Involved in migration (Informatica server migration/up gradation)
• Repository query to collect metrics and for coding standard check. Worked on implementing checklist for daily and monthly audits.
• Requirement analysis and to confirm the feasibility of the given requirement.
• Preparing Informatica Design documentation, test cases and test plan based on the functional specification.
• Designed and developed Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source Flat files and RDBMS tables to target flat files and tables.
• Developed schedules to automate the updated processes and Informatica Sessions/ Worklets.
• Error handling and email notifications to the concerned team.

Environment: Informatica 9.1, Oracle 10g, SQL Server 2008 R2, MS Windows, SSIS, Cognos, Statistica

Confidential

Responsibilities:

• Providing Production support - Monitoring day to day processes, timely fix of the production problems encountered, data fixes, execution of the Month/Quarter /year End batch processes.
• Discussing the business solutions with Selective Insurance Company of America and implement the process as per specification provided.
• Requirement gathering and analysis, time estimates, preparing design documentation, design reviews, development testing and deployment of application enhancements.
• Answering the technical queries, driving the product initiatives and metric collection.
• Assisted the Business Users in testing the reports using Business Objects.
• Participated in status review meetings and discussions for resolving application and test issues.

Environment: Informatica 9.1, SQL server 2008, MS Windows, Ratabase, IBM mainframes ZOS

Confidential

Responsibilities:

• Worked on research tickets pertaining data from IMSDB and DB2.
• Involved in analysis, design, and development, testing and supporting legacy data applications.
• Worked on service requests involving departments like Claims Payments/Edits, FEP(Federal Employee program)
• Worked on ITS Implementations as part of yearly upgrades.
• Worked on code from scratch to extract data to feed reports which were sent to client for auditing purpose.

Environment: DB2, IMSDB, SQL server, OS390