Data Software Engineer

PRAJAKTA SANGORE

add0ex@r.postjobfree.com www.linkedin.com/in/prajaktasangore +1-979-***-****

Passionate, responsible and committed Software Engineer with 7+ years of Oracle/SQL/Database Development experience in designing, implementing and adapting Data Warehousing and BI technologies.

PROFESSIONAL EXPERIENCE

7+ years of Experience in Data Warehousing including Performance Tuning, Query Optimization, writing Stored Procedures, Functions, Views, Database Normalization, ETL Architecture and Business Intelligence and Data Visualization

5+ years of Software development and implementation experience

6+ years of ETL (Extract, Transform, Load) Programming and Relational Database experience

6+ years of SDLC (System Development Life Cycle) experience

6+ years of SQL – PL/SQL experience

4+ years of Data Reporting and Data Visualization experience

1 year of Cloud AWS experience

3+ years of Team Management experience

Hands on Experience in Data Modeling, Physical and Logical Schema Design, Creating Triggers, Indexes and Views, Snowflake and Star Schema, Dimensional and Fact Tables, Slowly Changing Dimensions, Normalization and other Database Concepts.

Hands on Experience in Object-Oriented Programming and solid understanding of Data Structures and Algorithms

Software development engineering practices like Test Driven Development and writing Unit Test Cases

Solid Understanding of HTML, CSS and JavaScript, REST API web services (XML / JSON)

Superior communication skills, strong decision making, and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs

Able to work independently and in a team

Worked in Agile, Scrum Environment

Achieved an Honorable Mention Award from Microsoft Corporation in recognition for an outstanding effort and quality of the idea and project undertaken in the Imagine Cup 2011 competition

Awarded Deloitte Applause Award for good performance in project

Several You Rock Awards from Cerner Cooperation for leadership skills and being a team player

TECHNICAL COMPETENCIES

Programming Languages:

Java (Core), Python, JavaScript

Scripting Languages:

SQL, PL/SQL, UNIX, Shell Scripting, Cerner CCL

ETL / Data Visualization Tools:

SSIS, SSRS, Tableau, QlikView, SAP Business Objects 4.1, Power BI

IDE tools:

Eclipse, Visual Studio 2019

Cloud Technologies:

AWS, S3, EC2, Redshift, Athena

Web Technologies:

HTML, CSS, XHTML, XML, JSON

Database/ Modeling Tools:

ORACLE 9i/10g, MS SQL Server 2008, MySQL, Oracle, Vertica, PostgreSQL, Microsoft Visio, Erwin

Version Control Tools:

Team Foundation Server (TFS), GitHub, JIRA, SVN, Crucible

WORK EXPERIENCE

ETL-BI DEVELOPER Apr 2018 – Aug 2019

Deloitte Consulting, San Jose, CA, USA

Domain: Insurance

Responsibilities:

Performed ETL techniques on datasets using AWS S3, Athena to extract the data and create data sets and creating dashboards on Tableau Desktop, publish dashboards on Tableau Server

Designed, developed, tested, and maintained complex dashboards using BI tools (Tableau Qlik View, Power BI) based on user requirements

Consistently attended meetings with the client subject matter experts to acquire functional business requirements

Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting

Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications

Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets

Worked with Tableau tools like Content Migration Tools, Catalog, Conductor, Bridge

Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports

Scheduled extract refresh for weekly and monthly reports

Worked on workbook Permissions, Ownerships and User filters

Working with clients and stakeholders to identify the requirements and figure out the KPI’s and help achieve business with the clients

Managing and Co-ordinating between resources across different time zones

Environment: Qlik View, Amazon Web Services, EC2, S3, Athena, Tableau Desktop, Tableau Server, SQL, SQL Server, Microsoft Visio, Erwin, Tableau tools: CMT, Catalog, Conductor, Bridge

SOFTWARE ENGINEER II Oct 2011 – Apr 2018

Cerner Corporation, MO, USA

Domain: HealthCare

Responsibilities:

Developed and enhanced ETL framework that provides high-speed OLAP and BI reporting using Oracle SQL and SAP Business Objects 4.1 for Meaningful Use reporting

Developed data model and database design using Snowflake and Star Schemas, created indexes, keys and maintained database for Meaningful Use Solution

Created Tableau dashboards for team project management

Wrote PL/SQL Scripts for retrieving and loading data into fact tables

Developed Relational Data Models and performed Data Integration, Data Extraction, Data Reporting, Performance Tuning and Query Optimization

Wrote efficient Stored Procedures, Triggers, Views, and Cursors for accessing Oracle database and automation process

Applied Data Warehouse concepts of Normalization, Database objects, SQL Trace, Explain Plan, CBO and RBO Optimizers, Hints, Indexes, Materialized Views, Global Temporary tables

Automated processes using Python, SQL, Jenkins reducing 40% of the testing time

Worked directly with Consultants, Integration Architects, Area Portfolio Leader and Clients to gather requirements for BI reporting and analytics

Lead a team of 4 engineers provided designs, performed Capacity Planning assigned tasks and helped them target their project deadlines

Awarded “You Rock Award” for peer recognition for 2nd, 3rd Quarter 2016 and leadership skills 1st Quarter 2017,2018

Environment: PL/SQL, SQL, Cerner (CCL) Tableau, SAP Business Objects 4.1, Oracle SQL Developer, UNIX, Jenkins, JUnit, Python, Universe Design / Information Tool, GitHub, JIRA, Crucible, HTML 4.0, XHTML 1.0, XM, CSS, Microsoft Visio.

EDUCATION

University of Houston – Clear Lake, Houston, Texas, USA

Aug 2011

Master of Science in Computer Science

GPA: 3.82

University of Mumbai - Mumbai, India

May 2008

Bachelor of Engineering – Information Technology

GPA: 3.95

Contact this candidate