PROFESSIONAL SUMMARY:

• Over 9 yrs professional experience in data analysis, data integration projects covering data warehousing and Big data technologies with financial services (Life Insurance, banking), retail and pharmaceutical clients
• Knowledgeable in Tableau for building dash boards and charts for presentations
• Experience in SQL, Python and R
• Experienced in using ETL tools Informatica and SSIS, Use
• Familiar with various Relational databases - MS SQL, Oracle DB, Teradata and Postgresql
• Well versed in using verson control systems - Git and CVS
• Experience in migrating ETL operations into HDFS systems using Pig Scripts
• Conducted performance tuning of queries for Tableau dash boards and batch ETL
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development
• Detail oriented, thorough written and spoken communication skills
• Experience working in cloud platform (AWS) using MySQL and MongoDB
• Data modeling experience with relational and document data stores

SKILLS:

SQL(9+ years), Python(2 years), Java(4years), MS Excel/PPT/Word, Tableau ( 1 year), Hadoop(2 years), SQL Server (2 years), Teradata (3 years), Informatica ( 2 year)

EXPERIENCE:

Senior Data Analyst - Analytics

Confidential, New York

Responsibilities:

• Performed Data Ingestion, Batch Processing, Data Extraction, Transformation, Loading various formats of data - Excel, csv, xml and text files to Tabular format using Python
• Written complex HiveQL Queries and Pig Latin Scripts for retrieving data from Hadoop in required format
• Gathered the data modeling requirements for AWS based Insurance Analytics product - MRisk, created system documentation, schema documentation on the MySQL relational tables and No SQL DB - Mongo DB - Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams and Sequence Diagrams
• Build data quality control framework using the file checks, record count, aggregate counts, time dimension checks and business validation
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views using and Data Modeling
• Experience in Loading and Analyzing large datasets with Hadoop framework (MapReduce, HDFS,PIG, HIVE, Sqoop, Spark, Impala)

Environment: SQL, Python, Tableau, Cloudera Hadoop, MS SQL server

Data Analyst

Confidential, Bridgewater, NJ

Responsibilities:

• Build the data model in MongoDB for the AWS based Insurance Analytics product - MRisk
• Created Python based data simulator scripts to generate simulated data for Insurance customers
• Build MongoDB to My SQL data modeling transformation, to enable tabular format data sets for the analytical R models
• Build the database for product on AWS, using the SQL scripts and Python scripts for data generation
• Used HiveQL and Impala to build data sets (30 GB data sets) and pipelines from raw data
• Build UDFs in Hive to parse complex medical lab results XML data and transform to flat tabular format for consumption by the predictive models
• Installed Postgresql for Tableau installation on cloud and enabled business health dashboards covering Sales, Inventory, demographic data, linked public data for demographic purposes .Converted the transactional data tables to denormalized data tables for Tableau
• Built indexes for faster retrieval of data and reads for Tableau . For most important and frequently used data converted the data to Tableau data format for in memory access
• Created R based logistic regression models for assessing the risk of customers and provided lead data scientist with the initial models

Environment: R, Python, Tableau, Cloudera Hadoop, SQL

Senior Datawarehouse Developer

Confidential

Responsibilities:

• Build data model in Teradata to act as a ingestion, transformation and standardization platform
• Gathered requirements from business and built variety of business reports on weekly and monthly basis
• Created BTEQ scripts for conversion and loading of flat files into Teradata tables
• Created data model for customer communication ETL project, build the scripts and tables to extract customer information from major UK Banks - HSBC, Santander, Lloyds TSB
• Built the SFTP transfer mechanism between the test systems of the Bank System and Confidential Test environment as the kick off for the testing phase
• Responsible for building in integration layer between Websphere portal and backend for launching new Insurance Product on in house portal
• Created WSDL files for SOAP - CICS based back end application using Websphere RAD
• Created Cobol based copybooks to XML mapping based on the business requirements and User interface
• Responsible for building data schema inhouse used for consolidating data from various 3rd party companies selling Employer liability Insurance and ETL for the various sources. Created designs for data models, SQL scripts, web services
• Used Control M as the scheduler for automating the pipeline workflow covering the transformation and loading into the final set of tables

Senior Developer

Confidential

Responsibilities:

• Worked as senior developer for data integration layer for forex transaction services system of Confidential .
• This layer enabled integrating the front end cash management and different back ends for Confidential payment data from customers in various data formats EDIfact, XML, CSV, X12 and IDoc . Coded in Java, with Apache web services API.

Environment: Java, XML, Apache Axis

Analyst programmer

Confidential

Responsibilities:

• Wrote complex SQL queries to extract data from various tables
• Designed and developed Oracle PL/SQL Procedures, Functions, Database Triggers and involved in creating and updating Packages to meet business requirements
• Involved in the ETL process of developing new tables from the existing views and materialized views
• Used PIVOT, UNPIVOT and many functions to transform complex source data as per mappings
• Created various Function Based Indexes to significantly improve performance
• Extensively used Bulk Collect to insert and update huge amount of data into Confidential databases
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process
• Worked closely with end - users and team members to understand business requirements that drive the analysis
• Designed Technical Design Document based on the business requirements
• Participated in Peer code reviews and verifying coding standard
• Responsible for requirements gathering from Clients and implement the back end changes in existing intranet application and designing the database