Candidates About

 

Syed Rizvi

Data Modeler/Business Data Analyst

 

·         Above 7 years of experience as Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.

·         Experienced in designing Architecture for Modeling a Data warehouse by using tools like Erwin r9.6/r9.5, Sybase Power Designer and E-R Studio.

·         Experience in SQL and good knowledge in PL/SQL programming and developed Stored Procedures and Triggers and Data Stage, DB2, UNIX, Cognos, MDM, UNIX, Hadoop, Pig.

·         Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS Architecture by using tools like Erwin Data Modeler, Power Designer, E-R Studio and Microsoft Visio.

·         Excellent experience in SQL Loader, SQL Data, SQL Data Modeling, Reporting, SQL Database Development to load data from the Legacy systems into Oracle Databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables.

·         Good experienced in Normalization for OLTP and De-normalization of Entities for Enterprise Data Warehouse.

·         Experienced in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export with multiple ETL tools such as Abinitio, Informatica and Power Center.

·         Experienced in Data Modeling including Data Validation/Scrubbing and Operational assumptions.

·         Solid experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.

·         Extensively experience on EXCEL PIVOT tables to run and analyze the result data set and perform UNIX scripting.

·         Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

·         Experience in Normalization and Demoralization processes, Logical and Physical Data Modeling techniques.

·         Experience in Database performance tuning and Data Access optimization, writing complex SQL quires and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.

·         Experience with SQL Server and T-SQL in constructing Temporary Tables, Table variables, Triggers, user functions, views, Stored Procedures

·          Excellent problem solving, strong mentoring, communication, and analytical skills with ability to work in a team or individually.

·         Good understanding of AWS, GCP, Mule soft, Salesforce.

 

 

TECHNICAL SKILLS:

·         Data Modeling Tools: Erwin r9.6/r9.8, ER Studio, Sybase Power Designer and Oracle Designer. Erwin Data governance tool, Erwin web portal, Er studio team server etc.

·         OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9.

·         ETL Tools: SSIS, Pentaho, Informatica9.6. Talend.

·         Programming Languages: Java, Base SAS and SAS/SQL, SQL, T-SQL, HTML, Java Script, CSS, UNIX shells scripting, PL/SQL.

·         Database Tools: Oracle, Teradata, Microsoft SQL Server 2014/2012/2008/2005, and MS Access, PostgreSQL.

·         Web technologies: HTML, DHTML, XML, JavaScript

·         Reporting Tools: Business Objects, Crystal Reports

·         Operating Systems: Microsoft Windows 8/7, UNIX, Linux,

·         Tools & Software: TOAD, SQL *PLUS, SQL*LOADER, MS Office, BTEQ, Teradata SQL Assistant

·         Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Waterfall Model.

·         Cloud platform: Amazon web services and Google cloud platform.

 

 

EDUCATION

 

Bachelors of Science – Computer Science                                                                                                2007                                                                                                 

Calcutta University  

 

Master of Business Administration – Finance                                                                                           2011

Bangalore Management Academy                                                                                                       

 

PROFESSIONAL EXPERIENCE:

 

Business Data Analyst                                                                                                         Dec 2017 – Present State of Colorado, Denver, Co

 

·         Massively involved in Data Modeler role to review business requirement and compose source to target data mapping documents.

·         Created logical/physical data models using Erwin for new requirements and existing databases, maintained database standards, provided architectural guidance for various data design/integration/migration and analyzed data in different systems.

·         Created Business Requirement Documents (BRD’s), such as SRS & FRS, integrated the requirements, and underlying platform functionality.

·         Identify the business requirements by going over the business process and interacting with the business analyst and management.

·         Developed Logical/ Physical Data Models using EMBARCADERO ER Studio tool across the subject areas based on the specifications and established Referential Integrity of the system.

·         Discuss with different agencies and their role and responsibilities.

·         Integrate the different agencies data and bring into one platform. Handle the different source system and create the target system.

·         Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWIN and EMBARCADERO ER Studio.

·         Created and Maintained Logical Data Model (LDM) for the project. Includes documentation of all Entities, Attributes, Data Relationships, Primary and Foreign Key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc.

·         Designed the Database Tables & Created Table and Column Level Constraints using the suggested naming conventions for constraint keys.

·         Identified and mapped various data sources and their targets successfully to create a fully functioning data repository.

·         Reverse Engineered the existing database structure to understand the existing data models so that any changes incorporate would synchronize with current model.

·         Created conceptual models and conducted several walkthrough meetings with Architects for approvals and also conducted team meetings for creating logical and physical models from the conceptual model.

·         Created physical and logical models using Erwin to effectively translate conceptual model into logical and physical models conforming to the business and data requirements.

·         Updated the definitions & physical names based on the Oracle standards.

·         Created Core Fact Tables to track and measure all types of transactions.

Environment: Erwin 9.8, Erwin Web portal, Erwin data governance tool, ER Studio, Tableau, PL/SQL, DB2, Oracle, Flat Files, SAS, ETL, Meta Data, MYSQL, Unix, MS Excel.

 

Data Modeler                                                                                                                       Nov 2016 – Oct 2017 Deutsche Bank, Jacksonville, FL

 

·         Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects and produced Logical /Physical Data Models.

·         Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including SQL Server and Teradata13.1.

·         Involved in Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.

