♦ Having 6 years of experience as senior Informatica developer in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
♦ Having 1.8 years of experience as Business Analyst role for Functional requirement document writing, helping to resolve the Development and production issues in BNYMELLON.
♦ Working with UAT testing, Business approval and sign off for the project.
♦ Strong proficiency in the full life cycle of Business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.
♦ Hands on experience in ETL tools Informatica 10, 9.1 and 9.6 having more experience in developing the complicated mappings (Designer, Workflow Manager and Workflow Monitor) and Informatica support activities.
♦ Worked in DB2 using QMF
♦ Having experience in Teradata Data warehouse using SQL assistant.
♦ Experience in handling oracle data using SQL and PLSQL (Stored Procedures, Functions, Packages, Database triggers).
♦ IBM Cognos 10 BI author certified in 2013.
♦ Experienced in development and design of reports using Power BI and IBM Cognos Business Intelligence components like Report Studio, Query Studio and Analysis Studio.
♦ Complete implementation of the SDLC life cycle in the projects.
♦ Proficient in full life cycle design and development of Business Objects reporting Applications.
♦ Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
♦ Strong experience in client interaction and understanding business application, business data flow and data relations from them.
♦ Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
♦ Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
♦ Excellent experience in problem solving and supporting application.
♦ The ability to work independently and as part of a team with the ability to manage time and resources to meet assigned deadlines.
Working as Business analyst and Senior Informatica developer in BNYMELLON international operations India pvt ltd, in Chennai from September, 2017 to till now.
Worked as Technical lead and senior Informatica developer in IGATE (CAPGEMINI) in Chennai from April,2012 to September,2016
M.S (software engineering) in Birla institute of Technology, Pilani in duration of 2012 to 2014
B.E (Computer Science & engineering) in Jeppiaar Engineering College, Chennai in duration of 2007- 2011
Data warehouse and Business Intelligence
Informatica 10,9.x, SQL/plsql developer, SQL assistant
Unix and windows
Database & Data warehouse
DB2, Oracle, Teradata
IBM Cognos BI,AWS insight, Tableau
Certifications done: IBM Certified Cognos BI author.
The BNYMELLON is world largest custodian bank and provide single point solution for all the bank needs and providing services like asset managements, credit services, security management and etc.
Project Names – Wilshire, William Blair, Thomson Reuters, JP Morgan, Standard and Poor, BMO, FTSE TMX
Duration – September 2017 to till now
Role – Business analyst and senior Informatica developer
Project details – Load the index data from the vendor and send to the customer using Informatica
Project activity- working with Requirement gathering with business clients, Creating FRD, getting FRD Approval, working File transmission team, Developing Informatica mapping, Vendor set up and file automation set up, System testing, UAT testing and business sign off for the project and production support.
Tools and Tech used – Informatica, DB2 and Windows server
The General Electric Company is a multinational American technology and services conglomerate incorporated in the State of New York. In terms of market capitalization as of September 30, 2008, GE is the world’s third largest company and also second in the BrandZ ranking.
Project Name – CSA DATA Shop, WAWF-data load,ICAM2ODS
Duration – January 2014 – September 2016
Role – Technical Lead
Project details – Load the shop visit data to Bigdata from Oracle using ETL
Project activity- Creating informatica mapping, data warehouse development and Big data analysis.
Tools and Tech used – Informatica, Oracle ,Teradata, Unix and spot fire
Project Name – FDM-Fleet Data Management, FDM Reports
Duration – August 2012 – December 2013
Role – Senior software engineer
Project details – Maintaining the Fleet and Engine data details
Project activity- Load the flat file and Oracle data to Data warehouse using Informatica and shipment data analysis.
Tools used – PLSQL, Informatica, cognos, Oracle, Teradata and UNIX
Technical Lead Responsibilities
♦ working with Requirement gathering with business clients, Creating FRD, getting FRD Approval
♦ Working File transmission team, Vendor set up and files automation set up.
♦ System testing, UAT testing and business sign off for the project and production support.
♦ Provide technical solution to developers before preceding the construction
♦ Having the all the process related artifacts updated in Configuration Management system
♦ Guiding all the module owners during complex development tasks and increasing the value add counts with proper client approvals
♦ Prepare daily status report and update the project team and onsite Business team
♦ Gather requirements for upcoming projects and provide estimates
♦ Involved in understanding the Requirement from the project Business Analyst
♦ Prepared the High-level and Low-level design documents
♦ Worked with customer for the Testing and Production move.
♦ Co coordinating with customer for the Product support activity.
♦ Leading and tracking the team activity about the project and status update with customer.
♦ Maintaining and following Project tracking and Project estimation, task and metric creations.
♦ Attending training and helping the team with technical and non-technical activities in Project.