ETL informatica developer
Resume:
Sundar Rajan Sanjeevi Jayachandran
Mail: *********@*******.***
Phone: 651-***-****
PROFESSIONAL SUMMARY
Results-oriented, Talented professional with over 12 years and 9 months of visible achievements in both customer-driven and technological industries, facilitated development of Business Intelligence/Data Warehouse systems, provided BI expertise, designed and developed data models by translating user requirements into data flows and data mapping.
For 8 years I lead overall ETL processes and architecture, performed build, tested and deployed activities related to BI and data warehouse implementations with Informatica Power Center 9.5.0,9.1.0, 8.x, 7.x, and 6.x (Workflow Manager, Workflow monitor, Warehouse Designer, Source Analyzer,Repository manager, Informatica server), SQL, PL/SQL, Stored Procedures. Experienced in using parameter files, mapping parameters in mappings. Teradata 13, DB2, SQL server, ETL process.
Extensively worked on Teradata database including TSQL, BTEQ, Multiload, Fastload, Fastexport. Hands-on experience in performance tuning of queries.
Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools.
Proven experience in Unix Shell Scripting in different projects.
Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
Design and engineer solutions leveraging all appropriate components offered by ServiceNow to answer the needs for business workflows, ticketing or other ITSM requirements
Experience in Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.
Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.
Extensive knowledge of the entire Software Development Cycle right from Requirement Gathering, Converting Business requirements into Technical specifications, Impact Analysis, Root cause Analysis for problems or incidents, Estimation, Design – High Level and Detail, Code development, Maintenance, and support, Unit testing and Integration Testing to User Documentation.
Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.6.1, 9.5.0, 9.1.0, 8.x, 7.x, and 6.x,
WherescapeRED, TSQL, BTEQ, Multiload, Fastload, Fastexport,TPT
Databases: Oracle9i/10g/11g, Teradata 12, 13, 14, DB2 UDB,.
Scripting Languages: Unix Shell script, HTML
Methodologies: Agile, SDLC
Version Control: MS Visual Source Safe (VSS), IBM Rational clear case
Modelling Tools: MS Visio, Erwin
Scheduling Tools: SeviceNow
Operating system: Microsoft XP professional, Microsoft server 2000, UNIX.
Office Tools: MS Word, MS Excel, MS PowerPoint, MS Access, Outlook.
EDUCATION:
Qualification: Bachelor of science in Computer Science.
University: University of Madras.
PROJECT SUMMARY
Healthcare Services Corporation, USA
Project: Application Value Management
Environment: DataStage, Teradata, Zena Scheduler, MS Access
Role: Team Lead & Developer
Period: Jan 2017 – Till date
Description: AVM project aims in providing added value to existing applications in Healthcare Services Corporation (HCSC). The applications are various domains in Healthcare; The Integrated Data warehouse (IDW) holds the transactional data backup in the form of tables. AVM portfolio handles monitoring of all application loads to Teradata tables, Incident management, data quality validation, enhancement activities, and administration of Teradata database and Datastage server.
Role and Responsibilities
Debug and troubleshoot production environment application issues.
Handling of Error and its logging.
Maintaining various Data stage sequencer jobs
Operation & Maintenance - Testing of all break fixes and new business requirements that would be occurring for each release.
Interaction with QA and BA team to resolve the issues.
Raising clarification and following it to closure.
Had additional responsibility in ensuring quality, technical guidance, and code review.
Involved with Clients in requirement gathering.
Unit testing the code and Regression testing the ETL process.
Blue Cross Blue Shield of Minnesota, USA
Project: Protegrity
Environment: Informatica, Wherescape, Teradata SQL Assistant, Clear Case, ORACLE, Teradata
Role: Team Lead & Developer
Period: Jan 2016 - Dec 2016
Description: BCBS MN will protect its Data Warehouse data by applying a process of substituting PHI and other sensitive data elements with non-sensitive equivalents. The data substitution is referred to as token which has no exploitable meaning or value. The token is a data value that actually derived through an encryption process, however it maps back to sensitive data through a tokenization system.
Role and Responsibilities
Coordinating with Business users to identify the complexity and impact of tokenizing the PHI column.
Perform a detailed analysis on the PHI column that needs to be tokenized.
Perform downstream analysis to make sure the tokenized values is propagates all the way to the base layer.
Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager.
Created complex Informatica mappings using SQL Override, Stored Procedure, Expression, connected Lookup, Joiner, Rank, Source Qualifier, Sorter and Aggregator transformations to extract, transform and loaded data to staging / base layer.
Designing, Coding, Testing, scheduling and implementing project using Informatica and Wherescape RED.
Building production release plan and bundling the code package for production deployment.
Operation & Maintenance - Testing of all break fixes and new business requirements that would be occurring for each release.
Unit testing the code and Regression testing the ETL process.
Resolving SIT, UAT and Production issues.
Debug and troubleshoot production environment application issues.
Providing Knowledge transition to production support team.
Providing post production support.
Project: OMT (Operation Model Transformation)
Environment: Informatica, Wherescape, Teradata SQL Assistant, Teradata, FASTLOAD, BTEQ, MULTILOAD
Role: Team Lead & Developer
Period: Jun 2014 – Dec 2015
Description: This project involved loading the data that is received through files and transforming based on the requirement for outbound extracts. These extracts will be sent out to different external vendors to include new Highmark data along with legacy systems BCBS data in combined manner. During the transitioning phase a merged solution would be implemented between the current BCBS data warehouse and migrated data in Highmark.
Role and Responsibilities:
Interacting with Business users to identify their requirements and deliver results appropriately.
Transforming business requirements into technical specifications and source-to-target mappings.
Extensively worked on Informatica mapping (Source Qualifier, Filter, Expression, router, Aggregator, Connected & Unconnected Lookup, Flatfiles, Csv Files)
Involved in creating SCD TYPE I and SCD TYPE II mapping.
Extensively worked with Informatica – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
Designing, Coding, Testing, scheduling and implementing project using Informatica and Wherescape RED.
Unit testing the code and integration testing the ETL process.
Operation & Maintenance - Testing of all break fixes and new business requirements that would be occurring for each release.
Resolving SIT, UAT and Production issues.
Debug and troubleshoot production environment application issues.
Building production release plan and bundling the code package for production deployment.
Providing Knowledge transition to production support team.
Providing post production support.
Project: Application Value Management (AVM)
Environment: Informatica, Wherescape, Unix Shell scripts,Teradata, Oracle, Clear case, Teradata SQL Assistant,Teradata, FASTLOAD, BTEQ, MULTILOAD
Role: Team Lead & Developer
Period: Jun 2009 – May 2014
Description: AVM project aims in providing added value to existing applications in Blue Cross Blue Shield of Minnesota (BCBS-MN). The applications are various domains in Healthcare; The Integrated Data warehouse (IDW) holds the transactional data backup in the form of tables. AVM portfolio handles monitoring of all application loads to Teradata tables, Incident management, data quality validation, enhancement activities, and administration of Teradata database and Informatica server. The production support of BCBSMN comes in three phase namely wave 1, 2 & 3. Each wave has list of application and jobs associated with an application, these Jobs runs basically on Mainframes and Informatica. All jobs are interdependent and timed to run through schedulers.
The successful run of these applications takes care of transactional data getting backed up in Data warehouse for various domains in healthcare for BCBSMN.
Role and Responsibilities
Analysis of Specification document and mapping document.
Raising clarification and following it to closure.
Created Technical Design and UTC for the ETL Informatica mapping validation.
Involved in Implementation, reviews and Unit Testing.
Handling of Error and its logging.
Interaction with QA and BA team to resolve the issues.
Weekly status reporting to various stack holders of the project.
Had additional responsibility in ensuring quality, technical guidance, and code review.
Ensuring the developed code as per the coding standard.
Involved with Clients in requirement gathering.
Assigned work to offshore team on daily basis and made sure that the project is delivered on time.
Took additional responsibility in delivering on time.
Travellers
Project: Claim TCoE Manual
Tools & Database: Quality Center, DB2
Role: Team Lead
Period: Jan 2007 – May 2009
Description: The CLAIMS project is a development and enhancement project that ensure data quality of various Claims Applications viz., Dispatch, Impact, Tmate, Travpro, ClaimNet, CCA Convertion etc. Services will be available for interfacing the mentioned Claim Handling applications to access/update/add/delete the data. Those services will incorporate business rules that would apply to the overall enterprise. Cognizant will work with Travelers during the requirement phase to define the requirements of these Claims Applications as well as the requirements for the testing of them.
Role and Responsibilities
Understanding the requirements for each module and preparing the Requirement Understanding Document specifying all the functionalities that needs to be tested.
Design the test case for Functional testing.
Execute the test cases in Quality Center and update the status to passed/ failed.
Reporting and closing the defects in Quality Center once the defects are fixed.
United Health Group
Project: UHGI-RIOS
Programming Skills: C, C++, Unix Shell scripts, PowerBuilder
Database: DB2-UDB, MS Access, Visual Source Safe, Crystal Reports
Role: Developer & Team Lead
Period: Aug 2004 – Dec 2006
Description: RIOS is a Healthcare application which provides the tools (subsystems) to administer a managed healthcare product for a very wide range of health plans. Member Enrollment, Claims Calculation, Billing and Reporting are examples of what can be achieved through this system. RIOS application is a three tier client server application. The front tier of the application is designed in PowerBuilder and Java front end. Middle Tier business logic is written in C++ and DB2-UDB as a backend. CORBA and RW are used as infrastructure between front end, business logic and Backend. This project is a unique onsite/offshore project where Major decisions, Client requirements gathering and Client delivery are carried out at onsite while analysis, design, development and testing like functions are carried out at offshore.
Role and Responsibilities
Delivery Lead for UHGI projects. Leading a team of 10 members who work from offshore and onsite.
Account management: Overall UHGI account management activities like resourcing, timesheet maintenance, project proposals and offshore coordination for UHGI projects.
Technical / Production support consultant – Technical and production support consultant for RIOS application.
Requirements and Scoping – Understanding the requirements for each module from the clients and preparing the requirements and scoping document specifying all the functionalities that needs to be developed.
Worked on Six major RIOS Application releases which include two releases from onsite and four from offshore.
Involved in major reengineering of RIOS application and implemented successfully with good performance results.
Operation & Maintenance - Testing of all break fixes and new business requirements that would be occurring for each release.
Contact this candidate