Sign in

Data Engineer

Kings Mountain, NC
March 20, 2018

Contact this candidate



**** ******** ***** ****, *********, NC • Home: 503-***-**** •

Professional Summary

Data Modeling experience of more than 8 years with expertise in modeling for OLTP, data warehouse

and data mart applications using data modeling tools like Erwin, E/R Studio, IBM Data Architect.

Accompanying skills include data analysis and data profiling using SQL, ETL mapping, data analysis using Python.


Data Modeling Tools: Erwin9.64, E/R Studio, MS Visio, Oracle Designer, IDA 7.6, RTC Client

Programming Languages: C, SQL, PL/SQL, Python 2.7.12

Databases: ORACLE, MYSQL, SQL Server, DB2Host, DB2 LUW, Teradata 15.x and Netezza, NoSQL

ETL Tools: Informatica, Datastage, SSRS

Data Analysis Tools and packages: Hive, Anaconda, Tableau Desktop, Python’s Pandas, Numpy, Matplotlib

Operating System: Windows, UNIX, LINUX.

Other Tools: TOAD, Visual Studio, Aginity Netezza, DB Artisan, SQL Developer management studio 2012, Alation, SVN,Jira,MS Excel

Work Experience

Data Modeler Consultant

Wells Fargo, Charlotte, NC Sep 2017 – Till Date

Part of Wells Fargo Enterprise Market Risk Technology group on Market Risk and Risk Insight projects using skill set required that includes SQL Server 2008, SQL Server 2012, Data Modeling using Erwin.

Conceptualize the business requirements and then design the logical and physical models for target database.

Detailed study and data profiling of all underlying source systems of the subject areas to deliver a data model that adheres to enterprise standards.

Run the table scripts generated using Forward Engineering in Erwin within SQL Server Management Studio to create the tables and corresponding views.

Looked at the execution plan to analyze the optimizer execution path for a query and recommended additional indexes if needed for improving performance and query tuning

Implemented partitions for tables in database and testing the partition elimination in execution plans.

Reverse engineered the data model into Erwin by using database script file.

Used the complete compare option in Erwin to make sure the data model is synchronized with the database.

Created domains to ensure the data elements can be assigned to domains across the enterprise models.

Initiate and maintain client relationships, anticipate and identify client issues/concerns and propose appropriate solutions.

Data Modeler Consultant

MGM Resorts International, Las Vegas, NV Apr 2017 – Sep 2017

Create logical and physical data models for the data warehousing and data mart applications.

Supported various stakeholders and end users ranging across various functions within MGM resorts like table games, slots, finance cube, revenue management, property master for their reporting needs.

Worked in a fast-paced environment that involved following the best practices of SDLC and delivering as per the Agile timeline.

Worked on data profiling the source systems for validating data, defining the data standards, size and datatypes in the data warehouse or mart.

Created ETL mapping documents from source to target systems for ETL developers.

Worked with ETL developers to optimize various ETL jobs in Datastage.

Adept in designing data models suited for Teradata, which was the reporting database at MGM resorts.

Used Data Vault techniques to model the data warehouse for agile development

Implement master data concepts for the operational models by collaborating with the solution architect and MDM architect

Manager of Data Logics

EBay Inc., Austin, Texas Mar 2016 – Feb 2017

Design data models as part of Global Risk Platforms and Compliance initiative to identify risk, assess the risk and take appropriate actions to make eBay the best shopping experience for users.

To understand the end user requirements to develop a scalable data mart that can be consumed by various downstream applications for ad hoc analysis, dashboards and develop risk models for predictive analysis.

Perform Data Analysis to document the intended target models of various source systems.

Used Python’s Pandas, Numpy, Matplotlib libraries to conduct data exploration.

Wrote SQL Scripts to present data findings and data in aggregated/raw forms for business functions.

Involved in architectural design to leverage data within Hadoop environment.

Involved in design discussions and implementations with developers to leverage site data through Kafka and process near real time data in Storm.

