SUMMARY:

• Over 9+ years of IT experience in design, development, implementation of Business Intelligence and Data Warehouse applications using MS - SQL Server, SQL BI Stack, Tableau in various Industry verticals like Insurance, Healthcare, Banking and Financing sectors.
• Experience working in all phases of Software Development Life Cycle (SDLC).
• Expert level skills in data modeling, data mapping and table normalization.
• Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Worked extensively on writing T-SQL queries and creating complex stored procedures.
• Worked on different database programming concepts such as DDL and DML commands, Tables, Views, Constraints, Joins, Variables, CTEs, subqueries, Stored procedures, Functions, Triggers, Indexes, Locks and Error handling methods.
• Extensive experience working on design and coding of ETL (Extraction, Transformation and Loading) processes from different source systems (Excel, Flat files, XML files, Oracle, DB2, MS Access, etc.) into Data Warehouse using SQL Server Integration Services (SSIS).
• Experience using different SSIS transformations like data flow, lookup, merge join, for each loop and sequence containers, script component, file system and FTP tasks, break points, check points, error handlers, email task, change data capture (CDC) and slowly changing dimensions (SCD).
• Experience in creating, deploying and processing SSAS cubes.
• Worked on different SSAS objects like dimensions, measure groups, hierarchies, KPIs and writing MDX queries.
• Expertise in creating reports using SQL server reporting services (SSRS), like: ad-hoc, drill-down, drill-through, cross-tab, sub-reports, tabular, matrix, linked reports, cascaded and parameterized reports.
• Experience in creating SSRS reports using report builder and report designer and deploy them on to report server as well as share point.
• Experience working with Tableau desktop and Tableau server for creating various visualizations, datasets, data extracts, and visual dashboards.
• Experience in creating performance metrics, filters, sets, groups, parameters and calculated fields in Tableau.
• Experience in creating and publishing various types of reports including but not limited to bar charts, pie charts, area charts, bubble charts, Cross tabs, heat maps, tree maps, filled and symbol maps, scatter plots, trend lines and histograms using Tableau.
• Experience with database administration (DBA) activities such as backups, restores, and security and data transformation services for both OLTP and OLAP databases.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server (2014/2012/2008/2005 ), Cognos and Tableau software.
• Experience in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS)
• Hands on experience with other databases like Oracle, MySQL, Teradata and Access.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Experience supporting on going production processes and documenting different flow processes both for ETL and reporting projects.

TECHNICAL SKILLS:

BI Tools: SQL BI(SSIS/SSAS/SSRS), Cognos, Tableau

ETL Tools: SSIS, Talend and Informatica

Data Modeling Tools: Erwin, ER Studio and Visio

Databases: SQL Server, Oracle, DB2, Teradata, MySQL and Access

Languages: T-SQL, PL/SQL, C, Unix, Perl, Java, VB.Net and C#.Net

Other Tools: MS Office Suite, Visual Studio, BIDS, SQL Server data tools (SSDT), SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

BI Developer (SSIS/SSRS/Tableau)

Responsibilities:

• Designed, developed and implemented business intelligence solutions for different projects.
• Involved in gathering the requirements and creating data models.
• Designed ETL processes to extract, transform and load data from various sources across the enterprise to data warehouse.
• Developing efficient SSIS packages for processing fact and dimension tables using various transformations.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel and MS Access.
• Implemented slowly changing dimensions to load historical data.
• Implemented full and differential load processes using SSIS transformations like dataflow look up, merge join and SCD transformations.
• Created Database objects - Tables, Views, Constraints, Functions and store procedures.
• Used different T-SQL concepts like CTEs, joins, subqueries, temp tables, table variables, aggregate and analytical functions for creating complex stored procedures.
• Design and implementation of Security Model, Policies and Procedures.
• Used SQL profiler and query execution plans to optimize the T-SQL queries.
• Worked on rebuilding and reorganizing the Indexes as part of performance tuning exercise.
• Monitored error logs/Scheduled tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Deployed the SSIS packages and stored procedures to Test and Production environments.
• Scheduled and monitored the ETL packages for daily load in SQL Server job Agent.
• Designed, developed and deployed various analytical reports using different datasets in Tableau.
• Worked on creating various data visualizations like bar chart, pie chart, scatter plots, maps, trend lines, heat maps and histograms using Tableau desktop and Tableau server.
• Migrated workbooks from Tableau9.2 to Tableau10.0
• Worked on installing, configuring and managing tableau software.
• Creating Tableau live and extract datasets and schedule the data extracts as per business needs.
• Created different SSRS reports like tabular, cascaded parameterized reports, drill-down and drill-through reports.
• Deployed different SSRS reports on to report server and schedule them daily, weekly or monthly based on business need.
• Involved in debugging and validating the deployed reports.
• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration projects.
• Created and documented source to target mappings, business requirements and technical specifications.
• Worked in Agile/Scrum environment and used TFS (team foundation server).

Environment: MS SQL 2016/2014/2012/2008, SSIS, SSRS, Sql Server Management Studio (SSMS), Tableau9.2, Tableau 10.0, Tableau Desktop, Tableau Server, SSDT, Visual Studio, Visio, MS office, C#.Net, Business Intelligence Development Studio, Team Foundation server (TFS).

Confidential, Pittsburgh PA

