SUMMARY:

• Over 8 + years of experience as Data Analyst and Data Modeler with excellent knowledge on BI,Data Warehouse, ETL and Big data.
• Excellent experience in EnterpriseDataWarehouse (EDW), Business requirement analysis, Identifying sources, FinalizingDataGranularity, Identifying Facts and Dimensions.
• ArchitectingtheDataModel using Modeling tools like Erwin, ER Studio, Power Designer, Toad Data Modeler and data processing using ETL tools like Informatica Power Center, IBM InfoSphere Data Stage.
• Highly proficient inDataModeling and retaining concepts of RDBMS, Logical, Physical and MultidimensionalDataModeling (Star Schema, Snow - Flake Schema, Hybrid Schema).
• 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) and Indexes.
• Utilized complete knowledge ofdatawarehouse methodologies (Ralph Kimball, Bill Inmon), ODS, EDW and Metadata repository.
• Expert in theDataAnalysis, Profiling, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading (ETL)
• Consolidate and audit metadata from disparate tools and sources, including Business Intelligence (BI), relational databases, modeling tools, and third-party metadata into a single repository.
• Expertise indatacleansing for analysis, performdataquality testing for gaps and liaising withdata origination teams.
• Worked with variousdatasources such as Oracle, Microsoft SQL Server, Teradata, Netezza and Hadoop.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and multi joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Deployed and scheduled Reports using various Business Intelligence reporting tools to generate daily, weekly, monthly and quarterly Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop Down menu options and Parameterized/Linked reports.
• Proficient in Data Base tools such as Oracle SQL Developer, SQL Server Management Studio (SSMS), MySQL, SQLPlus, Toad and SQL Workbench.
• Experience in using MapReduce, BigData on Hadoop and other NOSQL platforms.
• Excellent Experience with BigDatatechnologies (e.g., Hadoop, BIgQuery, MongoDB, Hive, Hbase etc.)
• Expertise in creating OLAP cubes, datamarts, identifying dimensions, attributes, hierarchies and calculating measures.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Overcome Challenges, Stands on Deliverables and Ensure Successful Production Deployment.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

DataModeling: ERwin r9.6/r9.5/8x/7x, ERStudio 9.7/9.0/8.0/7. x, SAP Power Designer v16.x

Databases: Oracle11g/10g/9i, Teradata 14.x/15.x, DB2 UDB 8.x/7.x, DB2 Z/OS 9.x/8.2, SQL Server 2008/2005/2000, MySQL, MS- Access, XML files, Netezza.

Operating Systems: LINUX, UNIX, Sun Solaris 2.X/5/7/8, IBM AIX 5.3/4.2, HP-UX, MS-DOS, Windows XP/7/10

Scheduling Tools: Autosys, Maestro (Tivoli), Control M, UC4

Other Tools: Teradata SQL Assistant, Toad 9.7.2/7.4/7.3, Toad Data Point, Oracle SQL Developer, DB Visualizer 6.0, Informatica Developer 10.1, Microsoft Word, Microsoft Visio, Microsoft Excel, Microsoft Project, Netezza Aginity, PuTTY, JIRA, GitHub.

WORK EXPERIENCE:

Confidential, Philadelphia, PA

Sr. Data Modeler/ Data Architect

Responsibilities:

• Involved in Gathering Business requirements by organizing and managing meetings with business stake holders, Subject Matter Experts, Technical architects and IT analysts on a scheduled basis.
• Design and developed Entity-Relationship diagrams and modeled Transactional Databases andDataWarehouse using PowerDesigner v15.x/16.x.
• Identified Facts and Dimensions from the business requirements and developed the Data models. Transformed LogicalDataModel to PhysicalDataModel ensuring the Primary Key and Foreign key relationships in PDM, Consistency ofDataAttribute definitions and Primary Index considerations.
• Experienced in Using PowerDesigner Repository Services for effective model management in sharing, dividing, reusing information and design for productivity improvement.
• Highly generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis and profiling using tools such as Toad Data Point and Informatica Data Analyst.
• Responsible for the analysis of business requirements and design implementation of the business solution. Analyzed large amounts of data sets to determine optimal way to aggregate and create reports on it.
• Attended JAD sessions with Data Architects to build Subject Area specific data models.
• Involved in designing and architectingdatawarehouses in Teradata anddatalakes on high performance bigdata databases(Hadoop - Hive and HBase).
• Gathered and analyzed existing physicaldatamodels for in scope applications and proposed the changes to thedatamodels according to the requirements.
• Designed & managed large enterprise wide data/information architectures, which maps to the enterprise architecture while balancing the need for access against security and performance requirements.
• Developed target mapping spreadsheets for ETL team with Source to Targetdatamapping (STTM) comprising of physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Identify and fix defects, provide required information for development team to complete the build.
• Created database objects like tables, indexes, synonyms, views, materialized views etc.
• Involved inDatamapping activities for theDataWarehouse.
• Documented ER Diagrams, Logical and Physical models, business process diagrams and data flow diagrams.
• Designed the procedures for getting the data from multiple systems to Data Warehouse. This data is standardized to store various Business Units in tables.
• Developed QnA maker Knowledgebase to create chatbot and deploy it in different channels(Teams, Website)

