We provide IT Staff Augmentation Services!

Sr. Data Analyst/data Modeler Resume

0/5 (Submit Your Rating)

Teaneck, NJ


  • Over 9 years of Industry experience as a Data Analyst & Data modeling with solid understanding of DataModeling, DataAnalysis, dataprofiling, creating datamapping documents and strong understanding of DataWarehouse/DataMart Design.
  • Practical understanding of the Datamodeling (Dimensional&Relational) concepts like Star - SchemaModeling, SnowflakeSchemaModeling, Fact and Dimensiontables.
  • Experienced in designing the Conceptual, Logical and Physicaldatamodeling using Erwin, PowerDesignerand ERStudioDatamodeling tools.
  • Extensively experienced in using tools like SQLPlus, TOAD, SQLDeveloper and SQLLoader.
  • Experienced inDataModeling using designed tool Erwin, PowerDesigner, IBM Infosphere Data Architect etc.
  • Excellent SQLprogramming skills and developed Stored Procedures, Triggers, Functions
  • Experienced withDatawarehouse Appliances such asTeradata and Netezza.
  • Experienced using MapReduce, and "Bigdata" work on Hadoop and other NOSQL platforms
  • Experienced in modeling with both OLTP/OLAP systems and Kimball and Inmon DataWarehousing environments.
  • Well versed in Normalization (1NF, 2NF and 3NF) and De normalization techniques for optimum performance in relational and dimensional database environments.
  • Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and Microsoft SQL Server database management.
  • Experienced indatatransformation,datamapping from source to target database schemas and also data cleansing.
  • Expertise in usingTeradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
  • Experienced in logical/physical database design and review sessions to determine and describedataflow anddatamapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
  • Experienced in DataCleansing, DataProfiling, DataTransformations, Datamining, DataRelationships, SourceSystemsAnalysis and ReportingAnalysis
  • Experienced in facilitating JAD sessions involving Business, SME, Analyst, Developers and Testers.


Data Modeling Tools: Erwin r9, Erwin r8, Erwin r7.1/7.2, IBM Infosphere Data Architect, ER Studio and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Informatica, DataStage, Talend, Pentaho

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML

Database Tools: Microsoft SQL Server, Teradata, Oracle 12c/11g/10g/9i, Netezza& MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester


Confidential, Teaneck, NJ

Sr. Data Analyst/Data Modeler


  • Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and PhysicalDataModels and designing database, documenting and rolling out the deliverables.
  • Conducted analysis and profiling of potentialdatasources, upon high level determination of sources during initial scoping by the project team.
  • Designed and implemented AWS RDS data solutions
  • Breadth in established and emerging data technologies (including relational databases and MPP platforms): In addition to depth in established data management and reporting technologies, experienced in emerging tools like columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data.
  • Coordinateddataprofiling/datamapping with business subject matter experts,dataarchitects, ETLdevelopers, anddatamodelers.
  • Developed logical/ physicaldatamodels using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
  • Maintained and enhanceddatamodel with changes and furnish with definitions, notes, reference values and check lists.
  • Performed data analysis and design, and created and maintained large, complex logical and physical data models, and metadata repositories using ERWIN
  • Maintained strong data governance discipline
  • Created Target State Data Models that accommodated strategies across business.
  • Experienced in master data management (MDM) projects and solutions
  • DataMasking/DataPrivacy performing the Reverse engineering on theDataModel to identifying the Schemas based on requirements.
  • Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from the legacydata.
  • Reviewed the logicalmodel with application developers, ETLTeam, DBAs and testing team to provide information about thedatamodel and business requirements.
  • Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
  • Developed Enterprise Leveldatamodel anddatacontent designs.
  • Worked on differentdataformats such as Flatfiles, SQLfiles, Databases, XMLschema, CSV files.
  • Performed Forwardengineeringdatamodels for Schema generation, Reverse Engineered on the ExistingDataModels to accommodate new requirements.

Environment: SQL Server 2008, Erwin 9.x, Windows 7, XML, Excel, Access, Visio, Windows 2007, UNIX, Oracle 12c, SQL, PL/SQL, DB2, Teradata SQL assistant

Confidential, Bellevue, WA

