SUMMARY

• Over 9+ years of IT experience in teh field of Data analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Governance, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Over 2+ years of experience in Data Modeling wif expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Sybase Power Designer.
• Domain noledge of multiple industries, such as finance and Insurance, wif very challenging and demanding work environment.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good noledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Expertise in configuration, performance tuning, installation of Informatica, and in integration of various data sources like Oracle, MS SQL Server, XML, Flat files, COBOL files into teh staging area and Design ETL processes dat span multiple projects.
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on teh logical models.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle into a common target area such as Data Sets and Data Warehouse.
• Extensive experience in performing current state process assessment, gap analysis and proposing improvements.
• Expert in requirement gathering and documenting teh requirements in business requirement documents.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) wif expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Involved in teh data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to teh customer and feasible for teh developers and to limit a project’s exposure to teh forces of change.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Implemented Optimization techniques for better performance on teh ETL side and also on teh database side.
• Experience in integration of various data sources like Oracle, DB2, SQL server 7 and MS access into staging area.
• Strong business analysis skills and an understanding of teh Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP), Agile: XP, Scrum.
• Oversee teh installation of security softwares and ensure their regular maintenance
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, and Marine.
• Functional noledge of various modules of insurance like channel management, policy servicing, claims management, underwriting, reinsurance and finance.

TECHNICAL SKILLS

ETL TOOLS: DATABASES Oracle 11g/10g/9i, MS SQL Server 2007/2012/2008/2005 , Teradata, Netezza, MS Access

ETL TOOLS: Informatica Power Center, Metadata Manager, Informatica Analyzer, SSIS, SSAS SQL * Loader, Ascential Data Stage

DATA MODELING: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio

OPERATING SYSTEMS: Windows, UNIX, Sun Solaris, AIX, HP

PROGRAMMING LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, XML, Visual Basic, Basic HTML. Net

REPORTING/DSS/ANALYSIS: Business Objects 5.0, COGNOS 7.0 and Crystal Reports, QlikView, Base SAS, SAS, SSRS Enterprise Guide.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Sr.Data Modeler/ Analyst

Responsibilities:

• Developed Complex Queries in T-SQL, Stored Procedures, and Views wif best execution plan.
• Created User Defined Functions, Triggers, Indexes.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Used teh SSIS to migrate Databases such as Oracle and Access database, flat files to SQL server.
• Developed DTS jobs to import data from legacy systems. Involved in building teh ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Used SQL Server Mail Agent for sending automatic emails when any packages, queries are failed.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down and Crosstab Reports.
• Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, SQL Server 2005,Toad 9.0.

Confidential, Charlotte, NC

Sr. Data Modeler/ Analyst

Responsibilities:

• Categorization of issues from a Remediation perspective and bucketing into teh projects.
• Responsible to capture teh Data Issues identified during: EY Assessment, Pod Documentation, profiled source system fields and Enrich Fields.
• Collected Metadata from teh beginning of teh data collection process for both alphanumeric and spatial data.
• Conducted teh implementation of new internal risk score
• Document teh side by side comparison of Fed instructions, POD Business Logic and Profiling Results.
• Responsible for creating teh metadata and mapping document for teh data as per teh business requirements.
• Worked effectively wif Credit, teh line, and Finance and ensured data integrity.
• Verification of teh loan population requirements of teh CCAR Schedules as per teh Fed Regulations.
• Perform data profiling in teh source systems dat are required for financing.
• As a Data Governance council contributor many data policies were set and helped in making teh Strategic Decisions of company. Solved many escalated issues at teh strategic level.
• Involved in creating teh pivot tables and bar charts for teh schedule fields requiring teh obligor financial data.
• Document teh complete CCAR Data Requirements process flow to describe Business Logic, Technical Mapping, Historical Data Availability, Issue Details, Target System for Remediation and Remediation Status information.
• Responsible for creating test cases to check for failures based on teh Federal Reserve Guidelines, thus ensuring quality.
• Identifying teh manual sources if available for Fed items where system data is not captured.
• Gathering of user requirements and source system analysis and establishing mappings between source to target attributes.
• Document, clarify, and communicate requests for change requests wif teh issue manager and coordinate wif teh development and testing team.
• Involved in defining teh source to target data mappings, business rules and data definitions.
• Responsible for defining teh functional requirement documents for each source to target interface.
• Helping teh Remediation team in identifying missing data and backfilling teh data.
• Document data quality and traceability documents for each source interface.
• Responsible for creating test cases to check for failures based on teh Federal Reserve Guidelines, thus ensuring quality.
• Coordinate wif teh business users in providing appropriate, effective and efficient way to design teh new reporting needs based on teh user wif teh existing functionality.
• Involved in defining teh trumping rules applied by Master Data Repository.
• Define teh list codes and code conversions between teh source systems and MDR.
• Supporting teh QA team wif any issues and was responsible for mitigation of teh errors using Teh HP Life Cycle Application Management (ALM).
• Involved in configuration management in teh process of creating and maintaining an up-to-date record of all teh components of teh development efforts in coding and designing schemas.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Interact wif computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.

Environment: SQL/Server, Oracle 9i,Informatica Analyst, Informatica Data Quality, MS-Office, Microsoft Hyperion Planning, Hyperion Financial ReportingAccess,Oracle TOAD,HP ALM, ER Studio, XML, Business Objects.

Confidential, Louisville, Kentucky

Sr. Data Modeler/ Analyst

Responsibilities:

