SUMMARY:

• 11+ years of experience in complete Software development life cycle (SDLC) with a strong background in Analysis, Requirements Gathering, Data Modeling, Effort Estimation, ETL Design, Development, System Testing, Implementation, Production Support and Documentation of various Business Intelligence solutions populating Data Warehouse/DataMart, Operational Data Store(ODS), Enterprise Data Warehouse(EDW) and OLTP.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center 10/9.x/8.x/7.x Suite - Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Repository Manager, Workflow Monitor and Debugger and created Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various Power Center Transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, and Look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and Update Strategy.
• Experienced as Team lead, Offshore Lead, as well as Onshore Coordinator. Manage and Monitor Offshore team and provide daily oversight and direction. Gave guidance to peer Onsite team and analyze, remove and proactively prevent roadblocks.
• Hans on experience as Informatica Admin. Created User, Group and Role in Admin Console and assigned privileges to the same. Created Folder and assigned developers to folder. Also performed Deployment/Code Migration of ETL codes across various Environments and servers.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 10.0.0. Played lead role in Informatica Upgrade project and Installed, Configured and Upgraded Informatica from 9.5.1 to 10.0.0.
• Worked as Lead developer on high visibility projects utilizing Informatica 10.1.0 installed on Cloud Based Azure.
• Articulate and communicate effectively in fast paced Agile /Scrum based system, facilitated SCRUM ceremonies like Backlog Story Grooming Sessions, Sprint Planning Meetings, Daily Stand-Up Meetings and Sprint Reviews.
• Used JIRA for issue tracking, User Story management and Requirement Traceability. Also used for defining the scope of development work by prioritizing based on deadlines and level of effort.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Flat Files, CSV files, XML files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, Oracle PL/SQL.
• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading. Also performed Performance Tuning at Database levels using Indexes , Hints and Partitioning .
• Experienced to work as Production Support person in resolving on-going maintenance issues and bug fixes. Also handled critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experience in using the Informatica command line utility (PMCMD) to schedule and control sessions and batches.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Worked with complex type mappings with xml source and targets.
• Worked with Informatica Power Exchange in real time Change Data Capture environment to extract data from Operational System using PWX LogMiner CDC for Oracle.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type 1, Type 2, and Type 3) to keep track of historical data.
• Experienced in using Automation Scheduling tools like Autosys and Control-M and Version Control tool like Subversion and TFS.
• Played Project lead role in Migration project for both Informatica and UNIX. Migrated Informatica from Version 7 to version 8.3 and from version 8.3 to version 9. Also worked on Migration project to convert SSIS code to Informatica. Also Migrated code from Sun Solaris Unix box to IBM Unix box.
• Extensively worked on multiple Informatica versions and installed multiple versions on the same servers (due to business requirements) without impacting performance and availability.
• Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support.
• Sound knowledge of Relational and Dimensional Modeling techniques of Data warehouse concepts and principles (Kimball/Inmon) - StarSchema, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Skilled at managing, organizing complex projects, defining project priorities, delegating tasks and mentoring developers.
• Conducted internal project oriented sessions for testing team on ETL logic implemented and assisting them in creating Unit Test Plans and Test Cases and Deployment documents.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

TECHNICAL SKILLS:

Informatica Power Center: 6.x/7.x/8.x/9.x/10/10.1.0, Informatica Power Exchange 9.x, Informatica Power Exchange CDC for Oracle, Hyperion Financial Data Quality Management 9.x., SSIS

Oracle: 11g//10g/9i/8i/7.x, SQL server 2012/2014, Microsoft Access, DB2 8.1

UNIX, Linux, DOS, Windows XP/: 2003/2000/2008 / NT, Windows 7, Windows 10

SQL, PL/SQL, Unix Shell Programming,: C, MS-Excel, Basic, COBOL.REPORTING and ANALYSIS Tool Business Object6.x, Hyperion Financial Management 9.x, OLAP HFM Financial reporting . VERSION CONTROL System PVCS, Tortoise SVN(Subversion), TFS(Team Foundation Version), Microsoft Visual Source Safe JOB SCHEDULING Tool

Autosys, ControlM: GUI Tools

Toad, SQL Developer, PLSQL Developer, WinSQL,: SharePoint, TFS, Visual Basic, Visual FoxPro, ASP, Microsoft Visio WEB TECHNOLOGIES HTML, JavaScript, XML METHODOLIES

Agile/ Scrum:, Waterfall, Data Warehouse and Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Southborough, MA

Sr. ETL/Informatica developer

Responsibilities:

