Data Engineer/Analyst

Priya Prabha Dash 609-***-****

*** ***** **. ******, ** ***************@*****.***

Summary of Qualifications

• 7.5 years of experience in IT, with focus on Data Warehousing and ETL

• Leadership experience working with globally distributed teams

• Execution of ELT (Talend), and BigData (HDFS, HBase, Spark & HIVE) tools and legacy technologies such as COBOL, DB2, JCL, MQ-Series, VSAM & CICS

• Worked in Data Analytics Projects for Insurance and Banking industries

• Experience with S3 on Amazon Web Services (AWS) for executing Hadoop jobs

• Experience in Taxlot applications, Client & Accounting data applications; Cleansing, Validation and Migration of data to Hadoop from files and databases.

• Good knowledge of AUTOSYS scheduling

• Handling end to end process of an entire project life cycle that includes requirement gathering, analysis, design, development and testing

• Knowledge of CMM and ISO processes and their pertinence to relevant industry

• Experience in hiring new talent and involved in recommending promotions Work Experience

Project Lead. Tata Consulting Services. January 2015 - current Client: CitiCorp, Warren, NJ

• Leading a team of 15 (part of the team is remote, in India & Singapore)

• Using File and Database based ingestion frameworks to move data to Hadoop Hive

• Extracting from various structured and unstructured sources like pdf, excel, sequential, text, dat, csv files and from databases such as Oracle, Netezza, Sql server, DB2, Sybase, Teradata.

• Development [Coding], as well as unit testing

• Writing test scripts and reviewing test-results

• Handling on call requests and resolving production issues, bugs and user complaints

• Cleansing and validating data prior to ingestion.

• Working with Citi Data Profiling Framework (CDPF), which runs on Hadoop cluster server to profile files through HIVE or other interfaces,

• Save statistics result in Citi Data Quality repository (CDQ) for further reporting Module Leader. Tata Consulting Services. July 2011 - December 2014 Client: Bank of America

• Worked with the GWM (Global Wealth Management) Taxlot System

• Developed features to help maintain and update security-related information. In addition, when a security is liquidated, compute realized gain/loss

• Added the ability to understand current financial position and aid in formulating tax strategy and later tax reporting. Some of its more important features are: 1. Enrolment 2. Manual Adjustments

3. Corporate Actions 4. Daily Activity

5. Taxlot system provides gain-loss information to the downstream systems, which is later reported to IRS and customers in a detailed summary statement. Technical Lead, Htc Global Services (India) Ltd. March 2009 - September 2011 Client: Statefarm Insurance

• Worked with the Fire Enterprise Applications (EA) system, used by sales force and operations center, for processing quotes and applications for Homeowners, Renters and Condominium Unit owners.

• Developed a feed to capture Fire EA quote/app data and store in the enterprise Federated Data Warehouse (FDW). A subset of this data would be extracted to P&C Actuarial’s PCADSS environment.

• Processed data from front end, via various OLTP systems, bring it to a common platform through MQ Series, add business logic through COBOL & Informatica and feed to Federated data warehouse (Mainframe) and from it to FDW (Unix)

• Independent Cobol API programs were needed to be developed to load directly to data mart for specific business analysis and making strategic business decisions Technical Skills

Data Informatica 8.1, TALEND 5.6, AUTOSYS, Endeavor, RMS, File AID, File Manager, COBOL, DB2, JCL, VSAM, CICS, MQSERIES, HIVE, HBASE, SPARK, HDFS, AWS

OS WINDOWS XP, UNIX, Mainframe Z/OS

Methods Agile, Waterfall and Scrum

Domain Experience Insurance, Banking & Financial, Global Wealth Management, International Business Operations and Data Analytics

Business Development Business Analysis Program, L & D activities for domain and technical competencies

Certifications

IBM DB2 10.1 certification with a score of 100%

INFORMATICA 8.1 certification.

Completed TALEND 5.6 Certification

Post Graduate Diploma in International Business Operation Post Graduate Diploma in Human Resource Management Awards and Accomplishments

Education

Bachelor of Engineering, Electronics and Telecommunications 2007 Title Category Sub-Category Received On

Best Team Awards for Excellence Awards for Excellence 31/05/2012 Star Team Awards for Excellence Star Awards 30/01/2013 Special Initiative

Beyond Performance

Awards

Initiatives 23/05/2014

CLP Faculty Award Learning Awards CLP Awards 17/09/2013 Technical Excellence Awards for Excellence Awards for Excellence 13/02/2013

Contact this candidate