SUMMARY

• 7+ years of Experience in ETL programming, implementing BI solutionsandcreatingData Visualization using best practicesin Data Warehousing, BI tools and technologies
• 6+ years of SQL - PL/SQL, ETL (Extract, Transform, Load) Programming, SDLC (Software Development Life Cycle) experience using engineering practices likeTest Driven Development and writing Unit Test Cases
• Hands on Experience in various Database Concepts like 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
• 3+ years of gathering requirements, analyzing requirements, preparing flowcharts and specification documents for the team and other system users to follow
• 3+ years of Team ManagementandProject Management experience
• 1+ year of Cloud experience of building ETL pipeline for data analysis, data ingestion, data modeling using AWS, S3, Athena and Tableau
• Goodunderstanding of SaaS business models,ServiceOrientedArchitectures and Big Data technologies
• Ability to learn and adapt quickly in a dynamic and fast-growing environment, work independently as well as in large, collaborative teams to achieve organizational goals
• Worked in Agile, Scrum Environment
• Superior communication skills with strong work ethics, quick decision making, and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs

TECHNICAL SKILLS

Programming Languages: Java (Core), Python, JavaScript

Scripting Languages: SQL, PL/SQL, UNIX, Shell Scripting, Cerner CCL, SnowSQL

ETL Tools: Informatica Power Center 9.1, SSIS

Data Visualization Tool s: Tableau, QlikView, SAP Business Objects 4.1, Power BI,SSRS

IDE tools: Eclipse, Visual Studio

Cloud Technologies: AWS, S3, EC2, Redshift, Athena, Snowflake

Web Technologies: HTML, CSS, XHTML, XML, JSON, Rest API, Soap

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

Version Control/Tracking Tools: Team Foundation Server (TFS), Git, JIRA, SVN, Crucible

PROFESSIONAL EXPERIENCE

ETL-BI DEVELOPER

Confidential

Responsibilities:

• Integrated various Data Marts that targeted specific Business processes including Marketing, Generation, Transmission and Distribution etc., the data warehouse was designed using Erwin adopting Star Schema methodology
• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer in Informatica PowerCenter
• Developed Mappings using Transformations like Expression, Filter, Joiner and Lookups for better data messaging and to migrate clean and consistent data
• Extracted data from various sources (Oracle, SQL Server and Flat files) and loaded data into staging area
• Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor
• Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data
• Implemented ETL techniques on datasets using AWS S3, Athena to extract the data for creating dashboards using Tableau Desktop and publish the dashboards on Tableau Server
• Redesigned, developed, tested, and maintained complex dashboards using BI tools (Tableau Qlik View, Power BI) based on user requirements
• Initiated the implementation of case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting
• Generated revenue stream for Confidential by implementing the BI solution using various technologies which could be integrated across different platforms depending on client’s technology stack
• Implemented Scatter Plots, Stacked Bars, Pivot Tables, 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
• Working with clients and stakeholders to identify the requirements and figure out the KPI’s and help achieve business with the clients
• Presented the final product to leadership, team and other stakeholders across various time zones
• Designed high performant database model meeting client’s business requirements
• Lead a team of 2 across different time zones, mentored them and helped them achieve their targeted deadlines for project delivery

Environment: Informatica PowerCenter 9.1, 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

Confidential

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 designed database schema using Snowflake and Star Schemas, created indexes, keys and maintained database for Meaningful Use Solution
• Implemented automation of data ingestion, data processing and data uploads to a RDBMS data model
• Lead the design, development, and implementation of test data
• Automated processes using Python, SQL, Jenkins reducing 40% of the testing time
• Developed Relational Data Models and performed Data Integration, Data Extraction, Data Reporting, Performance Tuning and Query Optimization
• Applied Data Warehouse concepts of Normalization, Database objects, SQL Trace, Explain Plan, CBO and RBO Optimizers, Hints, Indexes, Materialized Views, Global Temporary tables, Snowflake and Star Schema, Dimensional, Fact Tables, Slowly Changing Dimensions
• Collaborated efficiently cross functional IT specialists like Integration Architects, Area Portfolio Leader and Clientsto gather requirements for BI reporting and analytics solutions and implement them
• Lead a team of 4 engineers provided designs, performed Capacity Planning assigned tasks and mentored them to achieve their project deadlines and professional goals

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.