SUMMARY:

• 8+ years IT experience with expertise in data modeling for transactional, data warehouse/ data mart development, SQL, data analysis for online transaction processing OLTP, OLAP and business intelligence (BI) applications and data science.
• Data modeler with strong conceptual, logical and physical data modeling skills for relational and dimensional modeling. Worked extensively on reverse and forward engineering processes.
• Multiple domain experience like banking, insurance, staffing, financial, etc. as a data modeler.
• Used Teradata banking data warehouse industrial model and ARTS (Association for Retail Technology Standards) from Teradata.
• Strong understanding of principles of normalization, data - warehousing concepts, star/snowflake schema modeling.

TECHNICAL SKILLS:

Data modeling tools: ERWIN 7.x 8.x, 9.5.2, ER Studio, Power Designer

Databases: Oracle 10g/11g, Teradata, DB2, MS access, SQL server, Big Data (Hive, Impala, etc.), Snowflake

Reporting Environment: OBIEE, Microstrategy, Tableau, etc.

ETL Environment: Informatica Powercenter 8x, 9x, SSRS, Datastage, etc.

WORK EXPERIENCE:

Confidential, Saint Louis, MO.

Data modeler

Responsibilities:

• Working on multiple products and systems related to retirement accounts, stocks, etc.
• OLTP data modeling with 3NF designs using Power Designer tool for enhancements or creating new systems
• Translating business requirements into a feasible design solution to enhance the technical capability of the product.
• Environment: Power Designer v16.6.x, Oracle, SQL Developer, Informatica

Confidential, Owing Mills, MD

Data modeler

Responsibilities:

• Lead modeler on the product offerings and Assets Under Management data for the brokerage line of business by designing the hierarchy of products using ERWin and fulfilling the reporting needs.
• Interaction with newer Informatica Cloud developers/architects about the capabilities of handling the current design requirements to provide solution for the snowflake database on Amazon Web Services (AWS) platform.
• Environment: ERWin, Snowflake db, Informatica Cloud

Confidential, Columbus, OH

Data modeler/ Analyst

Responsibilities:

• Relational data modeling and data analysis on policies, insurance holders, agreements, claims, transactions, etc. subject area connections and providing solutions to resolve the gaps in the dataflow.
• Rubymine for the testing automation on Netezza/Oracle databases using Informatica PowerCenter for the data migration and running the workflows.
• Environment: ERWin/ IBM Data Architect, DBeaver, IBM Netezza, Oracle, TOAD-Oracle, RubyMine, Informatica

Confidential, Riverwood’s, I

Data modeler

Responsibilities:

• Working on ER Studio v17 for the logical and physical model generation for Hive on top of HDFS and providing end customers solutions for data loading issues, performance optimizations, partitioning, bucketing, compaction level properties, transaction table properties, XML ingestion for updates and inserts of the data.
• Encryption of data using ER Studio, analyzing and profiling the data and discussions with the data governance.
• Fulfilling requirements of Neo4j, AWS (Amazon Web Services), Redshift by considering usage and statistical models.
• ENVIRONMENT: ER Studio, Big data/Hadoop/Hive/HDFS, Teradata 14.0, SAS, Data science (Python, R, Neo4j), Artificial Intelligence

Confidential, Hanover, MD

Data modeler

Responsibilities:

• Use case analysis on Cloudera/Hadoop solutions and framework and high level strategy discussion with vendors.
• Lead the efforts to analyze the data from multiple divisions at Allegis to get enterprise level view for the stakeholders.
• Working on ERWin to create the hive and impala structures for the faster retrieval of data from the impala layer.
• Syncing ERWin 9.5.2 with the Informatica Metadata manager, working with Informatica BDM (Big Data Management) Informatica IDQ (Data quality)
• ENVIRONMENT:ERWin, Oracle 12g, Hadoop/Hive/Impala, Hue Browser, MS Windows, Informatica Powercenter, Tableau, SalesForce, PeopleSoft, Tableau, Webfocus, etc.

Confidential

Data modeler

Responsibilities:

• Working on OLAP for datawarehouse using Ralph Kimball methodology as well as OLTP models (3NF).
• Relational data modeling for in-house applications like policy, auto/ life insurance, claims applications, etc.
• Technical and business metadata and naming standards creation by working with architects, data governance.

ENVIRONMENT: PowerDesigner 15, SQL Server 2008,2012, Teradata 12, SAS, Datastage, Microstrategy, etc.

Confidential, Jersey City, NJ

Sr. Data Modeler/Data Architect

Responsibilities:

• A centralized role involving working on multiple logical and physical data models to find the authoritative source for shared data elements across the LOB’s in semantic layer to build ‘true source of information’- ‘SOR.
• Worked on 3 layered Teradata architecture: staging, integration and semantic and consulted on naming standards.

ENVIRONMENT: Erwin 7.3, Oracle 11g, Teradata 12, SAS, Cognos, Informatica etc.

Confidential

Data Modeler

Responsibilities:

• Requirement analysis, design, enhancements and implementation and working with the data governance group.
• OLTP, OLAP and Canonical modeling for projects like Master data Management (MDM). Interacted with SOA (Service Oriented Architecture), PIM (Product Information Management) for MDM Hub as well as Java developers to provide solution on modules such as Taxing, Sales Audit, Retail, Merchandising, etc.
• Worked on reporting requirements for Teradata environment and created mapping docs for the ETL (ODI) using Erwin.

ENVIRONMENT: Erwin 9.5.2, SQL Server 2008/12, DB2, Mainframe z/OS 9.1/LUW, Oracle 11g, Teradata 12, ODI, Microstrategy, Java, .NET etc.

Confidential

Data Modeler/ Analyst

Responsibilities:

• Analyzing entities and relationships for billing and policy administration for insurance domain for 40+ databases
• Using ERWin and Web Portal to develop Logical and physical models according to Enterprise Architecture.
• Used Erwin Query tool for generating the customized reports and also generated data dictionary.
• Involvement in enterprise architecture for POC’s like big data analytics.
• Logical and physical database models to design OLTP system for applications using Erwin.
• Forward engineering to create a physical data model with DDL that best suits the requirements.
• SQL and data analysis of the genetics/proteomics data to identify patterns in genes and proteins sequences on NCBI.
• Perl/Python used for data manipulation/ extraction to find patterns in data using R (statistics language) and profiling methods.

ENVIRONMENT: MySQL, Perl, Python, Windows XP, R language, statistics