SQL BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Analysis of the business requirements and specifications provided by the client.
• Designing the data ware house system to maintain periodic data.
• Designing, managing and publishing various dash boards, score cards using SQL Server Reporting Services (SSRS).
• Data migration from text and excel files to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integration in SSIS.
• Developed Query for generating drill down and drill through reports in SSRS 2008 and prepared ad-hoc reports through report builder.
• Data migration using SQL Server Integration Services (SSIS) across different databases like Oracle, MS access & flat files.
• Implemented breakpoints check points and error handlers in SSIS packages.
• Created stored procedures, triggers, indexes, rules, integrity constraints, cursors, views and ad-hoc queries for the business logic.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Involved in converting existing DTS packages to SSIS packages (.dtsx).
• Wrote parameterized queries for generating sub reports, matrix reports using expressions, and functions, sorting the data, defining the data source and subtotals for reports using SSRS 2008.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Created SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Creating SSIS packages for archiving data and data migration.
• Maintained all the versions of the files and packages using the SVN source control tool and updated it as when required Scheduling SSIS packages through windows Scheduler and supported production activities and operations.
• Involved in ER diagrams and mapping the data into database objects.
• Created linked servers for data retrieval using OLE DB data sources and providers.
• Wrote distributed queries for linked servers.
• Working experience designing and validating Crystal Reports.
• Designed and analyzed a few databases (payments and follow up).
• Involved in analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed both logical and physical data models in Erwin and ER Studio.
• Scheduled jobs and alerts using SQL Server Agent.

Environment: SQL Server 2008, SSIS, SSRS, SQL Server Management Studio, T-SQL, ETL, Visual Studio 2008, VB.Net, Active X, .net, Microsoft Source safe, SVN, Erwin, MS Access, Windows 2003, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor

Confidential, SFO,CA

SQL Server Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, dataquality analysis.
• Created database objects such as tables, views, stored procedures, indexes.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Designed data models using Erwin.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Expert in working with BIDS, which includes SSIS, SSRS.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Reported Bugs using ALM Defect Tracking Tool.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Worked with a team of software engineers developing business analysis tools in an n-tier/object oriented environment with Visual Basic 6.0, XML, Excel, and Microsoft Access.
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services-SSAS
• Scheduled report and exported in PDF format.
• Responsible for monitoring, truncating and shrinking the log spaces and files used on the database level in SQL SERVER 2008
• Understanding and involved in the process of Data Migration.
• Unit Testing and Deployment.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS,C#.Net, SQL Server Management Studio, ASP.NET(2.0), T-SQL, ETL, Oracle 10g, DB2, Erwin, Active X, .net, Microsoft Source safe, MS Access, Windows 2003

Confidential, WA

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Worked on RDBMS database management system to create and maintain the Databases.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Created indexes for the fast retrieval of data from the database.
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Created Triggers to enforce data and referential integrity.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures.
• Created and designed reports based on query parameters and Report parameters
• Experienced in nested Grouping, sorting columns and writing expressions according to the business requirements.
• Experience in setting report parameter properties. Determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time.
• Created views to restrict access to data in a table for security.
• Responsible for monitoring, truncating and shrinking the log spaces and files used on the database level in SQL SERVER 2008.
• Deployed reports in the solution explorer and opened through browser.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS 2008).
• Supported Application Development team with any database issues, updates or new releases. anddeadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, ASP.NET (2.0), T-SQL, ETL, Oracle 10g, DB2, Active X, .net

Confidential, Chesapeake,VA

SQL Server Developer

Responsibilities:

• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in Requirements gathering, Analysis and design of all the client requirements.
• Involved in designing, testing disaster recovery model & implementation.
• Designed physical development databases on SQL 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in developing database for contract maintenance system.
• Enhanced database structures as per the business requirement which is applicable for the system.
• Developed and maintained data, procedures and performed Data Impact Analysis.
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Coordinated and assisted with the Front-End Developers in handling & solving bugs.
• Working Experience with lotus notes, same time software to communicate with in the environment.
• Created Jobs, Scheduling the jobs according to the client Requirements and monitoring the jobs .
• Using SSIS Package Calling Stored Procedures that would aggregate the data and load them in globally temporary table.
• Performing Unit testing and Integration Testing.

Environment: SQL Server 2005, SSIS, SSRS, C#.Net, ASP.NET(2.0), T-SQL, ETL, Oracle 10g, DB2, Active X, .net

Confidential, Springfield,VA

SQL Server developer

Responsibilities:

• Hands on experience in writing advanced programming using skills in Microsoft Expressions including Adobe Illustrator.
• Created various business process modeling diagrams based on the foundations laid down by Rational Unified Process to demonstrate software architecture and interaction of system components using Rational Rose, Requisite Pro for requirement traceability.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Responsible for the front-end design, analysis, development and testing of BCAS in Visual Basic 6.0, with reporting in SSRS Reports, data retrieval using stored procedures in Transact SQL on a Sybase 12.5 database.
• Expertise in developing, validating and optimizing SSRS reports using Business Intelligence.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked with a team of software engineers developing business analysis tools in an n-tier/object oriented environment with Visual Basic 6.0, XML, Excel, and Microsoft Access.
• Working Experience with Microsoft outlook and Microsoft Communicator
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2000/2005.

Environment: Reporting Services (SSRS), MOSS 2007, SQL Query Analyzer, SQL profiler and Enterprise Manager