SUMMARY

• Having 11+ experience and Possess strong ER Modeling and Dimensional modeling skills forOLTP, Data warehouse and data mart applications for more than 8 years.
• Modeled data Marts by following Star Schema and Snowflake Schema Methodology, usingindustry leadingData Modeling tools likeErwin, IBM Infosphere Data Architect and ER STUDIO
• Experienced with Data Vault modeling.
• Experienced in UML Modeling using IBM IDA data modeling tool.
• Implemented database standards and enterprise standards in the models and made sure the OLTP system adhere to 3rd normal form.
• Carried out data analysis tasks by querying the data that is present in the database and worked with the ETL teams to design source to target mapping documents.
• Familiar with Ralph Kimball and Inmon’s dimensional approach to design data warehouses and data marts. Guided team members in following the best practices.
• Familiar with all stages of theSDLC development life cycle: Requirements gathering, Design, Development, Construction,testingand Implementation.
• Familiar with both agile and waterfall methodologies and provided quality deliverables to meet the project timelines.
• Experience inSQLand codingPL/SQLPackages, Procedures.
• Provided support and coordinated withDBAon data base build.
• Assistedwith ad - hoc query and report requeststo various customers.
• Experience in data mining and data analysis using Tableau Desktop
• Made sure the data models are compliant with the best industry standard practices.
• Interacted with ETL teams to develop data mapping documents for target applications.
• Familiar with big data and Hadoop concepts for data analysis using hive.
• Experience of working on ETL tools like Informatica, Datastage
• Experienced in python programming language for data analysis.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 8.2,9.5, E/R Studio, MS Visio, Oracle Designer, IDA 7.6,RTC Client

Programming Languages: Matlab, Labview, C, SQL, PL/SQL, Java, Python 2.7.12

Databases: ORACLE, MSQL, SQL Server, DB2Host, DB2 LUW, SYBASE, Teradata and Netezza

Other Tools: TOAD, Visual Source Safe, Clear Case, Aginity Netezza, DB Artisan, SQL Developer,Alation

Operating System: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Data Modeler

Confidential, Las Vegas, NV

Responsibilities:

• 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 Confidential 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.
• Involved in data profiling source systems to identify any data issues, be a subject matter systems for various consumers of the data mart and data warehouse structures.
• Adept in designing data models suited for Teradata, which was the reporting database at Confidential .
• Used Data Vault technique’s to model the data warehouse for agile development

Logical Data Modeler

Confidential, Austin, Texas

Responsibilities:

• Design data models as part of Global Risk Platforms and Compliance initiative to identify risk, assess the risk and take appropriate actions to make Confidential 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.
• Used Erwin as a data modeling tool to forward engineer the models into scripts and reverse engineer the scripts into the tool .
• 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

Confidential, Phoenix, Arizona

Responsibilities:

• 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 third 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

Confidential, San Antonio, TX

Responsibilities:

• 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.
• Experienced in different data modeling approaches to suit the data warehouse, data marts and OLTP applications.
• Meetings with the application teams, DBA and business analysts to come up with the optimized and best approach for the data models.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained the data model and synchronized it with the changes to the 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.
• Worked closely with ETL and Business Objects teams for data mapping, extraction and reports.

Data Analyst/Modeler

Confidential, Columbus, Ohio

Responsibilities:

• 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.
• Worked on building and maintaining a metadata at the Business Object Model level to be shared across peers and other technical and functional teams.
• Built reports to cater to the technical and functional teams using the IDA data-modeling tool.
• Generated a customized business object model using the IBM recommended artifacts for classes and methods in Java.
• Transformed the business object models to logical and physical models using IDA data modeling tool.
• Generated the DDL using the IDA tool to be implemented by the DBA in the database.
• Worked on building baselines versions of various releases and scope down of the existing classes used in the IDA data modeling tool.
• Weekly reviews and meetings with the team and the data architects to make sure the tasks are carried out in a timely manner.
• Made sure the model is synchronized to the changes in the database.
• Analysis of data from legacy systems and designing data model for target DB2 database.
• Provided reviews and approvals to new release changes across different applications.
• 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.
• Trained and shared information with other members in the data architect team.

Data Analyst/Modeler

Confidential, Mooresville, NC

Responsibilities:

• Worked with the Business Analysts for requirements gathering, business needs analysis and project coordination and validated data requirements by conducting JAD sessions.
• Extensively 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.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Built data models to bring it in compliance with the 3rd normal form.
• Frequent meetings and brainstorming sessions in order to make sure that the data corresponds to the business needs.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• 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.
• Reviewed copybooks in order to make sure that the data adheres to the required standards.
• Maintained the data model and synchronized it with the changes to the database.
• Generated reports using the ERWIN tool in order to assist the ETL teams.
• Extensively used complex SQL queries for querying and analysis of data
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• 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.

Software Engineer

Confidential

Responsibilities:

• 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.
• Demonstrate a strong relationship with the developers and QA lead from the client side.
• Collaborate with the team manager and other team members to resolve team tasks and knowledge transfer to new team members.
• 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.