• Performed data profiling in teh source systems dat are required for Dual Medicare Medicaid Data mart.
• Created ETL SSIS packages both design and code to process data to target databases
• In corporate a system wifin teh stored data dat identifies violation or breach of security standards. If any violation occurs, undertake measures to seal teh security loophole.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Responsible for ETL development wif successful design, development, and integration of components wifin teh Talend ETL Platform and Java Technology.
• Responsible for management of data, duplicating teh data and storing teh data in to specific data warehouse using Talend Platform for Data Management and MDM.
• Involved in defining teh trumping rules applied by Master Data Repository.
• Defined teh list codes and code conversions between teh source systems and MDR.
• Worked wif internal architects and, assisting in teh development of current and target state enterprise data architectures.
• Worked wif project team representatives to ensure dat logical and physical ER/Studio data models were developed in line wif corporate standards and guidelines.
• Involved in defining teh source to target data mappings, business rules, and business and data definitions.
• Responsible for defining teh key identifiers for each mapping/interface.
• Responsible for defining teh functional requirement documents for each source to target interface.
• To Document, clarify, and communicate requests for change requests wif teh requestor and coordinate wif teh development and testing team.
• Reverse engineered all teh Source Database’s using Embarcadero.
• Coordinated wif teh business users in providing appropriate, effective and efficient way to design teh new reporting needs based on teh user wif teh existing functionality.
• Documented data quality and traceability documents for each source interface.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions
• Involved in data warehouse and Data mart design.
• Gained Experience wif various ETL, data warehousing tools and concepts.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Have good Experience wif Mainframe enterprise-billing systems involved in defining teh business/transformation rules applied for Dual Medicare Medicaid data.
• Worked wif internal architects assisting in teh development of current and target state data architectures.
• Generated several drill down and drill through reports usingSSRS.
• Worked wif project team representatives to ensure dat logical and physical ER/Studio data models were developed in line wif corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality for Missing data in teh existing Confidential Enterprise data warehouse (EDW).
• Also worked on some impact of low quality and/or missing data on teh performance of data warehouse client.

Environment: SQL/Server, Oracle10&11g, MS-Office, Embarcadero, SQL, SSIS, SSRS,SSAS, Netezza, Teradata, Enterprise Architect, Informatica, ER Studio, XML, Informatica, OBIEE.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Obtained business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.
• Established financial forecasts for teh given project by using already made scope of teh system.
• Developed use case model using MS Visio. Created a development plan for teh overall project and prototypes.
• Involved wif creation of UML diagrams such as activity and sequence diagrams by using MS Visio.
• Gathered and documented requirements for creating bureau reports and bureau reporting mart (ISO, Mass Auto, DMV).
• Performed in depth data analysis identifying data issues in legacy system and worked wif business to develop resolutions to those issues.
• Created business requirements document and functional requirements document after gathering both functional and non-functional requirements as well as user stories.
• Actively involved in data warehouse and mart design sessions for both Logical and Physical design.
• Communicated logic for teh parsing of data to ETL team.
• Created data mapping documents for teh movement of data from production databases to teh warehouse and from teh warehouse to teh policy and claims marts.
• Involved in configuration management in teh process of creating and maintaining an up-to-date record of all teh components of teh development efforts in coding and designing schemas.
• Developed teh financing reporting requirements by analyzing teh existing business objects reports.
• Interact wif computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible in maintaining teh Enterprise Metadata Library wif any changes or updates.
• Document data quality and traceability documents for each source interface.
• Established standards of procedures and generated weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica).
• Predicted and analyzed teh financial impact of health plan initiatives for large corporations
• Coordinate wif teh business users in providing appropriate, effective and efficient way to design teh new reporting needs based on teh user wif teh existing functionality.
• Remain noledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects.

Confidential, WI

Data /Business Analyst

Responsibilities:

• Analyze business information requirements and model class diagrams and/or conceptual domain models.
• Gather & Review Customer Information Requirements for OLAP and building teh data mart.
• Performed document analysis involving creation of Use Cases and Use Case narrations using Microsoft Visio, in order to present teh efficiency of teh gathered requirements.
• Calculated and analyzed claims data for provider incentive and supplemental benefit analysis using Microsoft Access and Oracle SQL.
• Analyzed business process workflows and assisted in teh development of ETL procedures for mapping data from source to target systems.
• Managed teh project requirements, documents and use cases by IBM Rational RequisitePro.
• Assisted in building an Integrated Logical Data Design, propose physical database design for building teh data mart.
• Document all data mapping and transformation processes in teh Functional Design documents based on teh business requirements.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1.
• Imported and Created Source Definitions (XML, Flat file, Oracle, COBOL, SQL Server) using Source Analyzer and Created Target Definitions using Warehouse Designer.
• Created Mappings using Mapping Designer to load teh data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, Sorter transformations.
• Created Mapplets using Mapplet Designer to generate different mappings for different loads.
• Created Post-Code Design documents for teh mappings wif MS Visio diagrams representing teh data flow in each mapping.
• Responsible for teh suggestion and development of new reporting to support/problem solve for teh business such as sales productivity reporting, ad hoc reporting using Micro Strategy, sales management reporting, and benefit utilization.

Environment: Informatica PowerMart/ PowerCenter 7.1 (Designer, Workflow Manager, Workflow Monitor), Oracle 8i, Erwin 4.0, Autosys 4.1, Micro Strategy, IBM Rational RequisitePro, MS Office tools Windows XP

Confidential 

Database Developer

Responsibilities:

• Involved in teh design of teh overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms 4.5.
• Assisted in building, debugging and running forms.
• Performed Data loading and Extracting functions using SQL*Loader.
• Designed and developed all teh tables, views for teh system in Oracle.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, SQL*plus, SQL*Loader, PL/SQL, Forms 4.5, Reports 2.5