SANI L SAWANT
* ******* **, *** #**, Brookline, MA - acyl79@r.postjobfree.com 774-***-****
SUM MARY:
I am an organised, detailed-oriented, strong communicator, experienced in working in a data-driven environment. Adept
i n database management, SQL querying, formulating solutions to business problems, requirement gathering, business
p rocess analysis and developing comprehensive reports and dashboards using visualization tools and working in waterfall
and agile methodology with collaborative cross functional teams.
E DUCAT ION:
Worcester Polytechnic Institute (WPI), Worcester, MA
Master of Science in I nformation Technology, GPA 3.66/4.0
A ug 2014 -May 2016
Ramrao Adik Institute of Technology (RAIT), U niversity of Mumbai, India
Bachelor of Engineering in I nformation Technology
Apr 2009 - Apr 2013
PROFESSIONAL DEV E LOP M E N T:
Certification in Secure Coding P ractise, Accelya Kale.
May 2014
SK I L LS:
P rogramming Language: Java, XML, HTML, SQL, JavaScript
Tools: Logi Analytics, JMP Statistical Discovery, Rational Rose, Net Beans IDE, Eclipse, Tableau, Web
I ntelligence(WebI), Statistica, SAP Business Objects, Apex, IBM Cognos, Android Studio, SharePoint, Qualtrics,
M icrosoft Office Suite, Visio, Project, Kibana, Elasticsearch, JIRA, Dbschema, A tlassian Confluence
Database: P LSQL, SQLite, Oracle, MS Access, Postgres SQL
EXPER I E NCE:
Technical Business Analyst, Cure Forward, Boston A ug 2016
- P resent
Led as a Scrum master for data architecture and development team to clearly document requirements and enable the
technical team to build product features and enhancements
Collaborated closely with the architecture team to ensure technical feasibility and product dependencies
Performed data extraction using Postgres SQL, ETL mappings and designed analytics to assist management
execution and funding activities
Defined user stories in JIRA and Atlassian Confluence for product-related work streams and Designed technology
solution architectures to achieve IS/IT operations insights
Automated system-related activities, generated ad-hoc reports and dashboards using Elasticsearch Kibana,
contributed innovative ideas and data-driven facts to enhance product functionality
Worked with cross-functional team members to execute new features and enhancements from requirements
gathering, prototyping, user and integration testing, reporting, t raining and support
Identified emergent data quality issues, root causes and provided recommendations to improve data quality
Assisted in data modelling for Unified Data Model (UDM), sprint planning and backlog grooming sessions
Experience working in the Agile Development Framework, involved in migration of UDM using DBschema and
documented Standard optimizing procedures (SOPs) and data dictionary for UDM .
Business Data Analyst, Sanofi, Framingham
Dec 2015 May 2016
Performed data acquisition, entry, verification and validation of manufacturing records into databases from all
applicable systems
Created data entry forms and guidelines in Apex to convert data for electronic usage
Performed comprehensive data analysis for downstream purification of Thyrogen and Fabrazyme using SAS
and JMP Statistical Discovery
Analyzed complex business and data requirements to design charts, graphs and reports
Performed predictive and statistical data analysis using Statistica and monitored the results
Assisted in validation of the software applications and created t raining material for new software
i mplementation tools.
Data Analyst, Admissions Department, WPI May
2015 Dec 2015
Served as a Business Ambassador for Robert A. Foisie School of Business at global level
Aggregated student data from Qualtrics, created ad-hoc queries and reports to perform conjoint analysis and
developed BI reports
Performed spreadsheet analysis using excel, created impactful visualizations using Tableau, summarized data
f indings after analyzing large data sets
Led the project plan in collaboration with marketing department to increase visibility of WPI
Designed survey for international students using Qualt rics, analyzed student behaviour by means of focus
g roups and provided recommendations to improve the existing survey system.
Graduate Research and Teaching Assistant, Foisie School of Business, WPI
Sept 2014 - May 2015
Assisted professor with literature searches, researched on local food banks by using KPIs for analysis,
performed data manipulation using excel and digitized quantative and qualitative data for research purposes
Worked with professor for Engineering Entrepreneurship Innovation course.
Business Analyst, Accelya Kale Solutions Limited, Mumbai, India
J uly 2013 - July 2014
Captured business and systems requirements, analyzed at code and data levels such as data mapping and
data conversion, adhered to software development life cycle methods
Designed interactive real time dashboards using Logi Analytics and PLSQL for project eSpin, deployed and
performed query tuning to enhance application performance
Exported reports on server side using Business Objects (BO) and provided technical support to go live
environment
Designed real t ime visualizations using WebI reports and participated in design and code reviews.
Awarded for performance in Accelya Kale during t raining course.
PROJECTS:
D atabase Development: I nventory Management system, WPI
Jan 2015 - Apr 2015
Analyzed the business requirements, designed the database architecture using SQLite and graphical user
i nterface using Android Studio
System Design: Asset Management System (AMS) - OneShield I nc, WPI
Jan 2015 - Apr 2015
Designed AMS using SharePoint, generated asset management reports, performed testing and provided key
solutions in critical situations
B usiness I ntelligence: User Generated Content Data Analysis, WPI
Jan 2015 - Apr 2015
Analyzed the survey data (internet and blog) to study customer behaviour and recommendations, implemented
data cleaning and aggregation to perform statistical analysis using IBM Cognos and MS Excel
Performed customer segmentation analysis to target different marketing strategy for optimum results
ACT I V I T I ES:
Vice P resident of Social Events, G raduate Student Government, WPI
Dec 2014 Jan 2016
Recipient of T homas J. T racy WP I G raduate Business P rogram Spi rit Award
M ar 2016