SUMMARY:

SQL BI developer and Certified Technology Specialist on Microsoft BI with over 10 years of experience in developing enterprise BI applications, Hadoop/Big Data applications, data warehousing, databased design and development, T - SQL development, creating reports & dashboards and Data analysis. Excellent technology lead and a problem solver experienced in handling end to end BI applications using waterfall and agile methodologies with CI/CD.

AREAS OF EXPERTISE:

• Experienced in creating ETL solutions using SSIS and processed big data using Apache Hive, stored procedures, views, functions etc. and SQL programming, data modeling for star, snow flake and Starflake schemas
• Proven experience in writing and fixing complex performance issues in procedures for web applications while handling huge data
• Created various reports and report models using SSRS and created interactive dashboards using Tableau
• Involved in building multi-dimensional cubes using SSAS and written MDX queries for data analysis
• Experienced in working with OLTP & OLAP systems and database design and development and data modeling

TECHNICAL SKILLS:

Languages/Scripting: SQL, C, HTML, XML and Unix shell, power shell

ETL tools: DTS and SSIS

Reporting: SSRS, Tableau

Data Analysis: SSAS, OBIEE

Databases: SQL 2005/2008/2012/2014 , Oracle 8i/9i/11i, HTML, Teradata, Sybase, NoSQL (MongoDB)

Tools: SVN, TFS, Jenkins, power designer, ERWIN, UCD, JIRA, HP Quality center, Gitlab, Liquibase and Control-M

Methodologies: Agile and Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Database consultant

Responsibilities:

• Worked on writing complex stored procedures, SQL scripts, data modeling, and resolving performance issues by refactoring procedures involving deadlock, high CPU usage issues, analyzing and providing necessary test data for load test scenarios
• Involved in designing the ETL solutions and required data models
• Involved in migrating huge volume from Teradata to Hadoop eco-system and worked with hive tables for analysis
• Created ETL processes using Hive queries and developed Tableau dashboards on Hive data
• Performed data analysis and data exploration for the various business problems
• Developed and published customized reports and dashboards with interactive views, trends and drill downs using
• Developed Tableau workbooks from multiple data sources using Tableau desktop and performed year over year, moth over month, YTD, QTD analysis
• Involved in cross team discussions to provide optimized data base solutions for robust OLTP system
• Designed and developed ETL processes using SSIS to extract data from OLTP to OLAP systems and enterprise Data Warehouse
• Involved in complete SDLC with CI and CD in both agile and waterfall methodologies.
• Developed SQL scripts, stored procedures, views, materialized views and functions to perform the business logic
• Troubleshoot and identify low performing queries and improve the performance
• Worked in designing and developing Sybase scripts for robust OLTP system
• Involved in automating reports and few areas of redundant work by using power shell scripts

Environment: Sybase, T-SQL, Teradata, Hadoop, Hive, Tableau, SSIS, power shell, XML, OLTP, Power designer, MS Visio, Excel

Confidential, Chicago, IL

Sr. Business Intelligence Developer

Responsibilities:

• Meeting with business to understand the requirements and business rules
• Involved in architectural discussions to provide optimized solutions to the business
• Single point of contact for handling all database design for front end applications.
• Involved in designing the logic data model, prepared schema diagrams and created the data model
• Designed ETL solutions and created various packages using SSIS to load the data into data warehouse
• Enhancing data model and creating/modifying various database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
• Created and developed Parameterized, Drill Down and ad-hoc reports using SQL Server 2008 Reports Services (SSRS)
• Designed and developed Tableau workbooks from multiple data sources and published to the server
• Built exception handling mechanism along with the process of loading the data into data warehouse
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers
• Managed Security privileges for each Subject area and Dashboards according to user requirements. Added users and configured security in web logic console of OBIEE 11g.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer
• Performance tuning for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning
• Created complex stored procedures to perform the validation for the business rules and used them in SSIS

Environment: MS SQL Server, SSRS, SSIS, Tableau, OBIEE tools, Oracle 11g, VB.Net, T-SQL, Query Analyzer, XML, SharePoint, SQL Profiler and Erwin

Confidential, Wisconsin

Sr. BI Developer/System Analyst

Responsibilities:

• Processed complicated XML files using SSIS, SQL and involved in generating reports, charts etc., by getting requirements from the business.
• Introduced new coding standards and optimized generation of XML files on a daily basis with high quality.
• Dealt end to end project right from requirement gathering to deployment to production after supporting testing in QA/UAT/STG.

Environment: MS SQL Server 2008/2012, Windows 2000/NT/XP, SSIS 2008/2012, C#, VB.NET, T-SQL, Query Analyzer, XML, ETL, SQL Profiler, Oracle, OLTP

Confidential, New York

Sr. Technical Lead

Responsibilities:

• Involved in extensive migration of data from SSIS to SAP using SSIS/SQL and generating reports using SSRS.
• Single point of contact for all the BI and data related migration activities from SQL to SAP.
• Dealt end to end project right from requirement gathering to deployment to production after supporting testing in QA/UAT/STG.

Environment: MS SQL Server 2008, Windows 2000/NT/XP, SSRS 2008, SSIS 2008, C#, VB.NET, T-SQL, Query Analyzer, XML, ETL, SQL Profiler

Confidential

Technical Lead

Responsibilities:

• Onsite technical lead handling multiple downstream projects for Shell (Energy &Utilities) by working with the business analysts to get requirements, design and develop end to end projects (SQL, SSIS, SSRS, SSAS) till production deployment.
• Involved in data migration/ SSIS packages migration to cloud. Worked with architects to design optimized solutions.

Environment: MS SQL Server 2005, Windows 2000/NT/XP, SSIS, SSAS, SSRS, T-SQL, Query Analyzer,VB.NET, XML, ETL, Microsoft Visio, Erwin

Confidential

SQL BI Developer

Responsibilities:

• Involved in development of multiple downstream projects for Shell, fixing performance issues, defects, deployment.
• Received ‘Feather in my cap’ award and ‘Thanks a Zillion’ award for multiple projects.

Environment: MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer