SUMMARY:

• More than 10.0 years of professional experience with close to having 7.5 years in areas of reporting and data warehousing. Demonstrated track record of successfully managing small to large projects from start to finish. I got a good exposure on different tasks with an erudite way and I decipher as follows,
• Have an exposure in Insurance, Banking and HealthCare Domains
• Proficient in SAS Programming at Base and Advanced levels
• Efficient at developing and maintaining the macros at different jobs.
• Good Knowledge in SAS BI Tools. Laid hands on SAS Data Integration Studio, SAS Enterprise Guide, SAS Management console, Business objects, Alteryx (ETL & Reporting tool), Tableau.
• Well exposed in debugging the log with logical and macro programming issues that run on daily, weekly and monthly Jobs.
• An Active Team Member in all aspects with the team.
• Worked on optimizing and performance tuning of codes and large sql’s.
• Participated in automating of jobs with wrappers under different schedulers in cross operation systems environments.
• Developed code in automated manner by enabling less manual intervention steps.
• Worked on creating interactive dashboards, where user can consider charts rather than data.
• Experienced in working on UNIX, Solaris and Windows environments
• Involved in SAS 9.4 platform administration tasks loading bulk users, implementation of metadata backup.
• Undergone on Hadoop components like PIG, HIVE and SQOOP.
• Undergone on R programming with spark environment.

TECHNICAL SKILLS:

Primary Skills: SAS/BASE, ADVANCE SAS, SAS/ACCESS, SAS/CONNECT, SAS/STAT SAS DI Studio, SAS EG, SAS Information Map Studio, SAS Management console, SAS add - in for Microsoft office, Tableau, Business Objects, Alteryx.

Operating Systems: WINDOWS 2000/XP/98, UNIX, Mainframes, Sun Solaris, AIX

Languages: C,SAS, VBA,SQL

Development Tools: SAS,Unix, Solaris

CRM tools: ACT CRM, Microsoft CRM and Salesforce as a user

Scripts: Unix Shell Scripting

Databases: Oracle 9i, SQL Server 2005, Teradata

Domain Knowledge: Banking, Insurance, Health Care

Legacy Systems: SAS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Base SAS, SAS/Macros, Proc SQL, SAS Connect, SAS EG, SAS management console, SAS Info map studio, AIX, Teradata, Control-M scheduler, SAS customer Intelligence Studio.

Responsibilities:

• Worked as Developer for Sales incentive process which s incentives to internal sales rep, external agencies and Producers. This consists of different programs under the bonus qualification process.
• Performed remediation of Episode treatment grouper process from Corporate Data warehouse to Enterprise Data warehouse.
• Performed feasibility study about warehouse changes in code to accept new diagnosis code (ICD10) when introduced.
• Provided the administration operations maintenance of installation, applying DB upgrades to third party tool (optum Symmetry)
• Handling incidents and Service request falls under application and provided with one-time solutions.
• Involved with the Marketing automation team in handling their inbound campaigns and tool administration.

Confidential

Environment: Microsoft BI SSIS, SQL Server and Tivoli Web Scheduler.

Responsibilities:

• Worked on design and development of EDW load jobs for downstream reporting.
• Coordination with cross functional team from production standpoint on day to day incident and request.
• Enhanced the performance by implementing tuning of jobs to bring down the run times.
• Performed batch optimization by implementing the dependencies of schedules.

Confidential

Environment: Base SAS, Proc SQL, SAS/Macros, SAS Connect, SAS DI Studio, UNIX.

Responsibilities:

• Created SAS Jobs using Data Integration Studio.
• Extracted users’ data from Production Environment.
• Worked on scheduling of DI job.
• Created the FTP code to send daily feed to SAM System.
• Worked on data owner requests to add more user groups.

Confidential

Environment: Base SAS, Proc SQL, SAS/Macros, SAS Connect, SAS DI Studio, UNIX.

Responsibilities:

• Involved Users and group creation.Maintaining user permissions at metadata level.
• Monitoring the daily Schedules and analyzing the reason for failures if any.
• Worked user access tickets, providing them permissions to the Data Sources

Confidential

Environment: Base SAS, Proc SQL, SAS/Macros, SAS Connect, SAS DI Studio, UNIX.

Responsibilities:

• Understanding the Business Requirements
• Interacting with client for requirement gathering, analysis and documentation.
• Data received in CSV files and Teradata database.
• Reading CSV files using SAS DI Studio Transformation and creating SAS datasets.
• Developed user written transformations.
• Developed SAS Macros to simplify SAS code and effectively reduce coding time.
• Created Staging, foundation and user related datasets.
• Developed Data Quality jobs for Staging and Foundation datasets.

Confidential

Environment: Base SAS, Proc SQL, SAS/Macros, SAS Stat, Oracle

Responsibilities:

• As a team member involved in development of SAS codes in creating the datasets and loading the data to tables for further process where they can create reports from the data that is been created.

Confidential

Environment: Base SAS, Proc SQL, SAS/Macros

Responsibilities:

• Understanding the Business Requirements
• Reading flat files using Base SAS and creating SAS datasets.
• Managing the data using Base SAS and Macros
• Generating the reports and listings using various Base SAS Procedures.

Confidential

Environment: MS Excel and VBA Macros.

Responsibilities:

• Working closely with technology team in preparing RFP’s, RFI’s and vendor registrations. Product Comparison analysis. Involved in mapping the fields a according to the requirements. Involved in data migration and mapping the data fields with the help of developers. Worked directly with US counterpart on Mortgage Industry and other verticals on capturing the day to day trend analysis and constantly looking out for Business development. Involved in activities for new comers into the team on ACT CRM