SUMMARY:

• More than 6 years of experience in the field of Microsoft BI tools (SSIS/SSRS/SSAS), Data Warehousing and T SQL using SQL Server ( 2008/2012/2016 ).
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS packages.
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services 2008/2012/2016 (SSIS).
• Extensive experience in designing databases, writing functions, stored procedures & triggers using T-SQL.
• Specialized in creating reports such as drill down reports, parameterized reports, linked reports, Matrix Reports, Charts using SSRS in Business Intelligence development studio (BIDS) and SQL Server Data Tools in Visual Studio
• Experience in writing expressions, variables and functions and defining query for generating reports in SSRS.
• Experience in High Level Design of ETL Packages for integrating large scale data using OLE DB connection from mixed sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and Complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Proficient in Development, Debugging, Testing and Deploying Complex Stored Procedures and different Database Objects across various SDLC environments (Dev, Test, UAT / Production)
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling, DMV’s, DMF’s and other database related activities
• Experience in writing complex SQL queries involving multiple joins, temporary tables, table variables.
• Experience in optimization tools such as Index tuning wizard, SQL profiler and Windows Performance Monitor for monitoring and tuning Microsoft SQL Server performance.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2016/2012.
• Experience creating many Drill Through, Drill Down, Parameterized reports using SSRS 2008.
• Experience administering interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012/2014.
• Significant experience with data intensive visualization/analytics tools Tableau Desktop and Tableau Server & SSRS.
• Expert level capability in Tableau calculations, compound calculations to large and complex data sets.
• Extensive use of Tableau desktop and tableau server for developing highly interactive dashboards.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL Programming, Dynamic SQL, XML, HTML, Visual Basic 6.0, Unix/Perl Shell Scripting

Databases: MS SQL Server, 2012,2008R2,2008, MS Access, Oracle 10g/11g

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Tableau

Tools: & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Power Pivot, Microsoft Office, Tableau., Crystal Report, Business Object, Cognos

Programming Languages: Java, J2EE, XML, PL/SQL, HTML,JavaScript and Korn Shell

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Responsible for updating Team Foundation Server source control.
• Involved in setting up aliases with SQL Configuration Manager for team members and managing Production server permissions accordingly.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in Optimization and performance reviewing of queries and stored procedures using SQL execution plan.
• Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages.
• Constructed T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation.
• Migrated Packages of SQL Server 2012 to SQL Server 2016 as per business requirement.
• Created a data driven report which provides defects raised by testers for the release using stored procedures and scheduled it daily.
• Formatted the report layout for the requirement of the end users.
• Created SQL Server Reports for the manager to track the real time status of every project.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Generated tester workload reports which calculates tester’s performance and provides required days to complete the project on time.
• Formatted the report layout for the requirement of the end users.
• Maintained the server permissions for Active Directory groups across the team.
• Involved in embedding Power view and Tableau reports into SharePoint 2016.
• Involved Creating database linked tables in SharePoint to maintain OLTP tables dynamically.

Environment: SQL Server 2012/2016, SharePoint 2016, Microsoft Visual Studio, SQL Server Data tools, SSRS, SSIS

SQL BI Developer/Report Designer (SSIS/SSRS)

Responsibilities:

• The systems dealt with building Reporting EDW using SSIS/SSRS and Excel apart from supporting OLTP needs.
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
• Involved in writing T-SQL stored procedures, complex joins, T-SQL features like Merge commands.
• Supported Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data Flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler etc.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Involved in creating ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Deployed reports across Development, QA and Production Environments.
• Involved in Trouble Shooting Complex Reports.
• Created Large Number of Report Models for users to create their own reports.
• Involved in code reviews, change control and auditing procedures
• Developed SSRS reports such as Matrix, table, chart using complex SQL queries and stored procedures.
• Configure and maintain Report Manager and Reporting Services for SSRS
• Assist programmers with scripts, SSIS projects and troubleshoot complex stored procedures.
• Wrote windows batch files for copying files to different locations.
• Identified and troubleshoot databases issues.
• Actively handled production support for different services.

Environment: SQL Server 2012, Microsoft Visual Studio, SSRS, SSIS, Management Studio 2012, MS Office, MS Visio

SQL BI Developer / Data Analyst

Responsibilities:

• Created database from scratch, designed tables, views, procedures, indexes and functions using SQL server 2012. Developed SSIS package to integrate data from XML file, flat file, Excel and SQL server
• Performed data analyzing, wrote chart flow of business logic and specification documents
• Created tables and views for the new business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Involved in gathering business requirements and designing functional Specifications for Tableau.
• Extensive use of Tableau desktop and tableau server for developing highly interactive dashboards.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Created and Published Tableau Dashboards into Tableau Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
• Creating Users, User Groups and Projects through tableau server Web and assigned roles and permissions for Tableau users.
• Continuously interacted with users to gather the business requirements.
• Designed and developed the web forms using ASP, HTML, Front Page, VB script and java script.
• Successfully implemented physical database design in SQL Server 2008.
• Developed various stored procedure for loading data from staging database to LITES database for group, eligibility, incentive, medical claims and pharmacy claims file.
• Developed procedure for adjudicating the claims and calculating HRA balances for members.
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler and Database Engine Tuning Wizards.

Environment: Tableau, VB, ASP, IIS, HTML, VB Script, SQL Server 2008, SSRS, Crystal Reports

SQL Developer

Responsibilities:

• Created reports to meet user requirements using Microsoft SQL Reporting Services.
• Wrote and maintained SQL database stored procedures.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Extensively used SSIS transformations such as derived column, data conversion, Aggregate, Conditional split, SQL task and Send Mail task.
• Participated in project scope discussions and business requirements meetings.
• Updated requirements documentation and assist with any updates discovered during the report implementation and UAT.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports and drill-down reports.
• Generated multi-parameterized reports allowing users the ability to make selections before executing reports.
• Developed Reports for business end users using report builder with updating statistics.
• Developed an automated report subscription process using SSRS.
• Responsible to support the issues with reports on the enterprise environments (development, UAT, test and production).

Environment: SQL Server 2008, SSIS, SSRS, SSAS, Visual Studio 2008, MS Visio 2008, Windows 2007, Oracle 10g.