SUMMARY

• Around 7+ years of professional experience working as a Data Analyst/ Modeler, business system analyst wif diverse industry verticals like insurance, banking and service domains.
• Extensive experience in developing logical and physical data models for both transaction as well as analytical systems.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience wif Business Process Modeling, Process Flow Modeling, Data flow modeling.
• Experience in analyzing teh business requirements and creating Business Requirement Document (BRD). Expertise in interacting wif stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Proficient in requirement gathering, Organizing JAD sessions, one to one interviews, and focus groups.
• Expertise in Data Modeling using tools likes ERwin, ER Studio and Power Designer.
• Experience wif Teradata using database commands and Teradata utilities such as BTEQ, SQL Assistant, Fast Load, Multi Load, Fast Export etc. Worked extensively on XML Schema designs.
• Hands on experience wif modeling using ERwin in developing Entity - Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact & Dimensional Tables.
• Hands-on noledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools.
• Extensive Experience working on SQL Queries along wif good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Good Understanding and Knowledge wif Agile and Waterfall Environments.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Experience in preparing project cutover plan, test plan wif test cases for unit test, regression test and User Acceptance Testing (UAT).
• Excellent in verbal and written communication, organizational skills combined wif teh ability to work in a fast-paced environment as an individual and/or as a team member.

TECHNICAL SKILLS

• Windows2003 Advanced Server
• ASP.Net
• MS SQL Server
• TSQL
• Pl/SQL
• QNXT
• Visual Studio 2008
• Oracle 11g
• Pentaho BI.4.8
• Pentaho kettle
• SharePoint 2007/2010
• Tableau
• Qlikview
• Lotus Notes
• Power BI
• SSRS
• SSIS
• Jasper Reports 6.1.0 API
• OBIEE
• Informatica
• Erwin.

PROFESSIONAL EXPERIENCE

Confidential, Houston,TX

DATA ANALYST/MODELER

Responsibilities:

• Gatheird business requirements, working closely wif business users, project leaders and developers. Analyzed teh business requirements and designed Conceptual and LogicalDatamodels.
• Worked wif business requirementsanalysts/subject matter experts to identify and understand requirements.
• Data validation and creating pivot tables for analysis, managing teh large sets of data export from excel into sql server vice versa.
• Configuring connections between Tableau and Sql server/Excel.
• Conducted user interviews anddataanalysis review meetings.
• Experience in SSIS to convert teh data from source files (E.g. Flat files) to target files (E.g. Excel)
• Defined key facts and dimensions necessary to support teh business requirements along wifData modeler.
• Resolved thedatarelated issues such as: assessingdataquality,dataconsolidation, evaluating existingdatasources.
• Manipulating, cleansing & processingdatausing Excel, Access and SQL.
• Responsible for loading, extracting and validation of clientdata.
• Coordinated wif teh front-end design team to provide them wif teh necessary stored procedures and packages and teh necessary insight into thedata.
• Created and modified several UNIX shell Scripts according to teh changing needs of teh project and client requirements.
• Worked closely wifDataArchitect to review all teh conceptual, logical and physical database design models wif respect to functions, definition, maintenance review and supportDataanalysis,Data Quality and ETL design that feeds teh logicaldatamodels.
• Conducteddatamodeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Created DDL scripts for implementingDataModeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon teh requirement, PublishedDatamodel in model mart, created Skilled in System Analysis, E-R/DimensionalDataModeling, Database Design and implementing RDBMS specific features.
• Created teh conceptual model for thedatawarehouse using Erwindatamodeling tool. Part of team conducting logicaldataanalysis anddatamodeling JAD sessions, communicateddata-related standards.
• Expertise in implementingDatamodeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, DataMart’s, OLAP, FACT & Dimensions tables, Physical & Logicaldata modeling and Oracle Designer.
• Communicating to various business stakeholders and understand their vision and ensuring dis achieved during teh project. Key tasks also include performing LOE impact analysis, ROI analysis, user experience analysis
• Createddatamapping documents mapping LogicalDataElements to PhysicalDataElements and SourceDataElements to DestinationDataElements.
• Participated in client discussions to gather scope information and perform analysis of scope information to provide inputs for project documents.

