Data Information Technology

KARTIK PATIL

**************@*****.*** www.linkedin.com/in/kartikpatil990 669-***-****

Education

Master of Science- Software Engineering, San Jose State University, CA, US. GPA 3.7/4.0 August 2015 - May 2017 Bachelor of Engineering- Information Technology, University of Mumbai, India. GPA 3.2/4.0 August 2008 - May 2012 Key Skills and Competencies

Databases: PostgreSQL, Redshift, Microsoft SQL Server, Oracle 10g and 11g, MySQL, IBM DB2, MongoDB Business Intelligence Tools: Tableau v9.2 and 10.1, Informatica v8.1 and 9.5, Business Objects, Control-M Programming Languages: PL/SQL, Hive, Impala, Java, Python, R, UNIX Others: MS Office, Excel, Visio, PowerPoint, Apache Spark, AWS, SharePoint, Confluence, JIRA, Eclipse, Hadoop, Agile, SVN Work Experience

Data Analyst Intern, Telenav (duration –10 months) June 2016 to Present

Generated dashboards, reports and conducted ad-hoc analysis with high attention to detail and fast turn-around deadlines.

Evaluated reports statistics and monitored business KPI’s to recommend the areas of improvement in the system.

Extensively analyzed large data-sets to turn it into actionable insights and effectively communicated the metrics to key decision makers.

Communicated outcomes effectively to a wide variety of audiences and determined best audience for data-driven insights.

Supported ad-hoc business scenarios, by developing complex SQL queries and data visualization reports in Tableau. Business Intelligence Engineer, Accenture (duration – 3.1 years) July 2012 to July 2015 Comprehensive experience in various Business Intelligence roles across the phases of SDLC- requirement gathering, analysis, designing, development, testing and deployment.

Data Mart Implementation (Client: CNA Insurance Company)

Worked on relational and multidimensional data model to implement optimized analytical data mart.

Devised strategies to implement change data capture to handle slowly changing dimensions.

Responsible for troubleshooting data issues and conducted root cause analysis when reporting data was in question.

Conducted deep dive analysis on the BI infrastructure to migrate, schedule and deploy ETL data flows.

Identified bottleneck within the mappings and improved the performance by using Pushdown optimization technique.

Collaborated with cross functional teams to meet tight deadlines, multi-task, and prioritize workload. Predictive Analytics on Data Mart (Client: CNA Insurance Company)

Interfaced with customers and end users of the system to understand the business needs and facilitate innovative solution.

Implemented business rules to calculate important business metrics and profit ratios, to be delivered to Sr. Leadership.

Optimized stored procedure by implementing database tuning techniques, thus reducing the execution time by 50%. Data Warehouse Implementation (Client: ICICI Lombard General Insurance Company)

Created detailed design document to educate clients on appropriate utilization of business intelligence entities.

Implemented Data Integration and Consolidation to integrate data from heterogeneous source systems and facilitate a strong foundation to build an ETL framework.

Devised error handling and error logging strategies to handle bad data and reprocess them.

Designed test cases based on technical requirements to test the code accuracy and conform if it meets project defined quality standards.

Analyzed and queried metadata repository to perform unit testing, isolate code defects and resolve them.

Developed several UNIX shell scripts to schedule, monitor and automate ETL pipelines.

Revised and improved standard development processes, thus reducing the development time by 30 percent. Academic Projects:

Customer Data Analysis (Big Data technologies)- Developed queries and data pipelines on customer data set to gain hands-on knowledge on big data technologies like Hive, Impala and PIG. Twitter- Sentiment Analysis (Big Data based project)- Performed large scale data processing on twitter stream data using AlchemyAPI, Hadoop, Python, R, MapReduce technologies. Certifications and Accomplishments

DEV 360 – Apache Spark Essentials (MapR Academy) March 2017

“Significant Contribution” Award - certificate of appreciation from Accenture during the Client Visit. November 2014

"212 THE EXTRA DEGREE" Award of Excellence from Client for going above and beyond to deliver projects. August 2014

Contact this candidate