SUMMARY:

• A result driven software professional with 9 plus years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2016/20014/2012/2008 , SSIS, SSRS and SSAS(Tabular and Multi - dimensional(MDX)).
• Microsoft Certified Database Developer
• Trained in Agile Methodologies for project management.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Extensive knowledge in working with Web API Sources (Service Now, Workday and SharePoint etc..)
• Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design and Performance tuning.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence and Web Intelligence) and its deployment.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Worked on Web Intelligence to develop and publish thin client reports
• Extensive experience in consolidating multiple data sources into Master database.
• Experience in developing interactive reports and dashboards by making use of actions, local and global filters, table calculations, calculated fields, groups, sets, hierarchies, and parameters in Tableau.
• Experience in designing stunning visualizations using Tableau charts such as Pareto, Waterfall, Bar graphs (Stacked, Side- by- Side), Lines (Continuous, Discrete), Geo maps (Symbol, Filled), Scatter plots, Pie-charts, Histograms, Bullets, Geographic visualizations, Heat maps, and Highlight tables etc.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Extensively worked on Business Intelligence technologies like SSIS, SSRS, SSAS (Tabular and Multi-dimensional (MDX)) of MS SQL server 2008/2012/2016 , MS Project Server, SAP Data services and Business Objects.
• Good understanding in Normalization and Relational Database Management Systems.
• Analyzed existing Universe and Database to enhance the existing Universe and created new Universe.
• Maintained and Enhanced Universes based on financial database.
• Created Alerts and implemented ranking in reports.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Experience in ETL implementation using SSIS/Data Services for loading the data from Various Data sources to using Variables, Parameters and Configurations to Other destinations
• Proficient in creating diverse types of reports such as drill down, sub reports, parameterized reports, interactive reports, ad-hoc reports, custom reports and formatting them using SSRS/Business Objects.
• Expertise in Analyzing and Optimizing the slow-running queries, cost-based queries using SET operations, Query plans, Statistics and Indexes
• Involved up gradation and migration from MS SQL Server 2012 to MS SQL Server 2016.
• Storing all the database objects and respective scripts in Collaborated Platform using Visual Studio Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr BI/ Azure Developer

Responsibilities:

• Created Operational reports for ServiceNow team and Finance Team
• Created Master data warehouse for Project Web Application, which helped to create One Stop Shop for Project Planning, resource allocation and Budget management.
• Created reports on top of Service now data (Incident, service requests, change management and Problem management)
• Created Solution Architecture based upon Microsoft Azure PaaS Services
• Designed solution for various system components using Microsoft Azure
• Create Web API methods for three adapters to pull data from various systems like Database, BizTalk and SAP
• Configured & Setup Azure Hybrid Connection to pull data from verities of systems.
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi POC.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Perform Peer’s Code Review to avoid any code quality issues.
• Provide Sprint Demo to client and stake holders.
• Coordinate with external teams to reduce data flow issues and unblock team members
• Trained business and end user to create ad-hoc queries that decreased dependency on IT by 90%.
• Developed database batch process to move reference data of the Traders to the Trading System. Extensively used Crystal report.
• Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for end users.
• Developed and designed the Registered Rep Systems to advance the ability of local management and compliance professionals in the process of supervision and compliance of registered representatives.
• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc. Rebuilding Indexes and Tables as part of Performance Tuning Exercise

Tools: & Technologies: Microsoft SQL Server 2014/2016, T-SQL, SSIS, SSAS TABULAR AND MULTI-DIMENSIONAL(MDX), Erwin, Team Foundation Server, SQL Profiler, Visual Studio 2014/2015/2017 , Power BI

Confidential

Sr. SQL Developer

Responsibilities:

• Responsible for PAS PAT Reporting application (Development and Production Support)
• Part of IPAF development Team (Tandem replacement project, Tandem to SQL Server 2016)
• Participated in Kick off meetings and Walk through meetings for requirement gathering.
• Developed complex T-SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Implemented T-SQL scripts, triggers, procedures, packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Identified and Implemented best practices for reporting.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created various actions in database such as action filters to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, MS Project Server and SQL Server.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Tools: & Technologies: Microsoft SQL Server 2016, T-SQL, SSIS, SSRS, SSAS TABULAR AND MULTI-DIMENSIONAL(MDX), Erwin, Team Foundation Server, SQL Profiler, Visual Studio 2014/2015/2017 , Oracle, C#.

