PROFESSIONAL SUMMARY:

• Total 12 years 5 months of experience in analysis, design, development, maintenance and testing in IT industry. Extensive experience in Decision Supports Systems Data Warehousing and implementing ETL using Informatica and also experience in Electronic Data Interchange (EDI) system implementation using Informatica B2B Data Exchange, Data Transformation, Managed File Transfer, EDIFECS, TIBCO tools.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating and production supporting on various platforms like Unix/Linux, Windows.
• Expertise in OLTP/OLAP System Study, analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in Informatica Administration using PowerCenter, B2B Data Exchange, Managed File Transfer,, Power Exchange, Data Integration hub (DIH) and Informatica Data Quality (IDQ)which includes Installation, migration, configuration, maintenance, jobs scheduling, systems monitoring was a constant to insure uninterrupted data and batch job scheduling processing, technical support and troubleshooting of Informatica server implementations in shared and dedicated environments, user access maintenance, folders creation, connections creation, code deployment, Table/view imports, query metadata from repository, code change management, repository backup etc.
• Experience in Data warehousing architecture system end to end data flow design and all types of Dimensions and Facts table data loading mapping development.
• Experience in EDI system administration using EDIFECS 8.x XEngine, XEServer, EAM, HIPAA and X12 guidelines installation and configuration. Develop EDI HIPAA validation Batch and Real-time profiles and integrate with Informatica B2B components.
• Experience in Informatica Data Integration Hub (DIH) components developing topics and applications to publish and subscribe data.
• Well versed in Teradata with Fast Export, TPT, Fast Load, Multi Load and BTEQ.
• Extensive experience with Master Data Management tools Informatica MDM and IBM initiate.
• Developed complex coding objects from varied tools like Informatica Power center, B2B Data Exchange and Managed File Transfer.
• Expertise in developing Informatica B2B Data Transformation suite project scripts Parser, Mapper and Serializer to translate various input/output data file formats.
• Experience in integrate objects SOAP/REST using with JAVA, HTTP and Web Service consumer transformations
• Strong experience in error handling, performance tuning and optimizing the source, mappings, transformations, sessions, and the targets, and expertise using Informatica Debugger.
• Proficient with wide variety of sources like Web Services, JMS, MQ, XML, COBAL, Flat Files, Oracle, Teradata, DB2, SQL Server.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience with writing UNIX shell scripting, and developing complex UNIX Shell Scripts for automation of ETL.
• Having good expose on Big Data Analytics and trained on Hadoop File System (HDFS), HBase and Hive tools.
• Conducted Functionality, Integration, System testing and investigated software bugs.
• Experience working in Agile methodology and ability to manage change effectively.
• Experience in interacting with onsite clients while being responsible for deliverables.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Experience in Customer Relationship Management and addressing customer issues.
• Strong Team working spirit, communication and relationship management skills.

TECHNICAL SKILLS:

Operating Systems: Unix, Linux& Windows

Languages: SQL, PL/SQL& Shell Scripting

Databases: Oracle 11g, Teradata V2R12, DB2, SQL Server

Tools & Utilities: Informatica Power Center 10.1, Informatica B2B Data Exchange, Informatica B2B Data Transformation, Informatica B2B Managed File Transfer, Informatica Data Integration Hub (DIH), Informatica Data Quality (IDQ),Informatica Power Exchange, Informatica MDM, Business Objects Data Integrator, Micro Strategy, SSIS, IBM Initiate MDM, EDEFICS, TIBCO(Foresight), XML, COBAL, Flat Files, Web Services, MQ, JMS, JAVA, SQL Developer and TOAD.

Domain Knowledge: Healthcare, HIPAA EDI transactions experience (270/271, 276/277, 837 I/P/D,835, 834 etc.)and Banking and Financial services

JOB EXPERIENCE:

Confidential, Columbus, GA

Senior Informatica B2B developer

