SUMMARY

• SAS Programmer with around 8+ years of experience in software development, design, analysis, coding, implementation as a SAS Programmer/Analyst
• Experienced in financial, healthcare and insurance industries.
• Experience in developing different methods of extraction, transformation and loading (ETL) into data warehouse.
• Experience in complete Software Development Life Cycle (SDLC) of the project such as modeling, process flows, development, unit testing and documentation.
• Experience with Symphony Claims data & Confidential t level data in healthcare environment.
• Strong experience in SAS Base, SAS Macros, SAS SQL. Certified in BASE SAS.
• Extensive experience in writing generic macros and risk based sampling.
• Expertise in Base SAS (Macros, Proc SQL), SQL, Windows environments (PC SAS) & dashboards in Tableau
• Hands on Experience of working on Hadoop (HIVE) and SAS VA.
• Excellent understanding of data management principles, database design, data analysis and data manipulation.
• Proven skills in Data Cleansing, Data Archival, Data Migration utilizing SAS on UNIX & Windows environments.
• Extensive experience in developing standard and Ad hoc Reports, tables, listings and graphs.
• Good knowledge of Symphony & Confidential t level data, financial, sales, and marketing data.
• Experience in UNIX Shell Scripting, SQL & Excel VBA
• Strong quantitative and analytic abilities to analyze and validate data.
• Strengths include strategic planning with optimum utilization of resources, analytical ability, team leadership and collaboration.
• Experience with using other tools like R.
• Excellent interpersonal skills and communication.

TECHNICAL SKILLS

Statistical Software: Base SAS, SAS/SQL, SAS/MACROS, Enterprise Guide

Certifications: Base SAS

Programming Languages: SQL, PL/SQL, Shell Script

Databases: MS Access

Software Packages: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr SAS Developer

Environment: SAS BASE, Enterprise Guide 7.1,Hadoop(Hive), SAS VA MS Excel, Excel VBA, PL/SQL

Responsibilities:

• Analyze user requirements, procedures, and build or improve existing systems and review workflow, and scheduling limitations and create dashboards in SAS VA
• Develop production reports and respond to ad - hoc reporting demands.
• Perform extensive statistical computing and data manipulation using SAS & Hadoop language.
• Design and develop a ETL database for supply demand model for all products of the client
• Create and maintain detailed documentation of processes and computer programs.
• Create, modify, and debug required programs in various platforms (SAS EG & Hadoop).
• Create reports in the form of executive summaries and technical documentation.
• Expand or modify system to serve new purposes or improve work flow
• Estimate work effort, identify task dependencies and determine optimal solutions.

Confidential, East Hanover, NJ

Sr Business Analyst

Environment: SAS BASE, PL/SQL, Enterprise Guide 7.1, Tableau MS Excel, Excel VBA, MS Power point, Think cell

Responsibilities:

• Program in SAS supporting a brand insights team tracking the brand performance as well as promotions and developing strategies to counter competition for Cosentyx drug.
• Review code, provide data and code quality control.
• Prepare decks showing the performance of the brand on a weekly basis
• Developed a model with the help of team by using various inputs with objective to find the best prospects who have the highest propensity to switch to Competitor brand in coming few months.
• Working on multiple project tasks in support of the design and implementation of analytic solutions.
• Interfacing between various business and technical teams.
• Providing technical leadership.
• Working closely with Brand & Market teams to build relationships.
• Continuously gaining a deeper understanding of relevant data, design and processes to build analytic solutions to meet business needs.
• Developed and automated the Cosentyx drug performance report which compares & tracks the progress of the brand in the market with competitors with IMS data, using SAS, Excel & Think cell
• Developed and automated the Taltz tracking analysis which compares & tracks the progress of the brand in the market, using SAS MACROS.
• Developed Gain/Loss analysis and Autodirect reports analyzing Confidential t claims and Medical claims.
• Developed a list of Physicians to be targeted first based on the Transaction data for promotion of the drug.
• Automated reports for other brands like Ilaris & Zortress.
• Developed Adhoc reports for the Brand Insights department.
• Participate in strategic conversations with clients at a high level of their organization, and contribute to long-term programmatic relationships.