Data exploration and analysis of hive tables to document data element needed for analysis and reporting within risk business unit.

Worked to design data marts for account level and account status databases that help various teams to analyze the user experience, user statistics etc.

Incorporated industry standard modeling practices to support a detailed and subject oriented data mart.

Used Tableau Desktop to build dashboards and storylines for datasets in Teradata.

Senior Data Architect/Data Engineer

American Express, Phoenix, AZ Feb 2015 – Feb 2016

Responsible for working closely with the customers and business analysts to understand the database requirements.

Worked with ER Studio tool to create logical and physical data models.

Built data models for Amex Operational premium portfolios like Global Card Member Remittance, Credit Authorization Service and Wire Fraud Protection Systems.

Captured appropriate and detailed metadata for the conceptual, logical and physical data models.

Incorporated Amex and industry standard naming conventions for the attributes and entities.

Incorporated the best modeling practices to avoid data redundancy and implement the operational models in its 3rd normal form.

Experienced in working for project teams that practice agile and waterfall methodology.

Reverse engineered data models using the tool from the DDL’s or database schema.

Developed data models to support the target databases like DB2 and Oracle.

Involved in discussion with the DBA’s to fine-tune the database performance and model by adding additional indexes or revisiting the key structure etc.

Data Modeler

USAA, San Antonio, TX Jan 2014 –Feb 2015

Collaborated with the Business Analysts and development teams for data requirements by conducting JAD sessions.

Developed data models for various target database platforms like Oracle, SQL Server, MySQL, Netezza, DB2 LUW, and DB2 Host.

Used Erwin Data modeling tool to design Logical and Physical data models to suit the business needs.

Designed Conceptual, Logical and Physical data models for OLTP, Data Warehouse and Data Mart Applications.

Worked on BILAB Agile projects to design models with stringent timelines.

Physically instantiated the DDLs generated from the tool to the target database.

Extensively used complex SQL queries for querying and analysis of data using the Squirrel Client, Aginity Netezza and DB Artisan.

Assisted the DBA’s by Looking at the tuning side by analyzing the queries using the EXPLAIN PLAN & Auto-trace utilities.

Provided other data analysis services as required.

Created data mapping documents to assist ETL teams using Informatica and Data Stage.

Data Analyst/Modeler

JP Morgan Chase, Columbus, OH Apr 2013-Dec 2013

Worked on reengineering projects in designing data models for target DB2 systems from legacy IMS database.

Extensively worked on IDA and RTC tools to develop, maintain and enhance the data models as per the needs.

Generated a customized business object model using the IBM recommended artifacts for classes and methods in Java.

Analysis of data from legacy systems and designing data model for target DB2 database.

Generated UML scripts and class diagrams using the IDA data modeling tool.

Worked on providing training across development teams to adhere and be familiar with the industry standard data models and artifacts.

Worked to ensure data governance across various applications and project teams.

Data Analyst/Modeler

Lowe’s Companies, Inc., Mooresville, NC Oct 2010-Jan 2013

Designed Conceptual, Logical and Physical data models for OLTP, Data Warehouse and Data Mart Applications.

Built data models to adhere with 3rd normal form in transaction systems and denormalized as necessary in data marts.

Used Model Mart in order to maintain a library of all the development models in progress.

Used Complete Compare in order to make migrate from development to production version.

Generated reports using the ERWIN tool in order to assist the ETL teams.

Software Engineer

Infosys Technologies Limited, Chennai, India Nov 2006 –July 2008

Web application testing regarding cheque fraud protection for Canadian client ‘Symcor’.

Involved in testing the end-to-end system functionality and regression testing, identifying and retesting defects.

Involved in application testing for Toronto Dominion and Bank of Nova Scotia for over 8 months. Testing ensured processing cheques and raising exceptions in case of fraudulent activity detection.


Master of Science: Electrical Engineering

University of Bridgeport - Bridgeport, CT 2010

Bachelor of Engineering: Electronics and Communication Engineering

Anna University -India 2006

Contact this candidate