PRADEEP

Email ID- admzir@r.postjobfree.com

Phone # 814-***-****

SUMMARY

Professional with robust work experience in Data Analysis, Data Cleaning, Data Examining, Data Aggregation, Data Mining, Trend Analysis, Descriptive Statistics, Inferential Statistics, Predictive Modeling, Model Validation, Dashboard, Application Development, Report Creation in Service/Healthcare/Financial/Insurance sectors. Streamlined Several Processes. Expert in automating SAS, Python and other technology jobs. An Automation Freak - will try to eliminate manual work by implementing automation in every phase. Experience included clear understanding and participation in all phases of SDLC, documenting, communicating with the business, working with Large Datasets, Writing Macros, Preparing Reports and Data Mapping. Experienced in Base SAS, Enterprise Guide, Statistical Procedures, SAS and other tools for effective Business Decision Making. Basically, a Data Savvy and can perform any task under tight deadlines with utmost quality. Always has the Thirst and Urge to Learn New things and optimize the process.

Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs

Experience in ETL processing on various data sources like Oracle, SQL server, MS Excel, Teradata, MS Access, DB2 and text files using PROC IMPORT, LIBNAME and SQL PASSTHRU facility.

Extensive experience in using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/GRAPH, SAS/SQL, Excel and SAS/ODS (RTF, PDF, EXCEL, XML) procedures.

Experience in SAS Report Generating Procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE, PROC PRINT.

Experience writing Advance SQL programs for joining multiple tables, sorting data, creating SQL views and creating indexes. Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries and Generated Detailed level reports

Expertise in various Advance MACRO debugging options such as MPRINT, SYMBOLGEN, MLOGIC to Debug store process and SAS code.

Experience in Developing, Testing, Debugging and Automating using Python

Experience in ETL- Extraction/Transformation/Loading, data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation

Expert in Python, SQL, SAS Visual Analytics capabilities that include statistical analysis, forecasting, modeling & mining

Skilled in analytical and business reporting using SAS, Python, VBA and RDBMS technologies

Experience in job scheduling and load balancing using SAS Grid and LSF

Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse

Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers (FTP) to external vendors

Involved in projects having to deal with cross functional teams and multiple stakeholders

Minimum time to self-sufficiency in any environment

Excellent communication and report writing skills, presentation with the ability to effectively communicate results of analytics to diverse audience

TECHNICAL SKILLS

SAS Tools

SAS 9.4, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY PORTAL SAS/CLOUD

Databases

Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 11/12, DB2, MS Access, Informix

GUI Tools

MS Office, MS Project, MS Visio, Tableau

Commercial Tools

Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion, ERwin, Roscoe, RCS, OnBase, UltraEdit

Operating System

WINDOWS XP/NT/Vista, UNIX(AIX), MVS, z/OS

Programming Languages

Python, R, C, C++, SQL, VBA, VB 6.0, Java, HTML, XML, Bourne Shell

Reporting tools

Crystal Report, Hyperion, MS SQL Server Reporting Services

WORK EXPERIENCE

Client: United States Census Bureau, Suitland, MD Apr 2018 – Present

Employer: Harmonia Holding Group LLC, VA Nov 2018 – Present

Employer: Sriven Infosys Inc., Flushing, NY, USA Apr 2018 – Oct 2018

Role: SAS Application Specialist, Developer, Analyst

I am part of the PEARSIS project in the Decennial Information Technology Division of the US Census Bureau. This project deals with Billions of Administrative Records numerous federal agencies like Internal Revenue Service (IRS), Center for Medicaid & Medicare Services (CMS), United States Postal Services (USPS), State Benefit programs Etc. The scope of the project is to developing/modifying software that processes the administrative records data and delivering it to the other divisions within the bureau for Decennial and reporting purposes.

Responsibilities:

Developing/Modifying/Enhancing SAS and Shell Scripting in Unix platform

Developing/Modifying/Enhancing the DATA received from Federal Agencies and outputting them into encrypted/unencrypted - Datasets/Reports/XML/CSV as per the requirement

Architecting and Automating the END – END software testing process which involves running all the modules in the project

Implementing data sampling process which involves in Intelligent sampling (not just the random sampling) of 100% data from production and transferring a percentage of it to lower environments (DEV/TEST). It also fixed space issues and effective management of data

Automating the software wherever there is the scope of Automation

Meeting different Branches & Divisions within the Census Bureau and other Agencies for requirements

Developing the SAS Common Macro Repository which is to be used by all the SAS programs using –config

Acquired SAS Data Flux knowledge exclusively and quickly for this project to standardize all the addresses related to administrative records using USPS - CASS package system. Successfully created a separate module specifically for Data Flux process

Assisting government in software development to Match Administrative Records to Census data

Responsible for quick debugging, resolving and redeploying Production issues

Attending other meeting outside of the project for enhancing the skillset like trainings, workshops etc...

Properly adhering the Title 13 (comingled data) and Title 26 (IRS Data) regulations with the bureau

Liaison between other Divisions and our team

Worked effectively under tight deadlines, priority changes

Worked closely with SAS Teams in installation and setting up the environment of SAS/Data Flux

