Data Engineer

ARATI RAM

Contact: +1-802-***-****

E-Mail: *********@*****.***

ETL (Informatica, SSIS) and Data warehouse developer BI Data warehouse Development

Nearly 9 years of relevant technical experience spanning database development, reporting and business

intelligence tools.

Skills in design, development, data conversion and migration (ETL- Informatica, SSIS), reporting(SSRS), and data warehousing. Experience with both Commercial and Open Source tools. Extensive SQL background. Strengths include both relational database design and data

warehouse / data mart skills. I also have good knowledge of Banking and health care domain.

Distinctive problem-solving and analytical skills combined with strong business acumen; demonstrated ability to multi-task and apply initiative and creativity on

challenging projects. I am passionate about working with data.

Agile methodology

Software Development Lifecycle

(SDLC)

Data Analysis

Data warehousing

Requirement Gathering

Client Relationship Management

HLD and DLD creation

Team management

Unit and System Testing

Process improvement

PROFILE SUMMERY

A result oriented professional with nearly 9 years of experience in Banking Applications, Core Banking, Retail and Healthcare Domain.

Excellent experience in providing application support including the end of day support, enhancement, upgradation for the applications.

Skilled in identifying issues and risks in a timely manner; developed/implemented appropriate mitigation and contingency plans.

Experience in delivering quality services without compromising with service standards.

Effective leader with excellent motivational skills to sustain growth while motivating peak individual performances

Experience in Providing technical support and development to the Profitability Systems and Reporting group to implement accurate models, cubes, and reporting on customer and product profitability for the company's global business operations.

Practical experience developing ETL processes and familiarity with an ETL tool such as Informatica and SSIS.

TECHNICAL EXPERTISE

Databases: MS SQL Server 200*-****-**** Netezza Azure SQL DW Oracle 10g.

Tools: Informatica Big data HPCC ECL MSBI SSIS SSRS SSAS Red point data management tool Microsoft Azure portal Unix.

Operating Systems: Microsoft Windows Server Microsoft

Utilities: Atlassian- Confluence JIRA Remedy Putty Service Now HP Quality Centre.

Version Control Tools: Atlassian- Bit bucket GitHub HP Quality Center SharePoint VSS PROFESSIONAL EXPERIENCE

Infosys Limited Technology Analyst Pune. Jun 2009 – Present ECL Developer Client: LexisNexis Risk solutions Inc Jan2018 – Present King of Prussia, PA Developer for Big data ETL application - designing migration strategy from Health market science (HMS) legacy platform to LexisNexis system using Big data HPCC ECL technology. Technology involved: Big Data HPCC data centric programming language (ECL).

Converting challenging business requirements into quality data extraction for reporting for each independent client.

Development involves requirement analysis, data analysis, Conversion instruction documentation, design, build, testing, implementation and data delivery support.

Drive process improvement projects to better leverage existing internal and external data sources and conduct thorough testing to ensure accuracy of data

Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project modules.

Technology Lead Client: Keurig Green Mountain Coffee Roasters June 2017 – Jan 2018 South Burlington, VT Leading offshore team for supporting cloud based Customer Data Platform (CDP) application that leverage data from Hybris processed by different Automation jobs in RPDM tool where data is pushed into azure data warehouse.

Technology involved: Informatica, SSIS, RPDM, RPI, Microsoft Azure cloud, Azure data warehouse

Developing, testing and supporting Informatica workflows and SSIS packages.

leading and prioritizing development and deployment efforts

Provided leadership as a subject matter expert (SME) on hosting issues, client and staff logins, and general upgrades/maintenance of servers.

Implemented and managed project Change Control System and processes and tracks project issues resolution.

Prioritized and handled multiple tasks in high-pressure environment. Technology Lead Client: Deutsche Bank Jan 2016 – June 2017 June 2012 – Mar 2015 Pune, India Led team to work closely with data architects, data integration engineers, system engineers, and other team members to deliver the very best ETL solution and Reports to the top management within Deutsche Bank. Technology involved: Informatica, SSIS, SSRS, SSAS, SQL 2008, SQL 2012

Developing new modules to accommodate new source systems data by building new SSIS packages and Informatica workflows.

Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools.

Implemented and managed project Change Control System and processes and tracks project issues resolution.

Proactively identify risks, issues and problems on programs/projects - leading engineering and project/program team to develop risk management and issue management plans.

Analyzed and executed the test cases for various phases of testing - integration, regression and user. Onshore Lead Client: Fidelity Investments Mar 2015 – Dec 2015 Smithfield, RI Leading team for Developing and maintaining ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts destination in Netezza.

Technology involved: Informatica, SSRS, Netezza

Designed and developed Informatica’ s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Implemented and managed project Change Control System and processes and tracks project issues resolution.

Proactively identify risks, issues and problems on programs/projects - leading engineering and project/program team to develop risk management and issue management plans.

Performed Impact Analysis of the changes done to the existing mappings and provided the feedback.

Participate in data analysis, mapping, dimensional modeling, and troubleshooting if necessary in order to maintain high quality, well-structured, and robust data

Helped to mentor, coach and supports less experienced staff as needed to meet project goals and objectives

Systems Engineer Client: Wells Fargo bank Jan 2010 – June 2012 Pune, India Worked as systems engineer and senior systems engineer in end to end application development with expense tracking and reporting system for Wells Fargo bank. Technology involved: dot net, SSIS, SSRS, SQL 2005, SQL 2008.

Design and develop optimal ETL processes to integrate new data sources.

Implemented multiple SSIS packages to Extract business data and transform various business requirements into meaningful data.

Developed multiple SSRS reports to report the tracked expense to business.

Monitor data sources and manage timely loads into our database to support reporting and analyses. EDUCATION

Bachelor of Engineering – Electronics

College: Walchand college of Engineering, India (2009) PERSONAL INFORMATION

Data of Birth: 24th July 1987

Nationality: Indian

Work authorization (Work Visa): H1-B

Contact this candidate