SUMMARY

• An IT professional with 7+ years of experience, seeking a challenging position in IT with emphasis on Data modeling/Data warehousing/Enterprise Business Intelligence projects for development of professional/ personal goals and organizational objectives and also having experience in data modeling with focus on Financial, Healthcare, Investment and Insurance domains.
• Certified as IBM DB2 Academic Associate (DB2 Certified) and IBM Certified Associate Developer (RAD Certified).
• Skilled Senior Data warehouse/Modeler with 7+ years technical leadership experience in all phases of Software development life cycle including System/data Analysis, Design & Architecture, development, testing and deployment of OLTP, Data Warehousing, Data Mart and OLAP applications
• Strong background in business intelligence, reporting systems, data quality (including ETL), full life - cycle development and managing SQL databases
• Extensive experience in designing robust data models using Erwin, ER/Studio and VISIO.
• Extensive experience in reverse engineering databases, Complete compare using ERwin.
• Hands on knowledge with 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.
• Experience in Performance tuning of ETL jobs to keep data loads within SLA.
• 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.
• Good understanding of Star and Snow Flake Schemas for Data warehouse Modeling.
• Strong background in business intelligence, reporting systems, data quality (including ETL), and full life-cycle development.
• Hands-on experience in PL/SQL, stored procedures, triggers, views, SQL, performance, complex Stored Procedures and Functions, tuning/optimization, indexing, partitioning, PLSQL, data profiling.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Expertise in writing complex queries in oracle, SQL Server and DB2
• In depth Functional knowledge of customer’s business, Process flow
• 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, Dimensional Modeling and Data Migration projects.
• Extensive experience in Database Management in managing SQL Server Databases
• Experience writing complex queries and Procedures
• Developed reports on SSAS & SSRS on SQL Server (2000/2005) and familiar with visual Studios business intelligence. Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Supported team in resolving SQL Reporting services and related issues.
• Proficient in SQL Server developing Stored Procedures, Triggers, T-SQL Statements, Cursors, User Defined Functions and Views.
• 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 ProErwin, ER/Studio, Visual Studios
• Rational Rose and VisioRUP, Waterfall, Agile, ScrumMS SQL Server 2000/2005/2008 MS Access, IBM RAD, Oracle
• MySQL, IBM DB2, HTML, XMLC, C++, TSQL, PLSQL
• SSIS, SSAS, SSRSMicrosoft Project, MS Office.
• OLAP,OLTP,IBM Data Studio

PROFESSIONAL EXPERIENCE

Sr. Data Modeler

Confidential, Charlotte, NC

Responsibilities:

• Helped conduct meetings with the end users and performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Analyzing the new file formats and input fields to make sure how it can be mapped to the existing database design so minimize the changes on the databases side.
• Developing new jobs for the inbound files to load data for settlement process.
• Reverse engineered existingdatabase to conductsourcedata analysistoidentify the relationshipbetween data sources.
• 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.
• 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 and developed stored procedures, functions, views and triggers to be used during the ETL process
• Worked extensively on BI (SSIS) Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.
• Develop data warehouse and business intelligence solutions using MS SQL server (SSIS and SSAS)
• 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.
• Created solid DSS databases for Reporting.
• Created complex SQL queries for validating target data against source data
• Worked with SSRS to generate reports, procedures in oracle Database.
• Worked closely with Database Administrator for creating queries using joins and also created
• 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.
• Developing jobs to extract Customer and Transaction Data on a daily basis from across the databases and sending it for Name and Address cleansing in Flat file formats.
• Working on incoming file formats for the cleansed data coming back for daily incremental load.
• Working with Data Analysts in Designing the Consumer Database to make sure the data can be keyed together for the internal and inbound process.
• Worked on the support plan for after implementation support for the Application support team.
• 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, ER Studio, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS.

SSRS/ETL Developer

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 ER Studio 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.
• Participated in customer team meetings and conversations with client personnel to understand business and technical requirements including requirements definition, schema design, ETL (SSIS), cube design and development (SSAS), end-user presentation (via analytic reports, graphs, scorecards, etc.), testing, deployment, and post-deployment support.
• Assisted the ETL team in extracting data from DB2 and collaborated efforts in generating source to target mappings.
• Performed Tuning in ETL processes, creation of the technical and system specification documents necessary to support ETL processes. Participate in development and execution of unit and system test plans. manage scheduled jobs involved in the ETL processing including monitoring, alerts and documented follow up processes for managing the daily operations
• Identify data quality issues
• Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries and created procedures and triggers for SSRS reporting
• Used SQL Server Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Develop database stored procedures as and when necessary for loading the files from source systems into the data warehouse.
• 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, ER StudioPLSQL, MS Word, MS Excel, MS PowerPoint, MS Access, MS Projects, MS Visio, Adobe Flash, MS SharePoint.

Data Modeler

Confidential, Broussard, LA

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Work with enterprise data warehouse team to provide inputs on conceptual, logical, and Physical data models for data warehouse and data marts.
• Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL Packages and solutions utilizing SSIS. Extensively used Star Schema methodology in building and designing the logical data model.
• Created data dictionaries and related schemas/models.
• 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 ER Studio to transform data requirements into data models.
• Performed Reverse Engineering of the current application using ER Studio, 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.
• 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.
• Created solid DSS databases for Reporting.
• 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.
• Gathered 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, SME 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, ER Studio, VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS

Data Modeler/Data Analyst

Confidential

Responsibilities:

• Building Data Mart (Conceptual, Logical and Physical) for reporting environment
• Creating Data Dictionary for user defined databases (Collateral, Securities and Reporting) in Oracle, SQL Server
• In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform
• Segregated data and organized the data for common subjects using ODS
• Generated operational reports from ODS as opposed to the transactional/ legacy system
• Performed Data Architecture in Designing and implementing a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merger with Wachovia
• Implemented Agile Methodology for building an internal application
• Worked on Data Aggregation
• Generating Discrepancy reports using Ascential Data Stage
• Preparing Functional Specifications Document for the project
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, and Supervisor)
• Universe designing, developing and generating complex, Adhoc, dashboard Reports
• Analyzing data in both application and reporting databases and solving the discrepancies
• Tracking Data Model Change Requests to closure
• Reverse engineering old database and creating subject areas for each schema
• Preparing High Level Data Flow for all the major Applications
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming
• Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis
• Fine-tuned existing PL/SQL code and worked on upgrade from 9i to 10g
• Fine-tuned Oracle SQL to be more efficient

Environment: Oracle 9i/10g, SQL Server 2000/ 2005, Erwin 7.5.2, BO 6.5/ XIR2,Qlikview 8.5, Ascential Data Stage 7.5, Clear Quest, Windows XP, XML, Excel, Access.

Data Warehouse Analyst/Tester

Confidential

Responsibilities:

• Designed & Created Test Scripts and Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Erwin tool for dimension and fact file creation
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application.

Environment: Windows XP, Erwin, QTP and Quality Center, Visual Basic 5.0, TSQL, PLSQL