Confidential, Washington DC

Senior Consultant

Environment: SAS BASE, Excel VBA, Tableau, MS-Excel, MS Office

Responsibilities:

• Responsible for Data Infrastructure, reporting, insights generation, optimization and marketing sciences.
• Focus on leveraging various data sources, ETL & data warehouse concepts to develop a report tracking lawsuit risk for various drugs.
• Conduct descriptive analyses: Identify, analyze and interpret trends or anomalies in data.
• Develop working dashboards used for filtering specific drugs using Tableau for customers.
• Responsible for building analytic solutions to meet business needs by continuously gaining a deeper understanding of relevant data, design and process.
• Integrated and reconciled data transfers.
• Reviewed and used the existing codes and updated them with the new changes.
• Performed statistical analyses, summaries, and reports.
• Aggregated data checks and other data review activity.
• Investigated potential software bugs, recommended solutions or patches as appropriate, and provided documentation to management and project teams.
• Assisted the manager in the coordination of project tasks and resources across the SAS Programming group, and acted as a backup during the Manager’s absence, as assigned.
• Used SAS for creating Data Quality Reports and Data Recon Reports in UNIX/Windows environments.
• Designed a master table for the Team with all the drug information by merging data from various tables using SAS.
• Collaborating with the clients to integrate new data source in to the existing system and providing insights to the new data along with the existing one.

Confidential, Washington DC

Senior Consultant

Environment: SAS BASE, Excel VBA, Tableau, MS-Excel, MS Office

Responsibilities:

• Created custom analytical reports to help clients understand financial inclusion prospects, identify key growth markets, measure competitive positioning, assess financial situation and provide overview.
• Developed location based dashboards and use-cases for clients based on demographics geography.
• Used SAS base, ETL concepts and MS- Excel for handling of the raw data, organizing and structuring the data.
• Provided dashboards showing the various financial services and access at different levels of geography.
• Extensively used SAS macros to automate the reports.
• Extensively used Datastep and Proc Sqls in the data manipulation and analysis.
• Created Macros and developed SAS programs for data cleaning, validation, analysis and report generation using newly created as well as existing macros.
• Working on multiple project tasks in support of the design and implementation of analytic solutions.

Confidential, NY

Senior Consultant

Environment: PowerPoint, Excel VBA, Tableau, MS-Excel, MS Office

Responsibilities:

• Doing market research analysis using various data sources for asset owners worldwide.
• Perform ad-hoc analysis for the Business teams.
• Design, develop and maintain documentation of the findings in the analysis we performed, and continuous client interaction to show the progress over weekly call.
• Inform business of latest trends of the asset owners, issues as they arise in the course of the project
• Used primary research approach for project management.

Confidential, Washington DC

Senior Consultant

Environment: SAS BASE, R, Tableau, MS-Excel, MS Office

Responsibilities:

• Designed & developed a tool called CATS (Country Analytics Tool & Services).
• CATS is a tool showing the ranking of countries best suited for investment based on different parameters for various industries.
• Had multiple discussions with the business teams and technical team to get an understanding of what needs to be done.
• Finalized on the list of variables we would require for the final tool.
• Applied the concepts of Extraction, Transformation & Load (ETL) while creating the finalized dataset for the tool.
• Interacted with the data from various sources, developed code and helped with optimization and automation of SAS Macros, R Macros and support of applications to the tool in Dashboard format using Tableau.
• Involved with writing SAS Macros & Data steps.
• Used statistical concepts to reduce the # of parameters for different industries.
• Converted the entire process from SAS to R.
• Documented operational processes and procedures for analytic data assets owned by business analytic support team.
• Performed code reviews to ensure proper design, standard, content and functionality.
• Performed the unit testing on the new methodology when converted the tool from SAS to R.