Environment: Microsoft SQL Server 2017, Informatica Developer 10.1, SAP SybasePowerDesigner16, Toad Data Point, InformaticaPowerCenter, UNIX scripting, PLSQL Programming, PuTTY, Jira, GitHub, Windows 7, MS Azure.

Confidential, Teaneck, NJ

Sr. Data Architect/ Data Modeler

Responsibilities:

• Supported agencydatamanagement programs anddatagovernance activities to align with the enterprise architecture and incorporatedatastrategy principles into program, project and IT portfolio management processes.
• Provided end to enddataarchitecture by identifying data sources, designing the target structure and generatingdatamapping between source and target for multiple projects.
• Implemented SDLC processes that ensure the consistent and effective creation, storage, presentation and control of metadata to support enterprise-widedatasharing and integration efforts.
• Used forward engineering to create PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel. Additionally, modeled new tables and added them to the existingdatamodel using Erwin as part ofdata modeling.
• Developed business and technicaldatarequirements, provide clear and coherent written solution recommendations for both technical and non-technical audiences.
• Involved in implementation of logicaldatamodel design for Pre-Stage, Staging, ODS, DW database and DataMarts.
• Finalized the naming Standards forDataElements, ETL Jobs and create aDataDictionary for MetadataManagement.
• Performeddataanalysis of source systems, datacleansing before ETL development and createdDataStandardization logic using SQL to standardize masterdataacross the source systems.
• CreatedDataValidation rules using SQL to validate the structure and integrity of the extracteddata.
• Developed complex mapping to extractdatafrom diverse sources including flat files, RDBMS tables, legacy system files, XML files, various Applications and Databases.
• Defined and delivered the data strategy roadmap for Stakeholders, including data modeling, implementation and data management for enterprise data warehouse.
• Worked on advanced data analytics systems incorporating structured, semi-structured and unstructured components.
• Developed medium and complex BTEQs, worked withTeradatautilities like MLOAD, FLOAD, FASTEXPORT, TPUMP.
• Supported enhancements, analyzed and altered existing Conceptual, Logical and Physicaldatamodels using Erwin.

Environment: Erwin r9.6,Teradatav15, SQL Developer, Oracle 12c, MS SQL Server,TeradataSQL Assistant, PL/SQL,TeradataManager, XML, UNIX Shell scripts, Informatica Power Centre, Salesforce, FTP, Windows 7.

Confidential, NYC, NY

Sr. Data Analyst/ Data Modeler/Architect

Responsibilities:

• Involved with multiple project teams of technical professionals through all phases of the SDLC using technologies Oracle, Erwin, Data Stage and Cognos.
• Extensively involved in the Physical/logical modeling and development of Reporting Data Warehousing System.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using industry leading Data Modeling tool like ERWIN and translated Business Requirements into working data models for OLTP, Data Warehouse and Data Mart applications.
• Maintained model documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business and transformation rules, glossary terms, etc.
• CreatedBigdata Data Lake modeling for Hadoop (Hive) database tables.
• Designed and developed the Source to Target Mapping documents (STTM), Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models. Coordinated with DBA on data base build, table normalizations and de-normalizations.
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data and prepared documentation for change management during the project.
• Worked directly with non-IT business analysts throughout the development cycle and provided post-implementation support.

Environment: Erwin 9.5, Windows 7, Informatica Power Center, Data Stage, Oracle 10g, Netezza, UNIX AIX 5.2, PERL, Shell Scripting

