OBJECTIVE:

To pursue a challenging career in the field of Information Technology and to be a versatile leader who can handle the projects and deliver the optimum business value to the clients in time with maximum quality.

PROFESSIONAL SUMMARY

● About 12 years of IT experience on multiple skill sets and roles.

●Design and Developed SSIS packages, SSRS reports, Stored procedures, Configuration files, tables, views, functions and to implement best practices to maintain optimal performance. And to implement best practices to maintain optimal performances.

●Successfully migrated the data between the heterogeneous sources like Flat file, Excel Source and SQL server using SSIS.

●Extraction, Transformation and Loading (ETL) process by pulling large volumes of data from various data courses using SSIS.

●Involved in extracting the data using SSIS from OLTP to OLAP.

●Build efficient SSIS packages for processing fact and dimension tables with complex dimensions.

● Worked on backend programming using SQL Server Stored Procedures, PL/SQL stored procedures, functions, packages and database triggers for Oracle 9i/10i/11g, and MS SQL Server 2014/2016.

● Hands-on experience includes 8 years data conversion in corrections domain using Oracle 9i/10g/11g

● Experience in Data Conversion, Reporting, RDBMS concepts and Database Development, Testing

and Implementation using MS SQL Server 2014/2016, Oracle 11g/10g/9i, SQL and ETL tools.

● Hands on experience on various SQL Server Services like Integration Services (SSIS), and Reporting

Services (SSRS).

● Expert in creating simple and parameterized reports and complex reports involving Sub Reports,

Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).

● Extensive exposure to concepts of Oracle Database and Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.

● Experience in OLTP System Study, Data Analysis and E-R modeling, understanding in developing Database Schemas like Star and Snowflake schema.

● Created ETL processes using the OWB design tool and repository.

● Analyzed and improved the efficiency, scalability, and stability of data collection, extraction and storage processes.

● Extensive experience in creating executive reports with Oracle Answers and BI Publisher integrated with OBIEE 11.1.1.7.14

● Built and designed KPIs, Alerts, and Data Mining Cubes in the project.

● Performed Migrations between Test, UAT and production environments.

Deploys OpAdhoc RPD into various environments

● Acts as a liaison between departmental end-users, technical analysts in the analysis, design, configuration, testing and maintenance of Oracle Answers (OpAdHoc reporting tool)/BI Publisher functionality

● Develops System documentation, Technical Documentation, Mapping Documentation, Translation Documentation for the users.

● Worked in Agile and Waterfall methodologies.

● Participates in user acceptance testing and testing of new system functionality.

● Provides technical assistance in training, mentoring, coaching professional and technical staff.

● Develops training curriculum and conducts formal training sessions covering assigned systems

module.

● Involved in translating high-level business requirements into logical business dimensional

Model

● Coordinates with other teams for quality performance and resolving at critical stages.

● Performs general technical troubleshooting and give consultation to development teams

● Strong skills in writing technical and functional documents defined by the business requirements.

● Excellent Interpersonal and communication skills, efficient time management and organization

skills, ability to handle multiple tasks and work well in a team environment.

● Excellent logical and analytical skills to solve complex problems.

● Energetic and positive individual with strong interpersonal and communication skills and ability to work as both an individual and a team member in a dynamic environment.

Technical Skills:

Database

Oracle 9i/10g/11g/12c, MS SQL Server 2014/2016, MS-Access,DB2

Operating System

Windows XP/NT/2000, DOS, Windows Server 2003

Tools & Schedulers

SQL Developer, TOAD, Microsoft Visual Studio 2014/2016, Quality Center, Jira, SharePoint Server 2007

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools

SSRS, SSAS, OBIEE Oracle Answers, BI Publisher, Cognos

ETL Tools

Pentaho, OWB, ODI, SSIS (SQL Server Integration Services), SQL Server Management Studio, SQL Server Data Tools, Informatica

Education:

Master’s in Computer Science

University of Southern Mississippi (August 2005 –August 2007)

Bachelor of Engineering in Computer Science and Information Technology

JNTU University, India (2001 – 2005)

PROFESSIONAL EXPERIENCE

Sr. Software Consultant - HNFS, CA May 2018- Current

