SUMMARY

• Diverse experience in IT industry with emphasis on Data Modeling, Data Analysis and SQL Development, working on multiple domains like Manufacturing, Technology industries across various clients.
• Experienced individual with expertise in Data Modeling, Analysis, Design, and Implementation of Business Applications using the Relational Database Management System (RDBMS).
• Acted as a strong liaison between business users and IT personnel, following the best practices in the field.
• Strong understanding of all phases of Software Development Life Cycle (SDLC) such as Development, Testing, Migration and Production support.
• Proficient in Data Warehousing concepts including Dimension Modeling (Star Schema, Snow - Flake Schema Design) and Relational Modeling.
• Strong Experience in Relational Data Modeling & Dimensional Data Modeling to deliver Normalized Data Models & Star and Snowflake schemas using Erwin 9.6, ER Studio 15, Sybase Power Designer 15/16.5.
• Well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments.
• Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Generated DDL scripts from the physical models for implementingDataModeling changes and worked on comparing and merging the data models
• Defined the Glossary and Naming Standards file for the Data Models
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Worked extensively across various DBMSs like SQL server (SQL Server 2017/2014/2012 R2), Oracle 11g/10g, Teradata and IBM DB2.
• Experienced with ETL tools such as Informatica Power Center, SSIS.
• Experience in Data Transformation, Data mapping from source to target database schemas and data cleansing procedures using Informatica Power Center and SSIS.
• Familiarity with Tableau, Cognos and SSRS - Query, Reporting, Analysis and Enterprise Information Management .
• Experience in collecting, organizing, interpreting, and disseminating various types of statistical figures.
• Created Source to target mapping for ETL loads.
• Good understanding of Business Intelligence (BI) and Data Warehousing layers: ETL, Data Warehouse, semantic and reporting.
• Excellent Analytical, Inter-personal and Communication skills with ability to interact with individuals at all levels in Software Development Life Cycle.
• Strong experience in translating business needs into technical design and solutions.

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data modeler /9.6,9.8,2020 R1, ER Studio, SAP Power Designer, SQL data modeler

Programming Language: SQL, PL/SQL, Python, T-SQL

Database: Teradata, Oracle 10g/11g/12c, MS SQL server, DB2

Reporting Tools: Tableau, Power BI

Operating Systems: Windows, Unix, Linux

Business Tools: MS Word, MS Excel, MS PowerPoint, Visio

ETL tools: Informatica PowerCenter, SSIS

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Data Analyst

Responsibilities:

• Gathering business requirements by organizing and managing meetings with business stakeholders, application architects, technical architects, and IT analysts on a scheduled basis.
• Responsible for End-to-End development cycle for Data modeling.
• Partnered with developers to support the use of the data model designs.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Created Conceptual, Logical, and physical models using Erwin.
• Created XML and JSON schemas to populate the reference data.
• Designed and implemented effective database solutions and models to store and retrieve the company data.
• Worked in Name rationalization process for standardizing Logical names.
• Migrated data from legacy systems to new core Platforms/ Solutions, On Prim to Cloud Migration.
• Supported data quality issue analysis and remediated strategic data.
• Identified source and created Source-to-Target mapping documents (STTM).
• Created data sheets for ETL to load the data also created Load order reports for ETL.
• Developed Enterprise Data Dictionary for reusable objects like domains, attachments, defaults, reference values, User data types and reusable procedural logic.
• Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Architects and ETL Developers.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: ERWIN r9, SQL Server, Snowflake, Oracle 11g, Microsoft Excel, Tableau, SSIS, Informatica, Python, Jira, AltovaXMLSpy 2018

Confidential, Cupertino, CA

Data Modeler

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Extensively used SQL for Data Analysis.
• Done Reverse engineering on existingdatamodel to understand thedataflow and business flows.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Created Schema objects like Indexes, Views, and Sequences.
• Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed normalized Logical and Physical database models to design OLTP system.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Developing the Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards fordata warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch datafrom legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of Erwin for effective model management of sharing, dividing, and reusing model information and design for productivity improvement.

Environment: Erwin r9/9.1, Oracle 11g, SQL Developer, Crystal Reports 9, Windows XP, DB2, Tableau.

Confidential, Dearborn, MI

Data Modeler/Analyst

Responsibilities:

• Understand database design and gather system requirements - review and discuss pre-approved business requirements from the team and begin identifying and collecting specific system requirements (technology specs that will meet the business needs).
• Involved with subject matter experts to identify and evolve key datamanagement strategies and initiatives within the organization.
• Performed source to target data mapping by identifying the source from existing databases and defined the transformation logics.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Ensured the ease of accessing history of reference data changes by implementing Slowly Changing Dimensions Type 2 and Type 4 of reference data.
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and Data warehouse.
• Implemented different types of data strategies, Data Cleansing rules, Data Profiling, and validity, built data flows.
• Implemented Snow-flak schema to ensure no redundancy in the database.
• Implemented Forward Engineering by using DDL scripts and generating indexing strategies to develop the logical data model using SAP Power Designer.
• Reverse Engineered physical data models from SQL Scripts and databases.
• Worked with the various teams to identify and analyze the Orphan/duplicate objects from the Database and performed appropriate action over it.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Developed best practices for PL/SQL stored procedures, functions to implement alerts and data integrity after each ETL process to maintain a balance between target and source tables.
• Analyzed SQL scripts and designed the solutions to develop a custom ETL pipeline using python.
• Developed a star schema data warehouse model for the proposed central model.
• Convert ERD Model into Relational Model for data warehousing.
• Performed Teradata (Enterprise Data Warehouse) validation and analysis to identify the accurate data source and to track data quality to detect/correct the invalid data.
• Developed OLTP system by designing Logical and eventually Physical Data Model from the Conceptual Data Model by reviewing the business requirements.
• Implemented dataquality checks on the monthly LAR file to make sure the datais within the federal regulations.
• Conducted team meetings and JAD sessions for the requirements clarifications and to translate the business needs into data models supporting long-term solutions.
• Identify required dimensions and fact using Power Designer tool for the Dimensional Model.

Environment: Oracle 11g, Teradata, SQL Developer, SAP Power Designer, T-Assistant, SQL Management Studio, MS Excel, SSIS, Microsoft Windows Vista, Metadata Repository.

Confidential

SQL Developer

Responsibilities:

• Created application database code objects such as stored procedures and views by planning, designing, and implementing them.
• For data analysis and extraction, I created and maintained SQL scripts, indexes, and sophisticated queries.
• Provided database coding to support business applications using Oracle SQL.
• Performed Query Optimization, Performance Tuning, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Tested and inspected the SQL server environment for quality assurance.
• Developed new processes to facilitate import and normalization, including data file for counterparties.
• Identified business needs and discussed solution choices with business stakeholders, application developers, and production teams, as well as across functional groups.
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Participated in process analysis to help produce and refine requirements and create technical solutions.

Environment: Erwin9.8, PL/SQL, SQL, Oracle 11g, QlikView11.6, Power Designer, Microsoft Visio, Adaptive.