SUMMARY

• Senior Data Modeler/Analyst wif 7+ years of experience in data analysis and modeling, wif excellent understanding of Data Warehouse and Data Mart designing.
• Thorough knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, slowly changing dimensions, foreign key concepts, referential integrity.
• Hands on experience in Data Power implementation & support.
• Proficient in writing complex SQL Queries, Sub Queries, views, stored procedures, Normalization, Database Design, Functions, Triggers
• Good knowledge on Splunk and Design Documents.
• Extract information from proprietary systems through automated tools for data analysis and delivery.
• Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Experienced in data access optimization, writing complex SQL queries and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.
• Well experienced in Extract transport and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS).
• Used XSLT, XML and web services in Data Power for complicated cases along wif command - line interface.
• Extensive knowledge of writing SQL queries, working wif back end tools such as Toad for data validation and verification.
• Worked Extensively across various DBMS like SQL Server (SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005), Oracle 10g/11g, Teradata and IBM DB2.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export wif the use of ETL tools.
• Having good exposure to modeling tools like E-R Studio, Embarcadero. And experience in developing Informatica Mappings and Workflows.
• Experience in XI52 box and security implementation using AAA framework.
• Have good experience wif logical and physical data modeling. Dimensional and 3rd Normal modeling.
• Have good knowlegde on data modeler wif DB2 and Oracle.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling a Data warehouse in Relational, Dimensional and Multidimensional modeling.
• Excellent analytical, interpersonal and communication skills wif clear understanding of business process flow.
• Having experience in reviewing current reports, automatically extract data from oracle tables, then automatically generate report using SAS and SAS/Macros.
• Have experience in tools like Informatics, BO, ClickView, Spot fire.
• Ability to use VBA language to automate tools and reporting in MS Excel and having experience wif a programming language, specifically HTML and JavaScript.
• Exceptional communication and presentation skills and established track record of client interactions.

TECHNICAL SKILLS

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data Integration and Migration, ETL Architecture and Design, Data Warehouse, OLTP, OLAP

Modeling Tools: Erwin 9.x, Rational Rose, ER/Studio, MS Visio, SAP Power designer, Embarcadero.

Databases: My SQL Server 2012/2008R2/2005, Oracle 12c/11g/10g/9i/8i, Teradata R14/R13/R12, MS Access

Programming Languages: SQL, PL/SQL, UNIX shell scripting, PERL

Operating Systems: Windows, UNIX, MS DOS, Sun Solaris.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x, Cognos7.0/6.0., Tableau, Informatica Power Center 7.1/6.2, Ab-Initio, Data Stage

Web technologies: HTML, DHTML, XML, CSS.

Scripting Languages: VBScript, JavaScript, UNIX Shell Script.

PROFESSIONAL EXPERIENCE

Confidential, Washington, D.C.

Senior Data Modeler/Analyst

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design, written test scripts / Test Case Development.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical database in the form of Star Schema for Data Mart Design.
• Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
• Identified objects and its relationship from existing database, which can be used as a reference for data mart, then transformed those objects into physical model using Reverse Engineering in Erwin.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Worked extensively wif XML schema generation.
• Created DFD (Data Functional Design) artifacts dat incorporated the process flow Visio, S-T Mapping document and all the specifications for proper ETL implementation.
• Participated in Performance Tuning using Explain Plan and Tkprof.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating the execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.

Environment: PL/SQL, SQL, ERWIN r7.3, INFORMATICA, VISIO, Oracle, MS-Word. Oracle, SQL Server, Teradata SQL Assistant 12.0, ERWIN data modeller, ODS, TOAD, CA Erwin 7.0

Confidential, Baltimore, MD

Senior Data Modeller/Analyst

Responsibilities:

• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.
• Worked wif the stakeholders to elicit the business and system requirements and importing them into rational requisite pro.
• Analyzed the scope of the project and identified the major actors involved.
• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Power Designer.
• Organized and conducted extensive JAD sessions wif users to identify, understand and document requirements.
• Provided key initiatives in working wif users in defining project and system requirements.
• Performed preliminary analysis on multiple origination and servicing systems and assisted the sourcing team wif the creation of Data Requirement Documents.
• Extensively used Power Designer to create Data Models for relational and dimensional modeling.
• Developed and co-authored the vision document dat defined the primary goals and objectives of the project.
• 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 between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Experienced in Testing the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Conducted internal and final DFD reviews wif the ETL team (EIS) and also FSD reviews.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL wif the development process.
• Worked wif the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Power Designer, MS Office (MS Word, MS, Access, MS Excel, MS PowerPoint, MS Visio),.NET, Teradata, Business Objects, Sybase, RUP, UML, SQL, SAS, ETL Abinitio, SWOT analysis, GAP Analysis, Load Runner.

Confidential, Troy, MI

Sr. Data Modeller/Analyst

Responsibilities:

• Interacted wif End user community to understand the business requirements and in identifying data sources.
• Prepared High-level logical data models and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing logical and Physical data models.
• Designed the Data Marts using Ralf Kimball's Dimension data mart modelling methodologies using ERWIN.
• Designed different type of STAR schemas using ERWIN wif various Dimensions like time, services, customers and FACT tables.
• Worked wif end users to collect business data quality rules and worked wif the development team to establish technical data quality rules.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Coordinated wif DBA's and generated SQL code from the data models using.
• Worked closely wif the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation.
• Supported UAT (User Acceptance Testing) by writing SQL queries.
• Created SQL tables wif referential integrity and developed SQL queries using SQL Server and Toad.
• Performed extensive data analysis and data validation on Teradata.
• Worked wif the Reporting Analyst and Reporting Development Team to understand Reporting requirements. Involved in Generating ad-hoc reports using crystal reports 9.
• Designed and Developed Oracle database Tables, Views, Indexes wif proper privileges and Maintained and updated the database by deleting and removing old data.
• Created and maintained Logical and Physical models for thedatamart, which supports the Credit, Fraud and Risk Retail reporting for credit card portfolio.

Environment: Microsoft Windows Vista/Unix, ERWIN 7.x, Oracle 9i, SQL, MS Excel, SSIS, DB2, TOAD from Quest software.

Confidential

Data Modeller/ Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system
• Wrote Requirement and Design document for Master Data Entities. Used Corporate Modeler to design the Process
• Conducted controlled brain-storming sessions wif project focus groups
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
• Conducted joint application design (JAD) sessions wif management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications
• Participated in the to generate target database layout use for the data marts
• Generated data mapping documents to define mapping from source to target
• Reviewed the business requirements or use cases, and convert them to logical data models after analysis
• Participated in high-level and low-level design sessions including writing technical project documentation.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content
• Helped define the data definitions, naming standards and create the target tables in the database.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms
• Worked on SQL queries by writing new and editing already existing codes using SQL Plus.
• Helped the team for data modeling support for numerous strategic application development projects.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

Environment: Oracle 9i, Toad 8.1, Erwin, Microsoft Windows, SQL Plus

Confidential

Data Modeller/ Data Analyst

Responsibilities:

• Involved in the entire system study, analysis and design.
• Requirement gathering from the users. A series of meetings were conducted wif the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system.
• Provide ER diagrams via Erwin.
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.
• Involved in writing the SQL codes and utilizing analytical, aggregate functions.
• Used different types of joins, halped build indexes, partitioning of the tables, etc.
• Performed user unit testing and interacted wif the testing team and halped debug the code.
• Interaction wif the developers and business teams for writing the technical specification document (TSD).
• Used SQL *Loader for data transfer to the oracle databases.
• Was involved in the query optimization.
• Involved in testing the database for queries dat were generated and handled the performance issues efficiently.
• Involved in documenting the entire technical process.
• Supported technical teams involved wif Oracle issues and operations.
• Involved in the maintenance of the database.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Designed XML schemas using Unified Modeling Language (UML) - translating business concepts into XML vocabularies
• Interacted wif end users to identify key dimensions and measures dat were relevant quantitative.
• Experience in SSIS, SSRS in solving business problems and managing reports in organization.

Environment: Oracle 9i, SQL Server 2005, SQL *Loader, XML, Erwin, Windows 2000/NT, UNIX