SUMMARY

• Having 8 plus Years of IT experience in Microsoft Database Technologies with various Industry like IT - Hardware/Networking, IT-Software, Utilities, Insurance, Mining and Manufacturing as a BI Developer in SAP Data services, Business Objects and MS SQL SERVER 2012/2008/2005 Databases in Windows environment
• Microsoft Certified T-SQL Developer
• Trained in Agile Methodologies for project management
• 8+ years of IT/BI experience with over 3+ years of solid experience of Tableau in the fields of Business/Data analysis, Report Development, ETL Development, and Data Modeling.
• In depth knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies such as Waterfall, Iterative and Incremental, Evolutionary prototyping, and Agile.
• 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.
• Excellent communication skills, analytical skills, understand business requirements in various domains, self-learning ability and leadership quality
• 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 of MS SQL server 2005/2008/2012 , MS Project Server, SAP Data services and Business Objects.
• Good understanding in Normalization and Relational Database Management Systems.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• 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.
• Involved in ETL Process of pulling data directly from different source systems like flat files, Excel, Oracle, MS Project Server and SQL Server.
• 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 different 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.
• Involvedin creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
• 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 2005 to MS SQL Server 2008.
• Storing all the database objects and respective scripts in Collaborated Platform using Visual Studio Team Foundation Server (TFS).

TECHNICAL SKILLS

Reporting Tools: Tableau, SSRS, Crystal Reports, Business objects

ETL Tools: SSIS, SAP Data Services, T

Databases: Teradata, Oracle 118i/9i, DB2 UDB, MS-SQL Server, Sybase

Requirements Management: Requisite Pro, Microsoft Office (Word,PowerPoint, Excel and One Note)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: Visual Source Safe 6.0, Share point, TFS 2015

Defect Management tool: HP Quality Center

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, Waterfall, Agile, Iterative

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Languages: C, C++, C#, .NET, SQL, PL/SQL and Java

Operating System: Windows

Web Applications: HTML, Perl, XML and JavaScript

Scheduling Tools: Control M, AutoSys, ESP Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

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
• ImplementedT-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.

Confidential, Denver, CO

Technical Consultant

Responsibilities:

• Reviewing project deliverables
• Participated in Kick off meetings and Walk through meetings for requirement gathering.
• Responsible for installing the software and setup configuration for Business Objects.
• Created Classes, Objects, Joins and Complex Conditions for each universe with specific naming conventions for each Functional Unit.
• Implemented best software engineering practices for gathering functional and non-functional specifications.
• Facilitated the Requirements Phase for multiple, simultaneous projects
• Studied Business process of client corporations to suggest improvements to be included into To-Be system
• Developed business process models.
• Participated in BODS training in Confidential
• Recommended processes for consolidation of data form different databases.
• Reviewing project deliverables
• Participated in Kick off meetings and Walk through meetings for requirement gathering.
• Responsible for installing the software and setup configuration for Business Objects.
• Created Classes, Objects, Joins and Complex Conditions for each universe with specific naming conventions for each Functional Unit.
• Made changes, expanded, enhanced exiting universes by adding tables (Fact and Dimensions), conditions(@select, @prompt, @where), resolving loops using contexts and alias’s.
• Developed reports using sub queries, optional prompts, drill filters, ranking, dynamic calculations, and hyperlink to link the reports and merge dimensions.
• Tuned universes to improve the performance by using Index awareness, aggregates.
• Used Central Management Console for deploying and managing the reports.
• Extensively worked on reports that contained several parameters.
• Expertise in converting DESKI (Desktop Intelligent) reports to WEBI (Web Intelligent) using Report Conversion Tool.
• Created reports using Business Objects functionalities like Drill Down.
• Created graphical representation of reports such as Bar charts, Line graphs and Pie charts etc.
• Conducted the team meetings for discussing the status and issues.
• Provided high level documentation on each universe and report along with the functionalities
• 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.

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 spread sheets intoSQL Server2008 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.

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
• ImplementedT-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.

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

Confidential, Duluth, GA

SQL BI/Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe 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 forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby 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) 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.

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.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• 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.