·         Involved in data analysis and modeling for the OLAP and OLTP environment.

·         Planned, scheduled, and controlled projects based on plans and requirements outlined by the business.

·         Conducted JAD Sessions with the SME, stakeholders and other management teams in the finalization of the User Requirement Documentation.

·         Reviewed Business Requirement Documents and the Technical Specification.

·         Involved in writing test plans and test cases using Mercury Quality Center.

·         Coordinated with Track Leads and Project Manager to setup the pre-validation and validation environment to execute the test scripts.

·         Participated in writing data mapping documents and performing gap analysis on the systems.

·         Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.

·         Used extensively Base SAS, SAS/Macro, SAS/SQL, and Excel to develop codes and generated various analytical reports.

·         Used Model Manager Option in Erwin to synchronize the data models in Model Mart approach.

·         Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

·         Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server2008 with high volume data.

·         Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.

·         Developed the code as per the client's requirements using SQL, PL/SQL and Data Ware housing concepts.

·         Wrote T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

·         Used Performance Monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.

·         Created SSIS packages to export data from text file to SQL Server Database.

·         Created new replications, DTS packages to maintain high availability of the data between the servers.

·         Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis

·         Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization

·         Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable

·         Created and maintained Metadata, including table, column definitions

 

Environment: Erwin 9.6, SQL Server 2008, OLAP, OLTP, Flat Files, Metadata, Taradata13, PL/SQL, BTEQ, DB2, Oracle, SQL, Teradata, Netezza, UNIX, Microsoft SQL Server, TOAD.

                                                                                     

 

Data Modeler                                                                                                                     Aug 2014 – July 2016 Genpact Gurgaon India

·         Created Business Requirement Documents (BRD’s), such as SRS & FRS, integrated the requirements, and underlying platform functionality.

·         Identify the business requirements by going over the business process and interacting with the business analyst and management.

·         Conducted Analysis and Profiling of potential Data Sources, upon high level determination of sources during Initial Scoping by the Project Team.

·         Involved in discussions with clients/users to determine the Dimensions, Hierarchies and Levels, Basic Measures, Key Metrics for Relational, Multidimensional Data Model for the system and understanding report requirements. Designing Star/Snowflake Schema Data Models.

·         Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Stewards, Data Architects, ETL Developers, and Data Modelers.

·         Interacted with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical and Physical Data Models, Designing Database, Documenting and Rolling out the Deliverables.

·         Involved in Dimensional Modeling, identifying the Facts and Dimensions.

·         Created Custom Fact Tables to track and measure specific types of transaction that customer made.

·         Updated the definitions & physical names based on the Oracle standards.

·         Created Core Fact Tables to track and measure all types of transactions.

·         Created Conformed Dimensions to allow Roll up & Drill down across to other data marts.

·         Used Degenerate Dimensions in order to create unique policy number for insurance claims.

·         Developed Logical/ Physical Data Models using EMBARCADERO ER Studio tool across the subject areas based on the specifications and established Referential Integrity of the system.

·         Maintained and Enhanced Data Model with changes and furnished with Definitions, Notes, Reference Values and Check Lists.

·         Worked very close with Data Architectures and DBA team to implement Data Model changes in database in all environments. Generate DDL scripts for Database Modification, Macros, Views and set tables.

·         Environment: EMBARCADERO ER Studio, Oracle 10g, Toad, Windows XP, SQL Server 2000/ 2005, XML, Excel, Access.

 

 

Data Modeler                                                                                                                    April 2012 – July 2014 Xchanging Bangalore India

 

·         Developed SQL and PL/ SQL scripts for migration of data between databases.

·         Involved in requirement analysis, ETL design and development for extracting data from the source systems likeDB2, Oracle, flat files and loading into Netezza.

·         Worked on MYSQL database on simple queries and writing Stored Procedures for Normalization De-normalization.

·         Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.

·         Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.

·         Created data flow diagrams and process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.

·         Prepared strategy to implement ETL code in production and load historical as well as incremental loads data in production.

·         Analyzed user statement of requirements to develop new reports.

·         Analyzed user requirements, attended change request meetings to document changes and implemented procedures to test changes.

·         Gathering statistics of data objects using Analyze and DBMS_STATS.

·         Involved in mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping, inclusive of logical names, physical names, data types, domain definitions, and corporate meta-data definitions.

·         Converted physical database models from logical models, to build/generate DDL scripts.

·         Created mapping document and mappings in MDM HUB ORS using various cleanse list and cleanse functions.

·         Strong knowledge of database such as Oracle, DB2, Netezza.

·         Coordinating with DBA in implementing the Database changes and updating Data Models with changes implemented in development, QA and Production

·         Knowledge of Merging several flat files into one XML file.

·         Extensively worked on creating, Altering and Deleting the Tables in different Development Environments and Production.

·         Extensively worked with logical models to change them into complete physical models from where we can implement these models into database.

·         Extensively worked with developers on analyzing the impacted changes on respective applications based on which design approach is taken and same changes are implemented in database with help of DBA.

·         In depth analyses of data report was prepared weekly, biweekly, monthly using MS Excel, SQL & UNIX.

Environment: Erwin 7.0, Informatica ETL, PL/SQL, Netezza, DB2, Oracle, Flat Files, SAS, ETL, Meta Data, MYSQL, Unix, MS Excel.