Divya Chandrashekar 510-***-****

ac0ab1@r.postjobfree.com

SUMMARY

•Tech Lead, Developer with 9 years of experience in Business Intelligence and ETL in Data Warehousing.

•Expertise in Informatica Power Center development, Oracle, SQL Server, Teradata.

•Revamped dysfunctional modules into high quality production ready modules.

•Identified bottlenecks in data flows and rectified them to improve performance (2x – 10x).

•Worked with multiple clients in both India and USA.

•Managed and coordinated cross functional teams.

•Provided critical feedback to the team through code reviews.

•Involved in testing, and QA, including System Integration, Unit and Regression testing.

•Self-taught and Tutored team on Customer Insight Appliance and conducted seminars on Informatica Power Exchange.

WORK AUTHORIZATION

• Authorized to work anywhere in USA, Green card.

•Willing to travel in USA.

APPLICATION DOMAINS

•Banking and Financial Services, Travel and Hospitality, Manufacturing and Logistics – Energy and Utility, Retail, Insurance, Health Care.

TECHNICAL SKILLS

•Databases Teradata 13.1, Oracle 11g, SQL Server 2000, Netezza

•Tools & Utilities Informatica, BODI, Customer Insight Appliance, Control M, DAC

•Languages Oracle PL/SQL

•Operating Systems UNIX, LINUX.

EXPERIENCE

•Lead Developer, Cognizant Technology Solns., Bangalore, India - Nov 2014 - Mar 2016

•Business Analyst/Lead Developer, Kohls, Wisconsin – Sep 2014 – Nov 2014

•Lead Developer, Cognizant Technology Solns., Bangalore, India - July 2014 - Sep 2014

•Lead Developer/Business Analyst, Florida Power & Light (FPL), Miami - Sep 2013 – July 2014

•Developer/Systems Analyst, Cognizant Technology Solns., Bangalore, India - Dec 2009 - Sep 2013

•Software Engineer, Accenture Services Pvt Ltd, Bangalore, India - Jan 2007 – Dec 2009

•Data Analyst, MediAssist, Bangalore, India – Sep 2006 – Dec 2006

ACHIEVEMENTS

•Received Star Performer Award for WellPoint Client, for timely delivery and support of a high quality, ETL solution.

•Customer appreciation from Florida Power & Light for developing, optimizing, and supporting a business critical ETL solution to satisfy Client requirements.

•Received Cognizant appreciation for leadership during revamping a dysfunctional tool and delivering Customer Insight Appliance project to the client, Kohl’s.

PROJECT DETAILS

1)International Hotel Group, Atlanta (Jul 2015 – Mar 2016) – Travel and Hospitality

Role: ETL Lead Developer

Tools: Informatica 9.5.1(Power Center), OBIEE, UNIX

Database: Oracle, Peoplesoft

Responsibilities

•Developed an end-to-end Business Management System based on Client requirements.

•Self-trained on OBIEE and Client Server structure.

•Provide performance improvement suggestions for the queries, resulting in 2x improvement in run time.

•Organized cross-functional team meetings, involving Customer, Support, Development, and Admin teams.

•Performed audit to ensure compliance of code for standards and to Customer needs.

•Provide production support for a month for all implementations completed.

2)Kohls ( Aug 2014 – Jun 2015 ) – Manufacturing and Logistics – Energy and Utility

Role: Business Analyst – Onsite / Technical Lead and Trainer

Tools: Informatica 9.6.1, Customer Insight Appliance (CIA), Netezza, UNIX

Database: Netezza

Responsibilities

•Revamped a dysfunctional customer analytics framework, namely, Customer Insight Appliance.

•Mastered Customer Insight Appliance by taking initiative and learning by myself.

•Enhanced CIA to provide a unified data access mechanism for data from heterogeneous sources.

•Provided technical support and trained 15 other people on internals of CIA.

•Prepared a detailed Understanding document about CIA.

•Provided Presentations on Customer Insight Appliance.

3)Florida Power & Light (FPL) (Sep 2013 – July 2014) – Manufacturing/Logistics - Energy & Utility

Role: ETL Tech Lead – Onsite

Tools: Informatica (Power Center and Power Exchange), SQL Server, UNIX

Database: SQL Server

Responsibilities

•Assessed the Client requirements and accordingly, drafted a functional design document, and developed an architecture blueprint to completely to support Client needs.

