Monika Ravi

561-***-****

acs5qu@r.postjobfree.com

Current Location – Reno, Nevada

SUMMARY:

6+ years of expertise in all phases of Data Warehouse in Development Lifecycle including Requirement Gathering, Data Analysis, Implementation, Testing and Supporting.

Extensively worked in Business Intelligence Technologies of Microsoft BI stack, Informatica Power Center 9.5.1/8.x, IBM DataStage, SQL Server, Oracle and Teradata.

Strong Expertise in developing dynamic PDF forms using Adobe LiveCycle designer.

Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft technology platform (SSIS, SSAS, and SSRS)

Provide technical assistance to the team on various MS BI stack technologies

Tailor solutions for Management dashboards, Financial Reporting and Operational Business Intelligence

Design, develop, deploy, maintain, monitor, and tune SSIS ETL solutions to incrementally load Enterprise Data Warehouse and Enterprise reporting systems. Set Scheduled Jobs for SSIS ETL Packages to run daily, weekly or monthly

Delivered end-to-end Business Intelligence and Data Warehouse solutions using Microsoft SQL Server, SSIS, SSAS (multidimensional and tabular models), SSRS, PowerPivot, Performance Point and Power View.

Expertise in varied Business Intelligence Services like Business Analysis, Technical Design, ETL Design, ETL Development. Data Validation, Data Cleaning, and ongoing production support.

Well versed with Relational and Dimensional Modeling techniques like Star Schema, OLAP, Fact and Dimensional Tables.

Extensive experience in creation and maintenance of database objects like tables, views, materialized views, indexes, constraints, primary keys, sequence, synonyms and database link, etc.

Through understanding and experience of Waterfall and Agile software development environments.

Good understanding of Business Intelligence tools like Business Objects, Cognos.

Excellent communication, analytical and interpersonal skills.

SKILL SET:

Data Warehousing

Microsoft BI suite (SQL Suite, Power Pivot, Power View), IBM DataStage 8.x, Informatica Power Center 9.x/8.x

Data Bases

MS SQL Server (2000, 2005,2008), Teradata, Oracle (9i,10g,11g), Access, DB2

Reporting Tools

Tableau v8.3, Cognos v8, QlikView v9 v11, SSRS

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling

Data Modeling Tools

MS Visio

Programming Languages

C, C++, SQL, PL/SQL, Unix Shell Scripting, Java-J2EE, JSP, HTML

Tools/IDE

Adobe LiveCycle Designer 9.2, Rational application developer (RAD), Eclipse, PVCS (Version Control System), HP Quality Center (IT Quality Management software), Cognos

Scheduling Tools

AutoSys, SQL Server Agent

Operating Systems

MS Windows 2000/XP/2007/2010.

PROFESSIONAL EXPERIENCE:

American International Group (AIG), Houston, TX Oct 2014 – Present

Senior BI Developer

Underwriting Project: Serving as a BI Developer in AIG for Executive Liability Underwriting subject area; The feed data (flat files) provided by business are imported from the server and subjected to detailed data validation using ETL jobs. The validated data is loaded into multiple Teradata tables which is then forwarded to EDW. Reports and Dashboards are generated automatically based on the requirement.

Responsibilities:

Actively Participated in business/technical discussions to understand changes and to gather business/technical requirements.

Created Technical and ETL Design Documents with details of Database Objects and Transformation logic.

Performed Data extraction using SSIS and Informatica Power Center

Developed Dashboards for Operations Team using Performance Point

Generated Canned reports using reporting tools like SSRS, Cognos and Adhoc reports using PowerPivot 2010, Excel

Created SSAS Tabular Model and SSAS Cube Model and support the existing database components

Performed Data Visualization using Power View and Visio Services 2010

Extensively worked on creating staging and target databases, schemas, tables, constraints, etc. and creating stored procedures, functions, views etc. and data validation by querying the respective source/target objects.

Designed ETL jobs to extract data from flat files, defined mapping and transformation logics for data validation and loaded Teradata tables.

Designed and implemented transformation stages like Aggregator, Filter, Lookup, Sequence generator and Sorter.

Eliminated Mapping Bottlenecks and used Informatica Partitioning extensively to increase performance (throughput) of the ETL.

Modeling on Teradata such as creation of tables, indexes, views, normalization, macros, and procedures.

