DW Specialist/ETL Tech Lead

Bhagya Sree

DW Specialist/ETL Tech Lead

609-***-**** / ***********@********.***

Summary:

Bhagya Sree is a Certified Informatica Powercenter Developer who has 9 plus years of professional experience in Data warehousing and Business Intelligence solutions. She is a high potential candidate with extensive hands-on experience working in highly demanding business & technical environments with focus on Architecture, Design, Development and Implementation of Data warehousing and Business Intelligence solutions.

Her core expertise is in Informatica Power Center with exposure and experience in multiple relational databases which includes SQL Server, Oracle, Teradata and DB2 and knowledge in UNIX and batch scripting. She is an expert across all stages of Software Development Life Cycle (SDLC),covering Agile and Waterfall models which includes business requirement analysis, design, build, quality reviews, testing and document preparation.

Bhagya has ample experience in conducting interviews and team building activities with exceptional interpersonal and communication skills. She has excellent analysis\debugging skills and an outstanding pace in designing and developing code. She has proven ability to co-ordinate activities between Onsite and Offshore and also Client interaction.

Bhagya has spear headed multiple data integration projects during her carrier. Her ability to foresee futuristic needs in an integration project and her advanced knowledge with Informatica Power Center Client has resulted in layout of proper ETL design which ensures reusability and high performance for large data volume systems.

Her proven management and leadership skills has always ensured smooth progress of work in all teams she has been part of. She demonstrated skills to work under stringent timelines and pressure situations when she efficiently managed the Business as Usual (BAU – Production support) activities while heading development team for parallel tracks.

She is graduated in Electronics & Communication Engineering from Mar Baselios College of Engineering.

Skills and Expertise:

Expertise:

Requirement gathering and detailed functional evaluation.

Proficiency in designing performance tuned ETL Code, database queries and batch\Unix scripts

Faster Root Cause Analysis and debugging capability.

Task Analysis, Effort Estimation and Resource Assignment.

Tools:

Informatica Power Center, SQL Server, Teradata, DB2, UNIX scripting, Batch scripting, Autosys Scheduling

Informatica Power Exchange, Informatica Proactive Monitoring, Informatica Rule Point, SSIS, .Net

Industry Domain: Insurance, Banking,Retail Services, Life technologies.

Certifications: Bhagya has completed the certifications in multiple Informatica Power Center versions:

External Certifications

Informatica PowerCenter Data Integration 9.x:Developer Specialist, Informatica University 08/26/2014

Exam S: PowerCenter 8 Mapping Design

Exam U: PowerCenter 8 Advanced Mapping Design

Exam R: PowerCenter 8 Architecture & Administration

Software courses/certification completed through Cognizant academy:

Cognizant Technology Solutions-Internal CCP – General Insurance -- United States Medicaid Certification

Informatica – Level 1 Certification

Awards and honors:

EIM Kochi Star Awards Q2 2013 – Bhagya was awarded in Technocrat category honoring her ideas and contribution to XL Catlin Enterprise Enablement track.

Best Managed Project Q1 2012- JCPenney project for which Bhagya was the technical lead was awarded the Best managed project in Systems Integration business unit of Infosys.

KM Rewards and Recognition Q2 2011- Appreciation for recognition of the knowledge management program conducted across multiple projects in the business unit.

Crown RCL Award for Excellence Q1 2011–Bhagya was recognized for superior performance in JCPenney Project. Her excellent design suggestions and quality code which ensured successful project delivery in proper time frame were highly appreciated.

Detailed Work Experience:

Client: Fannie Mae, Herndon, VA July 2017- Present

ETL Technical Lead

Project: Target State Multi Family Datawarehouse\ DataMart

The Multi Family DataWarehouse\DataMart (MFDW\MFDM) project focuses on building an integrated platform for a one stop of all the mortgage business data in a single database. The MF project has data spanning across different source systems that needs to be conformed based on a master data set, in-order to obtain a single platform to lookup on for different business processes across Fannie Mae. The tables populated as part of this program is used by the downstream applications to get details of each source system for reporting purposes.

The TSMF project assignment adapts agile methodology and aims in a faster completion of integration which also includes Production support. Bhagya got assigned to this program shortly after the work got started and has scaled up to full speed and is currently involved in design\development activities in parallel tracks across the DW and DM projects.

Her work has helped in building confidence in the partnership between Fannie.

Environment: Informatica Powercenter 10.1.1, Oracle 12.8.0.2, UNIX, Power Exchange 10.1.1, Autosys, Jenkins.

