SPOORTHI K S

adu1ya@r.postjobfree.com +1-904-***-****

https://www.linkedin.com/in/spoorthi-ks-96138574/

Professional Summary

•Over 9+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data warehousing solutions using ETL tools like Informatica Power Center, Informatica Data Quality and reporting tool as OBIEE.

•Proficiency in developing SQL with various relational databases like Oracle, SQL server.

•Knowledge in Full Life Cycle development of Data warehousing.

•Have functional knowledge in applications like SFDC and Zuora.

•Certified in ZUORA from ZUORA University.

•Have extensively worked in developing ETL program for supporting Data Extraction, Transformations and loading using Informatica Power Center.

•Excellent analytical, problem solving skills and a motivated team player with excellent communication and inter-personal skills.

•Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.

•Strong with the relational database design concepts.

•Good knowledge in AUTOSYS, Control-M and DAC scheduling.

•Independently perform complex troubleshooting, root-cause analysis and solution development.

•Good experience in fixing issues as part of data reconciliation between the source and target systems by identifying problems and developing solutions.

•Expertise in handling post go-live production defect fixes or any enhancements from the business.

Skills

Databases : SQL, Oracle 10G/11G/12C, MS SQL Server

ETL Tools : Informatica Power Center, Informatica Data Quality, Oracle Data Integrator

Reporting Tools : OBIEE

Scheduling Tools : Autosys, Control-M,DAC, Active Batch

Programming & Scripting : Unix Shell

S/W Development Methodologies : Traditional waterfall & Agile

Platforms : Windows 8.1, 8.0, Windows 10, Unix/Shell

Education

Bachelor’s in technology, Electronics and Communication Engineering, Pondicherry University, India.

Aug 2008- Apr 2012

Experience

Mediacom Communications

Role: Senior Informatica Developer Apr 2021- Present

The project aims to deliver data warehouse solutions for database migration project from Oracle 11g to Oracle 12c using Informatica Power center as the ETL tool and OBIEE as the reporting tool.

Technical Environment:

Informatica Power Center 10/Toad/Active Batch/Cognos/OBIEE

Responsibilities:

•Develop mappings to load data from source system to Database in the required format.

•Involved in Unit and performance testing.

•Involved in creation of migration documents for code migration as part of deployment activities across different environments.

•Created active batch jobs for automation of informatica workflows.

•Working on production issues on daily basis.

•Solving critical service requests or incidents raised by the business users for data issues as part of testing cycles.

•Coordinated with the OBIEE reporting team to ensure that correct data is present in the reports.

J P Morgan Chase Sep 2019 – Mar 2021

Role: Associate

The project aims to deliver solutions to the client with respect to the Asset and Wealth management line of business . Project focusses on generating trade alerts to the Supervisory manager’s review using Actimize application. Data is flown to Actimize on daily basis using scheduled jobs in Autosys and Informatica Power Center as ETL tool.

Technical Environment:

Informatica Power Center 10/SQL Developer/Unix/JIRA/Intellij/BitBucket/Jenkins/Autosys/Sybase

Responsibilities:

●Creation of Informatica mappings to load data from feed file systems to Database.

●Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Retrospective, Sprint Backlog, 1on1 meeting).

●Involved in Unit testing.

●Involved in code deployments using Bitbucket, Jenkins jobs.

●Involved in testing UNIX scripts and monitoring jobs using Autosys.

●Co-ordinate with multiple data teams to source data from multiple source systems to Actimize using ETL programs.

●Performing timely reconciliation of data between source and target systems using Informatica jobs and shell script.

●Involved in code deployment activities using BitBucket, Jenkins and Jules.

Deloitte Consulting Feb 2019 –Sep 2019

Client: Hertz

Role: Consultant

The project aims to deliver end–end data warehousing solutions using ETL tool as ODI .Focusses on timely reporting the business requirements using OBIEE as the reporting tool.

Technical Environment:

ODI/SQL Developer/OBIEE

Responsibilities:

•Develop mappings to load data from source system to Database in the required format.

•Involved in Unit and performance testing.

•Involved in creation of migration documents for code migration as part of deployment activities across different environments and Unit test case documents, mapping documents.