Environment: Informatica Power Center 10.1, Informatica B2B Data Transformation, B2B Data Exchange, B2B Managed File Transfer, MongoDB, MS SQL Server, JMS, Web Services, XML, Excel, CSV, Windows OS

Responsibilities:

• Work as senior Informatica developer in 8 members Agile team, design and development and deliver high quality outcomes for every sprint.
• Collaborate with Business analysts/SME to understand business requirements design, develop and deploy the best solutions to ensure high level of customer service.
• Analysis and design enrollment group benefit data and develop highly complex Informatica power center and Informatica B2B MFT/DX/DT components to process data validation good and bad data separation and reporting data errors, duplicates, orphans to submitters.
• Design and develop interface implementation which integrates submitter portals and client systems using with Informatica B2B managed file transfer and Informatica B2B data exchange components.
• Analysis and Develop Informatica B2B data transformation projects to process unstructured, semi-structured data file formats JSON, ACCORD, IMAX, XML, Excel, CSV, Text formats.
• Work on complex power center mappings using advanced transformations Web service, JAVA, HTTP, XML etc.
• Work on Informatica Data transformation scripts parser/mapper/sterilizer implement various business transformation rules data translation/validation for different file formats.
• Work on performance tuning process large enrollment files using with Informatica best practices and setup components with lowest possible time.
• Design and develop complex SQL queries and windows batch shell scripts which are necessary for file processing.

Confidential, Baton Rouge LA

Informatica B2B Lead

Environment: Informatica Power Center 10.1, Informatica B2B Data Transformation, B2B Data Exchange, B2B Managed File Transfer, Informatica Data Integration Hub (DIH), Data Quality(IDQ), Power Exchange, Informatica MDM, SSIS, MS SQL Server, Teradata, EDIFECS, Web Services, IBM MQ, Windows OS.

Responsibilities:

• Onshore ETL lead and responsible for ETL Informatica design and development.
• Collaborate with Business Analysts/SME to understand business requirements and design system architecture and process flow.
• Work with EDI submitter channels and backend systems requirements and design EDI process architecture and integrating them with Infromatica.
• Understand EDI business requirements including CAQH rules, HIPAA transactions requirements and define mapping cross walks for HIPAA and business specified formats.
• Design and interface implementation which integrates the user portals/ Confidential systems using with Informatica B2B Managed File Transfer components.
• Design and implement Informatica B2B Data Exchange and Informatica B2B Managed File Transfer components for exchange EDI HIPAA transaction data between Trading partner systems and Confidential EDI systems.
• Design and Implement Informatica B2B Data Transformation suite projects like converting any input unstructured data format into required output format using with B2B DT Parser, Mapper, Serializer components and execute them in Informatica Power Center workflows.
• Design and Implement the backend process to translate the inbound file to the backend application format using Batch process and vice versa for outbound files.
• Develop complex Informatica Power center mappings using advanced PC transformations like Java, SQL, HTTP, Web Service Consumer, UDT, DX transformations etc. and JMS, MQ, Web Service source/target.
• Design and build Data modeling EDI HIPAA DW star schema for EDI HIPAA transactions auditing, reporting and reconciliation.
• Design SSIS packages to ETL mappings conversion complex requirements into ETL specifications and develop reusable components, complex EDW dimensions and fact table data load from source to stage and stage to target system.
• Integrate business application and Informatica MDM hub using Batch Process and message queues
• Design and Develop Informatica MDM Hub Batch Process jobs, User Exits, Match rules for TPMS data management
• Develop Informatica Data Integration Hub (DIH) application topics to publish and subscribe from various source system data into EDW system and EDW system to external application systems.
• Provide assistance to Informatica administrator Informatica B2B, Informatica Data Quality and Power Exchange installation and configuration.
• Develop complex SQL queries and Shell scripts which required for EDI transaction tracking/reporting/Error handling.
• Conduct Functionality, Integration, System testing and investigated software bugs. Conduct root cause analysis and resolve production problems and data issues
• Participate in requirements, design, and development reviews. Conduct or participate in meetings with owners of key system components to fully understand EDI systems environments.

