Post Job Free

Resume

Sign in

Manager Data

Location:
Barstow, CA
Posted:
March 24, 2017

Contact this candidate

Resume:

Objective

To obtain a position as Lead Business Intelligence developer that provides challenging career opportunity to utilize my prior experience and prospects to enhance my skills and grow in the organization.

Profile

6 years of IT experience in Analysis, Design, Development, testing and Implementation of business applications in Insurance, Utility and Financial sectors.

Knowledge on Guidewire claim center product, legacy decommissioning, Claim operations improvement, Claims Transformation, Migration/Conversion, Requirement Mapping, Business Process Mapping, Guidewire Reporting and ETL.

Knowledge in Guidewire Claim Center Data Object and product model.

Strong Business Knowledge in Property and Causality Insurance, Auto Insurance and workers Compensation.

Experience in different areas of Data warehousing, RDBMS, Data extraction, Development and Implementation of data warehousing, business Intelligence system using Informatica PowerCenter, Data Conversion and various business applications in different platforms Informatica PowerCenter 9, Cognos 10/8 using Report Studio and Oracle 11g/10g/9i(SQL/PL SQL).

Creating technical design and functional design documents for Cognos report development.

Extensively worked with Cognos 10/8 studios Report Studio, Query Studio, Analysis Studio and Metadata modelling tool Framework manager and Cognos connection.

Good Knowledge on Developing dashboards using Cognos Insight and developed Active reports.

Developed the Cognos FM models using Framework manager tool.

Good knowledge on Cognos Business Insight and Advanced.

Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Managed scheduling of reports, public and my folders and distribution lists, users, groups and roles using COGNOS Connection in COGNOS 10.2.1.

Customized data by adding prompts, Filters, Calculations, Summaries and Functions.

Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.

Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger) as ETL tool on Oracle, DB2 and SQL Server Databases.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.

Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.

Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Experience with all phases of Software development life cycle (SDLC) with a passion to work with end users to manage requirements and translate high level business requirements to technical architecture specification with hands-on experience in designing, coding, testing (unit test/ performance test).

Experienced in file transferring from windows server to mainframes using perl scripts.

Experienced in Automating and Scheduling the Teradata and DB2 SQL Scripts on a daily, weekly and monthly basis.

Experience with XML and a scripting language such as VBScript and Java Script.

Rich and extensive experience in Agile Methodologies.

Possess strong analytical and problem solving skills and have quick learning curve. Committed team player and capable of working on tight project delivery schedules and deadlines.

Technical Skills

ETL

Informatica 9.X

BI Tools

Cognos 8 Business Intelligence 10.1/10 (Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager)

Databases

Oracle 11g/10g/9i, SQL Server 2008, DB2, Teradata

Languages

SQL, PL/SQL, VBA, C, Perl

Other Tools

Teradata SQL Assistant, TOAD, AQT

OS

Windows 2000/XP, Linux

Professional Experience (Career History)

Amway Corporation, Grand Rapids, MI

November 2015 – Present

Cognos Developer

Roles and Responsibilities

Involved in requirement gathering from business users and developed technical documentation for the business and team.

Developed and published packages in Framework Manager-Connecting and testing the Data Source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager.

Used Relational Modeling and Snow Flake Schema modeling technique to develop models.

Developed List, cross tab, chart and complex reports which involved multiple Prompts in Report Studio.

Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).

Used Query Explorer to create or modify queries and to perform complex tasks, such as defining Union, joins and writing SQL statements.

Customized data by adding Filters, prompts, Calculations, Summaries using Cognos 10 Report studio and Query Studio.

Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.

Created, refreshed (using Batch scripts) and supported Cognos Transformer OLAP models and Power Play cubes.

Developed and successfully deployed multiple initiatives with Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.

Scheduled and automated various reports using Event studio to send out to various users by email every week/quarter.

Organized cube dimensions hierarchically in a pattern which can easily be used for reporting by Cognos BI suite (Report Studio, Query Studio and Analysis Studio).

Implemented Framework manager security for Row-Level, Data access, Object level access and Package access.

