SUMMARY:

• Senior Data Modeler/Analyst with 8+ years of IT professional experience in Data Modeling, designing and data analysis with Conceptual, Logical and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems.
• Strong background in business intelligence, reporting systems, data quality (including ETL), and full life - cycle development.
• Extensive experience in designing robust data models using ERwin, Sybase Power Designer and VISIO.
• Extensive experience in reverse engineering databases, Complete compare using SAP Power Designer.
• Hands on experience on complete Software Development Life Cycle (SDLC) for the projects using methodologies like Agile, RUP, Waterfall, and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy.
• Vast experience of working in the area of data management including data analysis, gap analysis and data mapping.
• Worked extensively with ERwin, Visio and ER Studio, Power Designer for Relational, Dimensional Modeling and Data Migration projects.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Extensive experience in Database Management in managing SQL Server Databases
• Developing reports on SSAS & SSRS on SQL Server. Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Supported team in resolving SQL Reporting services and related issues.
• Extensive experience in Performance tuning databases for optimum performance
• Expert in Backup / restore of databases for maximum efficiency.
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives.
• Excellent technical, time management, communication, interpersonal and presentation skills.

TECHNICAL SKILLS:

• UML
• IBM Rational Requisite Pro
• ERwin
• Sybase Power Designer
• RUP
• Waterfall
• Agile
• Scrum
• MS SQL Server 2000/2005/2008
• MS Access. Oracle
• Teradata
• SQL
• HTML
• XML
• Rally
• C
• C++
• TSQL
• PL/SQL
• SSIS
• SSAS
• SSRS
• BO
• Microsoft Visio
• Informatica
• Microsoft Project
• MS Office
• Hue

PROFESSIONAL EXPERIENCE:

Senior Data Modeler/Analyst

Confidential, Bellevue, WA

Responsibilities:

• Attended the stakeholder’s meetings to analyze Report requirements and gather the attributes in order to fulfill the requirement from the data model perspective.
• Worked with System Analyst to identify the various source systems and the key columns which satisfy the attributes acquired from the business meetings there by helping the mapping.
• Performed data analysis using PL/SQL, SQL from source.
• Data Profiling of source using Oracle and Hue (Hadoop/Hive UI) and supporting developers by testing the target on Teradata and Hadoop
• Involved in Data Architects meetings and helped in designing the Conceptual Data Model for various subject areas (Line of Service, Supply Chain Management, UPS Shipment process, Product, Marketing, Insurance and Warranty Claims, Party).
• Designed Logical and physical data models (Hive and Teradata) using SAP Power designer 16.5.4.
• Conducted the Data model review sessions with Senior DA’s, Product Owners, and Governance team to get approval.
• Generated the DDL’s for Hive and Teradata target tables using Power Designer. Maintained the naming and domain standards.
• Created the Source to Target mapping documents following up with SME’s, Data Architects.
• Maintained the Data Dictionary, Repository of models, performed model merging’s for all the tracks.
• Generated the longitudinal reports which comprised of complex queries to join various subject areas and get the single record for a subscriber whose data input is from various source systems like front end billing systems and Customer - HUB.
• Performed data validation using complex SQL queries.
• Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Conducted GAP analysis and User Acceptance Testing (UAT).
• Using Agile Central (Rally) to enter tasks which has the visibility to all the team and Scrum Master.
• Using GitHub and Accurev to actively manage and promote DDLs

Environment: SAP Power Designer (16.5.4.1),Oracle SQL Developer, Teradata Developer (15.00), Hadoop,GitHub, Accurev, Hue.

Senior Data Modeler/Analyst

Confidential, Plano, TX

Responsibilities:

• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Designed Logical/Physical and Conceptual models of database using ERwin and VISIO
• Did extensive reverse engineering of databases using ERwin.
• Worked with the developers to understand the ERD (Entity Relationship Diagram) and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Worked extensively on BI (SSIS) Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.
• Extensively involved in using BI tools like Import and Export Wizard for developing the packages.
• Provided the sequence and flow diagrams for various modules in the project using Rational Rose.
• Participated in weekly review meetings to report the documented test metrics and defects found in the System. Closed bug reports once they are resolved and verified.
• Involved in Training and Documentation.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from sources.
• Gather requirements and design of data warehouse and data mart entities.
• Used SQL to perform data analysis, data profiling and generating reports.
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Worked with business people, data stewards, SMEs as a part of data model designing and source to target mapping document creation.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Worked with Data Quality and ETL teams as part of my job responsibilities.

Environment: Erwin 8.2, VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS.

Senior Data Modeler/Analyst

Confidential, NY

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted controlled brainstorming sessions with project focus groups.
• Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams and Conceptual Data Models in MS Visio.
• Worked extensively with VISIO and ERwin to do reverse engineering of Database for reporting
• Did extensive logical/physical modeling of database for ETL/Reporting
• Prepared functional requirements to define the system rules by creating Use Cases, Interface design and data dictionaries.
• Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
• Worked with the Business Objects developers to provide input for generating automated and adhoc Business reports.
• Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
• Used SQL Server Reporting Services to schedule reports to be generated on predetermined time.
• Built up and maintain a strong data warehousing system for the organization
• Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.
• Assigned problems to appropriate software development team for fixes.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Environment: MS SQL Server 2008/2005/2000, ERwin, VISIO, Oracle 11g, Oracle SQL Developer, Adobe Flex, MS Word, MS Excel, MS PowerPoint, MS Access, MS Projects, MS Visio, Adobe Flash, MS SharePoint.

Data Modeler/Analyst

Confidential, Broussard, LA

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Extensively used Star Schema methodology in building and designing the logical data model.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Prepared business case for the data mart and then developed and deployed it.
• Used ERwin to transform data requirements into data models.
• Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.

Environment: SQL server 2008, Linux, Windows XP, ERwin, MS Visio, TOAD, Microsoft Office.

Data Modeler

Confidential, Lakewood, NJ

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Created solid Logical/physical models of Database for Decision Support systems
• Laid out logical design of database with Data Mappings for Reporting system
• Created logical/physical models and conceptual models using ERwin and VISIO for Reporting
• Participated in JAD sessions to resolve critical issues
• Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
• Normalized the tables up to 3NF.
• Involved in the critical design review of the finalized database model.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in designing and implementing the security for the databases.
• Helped in migration and conversion of data from the Sybase database into Oracle10g database, preparing mapping documents and developing partial SQL scripts as required.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: SQL Server 2005/2000, Oracle Database 10g, XML, HP Quality Center, Java, RUP, MS Visio, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Database Developer/Data Modeler

Confidential

Responsibilities:

• Gathered user requirements.
• Identified high-level requirements for developing and documenting detailed business requirements
• Involved in meetings with SME (subject matter experts) and users for requirements gathering.
• Revised and updated the technical feasibility documents and created sequence diagrams.
• Utilized RUP to create use cases, activity, class diagrams and workflow process diagrams.
• Responsible for providing database solutions using Oracle database.
• Proficient use of T-SQL/ PL/SQL in creating tables, views, triggers, stored procedures.
• Created reports using Crystal Reports and Oracle Forms/Report.
• Provided technical/Functional support to end-user.

Environment: Oracle 8.0/9.0, Visual Basic 5.0, TSQL,