SUMMARY

• Over 11 years of experience in full life cycle development (SDLC) of middleware, Data warehouses (Analysis, Design, Modeling, Development, Implementation and Testing) as an ETL developer, Informatica Team Lead and Data Integration/Migration Lead.
• Solid understanding and Development experiences in Data Warehousing, Business Intelligence, Data Migration, Data Integration, using various RDBMS (Oracle, MS - SQL Server, DB2, MySql) and other applications.
• 4 years of leadership experience in architectural design, technical decision-making and solution estimation. Architected and developed solutions for highly scalable, highly available systems
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Conversion using ETL tool like Informatica, SSIS and SSRS.
• Excellent withInformaticaPowerCenter 10.1/ Data explorer/ PowerExhange/ MDM/ Studio/ B2B Data exchange
• Strong presentation skills with the ability to take very technical concepts and present them to non-technical teams
• Participate in technology leadership meetings to provide feedback and recommendations to other leaders
• Expertise in scoping and creating agile release for projects
• Spear-headed different initiatives like organizing knowledge sessions, creating knowledge repositories, reference checklists and templates for sharing knowledge and mentoring junior developers
• Professional experience using advanced SQL coding in various platforms, such as Oracle, Teradata and SQL server for data mining and report generation.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Extensive expertise in creation and automation of workflows using Autosys.
• Managed onsite-offshore model and coordinated with SMEs and project managers.
• Provided technical oversight and guidance during client’s engagement execution
• Worked with the Production Support team during month-end cycles to troubleshoot failures, provide workarounds and perform RCA for the bugs identified during the batch processing.
• Worked with the Production Support Team during the Production Release cycles and provided support for the release.
• Proficient in troubleshooting and fixing the bottlenecks in performance
• Supported Informatica admin activities in all environments and migrated the code from one environment to another.

TECHNICAL SKILLS

ETL: IICS (Informatica Intelligent Cloud Services), Informatica PowerCenter

Middleware: SeeBeyond e*Gate/ SRE 505

Scripting: LINUX shell scripting

Applications: Salesforce

Cloud Technologies: Amazon AWS, S3

Databases: Oracle, Teradata, DB2, MS SQL Server

Job scheduling: AutoSys, CA Workload Automation

Modeling Tools: MS Visio 2010/2013, Erwin

Version control: SVN

Project Tracking: Jira

Ticketing tools: ServiceNow, BMC Remedy, HP Open View, SM7

Domains: Healthcare, Publisher, Communication

PROFESSIONAL EXPERIENCE

Confidential, Branchburg NJ

Lead Informatica Developer

Responsibilities:

• Periodically met with the client team, gathered, documented and analyzed Business requirements. Developed detailed design documents and mapping documents.
• Handling the team members to make them to complete assigned tasks.
• Should be able to Test the initial setup with one initial DX process agreed upon by client and vendor in coordination with B2B developers.
• Should have strong DX experience.
• Strong Informatica Power Centre Knowledge or desirable experience in Informatica B2B Data Exchange, DIH and Health care domain.
• Install and register the set of transformations that you use in Power Center workflows to process B2B Data Exchange documents.
• Weekly status update to customer on project status.
• Preparing estimations for new/enhancement.
• Manage and archive B2B data exchange events.
• Working on the developing the mappings in Informatica 10x according to the user requirements.
• Working on creating the Script for the mappings, thus automating the process
• Create and manage B2B data exchange scheduler.
• Installed and configured webMethods 7.1.2.
• Responsible for coordinating capacity planning results across teams for the WebMethods applications to identify the necessities of Re-engineering the integrations and improving the webMethods platforms efficiency and throughput.
• Working on each of the release activities and thus implementing the business requirements
• Fine tuning and modifying the script in such a way to accommodate the release activity changes.
• Implementing a generalized method of scripting and mapping for around 46 countries, which was an achievement in a way that helped Client to save around 2 million dollars, thus providing a value add
• Made a notification system in UNIX shell scripting, providing the business the details of the interface run
• Worked on the adhoc activities, as and when required according to the business needs
• Provides support to the users on the salesforce activities
• Worked in the SAP connectivity to Informatica, where by extracting the data directly from the SAP open hub tables and then to load to Salesforce.
• Providing Knowledge transfer regarding the application to the AMS team
• Documenting the process and application flow