Involved in creating logical and physical data modeling with STAR and SNOWFLAKE schema techniques

Writing Teradata SQL queries to join or any modifications in the table.

Responsible for preparing the Release Documents and worked with Release Management to release codes/objects to QA and UAT environment.

Responsible for fixing issues and bugs identified by QA and UAT resources.

Extensively used PVCS for version control and HP Quality Center to track the business requirements, design, coding, test cases, test results and defects.

Actively involved to find the impact to EDW and downstream applications due to upstream enhancements/changes.

Performed the Source System Analysis to make sure Source Data is aligned with EDW Data Model.

Environment: Microsoft BI suite(SQL suite, Power Pivot, Power View), Informatica Power Center 9.x, Teradata Express Edition 12, SQL Server2008r2, Flat File, SSRS, Cognos, AutoSys, PVCS, HP Quality Center.

American International Group (AIG), Jersey City, NJ May’11 - Sep’ 14

Lead BI Developer

EDW: Served as a lead BI developer in Enterprise Data Warehouse (EDW) which aimed in maintaining a single data source for reporting purposes. The project was aimed at making a data warehousing system out of insurance customers having different insurance policies. The data used to come in as flat file, from different databases (SQL, Oracle) and loaded into the target database (Teradata) using SSIS and Informatica Power Center. Worked on migrating ETL workflows from Informatica to SSIS.

Responsibilities:

Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

Extracted data from different sources, designed and developed ETL processes for loading data into the database by utilizing SSIS and Informatica Power center 8.6.1/7.1 Mapping Designer

Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Gathered requirements, analyzed data, developed and built SSRS and Tableau Reports, supporting client companies’ business reports by using BI solution including cross-tab reports, matrix report, parameter report, dashboard with charts and drill through function

Configure report server and deploy reports on web server and SharePoint, build Performance Points Dashboards in SharePoint.

Used different transformations like Aggregator, Lookup, Filter, Expression, Router, Update Strategy and Sequence Generator.

Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLookup and formulas, built PivotTables and Pivot Charts using PowerPivot skill

Familiar with Data Warehouse Architecture, design methodologies and Best practices.

Load monitoring the Support Process by failure reporting and failure handling in Teradata.

Worked on error handling and performance tuning in SQL queries and utilities.

Experience in writing SQL scripts and implemented in Production database tables.

Loaded data into data ware house on a daily basis.

Followed Star Schema to design dimension and fact tables.

Performance tuned the Mappings, Tasks, Sessions, T-SQL and Scripts to optimize Data-Load performance.

Used data services for data profiling of sources between T-SQL server and Oracle sources.

Involved in System testing and User Acceptance Testing.

Changed existing Universes to accomplish the changes in business requirements.

Environment: BI tool Kit, Informatica 8.6.1, Teradata v2r6, Oracle 9i, T-SQL, TOAD, SQL*Plus, Windows 200, XML, SQL Server 2008(SSRS, SSIS, SSAS), Tableau, UNIX Shell Scripts.

CHARTIS Global Services, Jersey City, NJ Dec 10 –Apr 11

ETL Lead Developer

NURD project: Served as an ETL Developer for AIG Business Intelligence Group; NURD stands for National Union Reporting Database. NURD was developed to assist Executive Liability (EL) staff with reporting. NURD is a central data mart (SQL database) and is populated nightly from an ETL tool DataStage. Datastage extracts data from EDW tables and applies specific business logic applicable to EL.

Responsibilities:

Worked with various business teams to understand Business Requirements.

Involved in Source System (EDW, Salesforce) Data Analysis.

Prepared Detailed Design and Interface Analysis documents for maintenance releases and enhancement requests.

Designed and implemented BVT (Base Verification Tool) to establish a uniform, compliant standard for reporting of the renewable base and non-recurring gross-written-premium (GWP).

BVT provides underwriting management with the ability to efficiently review and edit the Renewal Base in a format that is conducive to automating the reconciliation of those records between Underwriting Divisions and Finance

Developed complex DataStage Mappings and server job sequences in IBM DataStage.

Performed Unit & Integration Testing.

Involved in design and development of data models, application framework from high level business requirements.

Developed functions and procedures in Oracle 11g database to be used for report generation.

Responsible for ‘Best Practices’ like naming conventions, performance tuning, and error handling.

