SUMMARY

• Having 5+ years of IT experience in Database Design, Development, Data Visualization and Business Intelligence (BI) technologies with expertise in ETL process and Reporting using SQL Server 2012/2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), and Tableau.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R2/2012 and Tableau.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Tableau.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Experience in creating Dashboards and rich interactive reports by connecting with different Datasets using Tableau.
• Knowledge and experience in developing scripts using T - SQL for querying against databases.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard and Bulk Insert.
• Excellent in Heigh Level Design of ETL, DTS Packages & SSIS Packages for integrating data using an OLEDB connection from heterogeneous sources like (Excel, CSV, Oracle, Flat File, Text Format, Data) by using multiple transformations provided by SSIS such as Data Conversion, Condition Split, Bulk Insert, Merge and Union All.
• Great ability to create and manage various database objects like tables, and Views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Performance Tunning and Query Optimization.
• Experience in designing Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports.
• Hands on experience in Creating Start Schema and Snow Flake Schemas.
• Worked in Agile and Scrum environments and provided daily and weekly status updates to higher management. Worked closely with stakeholders for gathering requirements.
• Strong expertise and knowledge in RDBMS including Normalization of Database Schema, writing Stored Procedures, User Defined Functions, Triggers, Views, and Joins in SQL Server 2008/2012/2014.
• Excellent analytical, communication, problem solving skills, strong teamwork orientation, dedicated to quality output for the team or to individual assignments as required by the work environment. Self Starter, willing to learn new technologies, the ability to learn fast, and determined to achieve.

TECHNICAL SKILLS

Reporting Tools: Tableau, SSRS BIDS, SSIS-ETL, SSAS

Databases: MS SQL Server 2014/2012/2008 , Oracle 12/11

Programming Languages: C, C++, Core Java, Python

Web Development: HTML, CSS, XML, JavaScript

Operating Systems: Windows, UNIX, LINUX

Other Tools/Packages: MS-Office, Adobe Photoshop, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Involved in full life cycle of the project from requirement gathering, analyzing, designing, implementing, testing and deployment using the AGILE Methodology.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Costs, Partners, Customers, and Service Hierarchy etc.
• Worked with data migration. Used tools like SQL Server integration services (SSIS) in transferring data from one database to another.
• Created Database objects like Tables, Stored Procedures and Triggers in SQL Server 2012.
• Created complex Stored Procedures and Formulae that bring the data from the database onto the reports.
• Extensively used to join, and Sub-queries for retrieving the data from multiple tables and databases.
• Analyze the query plans to enhance the performance of SQL queries.
• Worked on Exception Handling with Try/Catch blocks.
• Involved in maintaining of existing clubs.
• Generated reports by using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Extensively used audit functions and exception handling for catching and reporting errors in SSIS packages.
• Created SSIS packages for importing and Cleansing.
• Using SSIS extract and import the XML file data into Database using XML data flow task. Used import and export wizard SSIS for importing the excel file and database tables to another Database server.
• Scheduling the reports and stored procedures on weekly and monthly basis using SQL Agent.
• Generated ETL packages to extract data from various data sources, including Falt Files, XML files, Excel files, and SQL Server and the extracted data to be loaded into the destination.
• Performed the various Event Handler for Custome Handling using Store procedures for various events like On warning, On Task failed, and Execution of Tasks.
• Created the SSIS packages with security to perform the execution, maintaining, and monitoring the tasks.

Environment: SSRS, SSIS, SQL Server 2008/2012, Excel, CSV files, Windows 8.

Confidential, Hanover, MD

Tableau/SSRS/SSIS Developer

Responsibilities:

• Involved in gathering the requirements, preparing low level estimates, analysis, design, implementation and testing and deploying of reports.
• Interacted with business users for requirement gathering, analysis and grooming.
• Designed and deployed rich graphic parameterized visualizations with drill down and drop down menu options using Tableau.
• Created side by side bars, scatter plots, stacked bars, heat maps, filled maps and symbol maps according to deliverable specifications.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created aggregations, calculated fields, table calculations, percentages using Key Performance Indication (KPI).
• Used Python programming along with Data Extract API for creating Tableau Data Extract (TDE) files to create data sets from external web services.
• Used Tableau JavaScript API to integrate tableau screens into ISD web application.
• Administrated Tableau server, data content and report distribution. Created users, groups, projects, Data connections, settings as Tableau administrator.
• Maintain server activities, user activity, and customized views for server analysis.
• Involved in installing tabcmd to schedule the report’s and setup email reports using command line.
• Responsible for deployment of the reports to higher environments and resolving any post-deployment issues.
• Created complex SQL queries to get the required data from multiple tables while maintaining performance has high priority.
• Extracted data from various data sources, including MS SQL server, Oracle, Excel spreadsheets, XML, CSV etc.
• Worked with Business Intelligence Development Studio (BIDS) SSRS to develop new reports and maintain legacy reports.
• Worked with ETL tool SQL Server Integration Services (SSIS) and created packages for transferring data across different databases.
• Provided estimates, daily & weekly status updates to the client on progress of the tasks.
• Documented the procedures, solutions for issues and best practices on SharePoint.

Environment: Tableau, SQL Server 2012, Oracle 11/12, Windows 7.

Confidential, Saddle River, NJ

MSBI Developer/SSRS/SSIS

Responsibilities:

• Created and executed SQL Server Integration Service (SSIS) packages to collect the data from different data sources and also created packages for different data loading operations for many applications.
• Design, code, test, debug, and document complex database programs to ensure that data processing production systems meet user needs.
• Created and modified the existed Stored Procedures, Triggers, and Views.
• Tested queries to optimize the procedures and triggers to be used in production.
• 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 other formats.
• Created various SSIS packages using different Datasources like XML files, Flat files, and Excel Sheets, and SQL Server etc.
• Created and Deployed the OLAP cubes using SQL Server Analysis Service (SSAS).
• Defined measures, dimensions, and attributes for building the OLAP cube in SSAS.
• Involved in performance tuning and Query Optiization.
• Designed and implemented Parameterized and Cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server.
• Created and managed the databases in the development environment.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, OLAP, ETL, Data Mart, Query Analyzer, and MS Office 2003.

Confidential, Dallas, TX

SQL BI Developer/SSIS/SSRS

Responsibilities:

• Involved in full life cycle of the project from requirement gathering, analyzing, designing, implementing, testing and deployment using the AGILE Methodology.
• Created databases and schema objects, including tables, indexes and applied constraints, connected various applications to the database, Stored procedures, and triggers.
• Used Query Analyzer to optimize SQL Queries.
• Experience with Data Migration between heterogeneous sources such as flat files, Excel, SQL Server 2008 using SSIS, and Bulk Insert.
• Generated reports from cubes by connecting to SQL Server Analysis Service.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed, and Deployed reports in MS SQL Server environment using SSRS.
• Created the automated processes for the activities such as database backup process and SSIS packages run sequentially using SQL Server Agent job.
• Developed the SQL Server Integration (SSIS) packages to transform data from SQL 2005 to MS SQL 2008.
• Created reports from Web Services and used MDX on cubes in SSAS to create reports in SSRS.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Deployed SSIS packages into Production and using Package Configuration to export various package properties to make package environment independent.
• Designed SSRS reports with Subreports, Dynamic Sorting, Defining Data Source, and Subtotals for the report.
• Extensive knowledge working with SSRS, SSIS, SSAS, OLAP, Database, and Data Modeling.

Environment: ; SQL Server 2008, SSAS, OLAP, MS Access, Visual Studio, and SSRS.