Swapna Seshadrivasam

Email:adhp3z@r.postjobfree.com

Mobile: +1-917-***-****

Summary:-

Dynamic, analytical, and result oriented SAS certified professional with 12.5 years of experience in Data Analytics, Data Integration, and Data reporting fields.

High problem-solving skills and solution-focused individual.

Worked in Clinical, Banking, Auditing, and Health care domains with TCS, Deloitte, and UHG multinational companies

Trained over 35 professionals in BASE and Advanced SAS using cutting-edge real-time approach with an online institute – Eduemaster

Managed and mentored 6 people technically and functionally for timed successful completion and execution of project across Hyderabad and Gurgaon offices

Contributed as one of the key SAS developer towards end to end development of an auditing tool when worked with Deloitte

Extremely contributed towards improving the efficiency of SAS programs which benefited the business by reducing the job run time by one third

Excellent communication skills as evident by my direct interaction with clients in discussing the new versions and enhancements of a SAS based tool as an independent worker

Learning knowledge in Tableau

Quick learning capability

Experience in Agile scrum methodology

Certification: BASE SAS certified

BASE SAS CERITIFED

Version – 9.1.3

System Experience:

SAS

Base SAS, Macros, Proc SQL, SAS/Graph

Databases

SQL server, MS-Access

Utilities

MS-Visio, Microsoft Project Plan, SharePoint, InfoPath

Project Method’s

Agile/Scrum Methodology and Water fall model

Operating Systems

Windows, Unix and Mainframes

Work Experience:-

February 2017 to present:

Working as online SAS tutor with online training institute – Eduemaster. Teaches BASE SAS and ADVANCED SAS covering SAS Macros, SAS SQL. Received an excellent feedback from 20 students. Helped 5 students to settle in their professional career.

@UHG, Hyderabad – May 2014 to July 2016

Project : Fraud Claim Analysis

Role : Team Lead

Designation : Associate Lead

Environment : Base SAS, PROC SQL, Macros, Excel, VBA, AIX,

DDE, SQLCE

Responsibilities:

Worked as an Associate Lead leading 6 people in Hyderabad and Gurgaon offices, for Fraud analytics Programming and Commercial projects.

Responsible for delegating tasks to the team, ensure smooth delivery of work, troubleshoot issues in the team

Coordinate between offshore and onshore teams and track the status of work of everyone in the team on a regular basis.

Responsible for Performance improvements in the project.

As a reporting manager was also responsible to set goals to the team at the beginning of the year and communicate to every individual. Ensured that the team is working towards achieving their goals and understand and resolve any constraints they have in achieving them.

@ Deloitte, Hyderabad – May 2008 till April 2014

Project # 1:

Project : JOURNAL ENTRY DATA ANALYSIS ROUTINE

Client : Deloitte Support Services, Hyderabad

Role : Technical Lead

Designation : Senior Analyst

Duration : August 2008 – April 2014

Environment : Base SAS, PROC SQL, Macros, Excel, VBA, AIX,

DDE, SQLCE

Responsibilities:

Worked on end to end development of an auditing tool by implementing Base SAS, SAS Macros, SAS SQL along with Excel and Excel VBA.

Extremely contributed to the performance tuning of SAS programs which benefited the business by reducing the job run time by one third

Followed Agile/Scrum methodologies

Extensively used base SAS to import Source files (converting various raw data file

into SAS datasets such as Raw JE, COA (chart of accounts), TB (trail balance) files etc.

Implemented multiple analytical procedures to analyze the data and reporting utilities for generating highly sophisticated reports as per the client requirements

Perform preliminary checks on the received data files to ensure correctness of data,

cleanse the data and perform any variable transformations that seem appropriate to

perform the data analysis.

Perform account reconciliation of the Journal entry data to the Trial balance file.

Responsible for project WBS preparation and preparing Estimation by using Microsoft

project plan.

Coordinated with end users in accessing the user friendliness of the tool.

Coordinated with the US ITS team in fixing issues reported by users.

Tracking and communicating status / progress time to time

Project # 2:

JEDAR Client Service(Oct 2006 to June 2008):

Title

JEDAR Client Service

Company &Client

Deloitte Audit and Enterprise Risk services (AERS), Hyderabad

Environment

Base Sas, Macros, Proc sql and JEDAR tool

Region

Mid-America

Responsibilities:

Served various clients in performing SAS99 Journal Entry testing using JEDAR.

Executed multiple complex JEDAR engagements.

Read-in of various types of files including Report format files using SAS and ACL.

Perform preliminary checks on the received Journal entry data to ensure correctness of data.

Perform account reconciliation of the Journal entry data to the Trial balance file.

Perform Journal entry data analysis as per the Statement on Auditing Standards No.99 guidelines.

Experienced in using SAS and ACL.

Key member of North-east region executing various JEDAR projects.

@TCS, Chennai – July 2004 to October 2006

Project #1:

Name: OO Migration

Client: Citi Group

Role: Team member

Designation: Systems Engineer

Duration: July 2005 to October 2006

Industry: Banking

Service Area: Business Intelligence

Service Line: Citi Cards

Organization: TATA CONSULTANCY SERVICES.

Role: Team Member; 11 months.

Involved in functional analysis and gathering the information from client as per the project requisites.

Interaction with Onsite on daily basis.

Creation of SAS datasets by migrating the code from Solana Mainframe to Unix environment and uploading them to Common Data Area (CDA) as per the requirement.

Involved in OO compares on daily basis to compare the datasets created after migration with the existing Production datasets before migration for all the loads.

Creation of datasets for new portfolios that are included in FDA as per the requirement based on system Numbers and uploading to CDA.

Maintenance of daily, weekly and monthly reports by involving in core project management activities

Technical Environment: SAS/BASE, SAS/MACROS, UNIX Shell-script etc.

Platform: UNIX.

Project # 2:

Client : Eli Lilly

Role : Team Member

Designation : Assistant Systems Engineer

Duration : July 2004 – September 2005

Environment : Mainframes

Industry: Pharmaceutical

Service Area: Clinical Trials

Service Line: DSA

Organization: TATA Consultancy Services

Role: Team Member

Duration: 15 months.

Role :

• Creating analysis datasets for various studies for different product teams, creating standard ACDO (Automated Clinical Data Output) and custom reports for the statisticians using the analysis datasets

• Creating custom datasets

• Validating the report output

• Annotating CRF’s as a step in study submission to FDA

• Writing data definitions

• Combining various studies’ data to form safety or efficacy data warehouses for analysis & mining by internal or external research bodies and others as and when required

• Developing Analysis Data Sets

• SAS Version 6.09/SAS 8.2 testing and validation of the reports

Technical Environment:

Windows 2000, MVS, JCL, Base SAS, Macro SAS,

Tools: MS-VSS (for source code control).

Contact this candidate