Confidential

SAS Developer/Consultant

Environment: SAS BASE, SAS Macros, Unix Shell Scripting, MS-Excel, MS-Office.

Responsibilities:

• Created a Plan for the project from the business requirement discussion, finalizing the scope of the project. Gathered the business requirement from the users.
• Aggregated data from multiple sources and transformed and modified data according to client needs.
• Worked with data warehouses and data marts.
• Defined functional requirements and technical specifications.
• Created complex process mapping, handling technical resource management, software testing, training and documentation.
• Provided technical guidance to client groups.
• Responsibilities include acting as liaison between client groups and other internal groups.
• Developed different methods of extraction, transformation and loading (ETL) into data warehouse.
• Worked in complete Software Development Life Cycle (SDLC) of the project such as modeling, process flows, development, unit testing and documentation.
• Extensively used Data step and Proc Sql for data manipulation and analysis.
• Created and modified SAS Data sets using PROC SQL and SAS Macros.
• Developed and modified Unit test plan, test cases and also dummy test data to check the implementation of the codes using SAS/MACROS.
• Created reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Wrote SQL code to do the complex joins, views, and materialized view.
• Maintained/modified scheduled SAS reports using Base SAS, SAS Macros.
• Tested and debugged existing macros.
• Implemented the Anti Money Laundering (AML) using SAS base, Unix shell scripting and MS excel.

Confidential

SAS Developer/ Consultant

Environment: SAS MACRO, SAS BASE, MS-ExcelMS- Office

Responsibilities:

• Performed SAS Programming support and ad hoc analysis for Business Insights group at Confidential Audit & Enterprise Risk Services as a part of Risk Analytics team.
• Created custom analytical reports to help clients understand their internal control system and help increase their control parameters, identify key risk areas, assess audit risk and optimize database.
• Used SAS Base/SAS Macros, ETL and data warehouse for risk based sampling analysis.
• Extensively used SAS macros to automate the reports.
• Extensively used Datastep and Proc Sqls in the data manipulation and analysis.
• Created Macros and developed SAS programs for data cleaning, validation, analysis and report generation using newly created as well as existing macros.
• Performed independent code review and developed test plans as needed for SAS programming activities.
• Experienced with Audit Analytics.
• Performed Risk based sampling for various clients from different industries and provided the audit teams with most risky samples to help them write the Audit report.
• Integrated and reconciled data from clients systems at various levels to identify the gaps in the systems.
• Performed statistical analyses, summaries, and reports.
• Aggregated data checks and other data review activity.
• Investigated potential software bugs, recommended solutions or patches as appropriate, and provided documentation to management and project teams.
• Assisted the manager in the coordination of project tasks and resources across the SAS Programming group, and acted as a backup during the Manager’s absence, as assigned.
• Provided exploratory data analysis solutions to organizations to identify anomalies in journal entry transactions in support of the financial reporting and the associated risk of management override and financial statement fraud.
• Implemented fraud detection through the application of sophisticated data analyses of areas with specific fraud risk to identify anomalies or red flags and quantify the associated potential impact in concert with the overall anti-fraud programs and control strategy.
• Performed Journal Entry analysis, Accounts Receivable analysis and Accounts Payable analysis using Audit Command Language (ACL) and other Tools.
• Supported Internal Audit teams based at various client places in data analysis by providing assistance and support using ACL.
• Experienced in data analysis profiling, and cleansing using ACL and SAS.
• Interacted with the Business people to get the requirements and understand the business needs and translate them into programming requirements that support campaign solutions
• Developed the Adhoc Reports.
• Performed other duties as assigned.
• Ability to manage multiple tasks effectively in a fast-paced environment, and progress work in parallel
• Tested and validated the New data.
• Developed functional and technical documentation to assist in the design, development, and/or maintenance of deliverables