Client: XL Catlin Dec 2012 – June 2017

ETL Technical Lead

Project: Enterprise Enablement

The XLC initiative Enterprise Enablement (EE) developed an information management environment to alleviate current difficulties in performing finance and internal functions. EE build is an integrated architecture to support its strategic capabilities and address regulatory demands in a timelier and cost-effective way. It has the ability to deliver accurate, fast, and consistent data to the enterprise to enable business decisions to improve and accommodate growth. The EE project involved multiple tracks including Production support.

During her tenure with XL Catlin, Bhagya was the team lead for integrating 5 different source systems. She voluntarily invested her time in sessions with System Analysts to get proper understanding of the inter dependent systems. Her knowledge helped in foreseeing the break points in the system layout and suggested accurate scheduling to avoid all overlaps.

Environment: Informatica Powercenter 10.1, SQL Server 2012, Batch scripts, Autosys.

Infosys Limited Nov 2008 – Nov 2012

Client: CVS Pharmacy

ETL Team Lead

Project: Vertical

The project objective was large volume data population from Vertical Sql server to Teradata which aids in collating the pharmaceuticals’ drive through and call details on to a single platform. This project involved data extraction from various existing data storage places such as SQL Server and Flat files which was populated Teradata tables. These tables are further used for generating reports.

Bhagya led the track and ensured the perfect design was laid out for extracting data from multiple data storage places with different data storage formats and loading to a single platform. She initiated needed discussion with the client and onshore counterpart which aided in through understanding of the system and the integration requirements.

Her precise analysis skills ensured all functionality was met and also a performance oriented code was delivered for the high-volume systems. UNIX shell scripting to handlefile transfer across servers was designed to cover not only the requirements but also to handle any failure with network\FTS failures.

Client: JC Penney

ETL Team Lead

Bhagya was involved in different tracks under JC Penney Project. She was responsible in development of the code in loading the customer email related information from the CDB system to the MDM environment. The email details along with the email quality and email preference information were loaded using a single mapping that loads 21 target tables. Extra control logics and parallel session load were implemented in order to ensure best performance for the code developed.

Bhagya was involved in all phases which include understanding requirement, design, code development, testing, and documentation and production support activities. She was very effective in the coordination between onsite and offshore team which consisted of 10 members. She played a key lead role in the project in exploring and successfully implementing XML definitions as target for Informatica code. Ensured proper knowledge transition happened within the team that consisted of fresher.

Took extra responsibility of configuration control of the project and kept track of all Quality related processes. She was responsible for track management Process related activities.

She was the single resource for the track Use and Kill, and was involved in direct interaction with client for requirement gathering and data analysis. She was the single resource support during code deployment and production support phase.

Reporting 4B

The project objective is data population to Teradata tables which aids in report generation in JC Penney business environment. From the customer information database, the count of customer and customer related entities based on the different business requirements are calculated and populated on to the fact tables.

The data load for 4B reporting involved calculations at some complex level and load data to the reporting tables, so that further calculation could be avoided before generating the reports. The data from DB2 source tables were fetched and calculations were performed on the data for customer related entities and count and were populated to the intermediate tables, from where the data was populated to Teradata target tables.

Use and Kill

The objective of the project is to identify promotions and discount coupons applied to the J.C. Penney products. Based on the source information from the DB2 systems, details regarding used coupons and the discounted amount for every item were separately captured in Teradata tables.

Extracting data from driving table and promotion related information had to be looked up from a different server in DB2. The data is taken to the staging area where the calculations based on the data fetched are performed and data is finally loaded to the Teradata.

Subscriber load

The objective of the project is to identify and select all existing subscriber emails (emails which are registered via internet) and their applicable preferences present within the subscriber DB and load them to integrated database. This objective is referred to as the Subscriber Initial Load. The second objective is to redirect only to CDI any new and/or subsequent subscriber emails and their applicable preferences received through the existing online and batch processes once the subscriber initial load is complete. This objective is referred to as the Subscriber Deltas. The subscriber data is read, ordered and transformed to xml information and fed to MDM through TIBCO services.

Customer Data Integration (CDI) Phase 1A, B, C

The Customer Data Integration (CDI) Phase 1 aims in developing a centralized system to store the complete contact information of customers of J.C. Penney Corporation Inc. Customer data available in the existing multiple source systems is brought over an integrated Database which will provide a centralized view of the customers of J.C. Penney.

Education:

Bachelor of Technology in Electronics and Communication 2008

Mar Baselios College of Engineering and Technology, University of Kerala

Contact this candidate