Over 4 years of experience in Data Warehousing and Business Intelligen

PROFESSIONAL SUMMARY:

Over * years of experience in Data Warehousing and Business Intelligence emphasizing on ETL concepts, dimensional models and SCD’s.

Understand the Business Requirements and develop a unified solution to meet the needs.

Designed and developed enhancements for improving the current process, to reduce production failures and implemented Performance Tuning techniques to meet the defined Service Level Agreement consistently.

Experience in building mobile applications in Android and working with No-Sql database.

Experience in streaming data using flume and data analysis using Pig and Hive.

EDUCATION:

Master of Science in Computer Software Engineering May 2017

California State University Fullerton

GPA: 3.93

TECHNICAL SKILLS:

Data Engineering: Informatica Power Center 9.1/8.6, Pig, Hive, MapReduce

Scripting: Unix

Programming Language: Java, Android

BI Reporting tool: IBM Cognos 10, Tableau

Testing: Selenium IDE,

Languages: PostgreSQL, Oracle

INDUSTRY EXPERIENCE:

Cognizant Technology Solutions, Client: Orbitz Worldwide BI team (Sep 2009 – Feb 2014)

As part of development of new data warehouse platform "Nirvana" - worked on designing and developing dimensions

and Facts

oDeveloped SCD Type-1 ETLs to load dimension tables for different products like Hotel, Air and Car.

oInvolved in developing Greenplum Stored Procedures to update description columns in the Dimension tables and to create an aggregate table on top of the Fact tables.

Developed List and Crosstab Reports using Cognos Report Studio and Query Studio

oA Competitive Reporting to identify issues of rate parity that helped in maintaining consistent rates for the same product in all online distribution channels.

oHotel availability data including unsold inventory, hotel stop-sell flags, close-to-arrival restrictions, and minimum length of stay restrictions which helped to achieve goal of maximizing profits in a trading year.

Provided L1 and L2 Support for SLA Defined applications across multiple tools (Informaica, Cognos, Qlikview)

oWorked on supporting multiple functional high availability business applications and business users and was responsible for troubleshooting production data issues and manage critical incidents

oBased on the error message from logs, review Informatica mappings and stored procedures to identify the reason for batch job failure and propose/implement an appropriate solution.

oParticipate in problem analysis and incident management procedure meetings to enhance process improvements. Ensure timely communication to the impacted parties during an incident.

Refrain the organization from financial penalties by implementing Proactive alerts to increase the efficiency of

Production Support Team

oDeveloped alert for Long running jobs, source file not arrived, incorrect informatica parameter file, ODS tables not in sync with OLTP) which helped Production Support team to act and meet defined SLA regularly.

oAutomated House cleaning activities like removing older log files on Informatica/Cognos, trigger files.

oDeveloped smoke test scripts to ensure the validity and completeness of data at the end of each production loads

oDeveloped BI Data Dashboard of all Critical Deliverables in Cognos 10 which provides information about the Status of the deliverables and Time of Delivery of the artifacts

Created ad-hoc Custom queries and performed Data Analysis in GreenPlum DB Environment

o Analyze and identify ghost/duplicate bookings

o Identify top sources and destinations, busiest airports for newsprints,

o Passenger information during security situations, alerting passengers during DST.

ACADEMIC PROJECTS:

Android application development: This is the final term project demonstrating the lifecycle of software development. The project included the development of Expense Tracker application using Android and Firebase Database.

Design and development of front end using native android

Developing the application logic using Firebase (Real-time Database)

Testing of Social Networking website: This was a semester project involving the testing and evaluation of a Social networking website. This project included

Determining test requirements and developed test cases.

Developing and implementing automation testing methods and procedures using Selenium

Sentiment analysis of Twitter Data using Pig: This was a project implemented out of my own interest to learn Hadoop Eco System. This project included

Set up of single node Hadoop Cluster on Cloudera Virtual machine

Stream Twitter data using flume to HDFS

Perform sentiment analysis using Pig for positive or negative tweets. (Pig UDF function was written in Java)

Completed Tableau Online course on Udemy and published Charts on Tableau Public

Contact this candidate