•Used Informatica Power Exchange to access data directly from Sybase and transfer to SQL server web app.

•Worked with other Solution Providers for getting data from different Source Systems.

•Worked with the offshore and the business on fixing and resolving all the defects.

•Performed comprehensive System Integration Testing (SIT) and User Acceptance Testing (UAT).

•Drastically reduced runtime (week to 16hrs) by efficiently integrating Informatica with a new SQL server.

•Reviewed Technical Design Documents prepared by the offshore team and customized it to satisfy the Client.

•Got all the sign off from different teams at the Local Review Board.

•Provided Warranty support and ensured a timely resolution to all post-implementation issues.

•Tutored Client and other Solution Providers on our tool and Informatica Power Exchange.

4)Lowe’s (April 2013 – Aug 2013) – Retail

Role: Module Lead

Tools: Informatica 9.1.0, Oracle 11g, UNIX/Linux

Databases: Oracle 11g

Responsibilities

•Analyzed Client requirements and proposed a clean design with an understandable data flow.

•Performed Development and Unit testing of Informatica and UNIX shell scripting codes and added steps to improve performance of each workflow.

•Resolved the issues/defects, and integrated the corrected code.

•Most of the jobs were running for long durations as there were huge amount of data that needed to be refreshed on a daily basis, so we improved performance by understanding the process, adding parallel Hint, increasing the Auto Memory attributes, Adding Partitions, optimizing the SQL query based on the each requirement.

•Reviewed the code before integration.

•Suggested best practices to follow and performed root cause analysis after every performance improvement steps.

5)Wellpoint ( Jan 2010 – Mar 2013 ) Health Care

Role: Module Lead/ Teradata BETQ Developer

Tools: Informatica, Teradata BTEQ/Fast Load/Bulk Load, TPT, UNIN, Control M

Databases: Teradata 13.1, SQL Server

Responsibilities

•Based on the Business Technical Requirements document first drafted a High level Business Technical Document and then a Technical level Design documents are prepared.

•Support in Development and Unit testing of Informatica, BTEQ scripts for Fast Load, Bulk Load, TPT and UNIX shell scripting and review the development so that it is as per requirements.

•Provided clear Executive summary and consolidated status report for all modules.

•Supervised the support and development Teams by effective delegation.

•Coordinated with teams at different location for the process to run smoothly as there was inter-dependency of Jobs.

•Analyzed existing jobs by adding Statistics and improved performance by incorporating parallelism.

•Provide effective resolution of issues raised during Testing and ensured production quality results.

•Presented the project process flow and best practices implemented to Client and on-shore counterparts.

•Always maintained a good balance between the on-shore and offshore team members.

6)National Australian Bank (Jan 2009 – Dec 2009 ) Banking and Financial Services

Role: Business Objects Data Integrator Developer

Tools: Buiness Objects Data Integrator, OPC, SQL Server

Database: SQL Server

Responsibilities

•Development and Unit testing of Business Objects Data Integrator Jobs.

•Learn to operate and Schedule the Jobs using the mainframe tool called OPC.

•Move the developed Jobs after testing to Production and Handover the jobs to the Production support teams.

7)Washington Mutual Bank ( May 2007 – Dec 2008 ) Banking and Financial Services

Role: Informatica Developer

Tools: Informatica 7/8, Oracle PL-SQL, UNIX

Databases: Oracle 9i/10g

Responsibilities

•Communicate with the Client directly for the requirement analysis process over call.

•Develop or change the existing Informatica code with the correct requirements. Also perform the Unit Testing of the code.

•Development and Unit testing of Oracle PL/SQL programs based on the requirements.

8)Medi Assist ( Sep 2006 – Dec 2006 ) Insurance

Role: SQL Server Developer

Tools: SQL Server, Excel

Databases: SQL Server

Responsibilities

•Understand the process and perform Backend changes based on ad-hoc requests.

•Prepare codes for reports to be generated in SQL Server.

•Prepare the PL SQL code based on ad-hoc requests for the Data Load into the Database.

EDUCATION

•B.Tech - Computer Sci., Vishweshwaraiah Technological University (VTU), Bangalore India-2006.

•Pursuing specialization in Big Data and Phyton through Coursera, Mar 2016-Present.

Contact this candidate