About Me
9+ years of Progressive IT experience in Development/Support
Excellent knowledge and hands-on experience in Base SAS, Advanced SAS, SAS Enterprise guide, Data Integration.
Created reusable MACROS and extensively used exi…
9+ years of Progressive IT experience in Development/Support
Excellent knowledge and hands-on experience in Base SAS, Advanced SAS, SAS Enterprise guide, Data Integration.
Created reusable MACROS and extensively used existing macros and developed SAS Programs for Data Cleaning.
Experience in performing Ad Hoc Queries for various application and reports on a daily, weekly
and monthly basis using complex SQL Queries.
Excellent knowledge and work experience in data manipulation, data cleaning, sorting,
concatenating, interleaving, merging and combining SAS datasets using SAS/Base and SQL.
Experience in all phases of Software Development Life Cycle SDLC including Requirements,
Analysis/Design, Development, Implement, Validation, and Testing.
Extensive experience in DATA merging with the use of PROC SQL, Merge and SET statements.
Expert in using report generating procedures like PROC CONTENTS, PROC PRINT, PROC
REPORT, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY.
Excellent analytical & problem-solving skills. Highly motivated and productive.
Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
Experience on validation of reports and SAS programs Professional debugging.
Creating dashboard and generating insights on customer data using python
Experience
Sas Programmer
Performing ETL activities, connecting to RDBMS databases and generating SAS datasets.
Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel
Development and implementation of solutions to bank finance team regarding customer information and products.
Perform any post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs.
Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation.
Senior Consultant
<p>Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel<br>
Development and implementation of solutions to bank finance team regarding customer information and products<br>
Performed post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs<br>
Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation<br>
Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures<br>
Retrieved the original data and converted them into SAS readable format<br>
Made the SAS data sets and analyzed data as per given requirement<br>
Interactively met with the Actuarial teams for getting the required data to generate the reports as per business requirements<br>
Developed and analyzed key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL<br>
Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint<br>
Generated reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT and PROC GCHART<br>
Documented purpose and methods used in each SAS program</p>
SAS Developer/Data Engineer
<p>Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel<br>
Development and implementation of solutions to bank finance team regarding customer information and products<br>
Performed post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs<br>
Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation<br>
Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures<br>
Retrieved the original data and converted them into SAS readable format<br>
Made the SAS data sets and analyzed data as per given requirement<br>
Interactively met with the Actuarial teams for getting the required data to generate the reports as per business requirements<br>
Developed and analyzed key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL<br>
Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint<br>
Generated reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT and PROC GCHART<br>
Documented purpose and methods used in each SAS program</p>
Python Developer
<p>Accessed incident data and customer data on monthly, quarterly, and yearly basis to generate dashboard and insights as per requirement<br>
Created insights on the spending of credit cards transaction<br>
Enabled Google Maps API in the mobile app for suggestion regarding the transaction trend</p>
SAS Programmer Analyst
<p>Development and implementation of solutions to global technical service issues and concerns regarding EDC tools like Medidata RAVE, Oracle InForm and SAS programming<br>
Maintained a comprehensive data base for subject information<br>
Processed Machine and Program medical trails data<br>
Central scheduling of these data<br>
Kept an accurate database for each medical study</p>
Application Developer
<p>Maintained a comprehensive data base for Customer and Sales information<br>
Processed Machine and Program product orders<br>
Central scheduling of these orders<br>
Central control of returned machine<br>
Kept an accurate inventory of Products</p>
ETL Tester
<p>Understood the existing system and the flow of data<br>
Prepared specifications to create new Data model by coordinating with Data Architect and DBA<br>
Extensively involved in reviewing and analyzing the business and functional requirements<br>
Prepared High Level and Low-Level Design specifications<br>
Reviewed the ETL design, mapping documents, and provided suggestions<br>
Prepared the review checklist and test case templates<br>
Created test data, test scripts, performed testing and reviewed test results</p>