Analyzed and provided solutions to resolve critical system issues and addressed issues like performance tuning.

Created and enhanced Dynamic PDF forms for rebranding and functionality changes using Adobe Live Cycle Designer.

Migrated IBM DataStage jobs from 8.1 to 8.7 with no post production issues and provided high level technical support.

Many of the complex requirements were resolved by developing many new ETL jobs and around 75% of the manual reports were automated.

Handled client meetings and worked with senior level managers and developers across multiple disciplines.

Worked on the Database Triggers, Stored Procedures, Functions, and Database Constraints and the developing the applications using SQL Programming (DDL, DML).

Loaded the data into the SQL database and reports are generated using SSRS.

Responsible for Unit testing and Integration Testing of Database Objects, Mappings and Workflows.

Environment: IBM DataStage 8.x, Oracle PL/SQL, SQL server 2008, UNIX Shell Scripts, Adobe LiveCycle designer ES2, PVCS, HP Quality Center.

Continental National American Group (CNA), Chicago, IL Oct 09 –Nov 10

ETL Developer

NuCore Project: Served as an ETL DataStage Developer supporting Data and Report generation for Executive Liability (EL) Forecast. Maintained NuCore front end for application issues; NuCore (National Union Comprehensive Risk Evaluation System) is a web application that allows underwriters to create a workup and assess the risk for writing business for the account.

Responsibilities:

Responsible for converting Business Requirement Documents (BRD’s) and Functional Requirements into Technical Specifications/Templates.

Developed ETL jobs to pull the policy related data like New, Renewal and Expired policies from EDW (Oracle 10g) and load the SQL tables.

ETL jobs (server and parallel) were designed for both nightly batch runs and morning incremental load. The loaded data was used to generate Sales report for business.

Formulated the logic for forecasting Executive Liability policies and implemented using SQL 2008 Database.

Designed server jobs using various types of stages like Sequential file, Hashed file, Aggregator, Transformer and Links

Developed Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter and Dataset

Migrated reporting databases from SQL 2000 Server to SQL 2008 Server with all compatibility issues resolved.

Created and maintained SQL components like Procedures, Triggers and Views to generate reliable business reports

Proposed testing strategies and test plans to identify and track defects pre and post project implementations

Performed root cause analyses of defects and modified ETL applications to solve business problems

Coded JIL scripts to automate DataStage jobs using AutoSys and minimized report generation effort by 60%

Involved in detailed data analysis in EDW (Oracle 10g) in order to generate reliable reports according to business requirements.

Involved in Quality processes like Lean, ISO 9001:2000 and participated in audits to ensure Quality Standards are met

Extensive Data Modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake Modeling, and FACT and Dimensions Tables.

Worked on Performance Tuning at the Source level, Target level, Mapping Level and Session Level.

Developed Struts action classes, Form Beans (Java – J2EE) and business functionality validation for different business flows as a part of maintenance releases in NuCore.

Involved in common error handling functionality across the NuCore application.

Worked on Debugging and Troubleshooting the Data issues reported by users of all environments in all phases of Data Warehousing Life Cycle.

Environment: IBM DataStage 8.5/8.7, SQL Server 2000/2008, Oracle PL/SQL, Java-J2EE, eclipse, Rational Application Developer (RAD), PVCS, HP Quality Center, AutoSys

Tata Consultancy Services (TCS), India May09– Sep 09

Informatica Developer

Worked as an ETL Developer to support the BI Group through ETLs for processing Historical and Transactional Data.

Responsibilities:

Worked directly with technical lead to convert Technical Documents to ETL Designs.

Written Detail Design Documentations to describe program development, logic, coding, testing, changes and corrections.

Developed and monitored mappings, sessions in Informatica to load the data from various sources into the Data warehouse.

Implemented Slowly Changing Dimensions methodology to keep track of Historical Data.

Coded the functionality and change requirements in web service with Java and J2EE using IDE suites like Eclipse and RAD.

Responsible for regular production support activities with ad-hoc analytical tasks and routine report generation.

Designed test plans and performed unit and system testing of client requirements and ensured quality deliverables.

Worked on SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies in SQL Server.

Demonstrated both individual accountability and team work contributions to successful realization of client goals

Environment: Informatica Power Center 8.x, SQL Server2005/2008, Visio, UNIX Shell Scripting.

Contact this candidate