SUMMARY

• 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 InmonDataWarehousing 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 alsodatacleansing.
• 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.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, Teaneck, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Confidential

Data Analyst/Data Modeler

Responsibilities:

• 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