Sr. Data Modeler/Data Analyst


  • Designed the conceptualdatamodel and worked with the Business analysts and technical teams to design and update the logicaldatamodel in various iterations.
  • Responsible fordatamapping, metadata and datamodels.
  • Used ErwinDataModelerand Erwin Model Manager to create and maintain the model versions in Model Manager for further enhancements.
  • Developed thedatawarehousemodel (starschema) for the proposed central model. Also worked on normalizing star-schema to snowflakeschema to fulfill requirement.
  • ReverseEngineered source system databases wheredatamodels are not available in order to understand how the source systems are structured.
  • PerformedDataAnalysisand data profiling to find anomalies and various data patterns in the data
  • Responsible for coaching and mentoring less experienced team members.
  • Solid experience in relational modeling, dimensional modeling, conceptual, logical modeling, physical modeling, star schema, snowflakes schema, ER diagrams, granularity, cardinality and database reengineering.
  • Extensive experience in enterprise data warehouse and operational data store architectures
  • Experienced in data transformation, data mapping from source to target database schemas, data cleansing procedures.
  • Involved in Performance tuning of the database and SQLqueries as per the need, created partitions, indexes where necessary.
  • PerformedDataProfiling to identifydataissues upfront, provided SQL prototypes to confirm the business logic provided prior to the development.
  • Involved in designing ContextFlowDiagrams, Structure Chart and ER- diagrams.
  • CreatedDataDefinitions and help maintain Metadata repository.
  • Provided source to target mappings to the ETLteam to perform initial, full, and incremental loads into the targetdatamart.

Environment: Erwin r9, SQL Server 2008, SQL Server Analysis Services 2008,Informatica, SSRS 2008, Oracle 11g, Business Objects XI, Rational Rose,Datastage, MS Office, MS Visio

Confidential, Pittsburgh, PA

Sr. Data Analyst/Data Modeler


  • Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures) in thedatamodel.
  • Presented thedatascenarios via, Erwinlogicalmodels and excel mockups to visualize thedatabetter.
  • Designed and Developed logical&physicaldatamodels and MetaDatato support the requirements using Erwin.
  • Designed and Developed OraclePL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
  • Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
  • Developed the requireddatawarehouse model using Starschema for the generalized model.
  • Developed, enhanced and maintained SnowFlakes and StarSchemas withindatawarehouse anddatamart
  • Worked withDataWarehouse Extract and load developers to design mappings forDataCapture, Staging, Cleansing, Loading, and Auditing.
  • Involved in extensiveDATAvalidation using SQLqueries and back-end testing
  • Performed dicing and slicing ondatausing Pivot tables to acquire the churn rate pattern and prepared reports as required.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
  • Resolveddataissues and updates for multiple applications using SQL queries/scripts
  • Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.

Environment: Netezza, Erwin 9x, DB2, Oracle, Teradata, Information Analyzer, Informatica, MDM, Quality Centre, SQL, PL/SQL, Excel, MS-Word.

Confidential, Richfield, MN

Sr. Data Analyst/Data Modeler


  • Worked ondataanalysis,dataprofiling,datamodeling,datamapping and testing for a given task.
  • Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
  • Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
  • Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DWmetadata.
  • Utilized PowerDesigner'sforward/reverseengineering tools and target database schema conversion process.
  • Documented logical, physical, relational and dimensionaldatamodels. Designed thedatamarts in dimensionaldatamodeling using star and snowflakeschemas.
  • Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
  • Assist developers, ETL, BI team and end users to understand thedatamodel.
  • Interacted with Business analysts and Developers to gather theDataDefinitions for theDataModels to get theDataDictionaries in place.
  • Created logicaldatamodel from the conceptualmodel and its conversion into the physical database design using Erwin
  • Designed and developed UseCases, ActivityDiagrams, SequenceDiagrams, OOD (ObjectorientedDesign) using UML and Visio
  • Developed SQLQueries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
  • Identified/documenteddatasources and transformation rules required to populate and maintaindatawarehouse content.
  • Performeddatavalidation and UnitTesting before handing over thedatafor production and Quality Testing.
  • Maintain change log and history tables for eachdatamodel and solved the production issues by debugging the code.
  • Explained and guided developers on the database architecture and built objects for effectively accessing the database.

Environment: PDM, SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Visio, Informatica, TOAD, SQL developer, XML, and Microsoft Visio


Data Analyst/Data Modeler


  • Did dataanalysis (GapAnalysis), to map logical to physical elements.
  • Create logical and physicaldatamodels using best practices to ensure highdataquality and reduced redundancy. Define, document, and articulate design goals and standards.
  • Perform reverseengineering of physicaldatamodels from databases and SQLscripts.
  • Provide the technical documentation to the ETL developers for developing thedataloading techniques & the design details to the Reporting team.
  • Responsible for code migration & database changes through the various stages of the Project development life cycle.
  • Designed and built relational database models and defines data requirements to meet the business requirements.
  • Developed strategies for data acquisitions, archive recovery, and implementation of databases.
  • Developed logical and physical database models. Assured integrity of data, software, and hardware; developed policies and procedures related to development and support of new and ongoing systems.
  • Employ best practices indataprofiling and designing solutions for handlingdataquality issues.
  • Managed the Database security by providing the customized and configured product user authentications and authorizations.

Environment: Oracle 9i, Teradata V2R6 & SQL server 2005, Datastage, Erwindatamodeler, SQL developer & PLSQL developer

We'd love your feedback!