Data Analyst

Sudhakara Reddy Bobbity

Data Analyst/SAS Analyst/Programmer Analyst/Data and Integration Engineer/Sr.QA Analyst

Cell: 804-***-****

Email: *********@*****.**.**

QUALIFICATIONS:

Over 8+ Years of experience in Information Technology as Data Analyst/SAS Reporting Analyst/Programmer Analyst/Data and Integration Engineer/QA Analyst using Teradata, SAS, Oracle and SQL Server RDBMS.

Experience in MS Excel, PowerPoint and Other MS Office Suite

Experience in running PL/SQL, UNIX, Informatica Workflows and SAS scripts and troubleshooting issues

Experience in data loading from one database to another database

Experience in On Call rotation for Production Support

Experience in running scripts in SAS and generating reports by using Pivot tables

Experience in Writing BASE SAS Programs for converting Teradata table into Flat files (CSV, Fixed Format, delimited etc.)

Experience in Data Management and Data Validation

Experience in preparing Business reports using Teradata SQL, and Power Points

Experience in Data Validation and Verification and documenting the results for QA Testing.

Experience in all kind of Documentation

Generated weekly, monthly and quarterly reports and presentation using MS Excel and MS Power Point.

Experience in Banking and Credit Card industry business processes.

Good Experience in scripts conversion from Oracle to Teradata.

Quick learner and excellent team player with good communication and presentation skills

TECHNICAL SKILLS:

RDBMS : Oracle, SQL Server, Teradata, MS Access

Tools : Toad, SQL Server UNIX, Selenium, Informatica Power Center,

Teradata SQL Assistant, SQL*Plus

Languages: : SQL, PL/SQL, UNIX Shell scripting, BASE SAS.

GUI : MS Office Suite, Ultra Edit

OS : Windows XP, HP-UNIX, Linux

EDUCATION:

Master’s in Science from SV University, India

Diploma in Information Systems from Strayer University

Bachelor’s in Information Systems from Strayer University (in Progress)

CERTIFICATIONS

Certification in Oracle Database Management

PROFESSIONAL EXPERIENCE:

Magellan Health Services, Glen Allen, VA

Senior System Quality Assurance Analyst April, 2018 – Feb, 2019

Magellan Health Services provides Medicare and Medicaid claims, other insurance claims and other various products to Consumers.

Responsible to run test scripts when new patch to the oracle application is deployed.

Responsible to run Informatica workflows when new patch to the oracle application is deployed

Responsible to trouble shoot the job failures and rerun the jobs

Responsible to share the test reports to concerned Team

Responsible to run the UNIX scripts to load the data and trouble shoot the job failures.

Responsible for loading data regarding Drug Price, patient enrollment, service provider information.

Responsible to work on adhoc requests regarding drugprice, claims, Physician details and service provider details.

Responsible to document test results and share with concerned team

Environment: Toad. SAS, SQL Server, MS Excel, MS Office, HP-Unix..

Magellan Health Services, Glen Allen, VA

Programmer Analyst/ Data and Integration Engineer Aug, 2012 – April, 2018

Magellan Health Services provides Medicare and Medicaid claims, other insurance claims and other various products to Consumers.

Responsible for Weekly On Call rotation for Production Support

Responsible to document issues came across during on call and document, share with Team

Responsible to document for oracle patch load testing process

Responsible to run test scripts when new patch to the oracle application is deployed.

Responsible to trouble shoot the job failures and rerun the jobs

Responsible to share the test reports to concerned Team

Responsible to run the UNIX scripts to load the data and trouble shoot the job failures.

Responsible to make sure all the FDB loads are completed successfully.

Responsible for running scripts in SAS to load the data daily from oracle Database to SQL server database for 17 clients.

Responsible to load FastMac Baseline Prices into SQL Server Database.

Responsible to make sure the UAC data is loaded into SQL Server Database.

Responsible to make sure the FMT data is loaded into Oracle Database.

Responsible to make sure the FastMac data is loaded into SQL Server Database.

