SANJAY ASWANI

* ***** **** 201-***-****

Lincoln Park, NJ acwtye@r.postjobfree.com

SENIOR IT BUSINESS ANALYST

EXPERTISE

Software Development Life Cycle

SAS Programmer

Business Growth

Communication skills

Clinical Analyst

Data Queries

Data Mapping

Change Implementation

KEY RESULTS

Created adhoc reports to identify low sales by regions for Book Fair, Book Club, and Classroom Magazine divisions.

Created a weekly report to identify unmatched districts and schools missing from the database for Senior Management and IT Dept. for updates.

Team Lead for modifying all SAS programs/reports from ICD9 Codes to ICD10 Diagnosis Codes.

Created Claims, Members, Diagnosis Codes, and Enrollment reports for vendors (i.e. IHealth, Inovalon, and Medagate.)

Worked with onsite and off-shore maintenance and support to identify and define strategic business issues.

Worked with various departments (i.e. Claims, Medical Management, Clinical Analysis, Product Management, Enrollment, Providers, and Quality Assurance.)

KNOWN FOR

Results Team Building

Sense of Urgency Process Improvements

WORK EXPERIENCE

Scholastic Inc., New York, NY April 2016 – July 2016

Scholastic Corporation is an American publishing, education and media company.

Data Analyst

Analyzed sales activities, marketing campaigns, organizations and customers in detail through SAS Enterprise Guide.

Developed ad hoc reports for specific business issues related to book clubs, book fairs and class room magazines.

Analyzed key data fields in order to identify effect-cause relationships between financial outcomes and marketed actions, thus raising profitability.

Effectively researched areas of the market regarding customer needs and brand perceptions.

HealthFirst, New York, NY 2007 - 2015

Healthfirst is a not-for-profit, provider-sponsored health insurance company that serves more than 1.2 million members in downstate New York.

Senior Business SAS Programmer / Analyst August 2013 – April 2015

Solid understanding of all phases of Software Development Life Cycle (SDLC) methodology (such as business requirements, analysis, design, data modeling, business process modeling, implementation and deployment).

Worked closely with developers and business users, and participated in product design process and document reviews.

Involved in identifying the existing business processes by interacting with subject matter experts.

Strong experience in defining ETL processes, data migration, data mapping, data profiling, modeling and performing gap analysis.

Facilitated JAD (Joint application development) sessions on Business Requirement Document (BRD) and Functional Specification Documents (FSD’s) with Business Owners, Subject Matter Experts (SME’s), Project Managers, Business Analysts, and Development Team.

Acted as a Key Team Player and leading developers in Offshore and Onsite maintenance & support to solve programming problems in production systems, identify and define strategic business issues requiring database analysis. Performing User Acceptance Testing (UAT) and Regression Testing Performance (RTP).

Work as a key interface between the Business, Development, Vendors, QA, and Change Advisory Board (CAB) teams to ensure the project is installed in production phase.

Prepare and present the details and project status to Stake holders and Management.

SAS Programmer / Analyst August 2007 – July 2013

Categorized the business requirements into functional/Non-functional/Business rules.

Responsible for creating BRD, Functional Specifications Document and involved extensively in SDLC.

Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, activity) using MS Visio.

Created and facilitated the walkthrough sessions on the screen mock-ups of the proposed product with Business Owners, Business Managers, and External Users (Vendors.)

Facilitated issue resolution to ensure release schedule remains on track and functional issues are solved through appropriate solutions.

Involved and supported QA team in writing effective Test Plans, System Testing, UAT, and PRN’s by facilitating walkthrough sessions on BRD’s and FSD’s to ensure quality assurance of BI output.

Created SAS data sets, cleaned data, and extracted data and merged data sets used Base SAS, SAS Enterprise Guide, SAS/SQL, and SAS/Macro.

Lehman Brothers, NY August 2005 – July 2007

Lehman Brothers Holdings Inc. was a global financial services firm. Lehman was the fourth-largest investment bank in the United States.

SAS Programmer / Analyst

Developed and maintained Universe in Business objects XI

Customized the universe used Designer for better reported and user experience.

Converted current MUNI reports over to business object reports.

Supported credit evaluation engine of daily priced securities in Microsoft SQL Server 2005. Created custom Business Objects reports for either CDS or Bond.

Optimize tables to create the universe for best performance for both canned reports and ad hoc reports

Created complex Business Object reports used multiple data providers, Union, and Intersection.

Used Business Object designer to link universes together to put together reference data and trade data together for better reported.

EARLIER EXPERIENCE

Catholic Family & Community Services Assistant Billing Manager 2003 – 2005

Sodexho Inc. Data Support Analyst 2002 – 2003

EDUCATION

RAMAPO COLLEGE OF NEW JERSEY

Bachelor of Science Degree

Management Information System

Contact this candidate