Confidential, Dallas, TX

Informatica B2B Lead/ Administrator

Environment: Informatica Power Center 9.6.0, Informatica B2B Data Transformation, Informatica B2B Data Exchange, Informatica B2B Managed File Transfer, Oracle 11g,Linux, EDIFECS, TIBCO

Responsibilities:

• Onshore EDI B2B lead and responsible for EDI Informatica B2B Development, Informatica B2BAdministration and Production Maintenance.
• Estimation, planning and execution with specific focus on EDI requirement analysis and design.
• Collaborate with Business Analysts to understand business requirements, data, and optimize Informatica EDI components performance.
• Design and implementation of HIPAA operating rules requirements and define mapping cross walk for .
• Understand the CAQH rules and HIPAA EDI transactions requirements like 270, 271, 276, 277, 278, 820, 835, 834, 837I/P/D etc.
• Design and interface implementation which integrates the user portal/ state Medicaid system and Informatica B2B Managed File Transfer components.
• Design and implement Informatica B2B Data Exchange and Informatica B2B Managed File Transfer components for exchange EDI HIPAA transaction data between Trading partner systems and EDI State MMIS systems.
• Design and Implement Informatica B2B Data Transformation suite projects like converting any input unstructured data format into required output format using with B2B DT Parser, Mapper, Serializer components and execute them in Informatica Power Center workflows.
• Design and Implement the backend process to translate the inbound file to the backend application format using Batch process and vice versa for outbound files.
• Conduct Functionality, Integration, System testing and investigated software bugs. Conduct root cause analysis and resolve production problems and data issues
• Informatica environment setup installation and configuration. Maintaining Informatica systems software and the runtime environment and plan and apply Informatica software upgrades. Plan and execute deployments across all environments.
• Participate in requirements, design, and development reviews. Conduct or participate in meetings with owners of key system components to fully understand EDI systems environments.
• Perform the analysis for various change requests, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities

Confidential, Charlotte, NA

ETL Lead

Environment: Informatica 9.0.1, Oracle 10g SQL/PLSQL, Natezza and Linux

Responsibilities:

• Onshore ETL Lead and involved in ETL development.
• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Involved in Data warehouse environment architecture design for Stage and Target areas.
• Involved in target data modal requirement analysis, design, ETL source to target data mapping requirement specifications and review.
• Involved in complex requirements of ETL specifications and development for migration objects from PLSQL to Informatica.
• Involved in database table structure creation and data load design for Natezza target database.
• Preparing TSD, HLD and LLD based on BSD and target mapping requirements.
• Conducting walk through on TSD with client tech leads, team leads and data architects and DBAs.
• Conducting weekly status meetings to discuss about the progress in that week.
• Given Technical clarifications and assigned work to offshore team and monitored their work status daily.
• Worked with complex code requirements for data validation and reporting.
• Involved in Shell scripting needed for the ETL development.
• Involved in job scheduling objects creation from DAC to AUTOSYS code migration.

Confidential, Charlotte, NA

Senior ETL Developer

Environment: Informatica B2B Data Exchange, Informatica power center 9.0.1, Oracle 10g, Java and Linux, Web Services

Responsibilities:

