SUMMARY

• Senior Data Modeler/Analyst with 7+ years of experience in data analysis with focus on Financial, and Healthcare Insurance domains.
• A self - motivated Data Modeler/ SQL Server Developer with 7 years of experience, an amicable team player with excellent communication skills prepared to use my technical abilities and problem solving skills to achieve the goals and commitments of the organization.
• Experienced in developing conceptual, logical and physical data models for OLTP and OLAP systems with the companies standard naming conventions using the Erwin Data Modeling tool.
• Good understanding of Star and Snow Flake Schemas for Data warehouse Modeling.
• Broad experience in gathering business requirements, implementing business processes, identifying risks, impact analysis, UML modeling, sequence and activity diagrams and usind Rational Rose, MS Visio.
• Strong Data Modeling experience using ER diagrams, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, ER Studio.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs’ to apply the data model changes
• Extensive experience in Data Conversion in ACH Transactions.
• Performed system design with Entities, attributes, logical relationships (identifying, non-identifying) Preliminary database design, obligatory and non-obligatory analysis, and validation of a model using Normalization techniques.
• Good Knowledge and brief experience with Semantic Layer Development.
• Good understanding of Normal forms, Normalization and De-Normalization concepts.
• Strong experience in ER Diagrams, Conceptual, Logical and Physical Data modeling using EA Sparx Tool, Microsoft Visio, CA Erwin that involved requirement analysis with business team and translating them into Technical Specs.
• Good experience in data analysis, data profiling, data transformation, data mapping from source to target database schemas and also data cleansing, data quality.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility
• Very strong hold on Database designing and MS SQL Server Programming involving Database/Table creation, Triggers, Transact-SQL (T-SQL), PL-SQL, Stored Procedures, Views, Security and Indexes. Performance tuning and Query Optimization using DBTA, SQL Profilers, Management Studio, Execution Plans etc.
• Possess a strong analytical, verbal, inter-personal skill that helps in communicating with developers, team members.

TECHNICAL SKILLS

Database: MS SQL Server 2008 R1, MS SQL Server 2005, MS SQL Server 2000, MS SQL Server 7 and Oracle 11g

Programming Environments: SQL Management Studio, ISQLW Utility

Performance Tuning Tools: Database Tuning Advisor (DBTA), SQL Profiler and SQL Server Management Studio

Methodology: Agile (Scrum), Waterfall

Modeling: CA Erwin Data Modeler 8.2.07, Sparx Enterprise Architect 7.5, Microsoft Visio

Special Product/Tool: IBM Product for Master Data Management (MDM) Solution “IBM Initiate” / "IBM Info sphere"

Version Control Tools: MS Visual Source Safe 6.0, Team Foundation Server (TFS)

Reporting Tools: SSRS, Crystal Reports 8.5, 9.0, 10.0

Operating systems: Windows XP, Windows 2003 Server

Others: MS Office, MS Excel 2000 &2003. MS Visio 2010

ETL: SSIS, Informatica

PROFESSIONAL EXPERIENCE

Confidential, Bothell, WA

Data Architect/Data Modeler

Responsibilities:

• Work with business users and business analyst in support of system requirement analysis and clarify business requirements.
• Develop and maintain an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse. This effort involves working closely with the business.
• Involved in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Created Semantic Layerfor Cognos Framework manager model design.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Involved in capturing all business entities, Logical and Physical Data Model design to demonstrate business process flow, DDL Script creation for Database object using Erwin and its implementation and optimization. Collaborate with the data warehouse team and the business partners in designing Data Marts.
• Emphasize methodology, modeling, and governance: Define the IT design methodology, development process methodology and best practices.
• Establish and maintain data standards, policies and architectures.
• Identify opportunities for standardizing data descriptions, integration and archiving, and elimination of unnecessary redundancy.
• Capture and maintain metadata, creating business rules for the use of data.
• Creation of enterprise metadata that can be used across all line of business in CITI Bank.
• Create technical documentation such as data architecture design documents, ETL mapping specs and Data Model design and changes artifacts.
• Involved in end-to-end design, development, implementation and post implementation support in resolving complex data and technical issues.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing ad hoc and robust reports.
• Participate and lead aspects of the proposal development process and contribute to the development of project plan and deliverables milestone.

