SUMMARY

• Data Analyst/Data Modelling professional with around nine plus years of total IT experience and expertise in data modeling and Data analysis for data warehouse (OLAP) and business Intelligence (BI) applications.
• Strong Data Mapping experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin, E/R Studio and Sybase Power Designer.
• Experience creating DDL scripts for implementing Data Modeling changes.
• Experience creating ERWIN, ER Studio and Toad data modeler reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co - coordinated with DBA’s to apply the data model changes.
• Very strong in using data modeling Tools like ERWIN, Power Designer, Toad data modeler and E/R Studio.
• Normalized tables and dimensions up to 3NF in order to optimize the performance.
• Experience in Data Integration techniques like Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, MS Access, flat files, CSV files and XML files into target warehouse using various transformations in Informatics, Data Stage, ODI.
• Strong in Source to Target data mapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, Building Data Marts and Meta Data Management.
• Created the Logical and Physical design of the Data Warehouse (both Fact and Dimension tables) using STAR Schema approach.
• Delivered BI reporting solutions in Power BI, Reporting services (SSRS) and Tableau.
• Sound understanding of Gap Analysis, requirement management, risk analysis and project plans.
• Strong experience with architecting highly performance databases using PostgreSQL, Snowflake, MYSQL and Cassandra.
• Data modeling based on the data vault approach to enable historical storage of data, integration of data from different operational systems, and tracing of the origin of all the data coming into the database.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, System Administrators, Senior managers and Partners
• Well versed with SDLC software development life cycle. Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, MS Access and Excel.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, E/R Studio, Sybase Power Designer, MS Visio, Toad

Databases: IBM DB2, Teradata, MS SQL Server, Oracle, MongoDBv2.2-3.4, Snowflake, Toad for Oracle, Studio 3T.

Databases tools: Robo Mongo, MongoDB Compass, Oracle SQL Developer, Studio 3T for JSON.

Tools: MS SQL Server Integration services (SSIS), Analysis Services (SSAS).

Development Skills: SQL, PL/SQL, HTML, Java, DAX, Visual Basic, C, Python, JSON, PSQL

Operating Systems: Windows NT/XP/2000/7, UNIX, Linux, Sun Solaris

Others: MS Office, SharePoint

Data Warehouse: Informatica 9.6.1, Data Stage, Talend.

Modeling: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables, ER Modeling.

Big Data Technologies: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, NoSQL, Flume.

BI Reporting Tool: Power BI, Tableau, SSRS.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Modeler

Responsibilities:

• Assembling of large, complex data sets that meet functional / non-functional business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
• Actively participated in JAD sessions with Java Architects, ETL Leads, and Technical Leads.
• Responsible for creating conceptual, and logical and physical data models using a wide variety of modeling philosophies and techniques including Inmon and Kimball.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.
• Handled importing of data from various data sources, performed transformations using Hive, loaded data into HDFS and Extracted the data from Oracle into HDFS using Sqoop.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Maintain model metadata as required by QA modeling standards and applying security classifications to entities as defined by OA data governance
• Participate in data model review sessions to ensure models meet stated data requirements and responsible for physical entity creation in Dev, stage, and prod (via DBA request)
• Provided SAP HANA modeling and analytics expertise in the development of new solutions as well as the improvement of the existing solutions.
• Follow established configuration/change control processes and identified options for potential solutions and assessing them for both technical and business suitability

Environment: ERWIN, Tableau, Mongo Compass, Snowflake, Toad for Oracle, Oracle SQL Developer, Hive, Python 3,Mongo DB, Jira, Bit Bucket, Confluence, HDFS, Sqoop, SQL Assistance, OLAP, OLTP

Confidential

Lead Data Modeler

Responsibilities:

• Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of enterprise and customer information systems requirements.
• Conduct one on one sessions with business users to gather data warehouse requirements.
• Analyze database requirements in detail with the project stakeholders by conducting joint requirements development sessions.
• Responsible to profile the current data tables using SQL tools to determine the key relationships in existing tables and using that information to design postgres SQL data lake tables.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Design normalized logical and physical database models to design OLTP systems for insurance applications using ER Studio.
• Use Reverse engineering to create a physical data model with the DDL that best suits the requirements from the logical data model for the new ODS curated Data store that Employers Insurance group is currently developing.
• Extract data from the databases using data stage to load it into a single data warehouse repository.
• Created and managed schema objects such as tables, views, cursors and indexes.
• Involved in developing content for and delivering training to others on the use of Tableau.
• Also involved in designing, developing and maintaining the reports and multi-level dashboards in Tableau for the client on the data lake.

Environment: Power Designer, ER Studio Data Architect, Tableau, studio 3T, Mongo Compass, Toad for Oracle, Oracle SQL Developer, Mongo DB, Jira, Bit Bucket, Confluence, Soap UI.

Confidential

Lead Data Modeler

Responsibilities:

• Identify the business requirements by going over the business process and interacting with the business analyst and management.
• Reverse Engineered the existing database structure to understand the existing claims data models so that any changes in corporate would synchronize with current model.
• Gap analysis and Profiling of potential Data Sources, upon high level determination of sources during initial scoping by the Project Team.
• Created Star schema to effectively translate the physical model into a dimensional model using conformed dimensions, role playing dimensions. Profiling data and standardize names and data types.
• Studied source system data. Developed SQL queries to pull data into staging databases to analyze.
• Created hubs to represent business keys, links for each type of relationship and satellites to represent the attributes of hubs and links.
• Use power designer data browser to produce table and column specifications to be distribute ETL and report teams.
• Provided data validation support during UAT.
• Validate logical data model and physical data model against the physical database.
• Developed standard queries to validate post ETL data.
• Developed logical data model and physical data model.
• Developed class words and maintained.
• Developed different subject areas for different functionality and to communicate the same to ETL and Reports teams.
• During PDM development, identified right data type, width, worked with DBAs to plugin right schema, tablespace information and produced DB scripts through “complete compare”.
• Produced detailed design document with DDL and source to table column mapping details.
• Developed SQL queries using common table expressions, temporary tables to support power BI and SSRS reports.
• Developed complex calculated measures using data analysis expression language(DAX).
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Working with DBAs for physical implementation of the data model.
• Raised tickets for initial creation of the schema and tables.
• Submitted tickets for alter scripts to maintain changes.
• Studied standards defined by data governance team and followed the design patterns and security implementations.

Environment: Power Designer, Power BI, Toad for Oracle, Oracle SQL Developer, DB2, Mongo DB, Informatica 9.6.1, Jira, Data vault, Bit Bucket, Confluence, Soap UI.