Testing the Software rigorously in DEV/TEST environments before deploying it onto the PRODUCTION

Training/Mentoring on boarding team mates to catch up the speed

Gained good knowledge dealing with Administrative Records

Documenting the entire process from requirements gathering till deploying onto production as part of the release notes and creating Flowcharts in MS VISIO for visual representation of the software

Software Demonstration at the end of the work period for any training/updates/suggestions and improvements

Environment: SAS EG, BASE SAS, Data Flux, SQL, UNIX Shell Script, VDI, SVN and Ultra Edit, MS Visio.

Employer: Sriven Infosys Inc., Flushing, NY, USA Oct 2015 – Oct 2018

Client: Caresource

Role: SAS Application Specialist, Developer, Analyst

Care Source is a nonprofit health managed health care company headquartered in Dayton, Ohio. It is the largest Medicaid plan in Ohio and second largest in the US. I have been working in Business Intelligence department, Regulatory/Compliance Team dealing with Regulatory Reporting to State of Kentucky. I streamlined the process by optimizing code in terms of standards and efficiency and automated in such a way that the reports ran without any human effort, also report approval process for which have gained good recognition in the organization.

Responsibilities:

Experience in performing and managing Ad Hoc queries in production environment to validate data, identify data quality issues, and work on different technology to address them

Analyze and interpret data reports, draw conclusions and make recommendations answering specific business needs for various internal and external reports using complex queries and generated various summary and detailed levels of Regulatory/Audit Reports for the State of Kentucky, Ohio, Georgia & Indiana and CMS (Center for Medicare & Medicaid Services).

Have good exposure on Analytics involved in qualitative and quantitative problem solving skills and also build models using predictive analytics and statistical analysis

Responsible for all the Regulatory Reports to the State Health Department where every report had a high chance of getting cap or fine if found any discrepancy

Planned, initiated and executed the Automation of several SAS projects by using SQL, Base SAS, SAS DI Studio Unix Script, VBA, Cisco Enterprise Scheduler which will drop the reports in the designated location at the scheduled date and time without any human effort

Responsible for maintaining large & complex SAS datasets in Analytical Dataview (ADV) which are extensively utilized for reporting and analytical purposes by various departments across the company

Have worked on State Audits and Federal Audits under strict deadlines and short notices with utmost quality

Experience writing Advance SQL programs for joining multiple tables, sorting data, creating SQL views and creating indexes

Implemented many Research Forecasting Models into production using Enterprise Miner

Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy

Extensively involved in mainframe SAS for analyzing very large datasets

Converted SAS Programs to SAS Stored Processes using dynamic prompts and produced packaging and streaming outputs as required and also created Stored Procedures and views

Worked in Decision Support Informatics (DSI) and HealthCare Effectiveness and Data Information (HEDIS), Center For Analytics (CFA) teams for Technical and Analytical inputs

Tested and verified in multiple environments before going into Production

Worked on Facets, Care Advance & Teradata by gaining good knowledge on healthcare data (Hospital, lab and physician) including Medicare and Medicaid Health care industry data (Claims, Provider, Members, Pharmacy, HEDIS, care and med management etc.,)

Extensive knowledge about HIPPA guidelines, PHI, EDI standards, State File structures (834, 837) claim processing methodology and payment and check write methods

To provide analysis of healthcare on claims/member/providers and prepare analytics that will provide insight into trends, time series analysis and forecasting

Effectively used SAS Visual Analytics and TABLEAU for visualization and presented to executives of the company using SAS CLOUD

Utilized Visual Analytics to help the executives in Decision Support System(DSS)

Successfully converted projects from one platform to another (SAS to SSRS, SQL, Power query etc. and vice-versa) as per the requirement, usage of the business owners

Liaison between CMS and our team, advance analytics team and other stake holders

Worked on ICD 9 and ICD 10 upgrading process

Created complex reusable Macros in all the reports to improve ease and as well as consistency of results

Initiated to use VB Scripts to generate custom reports from data in SAS tables

Wrote Teradata code / SQL to enable the ETL processes to meet demanding business requirements

Developed SAS/MACRO to concise code for data cleaning and reporting and also to standardize the report and chart generation for re-use with PROC TABULATE, PROC REPORT, PROC APPEND PROC GPLOT, and PROC GCHART etc.

Worked effectively under tight deadlines, priority changes for regulatory and audits purposes

Improved code by reducing the run time to minutes from several hours

Developing dashboards using TABLEAU & POWERBI and published them on Tableau server that allows users to understand the data with usage of quick filters for on demand healthcare information

Participated in refinement and technical documentation of database reporting requirements

Planned and executed to build a separate DATA MART for Vendor Data/Partner Data in EDW

Using VMWare wherever needed to optimize my performance

Supporting and maintaining Reference Files

Used ONBASE for getting Approvals on the reports efficiently

Responsible for quick debugging and resolving Production issues, break-fix issues and tickets raised by users based on-call rotation

Also worked as a Data Analyst for efficient development

Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.

Performed code-reviews and Peer-reviews to juniors and created edit checks to verify the accuracy of data

Environment: SAS EG, BASE SAS, SQL, UNIX Shell Script, Visual Basics, Teradata, SAS Visual Analytics, and Cisco Enterprise scheduler, VMWARE, ONBASE, SVN and Ultra Edit, Tableau, PowerBI.

Employer: Randstad India Pvt. Ltd, Hyderabad, India Jan 2010 – Jan 2014

Project-1:

Credit Acceptance is an indirect auto finance company, working with car dealers nationwide to enable them to sell cars to consumers on credit regardless of their credit history. The project assists Dealer Support group.

Responsibilities:

Developed complex programming to extract and manipulate data

Created reports that provide the insightful analysis to business to optimize the high volume decisions

Used Proc SQL Libname and PROC SQL Pass-through methods to access data on Oracle database

Validate and test all code for accuracy and efficiency and moved it into Production

Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets

Conducted Ad Hoc analysis to support business strategy

Developed SAS programs based on the draft spec document

Delivered reports via portal using BI tools like SAS Enterprise Guide and Stored Process Web Application

Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results

Wrote different joins and merges to create reports based upon the requirements given

Written time and resource efficient code using PROC SQL

Analyzed the transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, 5.1 and SAS Add-in for Microsoft Office

Environment: SAS 9.2/9.3, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.3/5.1, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2, Windows.

Project 2:

Part of the audit team of Global Wealth Management (GWM). Involved in auditing various business processes related to securities’ trading, application performance, process controls etc as part of internal or regulatory requirement. Understanding the business justification of the audit, getting the requirements from the clients and stakeholders, interacting with the SMEs and the IT team, presenting the findings, improving upon the results and documenting the entire audit process are the main tasks performed. Teradata and SAS are the prime tools used.

Responsibilities:

Strongly served the data requests of varied nature pertaining to operational risk, management risk, policy enforcements, regulatory oversight, Investor portfolio management, P&L reporting to name a few

Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.

Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy

Using JCL’s for accessing data from mainframes

Automated the creation of Excel pivot tables from SAS data sets using SAS/Macro and VBA

Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel

Developed SAS stored procedures and views to provide BI analysis and insights

Involved in developing and maintaining documentation of operational processes and data mappings

Used Excel templates and VBA to generate custom reports from data in SAS tables

Extensively involved in mainframe SAS for analyzing very large datasets

Created SAS programs using the COBOL copybook layouts

Involved in creating SAS datasets out of the live VSAM datasets

Prepared several regulatory reports in standard formats as specified using SAS

Involved in fine tuning the code to reduce the churn time and improve the efficiency

Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files

Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs

Involved in creation of flat files out of database tables

Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage

Extensively used SAS/DDE to generate formatted Excel sheets maintaining data integrity from SAS output data sets

Exported large SAS data sets (more than 300 variables) to MVS external files to be sent to external vendors using SAS and SAS/Macro

Hands on experience in moving SAS data sets from Unix to PC environments using FTP

Used SQL Passthru method to load the manipulated data from DB2 tables into SAS data sets

Developed an application using Base SAS, SAS/Macro, Proc SQL and Proc Contents to generate concise data profiling reports

Environment: SAS 9, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ETL, TSO, MVS, VSAM, DB2, Teradata, SAS/ENTERPRISE GUIDE, ISPF, VBA

Project 3:

Developed and maintained Insurance risk score SAS application and Disclosure application. The main purpose of this application was to disclose the documents to insured and notifying them automatically via emails whenever there are any changes to their documents or whenever they are posted on the web. Also worked on Data mining, reporting, and application development (Windows) utilizing Microsoft Access, VBA, and SQL with emphasis in Fraud Prevention

Responsibilities:

Developed programs using the Libname statement & SAS Views to extract & report error statistics

Developed the Spectrum Business Credit Score application. Calculated the coefficient factor using selected Experian Credit data elements to derive the business risk score.

Updated business specifications, created system flow charts and prepared test plans.

Used Microsoft Access and Excel to provide output analysis data

Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information

Implemented research forecasting models into production by using Base SAS, SAS Macros, PROC SQL and many other SAS tools

Assisted architecture team in moving layers of the EDW from Oracle to Teradata for using SAS In Database technology

Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL

Performed the automated data driven testing using WinRunner

Performed functional, GUI, and Security testing using different checkpoints with the WinRunner scripts

Responded to ad hoc data requests from internal auditors and consumers

Analyzed requests generated data files using SAS and SQLPLUS etc

Performed back-end testing to verify the flow of data from the database to the front end

Used SAS Macros to produce drill down capability for the reports

Performed detail analytics while producing financial reports so that the financial data is checked and are accurate

Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets

Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, TOAD, UNIX, MS SQL Server, SQLPLUS, Java and ULTRA Edits

CERTIFICATION

Certified Entry-Level Python Programmer (PCEP-30-01)

EDUCATION

Master of Science in Information Systems (CMICH), Mount Pleasant, Michigan, USA 2014-2015

Master of Business Administration (Osmania University), Hyderabad, Andhra Pradesh, India 2007-2009

Bachelors of Computers & Commerce (Osmania University), Hyderabad, Andhra Pradesh, India 2004-2007

Contact this candidate