Environment: CA ERWIN r7.2, UNIX, Windows XP, PL/SQL, Oracle 10g, TOAD

Confidential, Charlotte, NC

Sr. Data Modeler

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.
• 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.
• 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.
• 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, VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS.

Confidential, West Newyork, NJ

Data Modeler

Responsibilities:

• Defined access requirements, data strategy, and architecture for Equity Trading management dashboard.
• Designed Multi-Dimensional data model (STAR Schema) Data Mart and iteratively enhanced it to meet the growing requirements for Equity Trading Management.
• Designed and developed OLAP cubes ( dimensions, outlines, measures) using Hyperion BI
• Designed and implemented three global ( BOS, HK, LON) data integration/ETL processes using SQL loader
• Created Oracle PL/SQL stored procedures, views to load data into data marts using SQL Loader. Developed Maxl scripts to automate the cube building process.
• Worked with Oracle & Hyperion to develop PoC for Oracle BI product for Equity Trading
• Administered security privileges using Hyperion Admin Tool.
• Delivery of complex enterprise data solutions with comprehension in areas such as Architecture, Configuration, Security, Performance, Scalability, Reliability, Infrastructure
• Participate in design reviews, validate technological approaches and products to ensure compliance with the corporate technology strategy
• Ensure data security is followed and that the security requirements are incorporated into the overall architecture of applications
• Validate the quality of data and find solutions to the problems of data integrity
• Drive performance monitoring standards and participate in performance tuning activities
• Provide technical guidance to the team in solving complex technical problems related to the ETL/ELT procedures that support the data warehouse.
• Publish database standards and enforce them through pre-defined work processes.
• Analyze technologies, technical processes and/or functions, and document findings, identify areas for improvement and create specifications for implementation
• Designed and developed UNIX shell scripts, autosys jobs for ETL processes.
• Researched and advised on emerging tools and products in data warehouse/BI domain

Environment: SQL Server 2000/ 2005, Oracle 9i, DB2, Main Frames, Erwin 7.5.3, Windows 7, XML, Excel, Access, Visio.

Confidential, St. Louis, MO

Sr. Data Analyst/Developer

Responsibilities:

• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked on SAS and IDQ for Data Analysis.
• Compared mortgage data including appended documents to ensure that they are consistent and accounted for; located discrepancies, if any.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Optimized robust Test Data Management process .
• Involved with dataprofiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Created several Test cases and scenarios for Test Data Management.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Worked on Front end Java applications for data analysis 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, data mining and trends in helpdesk environment using Access
• Recommended solutions to correct errors in disconnected actions of departments and suggested ways to enhance coordination.
• Responsible for Testing Schemas, Joins, Data types and column values among source systems, Staging and Data mart.
• Create simple and complex SQL scripts for Data validation between source system and staging Database
• Worked autonomously within a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data.
• Responsible for leading software testing, troubleshooting, and implementation.
• Support end-users, company-wide to resolve database and software issues utilizing remote desktop tools.
• Responsible for performing the data validation, process flow, dependency, Functionality Testing and User Acceptance Testing.
• Database recovery and subsequent problem resolution.
• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.

Environment: Informatica8.x, Business Objects XIR3.1, WebI, Universe Designer, SQL Teradata 13, IDQ, Oracle 8i/9i, PL/SQL, Windows XP

Confidential, Richmond, VA

Data Modeler

Responsibilities:

• Interacted with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generated DDL scripts for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Teradata, SQL Server 2000/ 2005, Erwin7.3, Windows XP, XML, Excel, Access, Visio.

Confidential

Database Developer

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 (Rational Unified Process) to create use cases, activity, class diagrams and workflow process diagrams.
• Extensive development providing data integrated solutions using VB 5.0.
• Responsible for providing database solutions using MS Access/ SQL Server/ 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: MS SQL Server 2000, Oracle 8.0/9.0, Visual Basic 7.0, TSQL, PLSQL, Windows NT /2000