Informatica Developer
Resume:
adchtn@r.postjobfree.com
Srinivasan Jeyakumar
Professional summary
Srinivasan Jeyakumar has around the 12 Years and 9 Months of professional work experience in Information Technology.
He has worked ETL Tools (Informatica Power Center 10.x/9.x), Databases (Oracle 10g/11i, DB2, VSAM, ADABAS, MS SQL server), Mainframe Technologies (COBOL, JCL, NATURAL, CICS),, Data Modelling (Star Schema, Snowflake Schema), Supporting Tools (Tidal, Control-M, CA7, CA-View, Endevor, Panvalet, File Aid, File Manager, QMF, Toad, Service Now, Autosys, DBVisualizer, Raven, SQL Server Management Studio), Project Tools (Jira). He was proficient with Waterfall and Agile Software Development Life cycles. He is conversant with quality standards and procedures, while executing his projects. He has good knowledge of Cards, Telecom, Manufacturing and Investment Banking, Insurance, Retail Business Domain.
In the first phase, he was worked for Mphasis an HP Company for various projects. He had also worked in Mphasis an HP Company, Australia, as an Onsite Coordinator. In the second phase, he was worked for Tech Mahindra for Nissan North America’s Inc., Later he worked for W/H/I/P Systems LLC D/B/A Aroghia Systems LLC for clients T.Rowe Price and H&R Block. He is working for Compunnel Staffing Inc., for Client Anthem Inc.,
Achievements
Received the various appreciation like Spirit of Winning, Star of the Month, Pat on the Back, Associate of the Month across the account and Organization level in Mphasis and Tech Mahindra
Education
Degree
University
Year of Passing
B.E (Electronics and Communication Engineering)
Anna University, Chennai, India
03,2006
XII (HSC)
Tamil Nadu State Board
03,2002
X (SSLC)
Tamil Nadu State Matriculation Board
03,2000
Certifications & Trainings
NA
Technical Skills
Software Development Methodologies
Waterfall, Agile
Operating Systems
Windows 2003/2000/NT, Linux
ETL Tools
Informatica 10.x/9.x (Power Center) (Mapping Designer, Workflow Manager, Workflow Monitor)
Languages
COBOL, JCL, CICS, NATURAL, Unix Shell Scripting, Python, Hadoop, YARN, SQL, PL/SQL
Databases
DB2, VSAM, ADABAS, Hive, Oracle 11i/10g, MS SQL Server
Data Modelling
Star Schema Modelling, Snowflake Modelling
Support Tools
BMC Control-M, CA-7, Endevor, Panvalet, File Aid, File Manager, CA-View, RTLS, QMF, BMC Remedy User, Service Now, HP Quality Center, Jira, DB Visualizer, SQL Server Management Studio, Tidal
Domain Knowledge
Manufacturing, Telecom and BFSI – Credit Card, Investment Banking, Retail, Insurance
Functional Skills
Management & Leadership Skills
Worked at the client location to coordinate with Business User and offshore team.
Lead 10+ members team as a Senior Analyst, preparing program specifications and provide Estimate to client, preparing regular status reports, task allocation, guiding the team Functionally and Technically.
Training & Development
Have successfully trained more than 10 resources as a senior member of Team.
Brief of Key Projects
Client: Anthem Inc., Norfolk, VA
Duration – Dec 2019 – Present
Role – Informatica Developer
Environment:
ETL – Informatica Powercenter
Databases – MS SQL Server
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Extracted data from relational databases SQL Server, Oracle
Loaded the Data into Relational Databases SQL Server, Oracle
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
Developed and implemented the Slowly changing Dimension Type 1 and Type 2
Developed and implemented the Star Schema Data Mart
Performance tuned the Informatica Mappings with the help of Pushdown Optimization
Created the Scripts to execute the SQL Statements
Written T-SQL Stored Procedure to used in the Pre/Post-SQL session
Loaded data into target database using the Target Load Order Plan and Constraint Based loading
Client: H&R Block, Kansas City, Missouri
Duration – Apr 2019 – Nov 2019
Role – Informatica Developer
Environment:
ETL – Informatica Powercenter
Databases – MS SQL Server
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Extracted data from relational databases SQL Server, Oracle
Loaded the Data into Relational Databases SQL Server, Oracle
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
Developed and implemented the Slowly changing Dimension Type 1 and Type 2
Developed and implemented the Star Schema Data Mart
Performance tuned the Informatica Mappings with the help of Pushdown Optimization
Created the Scripts to execute the SQL Statements
Written T-SQL Stored Procedure to used in the Pre/Post-SQL session
Loaded data into target database using the Target Load Order Plan and Constraint Based loading
Developed the New Data mart to support the Associate based reporting. Datamart created from Staging databases.
Developed the New Operational Data Store (ODS) to GUI application to query the Associate Related information
Developed the ETL process to support the migration of legacy application to Work-Center.
Client: T.Rowe Price, Colorado Springs, Colorado
Duration – Aug 2018 – Apr 2019
Role – Informatica Developer
Environment:
ETL – Informatica Powercenter
Databases – DB2, Oracle
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Extracted data from relational databases DB2, Oracle and Flat Files.
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
Automated the Year-end Tax Audit system and reporting from Ms Access to Informatica Power center
Convert the report file (.txt) to .csv format to process audit system
Compare the Report file(external) with the Internal report file and report the discrepancies on based on accounts, Funds
Created and tested the SFTP connection using Sterling
Created the Autosys jobs to schedule and execute the Informatica Workflows
Organization: Tech Mahindra America’s Inc.,
Role: System Analyst
Client: Nissan North America, Franklin, TN
Duration – Jan 2016 – Aug 2018
Environment:
Mainframe – COBOL, JCL, VSAM, Natural, CA-7
ETL – Informatica Powercenter, Data Modelling
Databases – DB2, ADABAS, Oracle, MS SQL Server
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Extracted data from relational databases DB2, Oracle and Flat Files.
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Served as a point of contact for the ETL testing, attend business, project and defect meetings with the development and the end-users to review and resolve the issues.
Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin
Worked in Onsite/Offshore model and coordinated with offshore team.
Adding requirements into Quality Centre, Mapping Requirements with Test cases.
Documenting defects in Quality center Uploading all necessary information into Share point.
Worked closely with UAT team.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
Managed the Metadata associated with the ETL processes used to populate the data warehouse.
Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
Organization: Tech Mahindra Ltd., India
Role: Senior Analyst
Client: Nissan North America, USA
Duration – Jul 2013 – Dec 2015
Environment:
Mainframe – COBOL, JCL, VSAM, Natural, CA-7
Databases – DB2, ADABAS
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Worked in Onsite/Offshore model and coordinated with onshore team.
Served as a point of contact to attend project and defect meetings with the development and the end-users to review and resolve the issues.
Adding requirements into Quality Centre, business Requirements with Test cases.
Documenting defects in Quality center Uploading all necessary information into Share point.
Worked closely with SIT team.
Analysis of the specifications provided by the clients
Design and Development of Mainframe applications for business needs
Database management and SQL
Responsible for overseeing the Quality procedures related to the project.
Handling Batch Support effectively & seamlessly.
Carrying out effective enhancement work
Organization: Mpahsis an HP Company
Role: Senior Software Engineer
Client: Telstra, Australia
Royal Bank of Scotland, India
Duration – 05/2007 – 06/2013
Environment:
Mainframe – COBOL, JCL, VSAM, Control-M
Databases – DB2
Responsibilities:
Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
Worked in Onsite/Offshore model and coordinated with onshore team.
Served as a point of contact to attend project and defect meetings with the development and the end-users to review and resolve the issues.
Adding requirements into Quality Centre, business Requirements with Test cases.
Documenting defects in Quality center Uploading all necessary information into Share point.
Worked closely with SIT team.
Analysis of the specifications provided by the clients
Design and Development of Mainframe applications for business needs
Database management and SQL
Responsible for overseeing the Quality procedures related to the project.
Handling Batch Support effectively & seamlessly.
Carrying out effective enhancement work
Personal Details
Name
Srinivasan Jeyakumar
Email Id
adchtn@r.postjobfree.com
Passport No.
M3794804 – Valid Upto 20th Nov 2024
Visa
H1B Valid Upto 22nd Jan 2022
Residential Address
1715 Birch Trail Circle, Apt # C, Chesapeake, VA - 23320
Mobile
Contact this candidate