Sr Data Modeler Resume
New York New, YorK
SUMMARY:
- 9+ Years of working experience as Data Architect and Data Modeler with good proficiency in requirement gathering and data modeling (Conceptual, Logical and Physical) including design and support of various applications in Data Warehouse, ODS, ETL and BI Environment.
- Strong experience as a lead data modeler implementing custom (Enterprise Data Warehouse) EDW solutions based on user specific requirements.
- Experienced in creating data models to support Health care, Education, Retail, Banking and Insurance domain needs.
- Good exposure to Relational databases like SQL Server (2005/2008/2014/2016 ), Oracle 10g, 11g, Teradata 12.0,13. 10, 14, DB2.
- Experience implementing Master Data Management(MDM) Solutions.
- Well versed in Data Warehousing life cycle (SDLC) like gathering business requirements, profiling and cleansing, source - target mapping, data integration/ETL, data marts, Inman/Kimball methodology, Normalized modeling for OLTP, dimension modeling for OLAP (star/snowflake design) systems.
- Experience in delivering Conceptual, Logical and Physical Data Models involving various Enterprise New and Existing Applications.
- Very well experienced in Metadata Management, Mapping documents (Source to target) and Data Dictionaries implementing and understanding business rules/ process.
- Extensive experience in Normalization (1NF, 2NF, 3NF) and De-normalization techniques for improved database performance in OLTP and OLAP Systems.
- Ability to enhance operational systems to reduce redundant data and created facts and dimensions in the data mart for multi-dimensional reporting
- Vast experience in using ER modeling tools such as Erwin r9.6, r9.5, ER/Studio, and Power designer 12.0.
- Capability of designing and handling the models for very large databases.
- Proficient in data mart design, identifying facts & dimensions for star & snowflake schemes.
- Experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
- Experience in clarifying client requirements, business needs and project objectives at each level of project implementation.
- Expert in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
- Work experience with ETL and Reporting tools like Oracle data Integrator (ODI), SSIS, SSRS, Informatica Powercenter9.5x, MicroStrategy.
- Good interpersonal and human relation skills to interact with clients and co-workers
- Excellent communication, documentation and presentation skills with clear understanding of business process flow.
TECHNICAL SKILLS:
Database systems: SQL Server2008, 2012, 2014, 2016, Oracle 10g, 11g, T/PL-SQL (Query Language) Teradata 14.0, DB 2, MS Access 2007.
Analysis and Data Modeling tools: Conceptual, Logical, Physical Data Modeling, Erwin r9.6, E/R Studio, Power Designer 12.0.
Office Applications: MS Word, MS Excel, MS Office, MS PowerPoint, MS Visio.
Operating Systems: Windows 7/Vista/2000/XP/2003, Unix
ETL and Reporting tools: SSIS, SSRS, Oracle Data Integrator 10g,11g(ODI), Informatica Powercenter, Microstategy9.5x, Tableau, Congos.
PROFESSIONAL EXPERIENCE:
Confidential, New York, New York
Sr Data Modeler
Responsibilities:
- Worked with senior management & stakeholders to build the strategic informational roadmap for the NYCHHC reporting needs in regard to data modeling, data management and advanced data analytics systems.
- Worked with all levels of external and internal business customers for requirements development.
- Reviewed existing Epic Data Models and architecture leading to new development that improved existing warehouse model to solve Business/ Reporting needs.
- Created Source to Target Data Mapping rules to extract data from central source databases like Dentrix, PCC, Radiology to Map to Integrated Layer/ OLTP system.
- Created Data Models to support 300 by 300 Initiative by HHC and supported Data Needs accordingly.
- Implemented Master Data Management (MDM) Strategies and created Data Models to support Integrated Data Models and Warehouse using Normalization techniques.
- Created Data Validation rules to support ETL Process and assisted Business users and Stakeholders to understand the data flow to support their reporting needs.
- Developed Conceptual, Logical and Physical data models from given business requirements.
- Responsible for different Data mapping activities from Source systems to PL/SQL and SQL Server.
- Created and updated Data dictionary following documents given by business and maintained metadata within Erwin.
- Updated the existing Dimensional Models to support Reporting needs.
- Implemented SCD Type1, Type2 dimensions to adapt changing business requirements.
- Architected data systems, strategies and business processes operational data store and warehouse models for new reporting customer.
- Created Data Marts and Models for Key Domains/ Subject areas like Provider, Procedure, Encounters, Visits.
- Highlighted gaps in reporting and data management capabilities, and developed mitigation strategies.
- Responsible in overseeing the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.
- Collaborate with project managers, address data related problems in regard to systems integration and compatibility, as well as act as a leader for coaching, training and providing career development to stakeholders.
- Created PL/SQL, T-SQL objects like tables, complex stored procedures, views, Indexes, triggers, constraints, defaults, user defined data types and functions.
- Worked Closely with DBA’s, Developers, and configuration teams to support Production implementing activities.
- Ensuring that DW/BI standards and guidelines are used to develop the information models and database designs.
- Working with the DBA to transform the logical information model into a first-cut logical database design (physical information model for the target DBMS).
Environment: Oracle 11g, SQL server 2018, Erwin r 9.6, SSIS, Tableau, MS Outlook, MS Project, MS Access, MS Excel and MS Word.
Confidential, Brooklyn, NYC
Data Architect and Administrator
Responsibilities:
- Developed and delivered long-term strategic goals for data architecture vision and standards in conjunction with data users, department managers, clients, and other key stakeholders.
- Worked with Business Owners, Business Analysts, Database Administrators and Content developers to gather requirements, conduct design reviews and validate the developed models.
- Developed Data Flow diagrams to visualize architectural, functional and process view of data flow with in many Confidential systems.
- Worked with old and legacy Confidential systems to get business logics and integrate them into single Enterprise Operational Data Source and finally into Enterprise Data Warehouse.
- Analyzed the business requirements and designed the appropriate Conceptual, Logical and Physical data models required to support the diverse reporting needs of the Special Education office.
- Used Erwin r9.6 Data Modeler to create graphical representation in the form of Entity Relationships (E/R diagrams) and elicit more information.
- Worked on Forward and Reverse Engineering for databases to identify certain data elements in use and study their relationships.
- Created and Updated Source to Target Mapping document applying business transformations/ logic.
- Designed a target Normalized Operational Data Source integrating different legacy systems in to one ODS.
- Implemented an Enterprise Dimensional Database to support reporting needs for all Confidential vendors and entities.
- Implemented slowly changing and rapidly changing dimension methodologies.
- Created and maintained surrogate keys on the master tables to handle SCD type-2 changes effectively.
- Maintained metadata with in Erwin and Data Dictionaries to support physical data models and business understandings after thorough analysis of source systems.
- Supported Front end Applications for SESIS domian and made changes to existing logics to support HPQC’s.
- Worked on integrating unstructured data as input from different source systems in to ODS.
- Extracted business logics from different legacy code like SAS, COBOL and implemented them in feeding unstructured data to ODS.
- Created Database Objects - Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure and Constraints.
- Helped in creating scripts in migration process and coordinated with SSIS developers to deploy them in Dev, QA, staging and production environments.
- Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance by creating indexes and partitions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Supported development and production activities for various databases and ETL, SSIS packages.
- Responsible for tuning complex T-SQL queries and Stored Procedures to increase performance in SQL Server.
Environment: Erwin r9.64, SQL Server, .Net Framework, SSIS, COGNOS, MS Project, MS Access, MS Excel and MS Word.
Confidential, Topeka, KS
Data Modeler / Data warehouse Analyst
Responsibilities:
- Involved in every stage of data warehousing-SDLC from Requirement gathering, source to target mapping, ETL, Base layer, Developing, Reporting layer (semantic layer).
- Worked on the enterprise level modules for the client to perform the data modeling and data architectural related tasks and providing solutions to migrate data on various platforms from hierarchical to relational databases to unstructured databases.
- Integrated Source DB2 tables, flat files and unstructured data into Teradata Data Warehouse.
- Lead the project for gathering requirements for the data element mappings and analyzing earlier models for all the LOB’s.
- Developed Conceptual, Logical and Physical data models from given business requirements using Erwin 9.6.
- Defined the relationship between primary and foreign keys in tables.
- Developed, Implemented and Maintained logical data model to full attribution within the scope of a specific data project.
- Worked on the OLAP for data warehouse and Sales Data mart developments using Ralph Kimball methodology as well as OLTP models (normalized 3NF) and interacted with all the involved stakeholders and SME is to derive the solution.
- Working on forward and reverse engineering the DDL for the SQL Server and Teradata environments and successfully deployed in Production database.
- Providing day-to-day Support and Maintenance for SQL Server and Teradata Databases.
- Responsible for Database Maintenance and Migration of database objects from one server to another Server and database to another database
- Created databases and database level objects like tables, views, functions to support and project implementation.
- Worked with ODI Developers to create Source to Target Data Mapping rules to extract data from central source databases.
- Responsible for different Data mapping activities from Source systems to Teradata and SQL Server.
- Created and updated Data dictionary following documents given by business and maintained metadata with in Erwin.
- Created Extract, Transform and Load (ETL) processes for large-scale Data Warehouses and SQL programming skills.
- Modified, updated existing ETL/ DTS and data warehouse queries for fast data retrieval and better performance.
- Experience in development, testing, production support and maintenance of projects.
- Used explain plan for query optimization, finding missing index and optimized existing index.
- Expert in developing production installation work flow and worked closely with project team in successful implementation.
- Excellent backend skills in creating PL/SQL objects like tables, complex stored procedures, views, Indexes, triggers, constraints, defaults, user defined data types and functions.
- Used ODI ETL tool to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
- Responsible for tuning complex queries and Stored Procedures to increase performance. Modify Stored Procedures and complex PL/SQL Queries to improve query execution process.
- Executed Shell Scripts to load the data files (Source files) into the database in SIT.
- Participated in Sprint planning, daily stand up meetings, Sprint review and Sprint retrospective.
- Addressed review meeting with senior data architects and developers on designing database.
- Provided assistance and guidance during the QA & UAT phases and quickly confirm the validity of potential issues to determine the root cause and best resolution of verified issues.
Environment: E/R Studio, SQL Server 2012, Teradata 14.10, Micro Strategy, Oracle Data Integrator(ODI) 11g, MS Project, MS Access, MS Excel and MS Word.
Confidential, San Francisco, CA
Data Modeler
Responsibilities:
- Responsible for producing a data roadmap to introduce BI/DW systems to the organization.
- Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization.
- Designed conceptual, logical and physical data model for the bank integration projects and accounts.
- Data Models, Logical Data models and transformed them to creating schema using Power Designer 12.0.
- Checked for all the modeling standards including naming standards, entity relationships on model and for comments and history in the model. Conducted design walk through with project team and got it signed off.
- Created a Data Mapping document after each Source to Target assignment and wrote the transformation rules for each field as applicable.
- Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
- Performed installation of SQL Enterprise 2012 Service pack1 Cumulative Update 5 64bit version on Windows 2012 Sp1 Clusters
- Experienced with creating Database maintenance plans for efficient operations.
- Experience in creating customized databases creating tables, views, Indexes, reference tables, relations.
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
- Data profiling and Data Cleansing is been performed on existing table/ databases using complex queries.
- Used joins, indexes effectively in where clauses for query optimization.
- Good Experience in Performance tuning activities like verifying the slow running queries and Stored Procedures.
- Created table indexes that optimize query speeds.
- Configuring and monitoring SQL Server Jobs and doing Job Failure Analysis.
- Worked Closely with DBA’s, Developers, and configuration teams to support Production implementing activities.
- Created stored procedures, functions, and packages by writing P/L SQL queries based on the client requirement as per the day to day updating of business logic.
- Utilized Dynamic T-SQL within functions, stored procedures, views, and tables.
- Modified custom database utilities using SQL Server T-SQL and UNIX shell scripts according to customer requirements.
Environment: Oracle 11g, SQL server 2012, Power Designer 12.0, Oracle Data Integrator 11g, Tableau, MS Outlook, MS Project, MS Access, MS Excel and MS Word.
Confidential, Omaha, NE
Data Modeler/Analyst
Responsibilities:
- Involved meetings with SME’s, Data Architect and Data modelers in getting the Business Requirements.
- Identified and understood the business function activities, entities, data attributes, table’s metadata and documented detailed design specifications for new system
- Ensured business requirements did translate into data requirements.
- Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
- Created Normalized (3NF) data models to support the business reporting systems and implemented Bill Inmon data warehousing methodology.
- Used Erwin for creating tables using Forward Engineering.
- Developed, Implemented and Maintained logical data model to full attribution within the scope of a specific data project.
- Defined the relationship between primary and foreign keys in tables.
- Installing new SQL Server 2012 Servers.
- DBCC checks to ensure the physical consistency of the database and objects.
- Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
- Worked with Data Analyst, Business analyst in creating data dictionaries and uploaded them into project folder for future reference.
- Utilized organizational standards for data naming, structuring and documentation.
- Responsible for defining database schemas to support business data entities and transaction processing requirements.
- Created source to target mapping documents considering the business rules and coordinated with ETL team.
- Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.
- Investigated and implemented solutions for data quality issues in Production databases.
- Reviewed current database design and making suggestions for better performance.
- Worked on writing stored procedures and queries for migration and interim project.
- Worked on Optimizing existing SQL code.
- Created Materialized views, Stored Procedures, tables, indexes using PL SQL querying language and deployed.
- Designed and changed existing data model as per business requirements.
Environment: E/R Studio, Erwin r9, SQL Server 2008,2012, DB2, MS Project, MS Access, MS Excel and MS Word.
Confidential
Data Analyst
Responsibilities:
- Addressed training sessions for developing Data Models based on business requirement.
- Created Logical and Physical data models with in Visio.
- Coordinate with business to help them understand the conceptual, logical and Physical data Modeling developed for the Business process.
- Created Transactional databases as Normalized structures to support data redundancy issues and maintained data integrity by creating reference tables.
- Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008r2, 2005.
- Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
- Developed the Data mappings documents used in ETL process.
- Created data dictionary for both logical and physical data models to help the reporting team.
- Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
- Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS).
- Experience in monitoring and troubling shooting existing data warehouse queries for better performance and data retrieval.
- Performing performance tuning of the database systems, jobs, indexes, queries and configurations.
- Experience in development, testing, production support and maintenance of projects.
- Performed explain plan and query optimization on existing complex queries.
- Developed complex stored procedure using T-SQL to generate Ad hoc reports.
- Performed and fine-tuned stored procedures, SQL Queries and User defined functions.
- Involved in generating Periodic Status Reports.
- Facilitates UAT (User acceptance testing) with business.
Environment: SQL server 2012 , Oracle 8i, and Reports 3.0, Windows XP, SQL server, MS Access, MS Visio, MS Excel.