Assisted and worked with data warehouse developers/data modelers to make sure that model being developed is according to the business requirements.

Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Interacting with the End users on a regular basis for resolving issues pertaining to the reports.

Installed & configured the Cognos 10.1 BI Environment, Troubleshooting, and Performance Tuning.

Involved in Deploying reports, cubes and packages from Development to Production environment.

Testing reports using review checklists for Quality Assurance before delivering to the end users.

Nationwide Insurance, Dublin, OH

January 2015 – October 2015

Cognos Developer

During my tenure with Nationwide Insurance -this project was implementation of new claims system that handled Auto, Casualty, Property and commercial lines insurance.

Roles and Responsibilities

Gathered Business requirements and designed functional and technical requirements documentation for Globalization of Reports.

Designed and developed reporting solution using Cognos Framework Manager (FM) and Cognos Report Studio for reporting needs using EDW Datamart utilizing Guidewire's InfoCenter.

Understanding the frontend usage and backend database of Guidewire to be able to verify the data within the Local Operational Data Store.

Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

Performed administrative activities to maintain the Cognos FM package, Cognos Server and Report migration activities.

Generated dynamic reports which allowed users to select their choice of dimensions and measures to be included in the report and this gave the ability to the users to select the columns they would like to see in the reports at run time.

Creating complex reports off of the Frameworks with features such as Dynamic sorting, Hidden Prompts, Drill downs, Drill Throughs and report with tabs.

Created conditional variables to change the graph headers and list column headers based on the user parameter selection.

Participated in the User Acceptance Testing (UAT) of Cognos Cubes and Reports and provided necessary assistance to the users during User Acceptance Test.

Created Custom Cognos report pages by modifying XML files and other Configuration files.

Created Oracle PL/SQL Stored Procedures, Functions, and Cursors for use by Framework Manager Packages and Report Studio reports.

Designed and Developed Framework Manager Models and Implemented security using Access Manager.

Designed Meta data model (Relational and Dimensional model) using Framework manager and published the package in Cognos connection.

Developed models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.

Involved in Troubleshooting, Bug fixing and enhancements of the existing reports.

Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take decisions on the Programs.

Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.

Pacific Gas and Electric (PG&E), San Ramon, CA

February 2014 – December 2014

ETL Developer

Worked on a project named MDS and ENDUR retirement. These applications are being retired from old database in oracle and been brought to new database in Teradata for efficient usable of data for reporting and audit purposes.

Roles and Responsibilities

Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.

Prepared various design documents like technical design documents, mapping specification documents, target to source mapping document.

Developed mappings using Informatica to load data from sources such as Oracle and SQL Server into the Teradata.

Extensively worked with transformations like Lookup, Update Strategy, Expression, Filter, Router, Joiner, Aggregator and Source Qualifier Transformations.

Loaded data to Staging area using Teradata parallel transporter.

Created Indexes, primary keys and checked other performance tuning at data base level.

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.

Developed Teradata Stored Procedures. Performance and fine Tuning of Teradata stored procedures.

Implemented complex mapping such as SLOWLY CHANGING DIMENSIONS (Type II).

Nationwide Insurance

February 2011 – January 2014

Data Analytics Specialist

Claims Solutions Reporting is responsible for development, maintenance and scheduling of business reports to Claims adjusters using the data available in DB2 and Teradata. These reports are used by Claims Directors, Managers and associates to perform sanity check on the claims and policies and relevant claims data.

Roles and Responsibilities

Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.

Worked with various Business users to gather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.

Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.

Wrote several SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.

Used Joins like Inner Join, Outer join and self join while extracting data from multiple tables.

Designed & developed various Ad hoc reports for different teams in Business.

Developed numerous SQL queries by creating tables, Views.

Used Date and string functions and advanced techniques like RANK and ROW NUMBER functions.

Extensively used VBA macro code in the process of report automation.

Used Auto Task (AT) Job scheduling tool to automate the Jobs to run daily, weekly, Monthly and run on specified times.

Designed various data flow data flow diagrams using MS Visio.

Education

Bachelors in Electronics and Communications Engineering, JNTU, India.

Masters in Electrical Engineering, Lamar University, TX.



Contact this candidate