SUMMARY

• Over 7+ years of IT industry experience in Microsoft SQL Server SSIS/SSRS (MSBI), OLTP and OLAP Data warehousing environments.
• Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Databases including SQL, MS Access at gathering and manipulating data from various sources.
• Expertise in Business Intelligence Solutions like ETL & Reporting using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Experienced in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
• Experienced in writing complex SQL Queries, Stored Procedures, Functions, Views, Triggers, and Cursors for discrete business applications.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Snow-Flake Modeling and Star Schema Modeling.
• Experienced in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experienced in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in conversion of packages from legacy systems and migrating, deploying the packages across production environment.
• Experienced on Tableau activities, Multidimensional database and writing SQL queries.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
• Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Have good understanding of Tableau architecture, design, development and end user experience.

TECHNICAL SKILLS

SQLServer Tools: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0, MSSQL Server Reporting Services (SSRS)

Packages: MS Office, Microsoft Office Suit

Reporting Tool: Crystal Reports, SQL Reporting Services and Actuate E-Reporting, Tableau developer

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Data Modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Languages: T-SQL, VBA

Operating Systems: Windows Variants

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. SQL Developer/ Power BI

Responsibilities:

• Developed PowerBI model used for financial reporting of P & L and Headcount.
• Writing complex DAX functions in Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into power pivot model.
• Created SSIS packages to pull Headcount data and load into power pivot model.
• Deployed power pivot model to SQL server Analysis services tabular instance.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Documented the entire workflow and processes involved in the Financial Reporting PowerBI Solution.
• Handled Finance close week reporting activities.
• Trouble shooting and resolving close week issues in the reports. These vary from identifying missed data, updating DAX functions and modifying SSIS packages.
• Worked on automating statistical financial reports. Reports included various graphs. Those graphs were used to identify unusual trends in budget forecasting.
• DevelopedSQLServer Stored Procedures, TunedSQLQueries (using Indexes and Execution Plan).
• Developed User Defined Functions and created Views.
• Created Triggers to maintain Referential Integrity.
• Prepare detailed statistical reports in MS Access and MS Excel to track the progress of weekly, monthly and quarterly customers and sales growth.
• Tuned and OptimizedSQLQueries using the Execution Plan and Profiler.Rebuilding Indexes and Tables as part of Performance Tuning Exercises.
• Ensure that the designs are consistent with the overall architecture for Business Intelligence
• Ensure that all SDLC and release management methodologies are followed.
• Used SSIS to transform / import data inSQLServer from different sources.

Environment: SQL Server 2014,SSIS, SSRS, ETL, Agile, Business Intelligence Design Studio, MS Office 2016, Windows 10

Confidential

SQL Developer, Business Reporting Analyst

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 withinTableau Desktop.
• Created views inTableauDesktop 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 onTableauserver.
• 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 inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: SQL Server 2014, SSIS, SSRS, ETL, Agile, Business Intelligence Design Studio, MS Office 2016, Windows 10

Confidential, New York, NY

SQL Developer/ Tableau/ Power BI

Responsibilities:

• Responsible for understanding and gathering business requirements and prepare interactive data visualizations inTableaudesktop and providing BI Solutions to the management for strategic decision making.
• Responsible for extracting data inTableaufrom Oracle database.
• Analysis of sales for each group/department, over different dimensions like Region, sssUnits, Organizations.
• Creating dashboard that navigates to the Detail dashboard for specific drill down Analysis.
• Plot Geographical maps like Filled Map and Symbol map.
• Worked on detail level analysis of each product and transport to give top performingproducts and the correlation between the quantity and sales is designed using scatterplot.
• Creating user filters at organization level.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Migrated DTS packages from and to 2012 SQL Server and modified Stored Procedures to comply with the current versions of SQL Server.
• Gathered requirements from business team and created technical specification documents
• Created Request for Change (RFC) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Written different T-SQL scripts for automated execution of the tasks, Review T-SQL code to verify it meet standards for both performance and error handling
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
• Worked on Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Leveraging frameworks such as continuous integration and development to enable the rapid delivery of working code.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.

Environment: MS SQL Server 2008 R2, Reporting Services (SSRS), Integration Services (SSIS), Microsoft SharePoint Server, T-SQL, .NET

Confidential, Naperville, IL

SQL Developer

Responsibilities:

• Create a Data Model while importing data, or from the Excel tables in the workbook.
• Data tables in the Data Model can be viewed either in Data View or Diagram View.
• Develop and implement data collection processes to improve and/or ensure data quality.
• Filter and clean data collected from different sources.
• Identify process improvement opportunities in the data analysis space.
• Worked extensively with the users, different levels of management; conducted formal interviews and JAD sessions to identify requirements, functional specifications and database specifications.
• Took participated in designing the dimensional model and 3NF model in Visio.
• Designed and developed SSIS Packages to extract, cleanse, transform and load data from OLTP into data warehouse.
• Used slowly changing dimension to monitor changes, add derived column to extract required information.
• Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent including Scheduled Jobs
• E-mail Notifications, Error Alerts and Error Logs as required; configured SQL mail agent for sending automatic emails with Success/Failure reports to assigned recipients.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010 (SSIS, SSAS), Windows 7, MS Office 2010, MS Visio 2010, SharePoint 2010

Confidential, Long Beach, CA

Jr. SQL Developer

Responsibilities:

• Designing and creating SQL Server tables.
• Assisting in SQL Server optimization including indexing and query optimization
• Assisting in transferring databases, including Tempt to new servers using TSQL scripts
• Writing SQL Server stored procedures using TSQL
• Writing, updating and supporting reports using TSQL
• Analyze end user database needs and provide efficient solutions Editing XML
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in creating data element maps between two distinct data models.

Environment: MS SQL Server 2008R2, OLTP, Business Intelligence Development Studio, Visual Studio 2010, SQL Server Profiler, SQL Server Management Studio, Excel, TFS, Windows XP.