Responsible for Data Management by making sure whether Data is loaded in the First Decision Database.

Responsible for loading data regarding Drug Price, patient enrollment, service provider information.

Responsible to work on adhoc requests regarding drugprices, claims, Physician details and service provider details and document them

Enveironmnt: Toad. SAS, SQL Server, MS Excel, MS Office, HP-Unix..

Capital One Financials, Richmond, VA Oct, 2011 – Aug, 2012

Data Analyst

Capital One provides Deposits, Credit Cards, Small Business, Auto Finance and other various products to Consumers and Business clients. Capital One also provides mortgage banking services.

Responsible for running scripts in SAS Enterprise Guide and generate Daily, Weekly and Monthly reports (Bank Ops Dashboards) and publish in KL

Responsible for Data Management by making sure whether Data is loaded in the BDW before running reports by running Teradata SQL scripts

Responsible to contact the BDW Support Team if the data is not updated for the status

Responsible to Import cash files from BDW to ‘G’ Drive by running Recon Plus Macro

Responsible to Transfer required files to SASdome from ‘G’ Drive before running SAS Scripts.

Responsible to Import data from SAS dome and BDW before running SAS Process

Responsible for Data Validation, after generating reports making sure the correct data is pulled or not, before publishing the reports in the KL

Responsible for generating reports by using Pivot tables

Responsible for Gathering, Analyzing Business requirements and developing reports by creating SQL Scripts, Excel to provide Business solutions.

Involved in Business Meetings for Requirement gathering and analyzing.

Worked with BA to provide Business Performance Data using Teradata, SQL.

Created Volatile Tables to get the Data from Multiple Tables.

Created Multi set Tables by using Volatile Tables.

Extracted data from existing data source and performed ad-hoc queries by using SQL.

Extensively used INNER and OUTER Joins while extracting data from Multiple Tables.

Improved Performance of the SQL Queries by Creating Primary Index and Collecting Statistics on Index Columns.

Developed Ad-hoc reports as per Business Analyst, and Project Manager Data request.

Provided data to Business analyst in graphical format by using MS Excel

Environment: Teradata, SQL, MS Excel, MS Office, SAS Enterprise Guide, HP-Unix..

Bank of America, Charlotte, NC Jul, 2011 – Oct, 2011

Data Analyst

BOA provides Credit Cards, Small Business, Auto Finance and other various products to Consumers and Business clients. BOA also provides Commercial Banking Business include Equipment Finance, Community development and Business credits.

Worked with Business Analysts to Provide Business Performance Data and other data using Teradata, Oracle, and SQL.

Responsible for Gathering, Analyzing Business requirements and developing reports by creating SQL Scripts, PIVOT Tables in Excel and Power Point presentations to provide Business solutions.

Created Daily, Weekly, Monthly and Quarterly reports related to financial departments using Teradata, MS Excel, and UNIX.

Wrote BTEQ SQL scripts for large data pulls and ad hoc reports for analysis.

Created numerous tables like Set, Multi set, Derived, Volatile, Global Temporary tables, Macros and Views using Teradata SQL.

Extensively used INNER and OUTER Joins while extracting data from Multiple Tables.

Used Explain Plan Statement in Teradata before Querying Large tables with Millions of records and with several joins.

Performed data analysis to look at credit exposures, risk profiles and trends of various business programs.

Used various Date, String and OLAP Functions like RANK, ROW_NUMBER, POSITION, CHARACTERS and SUBSTRING.

Improved Performance of the SQL Queries by Creating Primary Index and Collecting Statistics on Index Columns.

Extensively worked on Unix Shell Scripts for automating the SQL scripts, checking daily logs and emails with status updates.

Automated Excel Sheets to refresh the data directly from Teradata tables using ODBC connection.

Created BASE SAS programs to load data from Excel, CSV, TAB and other delimiter Text Files into Teradata Tables.

Environment: Teradata, SQL, BTEQ, Oracle 9i, Windows XP, Business Objects, PowerPoint, Excel.

Contact this candidate