SUMMARY

• Seven Years of excellent experience as a Data Modeler, Data Analyst and SQL Developer in IT, Finance, Management and Software domains.
• Also experienced in database management, strategic analysis, requirements gathering, application and decision support, which plays a key role in software development life cycle (SDLC).
• Seven Years of IT professional experience with strong background in Database development and designing ofdatamodels for different domains.
• Strong background in various DataModeling tools using Erwin, MS Visio.
• Extensive experience in SDLC (Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Forward and Reverse Engineering, Publishing Erwin diagrams, analyzing data sources and creating interface documents.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like Erwin.
• Participated in JAD sessions, created Use Cases, work flows and Power Point presentations.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Gathered and documented Functional and Technical Design documents.
• Have experience in writing High - level and Low-level Design documents.
• Have worked with ETL tools to extract, transform and load data from relational databases and various file formats and loaded to target database.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Experience in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing and TKPROF.
• Experience in creating Materialized views, Views, Lookups for the Oracle warehouse.
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Experience with Erwin model manager.
• Managed performance and tuning of SQL queries and fixed the slow running queries using utilities like Explain, Trace, and TKPROF.
• A dedicated team player with excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5, Embarcadero ER/Studio Oracle Designer, Sybase Power Designer.

OLAP Tools: Microsoft Analysis Services, Business Objects, Crystal Reports. Programming Languages SQL, PL/SQL, BaseSAS, HTML, XML, VB.NET, C, C++, UNIX

Database Tools: Microsoft SQL Server 2000/2005, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1.

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS.

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service.

PROFESSIONAL EXPERIENCE

Confidential, Oaks, PA

Sr. Data Modeler

Responsibilities:

• Analysis of functional and non-functional categorized dataelements fordataprofiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Involved with data profiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Wrote and executed unit, system, integration and UAT scripts in adatawarehouse projects.
• Troubleshot test scripts, SQL queries, ETL jobs,datawarehouse/datamart/datastore models.
• Worked on front end Java applications for dataanalysis and providing results to Business users.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Perform data reconciliation between integrated systems.
• Metrics reporting,datamining and trends in helpdesk environment using Access.
• Written complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects XIR2.
• Extensively used MS Access to pull the data from various databases and integrate the data.
• Worked on SAS for Data Analysis.
• Assisted in the oversight for compliance to the Enterprise Data Standards.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data.
• Worked with Excel Pivot tables.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL.
• Worked on Salesforce as a CRM tool to analyze the requirements of the customers.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Developed regression test scripts for the application and involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs.
• Analysis on Mainframedatato generate reports for business users.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 11G, Teradata V2R12, Teradata SQL Assistant 12.0.

Confidential, St. Louis, MO

Data Modeler/SQL Developer

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Extensively used SQL for Data Analysis.
• Done Reverse engineering on existing datamodel to understand the dataflow and business flows.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Created Schema objects like Indexes, Views, and Sequences.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.3.
• Used forward engineering to create a Physical DataModel with DDL that best suits the requirements from the Logical DataModel.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for datawarehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch datafrom legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracteddatafrom the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a singledatawarehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

Environment: Erwin r7.1, Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro.

Confidential, OH

Data Modeler/SQL Developer

Responsibilities:

• Reviewed requirements together with QA Manager, ETL leads to enhancing thedatawarehouse for the originations systems and servicing systems.
• Performed GAP analysis of business rules, business and system process flows, requirements and developed Requirement Traceability Matrix to ensure current project requirements are met and their timely update.
• Design discussions and meetings with thedataarchitects to come out with the appropriate design for thedatawarehouse.
• Responsible for souring originations systems and servicing systems like LIS, LPS, CORE, AS400 and Phoenix into MIDE (Mortgage IntegratedDataEnvironment) source/staging layer.
• Identified, organized, and documented the changing requirements of the project.
• Extensively involved in the Physical/logical modeling and development of ReportingData Warehousing System.
• Excellent experience managing the whole testing process, Project Status and monitor workload using HP Quality Centre.
• Documented requirements in Power Designer V16 /V15, ERWIN and created Requirements Traceability Matrices (RTMs).
• Created fully fledged Source to Target Mapping documents (S2T), documented business and transformation rules.
• Worked on different data formats such as Flat files, SQL files, Databases, XML schema, CSV files.
• Attended JAD sessions with Data Architects to build up subject area specific models.
• Working with other Data analysts and Info analysts for each subject area.
• Conducted internal and final DFD reviews with the ETL team (EIS),DataQuality, Metadata Management team,dataarchitects, business and application datastewards.
• Developed on overall project plan and implementation schedule through consultations with project team, management, employees and external consultants.
• Involved in project cycle plan for the datawarehouse, source data analysis,data extraction process, transformation and ETL loading strategy designing.
• Maintaining the Requirements Traceability Matrix (RTM) across the deliverables of a project.
• Supported QA/ETL teams in ensuring proper implementation of the requirements and developed and executed test plans and test scripts for testing and UAT (User Acceptance Testing).

Environment: Power designer V16/ V15, Erwin, Teradata V14, Teradata SQL Assistant, Oracle 10g, SQL Server 2005/2008, Mainframes, TOAD, XML, CA Harvest, PAC2000, Clear Quest.

Confidential, NYC-NY

Data Modeler

Responsibilities:

• Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems; and then building financial data mart in order to provide functionality for their reporting purposes.
• Created conceptual, logical & physical datamodels with Erwin and did design review meetings with other team members in order to finalize the model.
• Implemented advance modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi-dimensional model.
• Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.
• To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Developed and maintained enterprise datadictionary by interacting with datasteward, data governance team.
• Divided model into subject areas for reflecting understandable view to business as well as datamodel reviewers.
• Created DDL for physical model using Erwin and handed over to the DBA team.

Environment: Orac1e 11i, ER Studio 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2008, T-SQL, PL/SQL, TOAD 8.5.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Worked with identified business users to define data requirements.
• Defined corporate metadata definitions for all Enterprise Data supported databases (operational source systems,datastores anddatamarts).
• Performed Data Analysis,Data Profiling & Validity,Data cleansing rules etc.
• Developed mapping spread sheets that will provide the Data Warehouse Development (ETL) team with source to target datamapping.
• Took a leadership role when working with the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.
• Developed logical and physical datamodels that document source data from multiple sources (Client's internal data systems, external sourcedatasystems, 3rd PartyData, Prospect Lists, etc.).
• Defined and developed designs to support departmental and functional datamarts. Provided input to datamodeling and physical database development standards with the DataModeling Team.
• Assisted in the review of database structures of proposed business application purchases.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical datawarehouses were able to support all business requirements for OLAP reporting across the organization.
• Assisted in the design and administration of the corporate Metadata Repository.
• Maintained Enterprise logical and physical datamodels, reflective of current environments.

Confidential

Business Analyst

Responsibilities:

• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Managed changing requirements which included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing relationship between related requirements and maintaining version control.
• Prepared and documented System Requirements and workflows for the Content Management Application tool.
• Checked Business Readiness and determined activities of flow.
• Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Wrote Procedure Manuals and was responsible for continuity preparedness.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Helped in writing Training manuals and helped business with the Training on a one to one sessions.
• Employed Rational Clear Quest for effective Change Management (Requirements Creep) and bug tracking during the testing lifecycle.

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, XML, Windows XP, NT/2000, HTML, Vignette Content management Tool, J2EE (JSP1.2), XML, XSL, XSLT, HTML, Oracle 9i.