SUMMARY

• Highly qualified as a MS SQL Server Business Intelligence Developer with over 7 years professional experience in designing and developing T - SQL queries, ETL packages and business reports using SSMS, SSIS and SSRS in Telecommunication, Healthcare and Financial industries.
• Extensive experience with multiple development environments including SQL Server 2005/2008/2008 R2/2012/2014, Visual Studio 2005/2008/2010 , Windows Server 2003 R2/2008/2008 R2/2012, Team Foundation Server (TFS) 2008/2010, and SharePoint 2010
• High proficiency in creating, documenting, and deploying ETL packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services (SSIS) to load data from homogenous and heterogeneous data sources into data warehouses and data marts.
• Adept in Data Conversion, Normalization and Multi-Dimensional Modeling in Enterprise Data Warehouse design.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012 (SSRS).
• Adapt in writing Parameterized Queries for generating reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using Tableau 7.0/ 8.0.
• Strong experience in T-SQL and PL/SQL coding, Performance tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Strong understanding in Logical and Physical Database design & development, Data Conversion, Normalization.
• Exceptional understanding in database creation, maintenance, monitoring, backups and recoveries.
• Specialize in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server 2005/2008/2012
• Outstanding interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Relational Databases: SQL Server 2005/2008/2008 R2/2012, Oracle 8i/9i/10g, MS Access

Tools: and Packages: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SPSS, MS Office

Reporting Tools: SQL Server Reporting Services (SSRS), Macros, Tableau 7/8

Language: T-SQL, PL/SQL, C#, Java, STATA

Operating Systems: Windows XP/7/8

Data Modeling: Visio 2010/2008/2005

Application Packages: MS Outlook, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential | New York, NY

MS SQL Server/BI Developer

Responsibilities:

• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to support ETL packages.
• Gathered requirements from Marketing department, Human Resource Department, and provided the functional and non-functional reports.
• Extracted, reviewed and transformed monthly data from various data sources (Excel, SQL, Flat File) by creating various SSIS ETL packages.
• Troubleshot and debug ETL packages using breakpoint and checkpoint to facilitate stability and reusability; use XML configuration and SQL Server table configuration to prepare deployment-ready packages.
• Utilized ETL Tools such as SSIS to implement process chain which automates data cleaning and loads data from staging area into database.
• Deployed & configured ETL packages and coordinated with DBAs to schedule the package in SQL Server Agent to run the packages every weekend and run reconciliation queries to cross-check the data.
• Involved in fine-tuning the code of Stored Procedures in SQL Server and ETL Packages in SSIS to obtain optimal performance.
• Developed dynamic GL reports: Gross Margin, Net Revenue, Operating Expenses, Summarized Reports based on the Profit Territories etc., using SSRS/Tableau. Ran the reports every month and distributed them to respective users through mailing server subscriptions and SharePoint server.
• Developed Invoices Reports, Expenditure Trend Analysis Reports, and Asset Depreciation reports using SSRS and deployed to the Enterprise Dashboard for top management.
• Developed Operational Financial Reports/Dashboards (i.e. operational income & expenditure trend analysis, AR/AP, inventory turnover reports) using SSRS/Tableau.

Environment: SQL Server Management Studio (SSMS) 2012/2008 R2, Server Integration Services (SSIS), SQL Server Data Tools (SSDT), Server Reporting Services (SSRS), MS Visual Studio 2008, MS Office (Excel, Word, PowerPoint, Visio), Team Foundation Server (TFS) 2014/2015, SharePoint 2010, Visual Studio 2012, Tableau 8.0/9.0

Confidential | Gainesville, FL

MS SQL Server/BI Developer (SSMS, SSIS, SSRS, SSAS)

Responsibilities:

• Created SSIS packages to extract data from various sources from diverse locations and loaded data into SSMS for further use.
• Designed Data Warehouse using Snowflake schema by normalizing dimensional tables.
• Designed the new Credit Risk report using Transact-SQL (T-SQL) and SSRS, illustrated by interactive reports, linked reports, sub-reports, parameterized reports and drill down, drill through reports.
• Built efficient SSIS ETL packages for processing fact and dimension tables with transforms and Slowly Changing Dimensions (SCD) to ensure the database platforms are configured, hardened and maintained to capture record changes.
• Designed and built up high performance ETL packages to migrate and manipulate data from Teradata, Oracle, MS Excel and SQL Server by using SSIS;
• Used various SSIS transformations such as conditional split, derived column for data scrubbing, including data validation checks during staging, before loading the data into the Data Warehouse.
• Applied Unit Testing on reports and dashboards to ensure data integrity as per the business requirements.
• Communicated with all lines of business and management, proactively identified cross functional or technical issues to improve application stability.

Environment: SQL Server Management Studio (SSMS) 2012/2008 R2, Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Excel 2010, Teradata, Oracle 9i/10g, Tableau 7.0/8.0.

Confidential | Gainesville FL

BI Analyst (SSMS, SSIS, SSRS, SSAS)

Responsibilities:

• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs.
• Designed and developed SSIS packages to extract data from different source files - Excel file, Flat file, Access file, CSV file, etc. into SQL Server 2012/2008R2 for further data analysis and reporting.
• Implemented various SSIS Transformation tasks such as Conditional Split, Merge, Sort, Lookup, Aggregation, Derived Column, Dimension Processing, Slowly Changing Dimension etc.
• Created complex Stored Procedures, Functions, Views, Indexes for increasing performances
• Responsible for debug, performance checks and performed index tuning and query optimization
• Generated reports to retrieve data using stored procedures that accept parameters
• Generated Drill-down, Drill-through, and Parameterized Reports using SSRS
• Constructed technical documents for the stored procedure and schema requirements

Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL, Team Foundation Server 2010 (TFS)

BI Developer, Enterprise Analytics Solution Delivery (SSMS, SSIS, SSRS)

Responsibilities:

• Gathered reporting requirements from customer meetings, ad-hoc requests, types of questions that are asked
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements
• Created queries and developed stored procedure to provide ad-hoc reports, analysis, and datasets based on business needs using T-SQL
• Designed layout of SSRS Reports such as Drill Down, Drill Through, Sub as well as Linked Reports and determined the best way to present data to end users
• Communicated with team members to provide progress of deliverables, validated data structures and best methods for delivering customer projects
• Deployed reports on SharePoint Server, scheduled the delivery of reports in different formats such as PDF, Excel, HTML and used subscriptions in SSRS to generate daily, weekly, monthly and quarterly reports
• Improved the performance of reports by optimizing data sets and making use of report caching and snapshots
• Created visualizations such as Trellis chart, Tornado charts and dual axis line charts, using advanced Tableau features like Data blending, Custom SQL, Parameters, Calculated fields, Action filters and Extracts, etc.
• Wrote and maintained technical documentation based on business and functional requirements.

Environment: SQL Server Management Studio (SSMS) 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), Server Reporting Services (SSRS), T-SQL, Microsoft Excel 2010, Oracle 11g/10g, Tableau 6.1, Excel

Confidential

PL/SQL Developer

Responsibilities:

• Create interactive dashboards combining views & reports in Tableau Desktop that were presented to Business Users, Program Managers.
• Develop database objects like Stored Procedures, Triggers, Functions, Views and Constraints by using PL/SQL environment.
• Involved in writing SQL statements using joins.
• Worked with SQL in-built functions and user defined functions which includes scalar and table valued functions.
• Implemented database management techniques that include backup/ restore, import/ export and generated scripts.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Unit testing and integration testing of any new development.

Environment: Oracle 8i/9i, PL/SQL, UNIX.