SHOBHA YERUVA

E-mail: ad06oc@r.postjobfree.com

PH: 248-***-****

Professional Summary

I have more than 13 years’ experience as a Reports Analyst/Developer/Business Data Analyst. I have developed data source SQL queries for Oracle and SQL Server databases for data analysis, report development. I also have done data analysis, design, manual testing. I have developed test cases, and validated requirements and reports for correct data and execution performance of reports. I can work independently or in a team environment and I also have very good verbal and written communication skills.

Technical Skills

Databases: Oracle 10g, SQL Server 2008, MS Access, SQL Server 2008R2

Languages: SQL, PL/SQL, T-SQL

Software: MS Office Suite (Word, Excel, PowerPoint), SQL Server Integration Services R2 (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL*Plus, SQL*Loader, Cognos Report Studio, Cognos Analysis Studio, Cognos Metric Studio, Cognos Query Studio, Cognos BI, Crystal Reports, TOAD, Visual Studio, Oracle Forms Builder, Oracle Report Writer, PL/SQL Developer, OLAP, Visual Studio 2012, HTML

OS: Windows, UNIX

Methods: Software Development Life Cycle (SDLC)

Professional Experience

Consultant

Configuration Business analyst, Ally Financial, Detroit

April 2016 – Current

• Writing, executing, and Maintaining test cases and test suites for regression, functional and acceptance testing for Data Migration.

• Excellent Understanding and Expertise in writing SQL for analysis for the Data Migration projects.

• Creation of Bugs and Stories using Jira.

• Used Jira for tracking test cases, Stories, tasks, and test effort.

• Worked on CARS (Various Screens like AI, BRII, PDI, PDCLI, WDS and so on) mainframe to get the Dealer information for the analysis for both Retail and Commercial projects.

• Worked in Power BI to getting Data for Data Migration for easy validation.

• Involved in Retail and Commercial Data Migration.

• Involved in creation of Service now request for Database access to coworkers.

• Researching on Reconciliation Failures between source and Target then raising defects and assigning to application support team.

• Writing Test cases and execution of Test cases

• Providing technical support during deployment.

Consultant

SQL Developer, Health Alliance Plan, Southfield July 2014 – November 2015

• Develop and maintain Crystal Reports for CCMS and Care Radius systems.

• Deploy to the MCT Report Viewer application and to the Crystal server.

• Resolve errors of existing reports.

• Provide report access to the users using MCT Report Viewer and Crystal server.

• Support Case/Disease Management system (CCMS).

• Resolve data entry issue of the CCMS.

• Generate ad-hoc reports using SQL/PL-SQL.

• Generate and update existing UNIX shell scripts and SQL scripts.

• Create Oracle tables, views and stored procedures.

• Convert CCMS reports into Care Radius reports and Convert SQL scripts into Crystal reports.

• Create design document (with business and technical details) of reports.

• Generate change request using Service-Now.

• Promote reports and scripts to the production using Harvest CA-SCM workbench.

• Help other team members to resolve the issue related to Oracle, Crystal Report, Harvest and SQL Server.

• Data is moved from Dev to Test to Prod using Care Radius.

Consultant

Reports Developer at Flexible Plan Investments Jun 13 – Mar 14

• Designed a database with over 1000 tables to manage over 45,000 investors across 60,000 accounts with assets under management of over 2 billion dollars. Data marts consisted of Firms, Agents, Assets, Trading, Custodians, Strategies, and Products.

• The project goal is reduce the number of tables with valid data.

• I am member of Migration project moving tables from old system to new system in SQL server.

• I did work on writing store procedures scripts to load data to new system.

• I worked on store procedure converting crystal reports to SQL server reports.

• These tables are used to load data into FPI application using .Net framework.

• I worked loading data tables like fSalesManager,fSalesManagerBonus,

fSalesManagerBonusDetail, fAcctStrategyDailySummary,

fnvoiceBatch, fInvoicePrintControl, fInvoiceSummaryHeader, fAgentAdvancedPayment,

Charity, fchurch, fChurchWork and fFeeLiq tables so on.

• I converted all most 30 reports from crystal report to SSRS reports.

• Created drill-down, drill-through, sub and linked reports using SSRS 2012

• Generated multi-parameterized reports in SSRS 2008 allowing users the ability to make selections before executing reports to provide customized report output.

• Used cascaded parameters to generate a report from two different data sets.

•

Hewlett-Packard Jan 12 – Jun 13

• Reports Developer at County of San Diego

• Developed highly customized SSRS reports for the county of San Diego for the Department of Environmental Health, and the planning and development services

• Developed reports for the finance department business users.

• Analyzed report requirements.

• Identified data source details.

• Built data source views.

• Validated data source views using SQL queries

• Developed SQL queries using SQL Developer for data retrieval requirements of report templates.

• Defined the datasets for report generation which included report parameters.

• Generated reports using Global Variables, Expressions and Functions for the reports.

• Created, implemented and maintained over 25 standard reports while also customizing many reports to meet individual client needs.

• Created drill-down, drill-through, sub and linked reports using SSRS 2008

• Generated multi-parameterized reports in SSRS 2008 allowing users the ability to make selections before executing reports to provide customized report output

• Used cascaded parameters to generate a report from two different data sets.

• Performed Query Optimization by restructuring SQL for performance tuning of reports execution.

• Applied conditional formatting in SSRS to highlight key areas in the report data.

Consultant May 11 – Nov 11

Data Analyst at United Way

• I am member of Migration project of the application transition team moving data from a legacy application into a new CRM application.

• Worked with SSIS

• Created Stored Procedures.

• Mapped data between legacy and new CRM applications for data uploads.

• Worked with other project teams to integrate numerous Excel sheets into the data structure of the new CRM application.

• Configured organizational accounts.

• Configured Individual accounts.

• Developed CRM Data Import Templates

• Configured Advance Finds

• Analyzed source system tables for organization data.

• Developed SQL for organization data extract from legacy source system.

• Developed Stored Procedures for organizational and account data load to staging tables.

Consultant May 07 – Jul 09

Reporting Analyst at OnStar

• Responsible for generating various reports and supporting data processing requests of executives and business analysts.

• Developed ad hoc queries, extracted data from operational data sources and data warehouse databases.

Flash Reports

• Designed Flash Reports to capture system performance data points of OnStar Web Delivery Records (WDR) and Customer Delivery Records Systems, which was a business-critical report distributed to OnStar SOG Executive Team for daily business review each morning

• Entered data into spreadsheet form from various reports.

• Ran the appropriate macros to generate summaries and analytics.

• Sent the report to business executive team within the organization for decision support activities.

• Manually compiled reports by running various SQL queries and macros.

• Checked data and used analytical functions.

• Generated this report manually.

• Prepared for Business Executives Meeting with wireless vendor, Verizon Communications, for smooth running of OnStar subscriber services and to resolve day-to-day issues.

Pending Activation Queue (PAQ) Report

• Utilized report to keep a daily track of all pending cellular activity (any waiting cellular transaction that has not yet been returned)

• Generated report using PAQ Access database.

• Uploaded files from Verizon inv502 to hold and research data files.

• Ran ad hoc queries to validate ESN for PAQ Reporting

• Generated and sent to Verizon for automatic resolution of activation requests.

Cognos Reports

• Developed and scheduled the reports for daily delivery to email accounts utilizing Cognos Report Studio, Analysis Studio, Metric Studio and Query Studio

• Created ad hoc reports and SQL queries.

• Analyzed data.

• Created ad hoc SQL queries to extract data from Oracle 8i/9i databases.

• Advised DBA’s by suggesting improvements to SQL performance through the addition of indexes, views and tables.

• Delivered 7-10 high-volume SQL extracts/counts each week to business users.

• Used ad hoc SQL, migrated to Cognos, and scheduled to send data in report format to business users, as requested.

• Analyzed, collected, stored, and created electronic data.

• Responsible for testing data in information systems to make sure that the data was not corrupt or inaccurate.

• Compiled data in reports and sent to upper management or presented at board meetings in order to aid in decision making.

Education

Andhra University, India

Bachelors’ Degree in Science

Certifications and training

Certified Pharmacy Technician

Oracle Application Development

Software Quality Assurance

Cognos BI

Contact this candidate