Health Net Federal Services, LLC(HNFS) is a global health care services company that has provided high quality, cost effective managed health care programs and behavioral health services to public sector employees and beneficiaries for 30 years. Through the Department of veterans Affairs Choice Program, HNFS has ensured over 1.5 million eligible veterans received timely health care in their communities.

●Currently working with HNFS on Veteran Affair project on healthcare Claims and Invoice data.

●Work closely with business users to congregate and comprehend requirements.

●Responsible for analyzing, auditing, and investigating claims data and delivering reports using SQL reporting services.

●Migrated data from heterogeneous sources like flat file, Excel Source and SQL server using SSIS.

●Extraction, Transformation and Loading (ETL) process by pulling large volume of data from

Various data sources using SSIS.

●Built SSIS packages for processing fact and dimension tables with complex transforms.

●Created SSIS packages for error handling.

●Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

●Developed Dimensions, Data Sources view, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage, partitions and aggregations.

●Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX queries which are used in the Reporting.

●Created, maintained and Scheduled various reports in SSRS like Ad-hoc reports, Canned reports, Master Reports and Parameterized Reports using SQL server reporting services SSRS.

●Perform data analysis across large and varied data sets that includes data from claims, providers, accounts payables and EDI files.

● Designed, developed and implemented claims operational and financial reports using MS SQL Server, SSIS, SSRS.

●Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle.

●Creating different chart reports helped in analyzing performance counters using SSRS.

Decision Support Analyst 3

Sutter Health, Sacramento, CA May 2017- Sep 2017

● Has working knowledge of healthcare data on claims and incidents, health organization structure, business operations as well as data infrastructure and data warehouse lifecycle and how to integrate them and data.

● Perform requirements Analysis which involves a review of existing legacy systems and operating methods as well as understanding business.

● Identified and clarified the client’ issues, design analytical approaches and reporting infrastructure

● Wrote SQL queries to extract and integrate data from large-scale database and across multiple data

sources.

● Ensure data integrity and validity by data cleansing and responding to inquiries from clients.

● Designed Datawarehouse and developed reports based on user experience and interface using SSIS. ● Provided reports summarizing report design, data quality, findings and advice for further study for

data-driven decision making based on understanding business

Hewlett Packard Enterprise

Strategic Offender Management System (SOMS), CA July 2009 – April 2017

Senior Data Engineer Responsibilities:

SOMS is the largest Offender Management System implemented in the nation, the state is now able to provide CDCR staff real-time offender data improving the safety of staff and inmates along with better care of inmates.

BI Responsibilities: June 2013 – April 2017

●Interacts with internal and external customers to define reporting needs and report specifications.

● Design reports that integrate data from multiple sources.

● Worked closely with data modelers, business data analysts, and BI developers to understand requirements, develop ETL processes, validate results, and deliver to production.

● Created Ad hoc reports as per business requirement.

● Experienced in gathering reporting and analysis requirements, documenting the report

specifications, implementing the metadata layers including Physical, Business Model and Mapping and Presentation layer.

● Experience in Business Intelligence implementations and understand aspects of an Implementation project

