Data and Business Analytics

Abhishek R Bharekar

San Jose, CA - *****

Mobile: 408-***-**** / E-mail: ********.********@*****.*** / LinkedIn: https://www.linkedin.com/in/bharekarabhishek

Summary: Graduate student pursuing master’s in software engineering with a considerable experience in the field of Data Warehousing, ETL, Business Intelligence and Analytics.

Technical Skills

Reporting tool OBIEE 11g, Cognos 8 BI, Tableau

Databases Oracle (9,10g), MySQL, Apache Cassandra IBM DB2, MongoDB, SQL Server, Teradata

Languages C, C++, SQL, Hive, Python, Java, R, Go, HTML, CSS, VBA ETL tool Informatica 8.0, 9.1, 9.5.

Other MS Excel, MS Visio, AWS, Six Sigma, Oracle E-Business Suite, SPSS, Bash, cmd, Bigdata, Hadoop & Map/Reduce, REST, SOAP, Heroku, Data Modelling using Toad and MySQL Workbench, Google Analytics.

Relevant Experience

Enterprise Business Systems Analyst Intern (Vertex Pharmaceuticals Incorporated. Boston, MA) (June 2016 – August 2016)

Worked under the Enterprise Business Intelligence team in assisting the Vertex EBS Financial Analytics Project to gather and develop business requirements, analyzing trends in the complex data sets using SQL.

Designed, edited and tested reports and dashboards in OBIEE 11g and created UAT and A/B testing materials.

Performed Business analysis activities for the Global Spend Transparency Program and Revenue Analytics Program on data sets containing over 2 million records.

Supported testing activities that included the creation of user acceptance test scripts for solutions on the Global Spend Transparency Program, Workday, HR and Revenue Analytics Forecast Reporting.

Tested, Validated and Documented the General Ledger(GL) Report in OBIEE and Oracle EBS R12 for ERP.

Worked on the Headcount Data Analysis, Validation, Testing and creation of OBIEE report along with RPD administration.

Assisted the ETL process development, optimization and testing in Informatica.

Interacted with multiple departments (Human Resources, Finance, Accounting, Managed Markets), as well as work with talented people from different cultures and backgrounds.

Business Intelligence Analyst (Cognizant Technology Solutions Pvt. Ltd, India) (October 2013 – August 2014)

Enterprise Information Management - Banking & Financial Services

Project: BB&T production support and enhancement. (Enterprise Data Warehousing)

Retrieved and aggregated raw data from multiple sources and compiling it into a digestible and actionable format to enable effective decision making using Informatica Power Center and IBM Db2.

Identified process and system improvement by monitoring existent metrics, analyzing data and partnering with internal teams throughout the QA life cycle along with SQL query optimizations and SIT and UAT defect resolution.

Prepared design document for landing, staging, ODS and data marts.

Conducted requirement analysis and prepared mapping specification and technical design documents.

Creating parameter entries and assigning the variable values for the workflows accordingly.

Coordinated system development tasks to include data analysis, OLAP design, integration and formal testing.

Designed and developed data visualization and ad-hoc reporting solutions using MS EXCEL (formulas, macros, and pivot tables) IBM Cognos and Tableau with drill-down and slice-and-dice features to make effective business decisions.

Supported cross-functional teams on the day-to-day execution of the existent program implementation.

Worked on programming, database management and ETL interfacing that facilitated data driven decisions.

Academic Projects

1.HealthCare Analytics (August 2016 – November 2016)

Worked on data gathering, extraction, cleaning using Apache Cassandra, Spark and visualization using Tableau. Designed the Six Sigma DMAIC Architecture for process optimization with a focus on KPI improvement and applied predictive analytics using linear regression model using R. The project aimed at improving the operational efficiency and resource management in health-care.

2. Bitly URL Shortener (October 2015 – December 2015)

Built a cloud scale Bitly like Service on AWS and Heroku. I personally exploited various AWS resources like Beanstalk, SQS and EC2 along with MySQL and MongoDB to create a URL shortening service and deployed it on Heroku.

Education

MS Software Engineering – San Jose State University (Expected May 2017)

Relevant courses: (Software Systems Engineering, Cloud Technologies, Web and Data Mining, Business Intelligence Technologies,

Enterprise Software Platforms, Enterprise Distributed Systems, Software QA and Testing, Virtualization technologies)

Bachelor of Engineering (Computer Science) – University of Pune (2009 - 2013)

Contact this candidate