SUMMARY

• Informatica Subject Matter Expert (SME).
• Over 11 years of experience in Informatica Administration, Development, database designing and data modeling.
• Proven track record to improve Informatica performance and reduce failure points.
• Handled all phases of SDLC including requirements gathering, analysis, design, development, unit testing, on - going maintenance and production support.
• Hands on experience on RDBMS systems including Microsoft SQL server, Oracle and DB2.
• Microsoft SQL server Subject Matter Expert.
• Created successful data models using Relational & Dimensional modeling and ER diagrams.
• Experience in data analysis, data profiling, data standardization and data cleansing.
• Passionate about developing new solutions, prototypes, templates and proof of concepts.
• Knowledge of Service Oriented Architecture (SOA) and principles.
• Lead a six sigma project and participated in multiple lean projects.
• Experience in leading project teams using Agile / Scrum
• Excellent communication skills with crucial conversation and facilitation techniques.
• Extensive experience in healthcare, insurance, telecom, banking and finance domain.

TECHNICAL SKILLS

ETL: Informatica power center 9.x / 8.x / 7.x, Informatica Developer, Informatica Analyst, Informatica Administrator, Data masking, Informatica Power exchange, Informatica Data Services (IDS), Informatica Data Quality (IDQ), Informatica Metadata manager, SQL Server Integration Services (SSIS), DTS

Tools: /Applications: SQL server management studio, Oracle SQL Developer, Toad, ER studio, MS Visio, Visual studio, Visual Source Safe (VSS), Team Foundation Server (TFS), EA Sparks, SharePoint, MS Office, Business Objects, SVN, PuTTY, WinSCP, JIRA, Tectia SSH

RDBMS: MS SQL Server, Oracle, IBM DB2, Teradata, MS Access

Scripting: PowerShell, UNIX Shell Scripting (Bash Shell, Korn Shell)

Languages: C, C++, C#, ASP.Net, Java, SQL, PL/SQL, XQuery, XML

Operating Systems: Windows, DOS, UNIX, Linux, Solaris

Schedulers: Informatica scheduler, Tidal scheduler, CronTab

Project methodologies: Waterfall, Agile (Scrum, Kanban)

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer / Administrator

Confidential, Kansas City, MO

Responsibilities:

• Installed Informatica PowerCenter 9.6.1
• Upgraded Informatica Repository from 9.5.1 to 9.6.1
• Responsible for end to end implementation and operations of Enterprise Data Warehouse using Informatica, Oracle 11g, Microsoft SQL Server 2012 and DB2.
• Decreased production issues by more than 80%.
• Optimized the ETL and decreased nightly batch processing time by more than an hour.
• Developed Informatica code with good performance for highly complex business logic.
• Modeled databases for reporting and transaction processing.
• Performed data analysis, data profiling and data cleansing using SQL and Informatica.
• Worked extensively on performance tuning of Informatica workflows and SQL scripts.
• Developed and re-engineered database objects like Tables, Views, Stored Procedures, Triggers, Functions, Indexes and Constraints.
• Hands on expertise on data virtualization techniques for publishing data out of EDW.
• Leadership experience in coordinating between multiple technical teams, stakeholders and senior management.
• Provided on-call support to resolve production issues on time and meet SLAs.
• Enforced coding standards, best practices and formalized code reviews.
• Performed installation, configuration and upgrade of Informatica products.
• Installed and implemented Informatica Cloud services.
• Migrated code to different environments and monitored the jobs.
• Experience with native & LDAP authentication and change data capture (CDC).
• Designed data warehouse and data marts using Relational and Dimensional modeling.
• Developed Informatica data services (IDS) in Developer tool for data virtualization.
• Used Data Quality tools to identify possible data issues and cleanse data.
• Created technical specifications using Informatica Analyst tool and excel spread sheets.
• Supported SAP Business Objects reports with Informatica PowerCenter and IDS.
• Provided technical support to TWAI application developers and project managers.
• Experience in banking system including loans, bonds, securities and treasury services.
• Experience in managing and protecting personally identifiable information (PII).

Environment: Informatica Power Center 9.6.1 / 9.5.1 , Solaris, Windows, Oracle 11g, DB2, SQL server 2012, ER Studio, SAP Business object, Informatica developer, Informatica Data Services, Informatica analyst, Web services, Visio, JIRA, Tableau

