SUMMARY

• Specialized SQL Developer with over 7 years of IT experience in database on design, development, and maintenance, using the tools of MS SQL Server 2012/2008R2/2008
• Expertise in data Extraction, Transformation, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS)
• Over 3 years of experience in data visualization, Reporting and Analysis using various BI tools including Tableau, SSRS against multiple data sources for What if Analysis, Interactive, Decision Support and other purposes; Familiar with Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Superior knowledge in all phases of Software Development Life Cycle (SDLC) process, Process Documentation, Data Organization, System Documentation, and Report Writing
• Strong knowledge OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data Warehouse / Data Marts
• Adept in designing and developing - including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import / Export, Triggers, Cursors - Database objects such as Tables, Schema, Indexed Views and User Defined Functions, etc.
• Strong proficiency on SQL Server suite of products like SSIS, SSRS, SQL Server Management Studio (SSMS)
• Highly skillful in Data Conversion and Data Migration using SSIS services across different databases like Oracle, DB2, flat files and excel files
• Superior involvement in creating reports using Grouping and Sorting and creating Sub Reports, Cascading Parameters Report, Drill-through Reports, Parameterized Reports, and using SQL Server Reporting Services(SSRS)
• Exceptional performance in deploying SSIS projects using Integration Services Catalogs and SQL Server Agent, deploying SSRS projects to Confidential report server
• Proficient in Database performance optimization, debugging and tuning using the SQL Profiler, Database Engine Tuning Advisor and SQL Server Debugger.
• Leading experience in using Tableau to create well-formatted report using existing data-warehouse
• Excellent problem solving skills with strong ability to efficiently implement database solutions to accomplish all critical business objectives

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2008R2/2012, MYSQL Server

Database Services: Server Integration Service (SSIS), Server Reporting Services (SSRS), Server Analysis Service (SSAS)

Data Tools: SQL Server Management Studio (SSMS), SQL Server Migration Assistant (SSMA), Microsoft Visio, Tableau

Programming: T-SQL, Java, Scala, C#, Matlab, Python

Version Control: Team Foundation Server (TFS), SharePoint, Github, Jira

Development Tools: Eclipse J2EE

Document Tool: Microsoft Office Suite

Operating Systems: Windows/2000/XP/Vista/7/8/10

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

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

Responsibilities:

• Participated in scrum meeting and sprint meeting to coordinate with software development life cycle process; involved in Confidential global team environment.
• Gathered requirement from team lead and studied previous documents
• Extracted data from FTP server and internal website using Sequence Container, Execute SQL Task, Stored Procedure
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), and DML Triggers to support incremental loading packages
• Optimized existing stored procedure by monitoring through SQL profiler, Query Analyzer
• Involved in developing initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Report Requirements/Unit Testing Document and synchronized these packages/documents onto Team Foundation Server (TFS)
• Conducted Source Control in Team Foundation Server (TFS)
• Developed complex Stored Procedures in T-SQL to replace existing SSIS packages in ETL process and gained better performance
• Debugged existed Stored Procedures and SSIS packages
• Deployed & configured ETL packages and coordinated with Indian DBA teamto schedule the package in SQL Server Agent
• Involved in the process of generating reports using SSRS

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Team Foundation Server (TFS), SQL Server Management Studio (SSMS), T-SQL, MS Office, Windows 7.

Confidential, Orlando, FL

MS SQL Server Developer (SSMS/SSRS/Tableau)

Responsibilities:

• Involved in analysis of report design requirements and actively participated and interacted with Project Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Writing complex queries using Join, Pivot/Un-pivot, CTE, Window Function, Case When, Cast, Convert to extract data for reports generation.
• Created complicated reports including sub-reports, graphical reports, drill-down/through report, and formula-based/well-formatted reports according user requirements
• Conducted complicated calculation to develop KPI reports/dashboards according to clients’ requirement
• Involved in generating Weekly/Month Sales & Finance reports for internal departments by identifying the dimensions, measures, measure values
• Improved performance of existing reports through query optimization
• Perform UNIT testing and help the UAT testing team to performing various testing scenarios
• Writing and maintaining technical documentation based on business and functional requirements
• Provide technical assistance by responding to inquiries regarding errors, problems, or technical questions; train end users and technical support staff as required

Environment: SQL Server Reporting Services (SSRS), MS SQL Server 2012, SQL Server Integration Services (SSIS), Tableau7.x/8.x, SQL Server Management Studio (SSMS), SQL Server Analysis Studio (SSAS), T-SQL, TFS, MS Office, Windows 7.

Confidential, Miami, FL

MS SQL Server/BI Developer (SSMS/SSIS/Tableau)

Responsibilities:

• Involved in gathering business requirements from business users and analyzing data sources form Excel, SQL Server, and Oracle for design, development, testing, and production of reports.
• Built and maintained complex queries and scripts for data analysis and extraction.
• Developed reports on Tableau Desktop. Utilized quick filters, action filters, parameter controls, achieved functionalities such as dynamic displaying title, commentary, and corresponding records, collapse and expand table, sub-report linkage, dynamic tooltip displaying, etc.
• Migrated report solutions in Excel, Power Point to Tableau, and gained better performance and visualization
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Perform UNIT testing and help the UAT testing team to performing various testing scenarios.
• Guided and assisted end users interact with web-reports.

Environment: Tableau 7.0, Tableau Server, MS SQL Server 2008, Oracle 11g, SQL Server Integration Services (SSIS),SQL Server Management Studio (SSMS), T-SQL,MS Excel, MS Outlook, SharePoint, Windows 7.

Confidential, New York, NY

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

Responsibilities:

• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing package
• Implemented ETL packages dealing with different data sources and load the data into target data destination by performing different kinds of transformations using SSIS
• Developed complex SSIS packages using various Tasks, Containers, Data transformations like Lookup, For Each Loop and For Loop Sequence Container
• Implemented various SSIS Transformation tasks such as Conditional Split, Merge, Sort, Lookup, Aggregation, Derived Column, Dimension Processing, Slowly Changing Dimension, etc.
• Performed the Tuning of some existing ETL packages and gained 20% better performance.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), T-SQL, MS Office, Windows XP

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Involved in designing ER Diagram for the new database according to business requirements
• Performed SQL Database Development tasks - Creating stored procedures, triggers, user defined functions, index and other database objects, based on business requirements and provided documentation
• Implemented SSIS Packages to migrate data into new database from various data sources, for example flat file, excel file, SQL Server
• Designed and implemented Stored Procedures and Triggers for automating tasks
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.

Environment: MS Visio 2007, MS SQL Server 2000, Server Integration Services (SSIS), Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Management Studio (SSMS), T-SQL, MS Office, Windows XP.