• Worked in Health care domain like Medicare, Medicaid and Insurances compliance within HIPAA, PHI regulation and requirement.
• Lead developer on high visibility projects utilizing Informatica 10.1.0 installed on Cloud Based Azure VMs running on a Windows 2012 R2 Platform.
• Define, design, implement, improve, and support ETL solutions for OLTP, ODS and Data Warehousing projects.
• As a Lead, worked as an individual contributor, leading individual efforts but at the same time manage, monitor off-shore and peer developer team. Set up their account, manage and delegate work, gave them guidance and helped them prevent their road block, Conduct regular status meetings, conduct code reviews and evaluate work of team members.
• Train and Manage developers, advising other groups in organization on Informatica development, data warehouse development and ETL development best practices.
• As a Lead, work with senior management and business partners on multiple technology initiatives, gather requirements, provide estimates and deliver the projects related to the warehouse, ETL and database.
• Worked in integrating data coming from various domain like Claim, Gateway, Legacy system and from various data sources like Oracle, SQL server and non-relational sources like, XML file, flat files into staging area and then from Staging area to Oracle, XML and Flat Files.
• Worked with complex type mappings with xml source and targets.
• Created reusable transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, Java transformation and Rank and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Worked in managing Stored Procedures, Functions, Views and Triggers, complex SQL queries.
• Articulate and communicate effectively in fast paced Agile /Scrum based system, facilitated SCRUM ceremonies like Backlog Story Grooming Sessions, Sprint Planning Meetings, Daily Stand-Up Meetings and Sprint Reviews.
• Used JIRA for issue tracking, User Story management and Requirement Traceability. Also used for defining the scope of development work by prioritizing based on deadlines and level of effort.
• Performed performance tuning, debugging and error handling of mappings, sources and targets for better performance.
• Involved in Code Migration into different environments based on Testing Requirement.
• Performed the unit, Integration and system testing. Assisted in building UAT Test Scripts and provided support to the end-users test performed in UAT.
• Experience in creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts, etc. to production.
• Used Microsoft TFS to track Code changes.
• Worked on Service related tickets and problem tickets and identified the root cause for the business issues raised and provided enhancements and fixes in the current codes and gave a permanent resolution to the issue
• Continuously improve control processes, ensuring data integrity, quality, standardization, and security throughout the ETL process.
• Responsible for maintaining necessary documentation for design, development, testing, deploying and production support.
• Support production solutions and the ongoing updating and maintenance of our Data Warehouse.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Participate in project planning sessions, working closely with business analysts and team members to fully understand and analyze business requirements.
• Work in a fast paced environment, on multiple concurrent projects, manage conflicting priorities.

Environment: Informatica Power Center 10.1.0, Oracle 11g, SQL Server 2014 Management Studio, Agile/Scrum Methodologies, Microsoft Azure, Microsoft Visual Studio 2012, SQL/PLSQL, SQL Developer, PLSQL Developer, TFS, ControlM, Windows 10, MS Office Suite.

Confidential, Wellesley, MA

BI Team Lead/ Product Engineer (ETL-Informatica)

Responsibilities:

• My primary responsibility is Informatica application development and administration within DEV, TEST, PROD and DR (Disaster Recovery) environments at Eagle ACCESS for both dedicated and multi-tenant MicroStrategy client deployments.
• Manage and Monitor Offshore team and provide daily oversight and direction for offshore team for any Informatica development.
• Manage and monitor onsite development team and Analyze, remove and proactively prevent roadblocks across teams to meet quality standards, project milestones and business objects.
• Involve in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Create complex mappings using various tools in Informatica Designer like Source Analyzer, Mapplet Designer and Mapping Designer.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Optimizing performance tuning at source, target, mapping and session level
• Worked on Migration project to convert SSIS code to Informatica. Analyzed old SSIS code and convert SSIS code to Informatica and also modified SSIS code for testing purpose and execute SSIS job to validate results with Informatica.
• Played lead role in Informatica Upgrade project and Installed, Configured and Upgraded Informatica from 9.5.1 to 10.0.0
• Participate in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Handle production issues and outlined backup of Informatica environment. Identify root cause and implement resolution for production processing issues.
• Provide Informatica Admin task also like Setup and administer PowerCenter security, adding new users, Restrict permission etc.
• Work with different Client and Vendor.
• Assist with forecasting and planning for both applications functionality and capacity requirements in a rapidly growing, changing and complex environment.
• Define and implement best practices to deploy, configure, and migrate Informatica components and code in all Eagle ACCESS environments in support of multiple client projects.
• Help define the approach to enable client-specific extensions of core Informatica assets across the entire project life cycle.
• Participate in impact assessments for major releases, service packs, and patches (as needed) for all Informatica products from a system perspective; planning and executing installations/upgrades following organizational standards (e.g. SLAs, audit trail, ability to rollback, etc.).
• Coordinate prioritized support for all escalated activities.
• Maintain cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise.
• Define Disaster Recovery procedures for all Informatica components and conduct tests consistent with Eagle ACCESS best practice.

Environment: Informatica Power Center 10.0.0, Oracle 11g, SQL Server 2012 Management Studio, Microsoft Visual Studio 2012, SSIS, SQL/PLSQL, SQL Developer, PLSQL Developer, TFS, Windows 7, MS Office Suite.