Sr. Data Modeler & Data Analyst Resume Baltimore, MD - Hire IT People (2024)

SUMMARY

• 8 years of working experience as a Data 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
• Very good experience with data governance
• Experience integrating Tableau into various external environments (such as websites, SharePoint, etc.)
• Extensive experience developing reports, dashboards, and cubes in Microstrategy version 9
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Ability to write test cases and execute testing within a web service environment
• Assist business users in defining User Acceptance Testing, test cases and plans.
• Experience of creating of different dashboards for analytics projects. Expert level experience on visualization of data as per client requirements.
• Worked in Data quality latest tool Information Steward
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Created and maintain test cases in Quality Center and/or Test Director
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Good in ETL testing concepts.
• Hands on experience in ETL testing and in writing test cases
• Highly proficient inDataModeling retaining concepts of RDBMS, Logical and PhysicalDataModeling using 3NormalForm (3NF) and MultidimensionalDataModeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Used complete knowledge ofdataware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Expert in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases.
• Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.
• Expert level understanding of using different databases in combinations forDataextraction and loading, joiningdataextracted from different databases and loading to a specific database.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies.
• Expertise indatacleansing for analysis, performdataquality testing for gaps, and liaising withdata origination teams.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC)
• Worked with variousdatasources such as Oracle, SQL Server, Teradata & Netezza
• Extensive experience with OLTP/OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensively experienced in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Deployed and scheduled Reports using Tableau, SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Experienced using MapReduce, and "BIgdata" work on Hadoop and other NO SQL platforms
• Excellent Experience with BIgdatatechnologies (e.g., Hadoop, BIgQuery, Cassandra)
• Experienced in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Extensive experience in advanced SQL Queries and PL/SQL stored procedures.
• ExcellentDataWarehousing concepts including MetadataandDataMarts.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i/7X,SQL Server 2000/2005 and SYBASE ASE 15,Teradata

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 5.9, 5.10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES: SQL, PL/SQL, T-SQL, C, C++, VB, UNIX Shell Scripting, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: SQL*PLUS, SQL*LOADER, EXP, IMP,DataPump (expdp, impdp), Erwin, TOAD,Powerdesigner,Embarcadero,MS Visio, Rational Rose, SQL TRACE, EXPLAIN PLAN, TKPROF, SYBASE Central and MS Management Studio

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metal ink, MS isio.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Data Modeler & Data Analyst

Responsibilities:

• Designed an Industry standarddataModel specific to the company with group insurance offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Expert Data Governance and policy analysis and creation skills
• Knowledge of risk management methodologies and techniques
• Experience in change management related to governance policy initiatives
• Ability to navigate a highly matrixed organization effectively
• Good stakeholder management and influencing skills, effective at the senior executive level
• Excellent relationship management and consulting skills which results in proven ability to quickly earn the trust of sponsors and key stakeholders, mobilize and motivate teams; set direction and approach, resolve conflict, deliver tough messages with grace, execute with limited information and ambiguity
• Experience integrating Tableau into various external environments (such as websites, SharePoint, etc.)
• Perform clerical review of potential linkage and duplicate tasks created within Adobe’s MDM solution (MDS)
• Perform mass data cleansing initiatives for the purging and elimination of corrupt or redundant information
• Manage data stewardship metrics
• Ability to write test cases and execute testing within a web service environment
• Assist business users in defining User Acceptance Testing, test cases and plans.
• Experience of creating of different dashboards for analytics projects. Expert level experience on visualization of data as per client requirements.
• Extensive experience developing reports, dashboards, and cubes in Microstrategy version 9
• Running and loading files into Business Warehouse(SAP)
• Respond effectively and in a timely manner to research requests from business stakeholders
• Research and create customer hierarchies using a variety of tools including Dun & Bradstreet, Hoovers, the internet.
• Installing apache hadoop and implementing sub hadoop projects.
• Hadoop cluster configuration & deployment to integrate with systems hardware in the data center
• Troubleshooting, diagnosing, tuning, and solving Hadoop issues.
• Monitor a Hadoop cluster and execute routine administration procedures.
• Identified and compiled common business terms for the new policy generating system and also worked on contract Subject Area.
• Implemented Proof of Concepts on Hadoop stack and different bigdata analytic tools, migration from different databases like mysql, oracle to hadoop.
• Loaded and transformed large sets of structured, semi-structured and unstructured data using Hadoop ecosystem components.
• Created a high-level industry standard, generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Identified and Defined entities, relationships and attributes in thedatamodel as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Tuned and optimization of Teradata Queries Created the ETLdatamapping documents between source systems and the targetdatawarehouse.
• Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead,DataModeler,DataMapper, Architect etc.
• Worked with OLTP and OLAP database to generate the ddl.
• PerformedDatamapping using Business Rules anddatatransformation logic for ETL purposes.
• DevelopedDataMapping,DataGovernance, transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing the OLAP model.
• Generated ad-hoc reports using Crystal Reports 9.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using ER/Studio.
• Designed the 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 action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.
• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.