Sr. Informatica Technical Lead (Administrator / Developer)

Confidential, NE

Responsibilities:

• Provided technical leadership and developed new business opportunities.
• Installed and configured Informatica PowerCenter 9.1 and 8.6
• Supported day to day activities of the Data Warehouse.
• Mentored Informatica and SQL developers.
• Migrated Informatica code and managed security and permissions.
• Fine-tuned Informatica transformations and workflows for better performance.
• Created Informatica mappings using transformations like Source qualifier, Expression, Aggregator, lookup, Router, Filter, Update Strategy, Joiner, Stored procedure, XML generator and XML parser transformations.
• Designed, created and modified SQL database objects.
• Developed data models from technical and functional specifications.
• Hands on experience on OLTP and OLAP applications.
• Provided 24x7 on-call support including nights and weekends.
• Excellent knowledge in data analysis, data cleansing and data validation.
• Represented Informatica and SQL server on Enterprise architecture board.
• Developed SSIS packages to load data into warehouse and benchmark the performance.
• Supported multiple lines of business and IT initiatives.
• Extracted data from Mainframes IMS databases and VSAM files using Power Exchange.
• Used Informatica Metadata Manager to show data lineage.
• Collaborated with remote offshore team, creating the requirement documents, verifying coding standards and conducting code reviews.
• Utilized an opportunity as interim Project Manager and successfully integrated the third party source data ahead of schedule with good performance.
• Developed Informatica data services (IDS) in Developer tool for SOA applications.
• Developed PowerShell scripts and batch scripts for file processing and cleansing.
• Developed basic applications using C# and .Net
• Experience in integrating vendor systems with in-house applications while maintaining system integrity and compliance with HIPAA regulations.

Environment: Informatica Power Center 9.1/8.6/8.1, Power Exchange, SQL server, Metadata manager, Solaris, Windows, Oracle 11g, DB2, ER Studio, Informatica developer, Informatica Data Services, Informatica analyst, Web services, VSS, Visio, TFS, SSIS, SSRS, Tidal

Sr. Informatica Developer

Confidential, Meadows, IL

Responsibilities:

• Created data extractions, transformations and load processes for enterprise data warehouse, data marts and enterprise applications using Informatica and SQL scripts.
• Developed complex Informatica mappings and workflows.
• Performed Informatica administration activities.
• Migrated code to Informatica QA and production environments.
• Worked on Informatica PowerExchange for Change Data Capture (CDC).
• Mentored junior programmers in SQL Server 2005/2000 and Informatica.
• Extensively used T-SQL DML, DDL, DCL, TCL statements.
• Created and implemented stored procedures, user-defined functions and transactions.
• Liaison between development team, test team and project managers.
• Provided support for development and deployment of database models based on business requirements and mapped entities to existing data sources.

Environment: Informatica Power Center, Power Exchange, SQL server, ER Studio, Web services, Visio, SSIS, SSRS, VSS, Windows

ETL Developer

Confidential Chicago, IL

Responsibilities:

• Responsible for developing ETL processes using Informatica Power Center.
• Created reusable mapplets, transformations and user defined functions.
• Prepared mapping specification for Informatica mapping.
• Scripted PMCMD, PMREP command line utilities to interact with Informatica server.
• Dimensional modeling using star and snowflake schemas and implemented Slowly Changing Dimensions.
• Extensively created SQL stored procedures to implement business logic.
• Optimized SQL scripts for better performance.
• Extracted and Transformed data using DTS in SQL Server 2000 and SSIS in SQL Server 2005.

ETL Developer

Confidential, Newark, CA

Responsibilities:

• Created SQL Scripts, tables, views using Microsoft T-SQL and Oracle PL/SQL.
• Designed and developed stored procedures, Triggers, User Defined functions.
• Experience in fine tuning the SQL queries using SQL Query Analyzer.
• Developed complex queries using joins and sub-queries for extracting data from multiple tables.
• Created Informatica mappings, sessions and work flows.
• Expertise in working with Informatica and client tools like Repository Manager, Designer, Workflow Manger and Workflow monitor.
• Used Informatica to extract data from various sources including SQL server, Oracle, Mainframes and flat files.
• Documented disaster recovery plan and restart procedure of critical workflows.