Environment: SSMS, Sql Server, MS Office 2016/13/10/7, Tableau, MS Visio 2003, PowerPoint, Windows XP, UML, SQL, Test Director, MS Outlook, Data Warehouse, OLAP, SQL Navigator, SQL Developer, Erwin 4.0, XML, OLTP, MS-Excel 2000, MS-office 2000, Microsoft XP Professional.

Confidential, Beaverton

Data Analyst/Modeler

Responsibilities:

• Involved in requirement gathering along wif teh business analysts group.
• Gatheird all teh Claims Analysis report prototypes from teh business analysts belonging to different Business units.
• Gatheird various requirement matrices from teh business analysts.
• Extracted data from different flat files, MS Excel, MS Access and transformed teh data based on user requirement using SSIS Transformations.
• Reversed Engineered existing databases to understand teh present database structure using Erwin.
• Conducted Design discussions and meetings to come out wif teh appropriate Data Model.
• Designed for teh various reporting requirements.
• Designed a logical data model using database tool Erwin r9.6.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance wif reporting requirements wif dimensions like time, members, services and providers.
• Developed Star and Snowflake schemas based dimensional model to develop teh data warehouse.
• Modeled teh dimensions and facts using Erwin for centralized data warehouse.
• Identified and tracked slowly changing dimensions and determined teh hierarchies in dimensions
• Created summary tables using de-normalization technique to improve complex Join operations
• Worked wif Data Scientist in order to create a data mart for data science specific functions.
• Participated in teh tasks of data migration from legacy to new database system
• Conducted Design reviews wif teh business analysts, content developers and DBAs.
• Designed ETL Mapping Specs for ETL team for Source to Target Mappings and corresponding business rules involved.
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked wif ETL team using SSIS packages, to plan an effective package development process, and design teh control flow wifin teh packages.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose using Erwin 9.6 report designer.
• Interacted wif SSRS reporting team to gather reporting requirements, and review summary tables
• Worked wif teh Implementation team to ensure a smooth transition from teh design to teh implementation phase.

Environment: ERWIN, SSIS,SSMS, Oracle 10g, SQL Server 2012/2005, PL/SQL, PeopleSoft V8, Toad, Case Management System, Business Objects

Confidential

SQL DEVELOPER

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Extensively worked in developing SSIS packages using Derived Column, Conditional split, Script Task, Merge, FTP task and Multicast.
• Reverse engineered teh existing Informatica application, to replace teh source system to a new system using SSIS and stored procedures.
• Involved in integrating Share Point Server wif SSRS and deploying SSRS reports on to Share Point Server.
• Created Linked reports and Ad-hoc reports based on teh requirement. Linked reports were created in teh Report Server to reduce teh repetition teh reports.
• Created multiple ETL packages to extract, validate, transform, load data and generate files for various project specific functionalities.
• Hands on experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports.
• Designed and implemented modular and reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Exception Handling, Surrogate Key Generation & Assignment, Data Lineage Tracking, and ETL Auditing.
• Maintained databases wif Data Base Consistency Checks (DBCC) such as Rebuilding Indexes and Integrity Checks.
• Wrote complex stored procedures for teh Application Development using T-SQL.
• Worked on Common Table Expression which uses rank function to calculate teh ranking of clients based on teh policies they insured.
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Using Informatica Designer, developed mappings, which populated teh data into teh target.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Dashboards using SSRS.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS).
• Designed and deployed various different professional reports wifSSRStools, utilizing Dynamic and Cascading Prompts, sub-reports, conditional and dynamic reports.
• Created different Power Pivot reports as per teh client requirement.
• Developed reports for business end users using report builder wif updating statistics.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experienced in Cognos 10, 8, ReportNet wif Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Experience in Designing, Building teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Copied Facet State to XML file using T-SQL.
• Analyzed and designed software and database solutions.
• Deploy Clarity reports in both BOE Info view and Epic-Crystal Integration
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.

Confidential

Data Modeler

Responsibilities:

• Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing teh tables/relationships to arrive at effective Relational Schemas.
• Identifying teh facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Rapid Audit of teh requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained teh Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains teh Enterprise Schema across all applications. Enforces principals of good canonical data design.
• Developing Snowflake Schemas by normalizing teh dimension tables as appropriate.
• Implementation of Business Rules in teh Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Worked wif data compliance teams,Data governanceteam to maintain teh data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participate in biweekly technical huddle meeting wif development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services and MS SQL Server 2008