Data Quality Assurance
Resume:
SANJAY ASWANI
Lincoln Park, NJ ******@*****.***
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