•Solving critical service requests or incidents raised by the business users for data issues as part of testing cycles.

•Involved in data reconciliation between source files and data extracted from target systems.

•Attended daily status call with internal team, updated status report to management and business users.

•Coordinated with the OBIEE reporting team to ensure that correct data is present in the reports.

Deloitte Consulting Jan 2017 – Feb 2019

Client: S & P Global

Role: Consultant

The project aims to deliver on a customer-focused strategy, where our businesses go-to-market together and offerings can be combined in new ways and delivered with new business models.It also includes migration of sources from legacy systems to new platforms(Zuora/Salesforce/Oracle12), which includes various data transformation activities using ETL tool.

Technical Environment:

Informatica Power Center 10/SQL Developer/Unix/Salesforce Functional/Zuora Functional

Responsibilities:

•Creation of mappings to load data from legacy system feed files to Database and generate feed files to new systems in the required format.

•Involved in Unit and performance testing.

•Extensively used complex Source Qualifier queries, Pre and Post SQL queries in the Target.

•Involved in creation of migration documents for code migration as part of deployment activities across different environments and Unit test case documents, mapping documents.

•Performed defect/bug fixes in environments like UAT, SIT to ensure delivery of properly developed jobs.

•Solving critical service requests or incidents raised by the business users for data issues as part of testing cycles.

•Involved in data reconciliation between source files and data extracted from target systems.

•Supporting post go-live production activities, defect fixing or any enhancements from the business.

• Status reporting with internal team onshore and offshore on daily basis.

Cognizant Technology Solutions Jan 2016 – Dec 2016

Client: Intel Security

Role: Associate-Projects

The project aims to provide a single global platform for Planning and Forecast reporting and analytics. The project includes migration of sources from SIEBEL to SALESFORCE,data related issue resolution; perform various maintenance activities in the warehouse. This also includes performing development work and deployment of small ETL deliverables, reporting work. It was followed by System integration testing, User acceptance testing and performance testing.

Technical Environment: Informatica Power Center 8.6/IDQ/SQL Developer/SQL Server 2008/Unix/DAC scheduling Tool/OBIEE

Responsibilities:

•Modified existing mappings as part of migration of source systems,created new codes and modified existing for enhancements of new business requirements.

•Involved in Unit, Integration, System, and Performance testing levels.

•Developed mappings in Informatica to load the data into datawarehouse.

•Extensively used complex Source Qualifier queries, Pre and Post SQL queries in the Target.

•Involved in dealing with performance issues at various levels such as source, target, session, and mapping, Query performance.

•Written shell script to connect reporting tool server and perform file transfers to different servers, used PMCMD command to automate sessions and workflows and errors handling.

•Ensuring the scheduled job runs/execution plan is running as expected and re-run or fix the jobs incase of any failure.

•Performed defect/bug fixes in environments like UAT, SIT to ensure delivery of properly developed jobs.

•Involved in resolving on-going production issues and support during the deployment activities.

•Experience in dealing with post production support activities and fixing production issues during the soft go live window.

•Attended daily status call with internal team, updated status report to management and business users.

•Coordinated with the OBIEE reporting team to ensure that correct data is present in the reports.

Tata Consultancy Services Sep 2012 - Dec 2015

Client: J P Morgan Chase

Role: Senior System Engineer

Technical Environment: Informatica Power Center 9.0.1/SQL Developer/Unix/Control-M

Responsibilities:

•Scheduling workflows using Control M, control m job creation.

•Testing the code in various environments such as DEV, UAT, and PREPROD.

•Attended daily status call with internal team, updated status report and reporting any risks and contingency plan to management and business users.

•Responsible for Business Analysis and Requirements Collection.

•Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

•Parsed high-level design specification to simple ETL coding and mapping standards.

•Designed and customized data models for Data warehouse supporting data from multiple sources on real time

•Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

•Created mapping documents to outline data flow from sources to targets.

•Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

•Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

•Developed mapping parameters and variables to support SQL override.

•Created mapplets to use them in different mappings.

•Developed mappings to load into staging tables and then to Dimensions and Facts.

•Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

•Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

•Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

•Modified existing mappings for enhancements of new business requirements.

•Used Debugger to test the mappings and fixed the bugs.

•Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

•Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Contact this candidate