● Expertise in design and development of the three layers (Physical/Business Model and

Mapping/Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI

Administration Tool.

● Highly skilled at configuring OBIEE Metadata Objects including repository, variables, Interactive dashboards and reports.

●Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters and variables.

●Managed Application Administration includes Connections, Roles and permissions, Catalog groups, Sessions, Scheduler.

●Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

● Established connections to multiple databases in repository for Oracle, BI oracle warehouse and Essbase.

● Deployed OpAdHoc RPD's into multiple environments.

● Used Oracle Warehouse Builder ETL tool for extracting the data from the data sources, performing any necessary transformations on the data, and loading the data into the BI data warehouse.

● Built and designed KPIs, Alerts, and Data Mining Cubes in the project.

● Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

● Developed various Reports, Interactive Dashboards with drill-down capabilities, with various Charts and views, and tables using global and local Filters.

● Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

● Used OBIEE Web Catalog to set up groups, access privileges and query privileges. ● Developed templates and reports in Oracle BI Publisher in rtf format.

● Performed Data Masking using OEM to non-production environments for the purposes of Application development, testing, or data analysis.

● Acting as a mentor for Business partners in BI transition.

● Part of migration from oracle database to SQL server.

Data Conversion Responsibilities: June 2009 – May 2013

Worked on different modules of migrating data from different systems to SOMS. Migrated information of inmates on movement details, Bed assignments, transportation details, Demographic details, Address and Phones details, Visitors details, Victims information, Employees data and parole data using customized Pentaho data mover. Working on sending the data to the downstream partners from SOMS by creating scheduled job pulling the delta data by using/creating packages, procedures, triggers, delta tables, views, indexes.

● Working on ETL tool Pentaho Data Mover for Data Conversion.

● Performing data analysis and profiling using Pentaho Data Mover.

● Developing Oracle PL\SQL code to access and manipulate data on Oracle database. ● Write JavaScript functions to convert and clean data.

● Analyzed and improved the efficiency, scalability, and stability of data collection, extraction

and storage processes.

● Created ETL transformations using Pentaho data mover to pull legacy data and transform

data as per business requirement and load to the tables.

● Converted flat-file, Excel Sheet data extracts into Oracle DB and integrated data into multiple

source.

● Created various ETL jobs to run the multiple transformations on a single click to transfer the data into Database with minimal time.

● Did POC on ODI tool and used in conversion project.

● Generated Insert Delete and Update scripts to execute in other environments.

● Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA’s, BA’s and selected business users.

Avenir Associates, Piscataway, NJ Apr 2008– May 2009

Westwood Online University, Denver, CO

Cognos Report Developer

The scope of this project was complete enterprise reporting coverage. The project involved designing of Functional Requirement Specifications for report development, defining relationships between different Data base tables and building models using Framework Manager. Reporting included the development of flexible scorecards, dashboards their web publishing. Installation of Cognos 8.2 setting Cognos configuration and integrating different components were part of the project.

Responsibilities:

● Gathered business requirements and Report Specifications, which involved a lot of interaction with business users.

● Migrated Impromptu catalogs to Framework Manager Models.

● Responsible for creating packages which connect to different data sources, establishing relationships in model, and publishing packages to Report Net server.

● Created IQDs and used them as data sources.

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

● Maintained the packages and reports in development, test and production environments.

● Created Filters, Prompts, Calculations both at package level and report level.

● Created various reports using drill through, cascaded prompts, conditional formatting and master

detail relationship.

● Setup security both at package level, query subject level in Framework Manager, object level in the portal and at the cube level.

● Design, development and implementation of Impromptu Catalogs for various organizational cubes as well as detail drill-through reporting in Impromptu Web Reports (IWR).

● Developed interfaces for ad-hoc reporting using Cognos Query Studio.

● Used Cognos Connection for security, organizing, scheduling and distributing reports. ● Created Hot Files and Snap Shot in Impromptu.

● Created different types of Prompts, Calculated fields and Conditions.

● Was member of team to do a proof of concept on Cognos 8 BI

● Worked on migration of impromptu catalogs to Cognos 8.

● Compared Cognos 8 BI analysis tool to Cognos 7.3.

● Was responsible for configuration of Cognos 8 BI portal in test environment.

Environment: Cognos 8.2 BI, Cognos PowerPlay 7.3, Framework Manager, Cognos Impromptu, Impromptu Web Reports (IWR), SQL Server2000, MS Excel, MS Word, Visio, MS Outlook, Windows XP Professional.

Academic projects:

Banking System Project,

Department of Computer Science, USM

●Designed and developed a Database for a Banking System Project.

●Designed Normalized Tables, developed complete ER diagrams for the Banking System

●Developed various transaction forms like Deposits, Withdrawals, Transfers, Stop Payments, etc.

●Developed additional integrity constraints using Triggers, developed various reports. Technologies: Oracle 10g, Windows XP

Hotel Management Web Site

Department of Computer Science, USM

●Developed a Web based User Interface web site for an upcoming Hotel which keeps track of the check-ins, check-outs, Reservations/ Availability of rooms, booking of Banquets, etc..

●Performed User, Task and Functional Analysis, Designed Screen Sketches, Created Task Flows. Developed Prototype Design and carried out usability testing,

●Technologies: PHP, Dreamweaver 8, HTML, CSS, JavaScript, MySQL, Windows

●Teaching Assistant in Computer Science Department, University Of Southern Mississippi.

●Webmaster, Dept of MBA, University of Southern Mississippi.

Contact this candidate