Environment: Informatica PowerCenter 10.4, Informatica Cloud (IICS); Informatica B2B Data Exchange 10.2,Oracle, MS SQL Server, PL/SQL, Salesforce; AutoSys; LINUX, Shell Scripting webMethods Broker, BAM.

Confidential

Informatica Developer

Responsibilities:

• Periodically met with the client team, gathered, documented and analyzed Business requirements. Developed detailed design documents and mapping documents.
• Implemented Slowly Changing Dimensions (SCD2). Used Type 2 dimension to keep the history changes.
• Developed Code review checklists to ensure consistency across the codebase and to reduce technical debt
• Supervising the whole conversion process for all rehearsals/cycles as Data Migration/Integration lead.
• Implemented different techniques to improve the performance in Informatica level.
• Used Push down Optimization for better performance. Even used TPT for better performance.
• Developed mappings to connect Salesforce using Salesforce Adaptor
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the external applications in the form of flat files, XML files and relational tables. Most of the extract process was incremental, while others were full loads and snapshots.
• Understand Functional requirements by analyzing the functional documents
• Designed dataflow layout for the project through AutoSys to run all the jobs smoothly.

Environment: Informatica PowerCenter: 9.6, Oracle, MS SQL Server, PL/SQL, DB2, Teradata; AutoSys; LINUX, Shell Scripting.

Confidential

SeeBeyond Senior Developer

Responsibilities:

• Analysis of the specifications provided by the clients and mapping them to the technical requirements.
• Working with the Architecture team to get the required databases and SeeBeyond environment set up.
• Developed and enhanced multiple custom UNIX scripts.
• Created Functional specifications and testing documentations
• Coordinated and worked on releases to migrate code from multiple environments into Production.
• Performed unit testing and identified the gaps between the functional requirements and schemas and fix bugs if any. Worked closely with the Business to provide demos and provide the required support for the POC schema for UAT.
• Documented the known issues and roadblocks for the development of the actual interfaces after the POC interfaces have been approved.
• Supported batch in SIT, UAT, Regression testing, also in production parallel and post go live warranty period support.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Performed the code reviews involved fixing high priority issue by supporting the application and made the application Successfully moved to Steady state

Environment: SeeBeyond eGate, SRE 505, Oracle 10g, SQL Server; PL/SQL; HP Open View; UNIX, Shell Scripting.

Confidential

SeeBeyond Developer

Responsibilities:

• Developed Schema's to implement the business requirement
• Working with the Architecture team to get the required databases and SeeBeyond environment set up.
• Interacts and worked along with other vendors to in corporate any enhancements..
• Created Functional specifications and testing documentations
• Worked on Change Requests as per customer requirement.
• Performed unit testing and identified the gaps between the functional requirements and schemas and fix bugs if any. Worked closely with the Business to provide demos and provide the required support for the POC schema for UAT.
• Understanding and Analysis of issues raised by client and act proactively based on the priority.
• Supported batch in SIT, UAT, Regression testing, also in production parallel and post go live warranty period support.
• Effectively worked to provide the root cause and solution for permanent fix.
• Performed the code reviews involved fixing high priority issue by supporting the application and made the application Successfully moved to Steady state

Environment: SeeBeyond SRE 505, Oracle 10g, SQL Server; PL/SQL; HP Open View; UNIX, Shell Scripting.

Confidential

SeeBeyond Developer

Responsibilities:

• Interacts and works along with other vendors to in corporate any enhancements.
• Communicated effectively with clients to identify the problem area.
• Understanding and Analysis of issues raised by client and act proactively based on the priority.
• Created Functional specifications and testing documentations
• Worked on Change Requests as per customer requirement.
• Documented the process and application flow Tools and Technology used
• Effectively worked to provide the root cause and solution for permanent fix
• Worked on a client requirement with flexible time

Environment: SeeBeyond e*Gate 4.5.3, SRE505, Oracle, SQL Server; PL/SQL; SM7 ticketing tool, UNIX