Confidential, McLean, VA

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Performed DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and DataFormats.
• Developed and delivered long-term strategic goals for application architecture, data architecture, data analytics, reporting, and data governance in conjunction with key stakeholders.
• Built the process to extractdata from source, cleansedatain staging area, load static/ datainto target systems and carry out system testing. Created dynamic PL/SQL scripts to cleanse and load static and data.
• Analyzed Manual Reports to develop design concept and technical approaches. Created logical, physicaldatamodels and MetaDatato support the business requirements.
• PerformedDataanalysis and Dataprofiling using complex SQL on various sources systems like Teradata, Oracle and Netezza.
• Involved in extensiveDatavalidation, back-end testing, tuning and optimization of Teradata Queries.
• Provided technical, strategic advice and guidance topeers and technical resources in the creation and implementation ofdataarchitecture anddatamodeling.
• Defined corporate metadata definitions for the enterprisesupported databases including operational source systems,datastores anddatamarts.
• Involved in Migrating thedatamodel to Teradata database and prepared the staging model.
• Designed star schemas and bridge tables to implement slowly changing dimensions (SCD). Applied normalization forms on the OLTP database objects.
• Consolidated database standards and naming conventions to enhance Enterprise DataArchitecture processes. Built Tableau reports visualizing data in dashboard.

Environment: Windows XP/7, Informatica Power Center 6.1/7.1, QTP 9.2, Quality Center, Load Runner 11.0, Oracle 10g, UNIX AIX 7.1, PERL, Shell Scripting, Teradata, ERWIN, Tableau.

Confidential, Jacksonville, FL

Data Analyst/ Data Modeler

Responsibilities:

• Worked ondataanalysis,profiling, modeling, mapping and testing for a given task.
• This project involved analysis of a variety of source systemdata, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relationaldatamodel using Erwin v7.3 modeling tool, publishing of adatadictionary, review of the model and generation ofdatadefinition language.
• Conceived, designed, developed and implemented data model from the scratchto implement on Teradata Environment.
• Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes for the facts and dimensions.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes anddatarelationships.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created.
• Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract thedatafrom Database.
• Managed end to end SDLC processes involving requirements/sourcedata analysis, workflow management, datamapping, meta data management,dataquality, testing strategy and maintenance of the data model.
• Expert level understanding of using different databases in combination forDataextraction and loading, joiningthe dataextracted from different databases and loading to a specific database.

Environment: SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 7.3, Visio, Informatica, Business Objects XI, Teradata SQL Assistant, MS Office

Confidential, MN

Data Analyst/Data Modeler

Responsibilities:

• Experienced in enterprise architecture planning effort to outline the client's future state business model.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Designed the conceptual, logical and physical data models for Data Warehouse and MDM in support of the AMBU Data Foundation Strategy.
• Participated in all phases of project including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and maintenance period.
• Extensively used SQL for Data Analysis and Data Profiling to understand the data behavior.
• Done Reverse engineering on existing data model to understand the data and business flow of existing system and to integrate the new requirements to current system.
• Designed ER diagrams, logical model (relationship, cardinality, attributes and candidate keys) and convert them to physical data model using ERwin.
• Involved in capacity planning, object creation, implementing multiple strategies for aggregation, partition and purging as per business requirements.
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions and proposed ETL strategy.
• Performed complete compare in Erwin tool to find differences between versions of models.
• Created domains and assigned them to the attributes of similarity, across the database.

Environment: Windows XP/7, Informatica Power Center, QTP, Test Director, Load Runner, Oracle, UNIX AIX 5.2, PERL, Shell Scripting, Erwin

Confidential

DataAnalyst / Data Modeler

Responsibilities:

• Created the conceptual, Logical and Physical Model with entities and attributes for the data warehouse With Erwin Data modeling tool.
• Worked with 1st, 2nd, 3rd normal forms for designing the OLTP database.
• Created a naming standards list and class words list for maintaining data standards.
• Generated DDL from Model and deployed it on databases.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Used SQL assistant tool extensively to profile data and check mapping accuracy.
• Performed Data mapping (STTM) between Source and Target systems, created class diagrams and ER diagrams.
• Created DFD (Data Flow diagram) artifacts that incorporated the process flow in Visio and all the specifications for proper ETL implementation.
• Participated in internal and final DFD reviews, Functional Specification Document (FSD) reviews and responded to queries related to the mapping, modeling and processing logic flows with the ETL team.
• Worked with Business and ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Windows XP, Informatica Power Center, QTP, Erwin, Oracle, UNIX