Confidential, Denver, CO

Sr. SQL BI Developer (Data Services, BO and SQL Server)

Responsibilities:

• Designed and developed Mortgage, Credit Card, Marketing, Lender and Ad Hoc reports using SQL of Business Objects or Business Objects Universe.
• Updated and submitted reports to Broadcast Agent to be displayed on Intranet on monthly and daily basis for easy access to data.
• Consulted with Oracle DBAs and Java Developers on issues related to connectivity, tables, data corrections, data integrity and project updates that resulted in reduction of connectivity errors.
• Oversaw daily, weekly and monthly backups and developed a login system to ensure the accuracy of backups. These procedures improved quality of reports and reliability of data.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Tools: & Technologies: SAP Data Services, Business Objects, Crystal Reports, Microsoft SQL Server 2014, T-SQL, SSIS, SSRS, SSAS TABULAR AND MULTI-DIMENSIONAL(MDX), Erwin, Visual Source Safe, SQL Profiler, Visual Studio 2014/2015, Oracle, C#.

Confidential, Broomfield, CO

Data Team Lead

Responsibilities:

• Consolidation of ETL tools across the company
• Creating databases for multiple applications, such as Intranet (social networking site across the company), Inventory Management and SMIL application (LMS System)
• Replacing Plateau, a third party LMS system with house grown SMIL application
• Understanding various applications and support them with minimal effort
• We need to Sync multiple data systems in a timely fashion so that all systems will be in sync with others with a latency of <= 15 mins
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools: & Technologies: Microsoft SQL Server 2008/R2/12/14, T-SQL, SSIS, SSRS, SSAS TABULAR AND MULTI-DIMENSIONAL(MDX), Erwin, SAP Data services, Business Objects, Windows server 2008, Visual Source Safe, SQL Profiler, Visual Studio 2008/2012/2014/2015 , Oracle 10g, C#.

Confidential, Englewood, CO

Sr. SQL BI/Tableau Developer

Responsibilities:

• Involved in daily Scrum meetings and managing the user stories in providing an efficient work plan.
• Developed complex T-SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Implemented T-SQL scripts, triggers, procedures, packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Tested queries to optimize the procedures and triggers to be used in production.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS
• Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Developed dashboards, reports as per the requirements with appropriate guided navigation.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Extensively worked with SQL Server and Oracle databases for running different queries.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Actively participated in clarification meeting with the Clients.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Tool: & Technologies: Tableau, SQL Server 2012/2008/R2, SSRS, SQL, PL/SQL, SQL Developer Oracle, MS Project.

Confidential, Duluth, GA

SQL BI/Tableau Developer (Fulltime - Intern),

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS TABULAR AND MULTI-DIMENSIONAL(MDX)) 2008.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Involved in setting up and implementation of the 2008 reporting server.
• Created complex reports using SSRS 2008 from the OLAP cubes for end user analysis.
• Migrated reports from MS SQL Server Reporting Services .
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 20012 using data from a variety of sources.
• Ran and tested required queries and reports before publishing.
• Published the reports and scheduled the reports in different formats (Email, Public, folder)
• Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Created a number of complex formulas to find the capacity levels of different servers.
• Scheduled tasks to run every day to update changes in the base tables.
• Added/modified Users, Groups, folders and rights.

Tools: & Technologies: MS SQL Server 2005/2008/R2/2012, SSAS 2008, SSMS, Tableau Reporting tool admin/developer, Crystal reports XI, T-SQL, Oracle 10g, Access and Excel.

Confidential, Webster, NY

SQL Server Developer/ SSIS/ SSAS Developer

Responsibilities:

• Planned, Defined, and Designed data based on business requirement and provided documentation.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools: & Technologies: MS SQL Server 2008/R2/2005, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.3