PROFESSIONAL SUMMARY:

• Associate with around 4 years and 2 months of IT Experience in Base SAS, SAS EG, SAS Macros, VBA, MS Excel, PIVOT tables and MS Access. Demonstrated ability to work actively in different phases of Software Development Life cycle (SDLC) and Agile Methodologies (Scrum). Responsible for converting the functional requirements into technical request, understanding the requirements for development, enhancements, and production support work.
• Certified BASE SAS Programmer with about 4 years & 2 months of experience in Financial Analysis.
• Experience in creating customizable reports using Base SAS, SAS/Macros, SAS/SQL, VBA macros, MS Excel, Complex Excel formulas, Excel Add ins, Pivot tables, MS Access.
• Experienced in automation of Excel reports using Visual Basic Application.
• Experienced in using VLookups/HLookups and complex statistical formulas in MS Excel.
• Possess excellent skills with PROC SQL, SAS Base procedures, and especially Data Step programming and reporting.
• Expert in using PROC IMPORT, PROC EXPORT, PROC FORMAT, PROC APPEND, DATA MERGE, SORT to generate Ad - hoc and customized reports.
• Good at creating, reviewing, retrieving, validating SAS Datasets and to read, write, import and export to another data file formats.
• Experience with SAS Enterprise Guide and SAS PC.
• Proficient in using Import and Export procedures to handle data in raw data files.
• Experience in preparing test cases and performing unit testing. Also, involved in Peer review, maintained defect logs, and coordinated discussions between offshore and onsite teams.
• Good at migration of SAS jobs from Mainframe to SAS programs in Enterprise Guide.
• Possess Knowledge in UNIX basics.
• Experienced in monitoring of scheduled jobs in Control-M and creating customized reports using SAS web report studio.
• Comprehensive understanding of software development life cycle including requirements gathering, design, development, testing, and maintenance.
• Reviewing business requirements and design specifications to identify gaps and ensure documented business requirements are clear, consistent, and testable.
• Involved in system testing of SAS and VBA applications identifying test scenarios, testcases and identifying bugs.
• Actively involved in all phases of SDLC of project and agile methodologies.
• Knowledge in Risk Ranking and Assessment of UDA’s (User Defined Applications).
• Knowledge in AWS cloud practitioner concepts.
• Highly motivated, Organized Team player with excellent analytical, communication and leadership skills.

TECHNICAL SKILLS:

Programming Languages: VBA, MS Excel, SAS / Base, SAS / SQL, SAS / MACROSUNIX basics, SQL, AWS cloud practitioner concepts.

Tools: SAS Enterprise Guide 4.3, PC SAS, SAS Web Report Studio,Star Team, SQL Developer

Databases: Oracle, SQL

Other: Control-M.

Domain: Insurance

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Project included development, execution and enhancement of reports using SAS, SAS/SQL, and SAS MACRO, VBA, MS Excel, Pivot tables, MS Access.
• Developed, maintained, and supported existing VBA applications using VBA macros, vlookups/hlookups, creating and modifying pivot tables and creating data tables & charts and data manipulation using complex formulas.
• Project included several optimization activities using SAS and VBA macros.
• Extensively used the SET, UPDATE, and MERGE statements in SAS for creating, updating, and merging various SAS data sets, along with APPEND procedure.
• Extensively used Dataset manipulations and various SAS procedures PROC SORT, PROC FREQ, PROC SQL, PROC PRINT, PROC REPORT and various summary functions.
• Automated and optimized several manual jobs and long running programs using SAS and VBA macros.
• Focused and prepared user-friendly program documentation.
• Involved in Requirements gathering, Analyzing the specifications, and performed design, Coding and Unit testing of the SAS and VBA modules.
• Developed and modified SAS macros and extensively used on coding programs.
• Migrated SAS jobs from Mainframe to SAS Enterprise Guide and migrated long running MS Access queries to SAS.
• Re-engineered Access SQL queries using PROC SQL.
• Lead the Risk Assessment team for accessing the risks involved in the existing UDA framework.
• Managed the movement of Production SAS codes using StarTeam tool.
• Job monitoring using Control-M.
• Involved in execution of SAS jobs in Unix environment.
• Developed customized reports using SAS web report studio.
• Extensively used Excel formulas like SUM, COUNT, RIGHT, LEFT, MID, AVERAGE, IF Functions, VLOOKUP, HLOOKUP, TRIM, CONCATENATE to compute values for reporting.
• Also, used Excel advanced functions like GETPIVOTDATA, DATE&TIME, functions using LOGICAL OPERATORS, TEXT FUNCTIONS, ARRAY Formulas.
• Extensively used various worksheet functions to populate data across workbooks and excel sheets.
• Gathered Business requirements and developed VBA macros and presented reports using Graphical, Chart representations.
• Created weekly, monthly, Annually, and ad hoc reports by pulling data from databases and used Excel to create dashboards in chart, graphical representations.
• Used Excel ADD-INS to extract data from various external data sources.
• Automated and streamlined manually created reports with VBA, Macros and MS Access and other automated processes.
• Automated reports by integrating MS Access, Excel using VBA macros.
• Created user interface using Forms, Buttons and developed executable macros on button click.
• Streamlined and automated monthly reporting metrics for management team by pulling data from an MS Access database with advanced query functions, SQL functions and MS Access VBA coding that extracted millions of rows of data from the database with the click of a button. Integrated this Database records with Excel using ADD -INS, advanced functions and formulas and presented in the form of charts, graphs, pivot tables. To create report and update this report monthly with the click of a button.
• Conducted many knowledge sharing sessions on SAS & VBA.
• Involved in Unit / Delivery testing and actively managed & communicated the test status to onsite and offshore leads.

Confidential .

FIRS REENGINEER

Responsibilities:

• Project included automation of manual execution of excel reports using VBA user defined macros, EXCEL formulas like COUNT, SUM, SUMIF, COUNTIF, RANGE, Statistical functions, Pivot table functions, Text functions like TRIM, MID, LEFT, RIGHT, LOOKUP functions.
• Also, developed and used field mapping technique, macros to populate data values across various workbooks, worksheets on a single click of a button.
• Developed VBA macros to extract data from various databases and computed values using formulas and created dashboards.
• Also, included optimization of VBA codes to reduce the manual execution of reports.
• Maintenance of reports by solving the infra and making necessary code changes timely.
• Experience at Batch support of applications on Unix console in Campaign analytics area.
• Worked on Base SAS, SAS Enterprise guide, Office Applications.
• Developed SAS macros and used various SAS procedures, Data step manipulations.
• Controlled the Disk space issues by implementing the email alerts &zipping methods.
• Documented all code related issues during different phases of project.
• Worked on implementation of enhancement requests.