• ETL Lead and involved in ETL development.
• Involved in leading team tasks assign to team members, code review, code deliverable and project managerial activities.
• Involved in analysis, design, coding and testing for Informatica B2B data exchange, Informatica power center, Linux and Java coding objects.
• Involved in High level and Low level design documentation for ETL and Java process.
• Analysis of process flows with different tools objects in Informatica B2B data exchange, Informatica power center and Java.
• Involved in coding Informatica B2B data exchange objects Partners, Profiles, Endpoints, Workflows, Event attributes and Statuses based on the input file process flow requirements.
• Involved in Informatica B2B data exchange admin setup.
• Involved in complex Informatica mappings with B2B data exchange, Java, SQL and Lookup transformations.
• Created reusable mapplets using with Informatica B2B DX transformations and Power center transformations for Informatica power center mappings.
• Performance tuning on coding objects in Informatica B2B data exchange, Informatica power center mappings and Java.
• Involved in Informatica B2B data exchange, Informatica power center, Java and Linux coding objects migrations to higher environments SIT, UAT, TEST and PROD. And also defect fixing Informatica B2B data exchange, Informatica power center and Java coding objects.
• Worked with Java developers receive the requirements for Informatica coding and also provide the Informatica related requirements to Java developers.
• Creates Linux shell scripts for the real time data load requirements.
• Trained project resources ASE’s level and Java developers in Informatica B2B Data Exchange, Informatica power center and Linux scripting.
• Quickly learned new tools Informatica B2B data exchange and basic Java.

Confidential

Senior ETL Developer

Environment: Informatica 9.0.1, IBM-Initiate(MDM), Oracle 10g and Unix

Responsibilities:

• Involved in ETL developing for Data loading team.
• Involved in analysis, design, development, testing and review the Informatica code.
• Involved in Fine tunings mappings as a Performance activity.
• Involved in complex mapping coding using with advanced Informatica power center transformations.
• Involved in UNIX shell scripting for the project requirement.
• Trained on IBM-Initiate MDM tool and developed the coding objects for the project requirement.
• Involved in MDM requirement master data analysis, development, testing and migration.

Confidential, Los Angeles CA

Senior ETL Developer

Environment: Informatica 8.6, Informatica Power Exchange, DB2 and Unix

Responsibilities:

• Involved in production support, lead a team of 6 members at Offshore.
• Arrange weekly meetings with the offshore team discuss on production issues and weekly status meetings with client.
• Prepare the roadmap for the completion of tasks and plan to share the work among the team as per each individual capability.
• Involved in production code fixes like Change requests, Bug fixes.
• Responsible for monitoring scheduled Informatica workflows, responding and resolving the issues in production jobs immediately.
• Gathered requirements for the changed components from the business users and Analytics team.
• Involved in performance tuning at source, target and mapping level in production jobs.
• Involved in project documentation for production fixes and code changes and review.
• Reviewing and testing of mappings, sessions, workflows.
• Analyzing the impact and providing the Estimations to Client in production issues.

Confidential, Richmond VA

ETL Technical Lead

Environment: Informatica 8.6, Teradata V2 R12, Oracle, COBAL files and Unix

Responsibilities:

• ETL Technical Lead and Involved in Informatica design and leading a team size of 5.
• Imparting domain and technical knowledge to the new entrants and also fellow team members. Involved in analysis, design phases of the project.
• Analyzed the records which are going to be extract and loading.
• Involved in analyzing the data model from the offshore took the responsibility for delivering the code to the onsite within the time frame.
• Participated in analysis and peer reviews within the team. Involved in coordinating with other team members to get the tasks accomplished
• Responsible to perform the analysis for various change requests, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• Involved in development of Informatica mappings, Teradata BTEQ scripts, UNIX shell scripts, DDL creation and Documentation.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ scripts.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export, Fast Load, MLoad and Tpump.

Confidential, San Mateo CA

ETL Developer

Environment: Informatica 7.1.3, Oracle 9i, Flat Files and Unix

Responsibilities:

• Mainly involved in ETL developing.
• Also responsible to perform the analysis for various change requests, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• Facilitating as a Quality Coordinator by performing all Quality process such as preparing Metrics report, Code Review & Testing.
• Involved in development of Stage, Dimension & fact tables mappings. DML creation and Documentation.
• Involved in Fine tunings mappings as a Performance activity.
• Using ETL Process to Extract, Transform and Load the data into stage area and data warehouse.
• Using Transformations to clean the data from staging area as per the data warehouse requirements.