Environment: Erwin R8.2.5, MS Visio, Oracle 11g, Toad, Tableau,Etl testing,Microstrategy, Data visualization,Big data, Hadoop, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9.

Confidential, Southfield, MI

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved inDatamapping specifications to create and execute detailed system test plans.
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Closely worked with business analysts/Data Modeler in the process of requirements gathering for various application specific databases
• Worked on two sources to bring in required data needed for reporting for a project by writing SQL extracts
• Worked on building up a SQL query for extraction of data from the warehouse for a reporting schedule
• Worked on building a conceptual and logical model starting from basic fields analysis spreadsheet as a part of one of my projects.
• Worked on Metadata Repository(MRM) for maintaining the definitions and mapping rules up to mark
• Was involved in fulfilling all the end users request which fell under the general maintenance work such as adding and removing columns and tables from data base not without the prior approval from BA’s and Data Modeling Team
• Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements for a project.

Environment: Informatica 8.1,DataFlux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Pittsburgh, PA

Data Analyst / Data Modeler

Responsibilities:

• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Responsible for differentDatamapping activities from Source systems to Teradata
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER-Studio
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document.
• Analyzed, designed, simulated and defined solutions for the most complex system processes. Analyzed business requirements and develop effective technology solutions.
• Possess the highest level understanding of organization's business systems and industry requirements. Assisted in the business process redesign and documentation as needed for new technology.
• Translated high level business requirements into functional specifications for the IT organization and manage changes to such specifications.
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determine data definitions and business rules governing the data, and facilitated review sessions with subject matter experts (SMEs) on the logical and physical data models.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed

Environment: Informatica 8.1,DataFlux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Buffalo, NY

Data Analyst

Responsibilities:

• Excellent exposure inDataProfiling in reference toDataWarehouse and BI development.
• Involved with data profiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Wrote and executed unit, system, integration and UAT scripts in adatawarehouse projects.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Performeddatareconciliation between integrated systems.
• Metrics reporting,datamining and trends in helpdesk environment using Access
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volumedata
• Performeddatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant

Confidential, San Jose, CA

Data Modeler/Data Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, Analysis, meta data, Performance and Data Quality.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Developed Logical and Physical Data models for the loan Systems by using ERWin 7.2.
• Conversed with Business Analyst and developers to gather information about the data models (Data Definition) to place the data dictionary in place.
• Redesigned some of the subject areas and introduced some new entities and attributes as per the requirements and also Supported database modifications.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Interacted with Business analysts and Developers to gather the Data Definitions for the Data Models to get the Data Dictionaries in place.
• Supported the DBA to physically implement the tables in both oracle and db2 databases.
• Analyzed the physical data model to understand the relationship between existing tables. Cleansed the unwanted tables and columns as per the requirements as part of the duty being a Data Analyst.
• Established process on the work flow to create Work flow diagrams using Microsoft Visio.
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Transformed requirements into data structures which can be used efficiently to store, manipulate and retrieve information.
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Data Stage 7.5, ERwin 4.0, PowerDesigner, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, TOAD, CSV files, XML files, Cognos, UNIX, Linux, AWK