SUMMARY:

• 6+ years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2012/2008/2005 on various development, test and production environments in various business domains.
• Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes, Dynamic SQL, joins, Cursors, CTE and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2012/2008/2005 .
• Highly proficient in Tuning SQL queries and improving the query performance.
• Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Developed reports using global variables, expressions and functions.
• Expert in Creating and managing roles for security in SSRS reports.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and creating report layouts using SSRS 2012/2008.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Conditional, List items, Charts, Sub reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created various Complex Formula Reports to query the database for business Intelligence.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
• Expertise with parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008/2012.
• Experience in creating data driven subscriptions in Report Manager.
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
• Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates like Named Set, MDX Query and Custom Table.
• Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports in Performance Point.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions & MDX Queries using SQL Server 2012/2008 Analysis Services.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Experience using different Version Control Tools like Microsoft Source Safe and TFS.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), BIDS

Databases: MS SQL Server 2012/ 2008/2005/2000/7.0 , MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS) 2012/20, SQL Server Analysis Service (SSAS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Data Modeling Tools: Erwin, Visio

IT Processes: Software Development Life Cycle (SDLC), Project Management

Other Software: MS Office- 2007/2003/2000 , MS Excel, MS Access, MS Project

Operating Systems: Windows 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

SQL/BI (SSIS, SSRS, SSAS/Tableau) Developer

Responsibilities:

• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracles to SQL Server.
• Moved Data from flat files and Excel sheets using SSIS.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Created packages using Error handling mechanism and used variables to handle package dynamically.
• Moving data to staging tables using SSIS.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Developed complex reports using SSRS for HR and other Business users.
• Extensive experience in the development of Reports using SQL Server 2005, 2008 R2 reporting services.
• Designed and maintained Tableau 5.1 reports used to graphically analyze business data.
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Generated Tableau Dashboards with Oracle Essbase multidimensional database. Used filters, quick filters, sets, parameters and calculated fields on Tableau reports
• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Designed data warehouse with required facts and dimensions using Star schema.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transform.
• Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created reports that call Sub reports in SSRS.
• Responsible for the deployment of the Cube on the SSAS.
• Designed reports in SSRS with the use of data from SSAS cube (MDX) and DW database.
• Created Ad hoc reports using SSRS.
• Handling the orphan rows in Dimension and Fact tables.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
• Extensively worked with Team Foundation Server (TFS) 2012.

Environment: MS SQL Server 2012/2008R2, T-SQL,SSIS, SSRS,SSAS, SQL Profiler, Rapid SQL (2016), Visual Studio (2012), Tableau 5.1,Team Foundation Server (2012), Windows XP / NT / 2000/2003, MS Office 2003/2007,.Net.

Confidential, Pittsburg, PA

SQL / BI (SSIS, SSRS) Developer

Responsibilities:

• Extensively worked on designing reports using SQL Server Reporting Services.
• Worked on SSRS 2012 to generate about 80+ reports for various Business user groups.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS
• Developed various dashboards , used context filters, sets while dealing with huge volume of data. Used excel sheet, flat files, CSV files to generated Tableau adhoc reports .
• Performed the Migration the Existing DTS packages to the SSIS Packages.
• Created stored procedures to use as the datasets for the Report Design.
• Analyze the client requirements and translate them into technical requirements.
• Designed and built DTS/SSIS packages and ran several scripts for implementing changes in the backend for applications.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa. Used SSAS in BIDS to create new facts and dimensions.
• Created calculated measures using MDX implementing business requirement.
• Created and processed cubes that support new organization structure.
• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Developed Applications using VB.NET, C# with SQL Server, Oracle and Microsoft Access as databases using ADO.Net and LINQ Components.
• Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls and CSS.
• Developed the end-user documentation and performed periodic updates of the design documents.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, Windows Server 2003, Visual Source Safe 6.0, VB.NET, LINQ, Tableau 5.1, VB.net, MS- Access.

Confidential, Providence, RI

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Expertise in BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS) and Pervasive Data Integrator (V.10)
• Created queries with Inner Join, Outer Join, left join, right join and Co-Related sub-query with Mathematical function, Aggregate function.
• Extensively used Joins, sub-queries for complex queries involving multiple tables from different databases.
• Used various SSIS tasks such as Conditional Split, Derived Column and Slowly Changing Transformation which were used for Data validation checks during Staging.
• Responsible for creating SQL Server Drill down and Drill through Reports using SSRS to fit business requirements, and implemented into SQL Server 2008.
• Expert in creating simple and parameterized reports involving Sub reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business Intelligence development studio (BIDS)
• Created Datasets, Maps, also and Process using Pervasive Data Integrator. Handled pipe delimited files, fixed format files in pervasive data integrator.
• Deployed the pervasive process to production servers and scheduled the process to run daily, weekly, monthly.
• Generated tableau dashboards with quick filters and sets for ICD9 codes connecting to Oracle Database.
• Generated adhoc Tableau reports on demand for providers.
• Generated Tableau reports with Trend lines.
• Generated Tableau Dashboards with Oracle Essbase multidimensional database. Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Performed incremental extracts for OLAP database.
• Handled production issues and resolved them to meet the deadline
• Experience working in formal life cycle methodologies i.e., agile.
• Capable of functioning in an agile development environment, at times extracting data to enable discovery to help refine report specifications.
• Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
• Effectively used TFS to update user stories and tasks to show the performance.

Environment: SQL server 2008r2, SSIS 2008, SSRS 2008, Action Pervasive Data Integrator (V.10), Visual Studio Team Foundation Server (TFS) 2013.

Confidential

SQL Server Developer/SSRS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Created database triggers to implement business requirements.
• Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spreadsheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Managed up gradation of DTS packages to SSIS packages.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in designing high level dashboards according to business requirement using SSRS 2005.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc. Experienced in developing stored procedure driven reports, building custom application on reports and formula writing/editing in reports.
• Created report models for ad-hoc reports using SSRS 2005
• Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2005.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

Environment: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SSRS. SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.