SUMMARY:

• Over Eight (8+) years of extensive experience in Microsoft BI tools (SSIS, SSRS and SSAS) and SQL Server 2005/2008/2008 R2/2012/2014 versions.
• Expertise in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012 for Batch Processing using DDL, DML, DCL commands for various business applications and Data ware - housing Systems (SSRS, SSIS, SSAS).
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins and experience in creating scheduling Jobs, sending Alerts.
• Experience in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, Oracle, SAP, and SQL Server) and loading for data warehousing using SQL Server Integration Services.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in developing management reports by using SSRS (SQL Serving Reporting Tools).
• Strong experience in creating Ad Hoc Reports, parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2, 2012 and 2014.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Knowledge in Tableau Desktop for data visualization through various charts such as Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience on GIT, Team Foundation server, Visual Studio online and the application lifecycle tools associated with it.
• Excellent communication and inter-personal skills with ability to develop creative solutions for client needs using Agile and Sprint Methodologies etc.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008r2/2012/2014

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008/2005, Tableau

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS), BCP

Languages: T-SQL, PL/SQL, C#, ASP.Net

Web Technologies: Web Services, XML, HTML

Operating Systems: Windows 98 /2003/NT/XP/7, MS DOS

Applications: MS Visual Studio 2010/2012, MS office 2003/2007/2010, XML, Visual Studio IDE

Data Modelling: Erwin Tool, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Anaheim, CA

Sr. SQL BI Developer / SSIS / SSRS

Roles & Responsibilities:

• Actively participate in gathering of user requirement and system specification.
• Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views, Cursors, CTE’s, schemas, used DDL, DML commands.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS-SQL Server by using DTS and SSIS services.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created ETL SSIS packages both design and code to process data to target databases.
• Effectively used various properties in SSIS package to improve the performance
• Used various SSIS task such as conditional split, derived column, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts.
• Maintain historical data in data warehouse used ETL to implement the slowly changing transformation.
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions.
• Created dashboards for Sales, Inventory, Production, Purchase, Quality, Capacity and Finance.
• Deployed and uploaded the SSRS reports to Report Manager and organized them into folders for the end users and involved in enhancements and modifications.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Worked on building PowerPivot DAX reports from SSAS Tabular Cubes.
• DBA activities like creating users, roles and granting and revoking privileges.

Environment: T-SQL, MS SQL Server 2017/2012/2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau, Visual studio 2012/2013/2015, Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, MS Excel, Microsoft windows server 2012

Confidential, Indianapolis, IN

Sr. SQL BI Developer

Roles & Responsibilities:

• Work closely with business users to congregate and comprehend requirements.
• Optimized the stored procedures which are using cursors and increased the performance.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Designed and worked on extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.
• Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Effectively used various properties in SSIS package to improve the performance.
• Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Developed drill down, drill through, cascaded and parameterized reports using SSRS and developed excel pivot chart reports and pivot tables.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created customized reports using various chart types like, Text Tables, Bar, Pie, Tree Maps, Heat Maps, Line Charts, Pivot Tables, Combination Charts in Excel and Tableau.
• Coordinating post-implementation events such as testing.
• Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Development experience with RDBMS such as SQL Server and ODBMS such as Geneva.

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) 2014/2010, Tableau, Visual studio 2012,2013,Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, MS Excel, Microsoft windows server 2012

Confidential, St. Louis, MO

Sr. SQL BI Developer

Roles & Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Involved in high level architectural design discussions for designing the MDF (Meta data framework) tables which store the business and patient data.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database and checked constraints to maintain data integrity.
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Worked on for each loop containers, sequence containers and used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Developed master package which calls the child packages and loads the files to stage and history tables in GDW.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Identified and defined the Datasets for the report generation and wrote the queries for the drilldown reports, sub-reports.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Created various visualizations and reports using Power Bi.
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Created report snapshots to improve the performance of SSRS.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Coordinating post-implementation events such as testing.

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2012,2013, Power Bi, Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, Erwin, MS Excel, Microsoft windows server 2012

Confidential, St. Louis, MO

Sr. SQL BI Developer

Roles & Responsibilities:

• Worked in AGILE methodology in development of Database Objects in SQL Server 2005/2008/ 2008 R2/2012.
• Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL joins.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012.
• Used SQL Server Destination in Data flow to improve a superior performance changes in Replications.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution
• Published dashboards on an intranet site using SharePoint Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), SQL Profiler, Team Foundation Server, MS Excel, Windows XP

Confidential, Montgomery, AL

MSBI Developer

Roles & Responsibilities:

• Closely worked with end-users to analyze, understand and gather report requirements.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries and updated statistics using query Analyzer and Enterprise Manager on the existing servers.
• Migrated all DTS packages to SL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Used SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse.
• Developed reports using SSRS, used table control, matrix control for cross tab reports.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Worked on ADO.Net to access data from database.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Handled issues like data correction and resolved error handling.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, SSRS, C#, Share Point Windows Server, windows 7/XP, Visual Studio 2010 & TFS

Confidential, Plano, TX

MSBI Developer / Analyst

Roles & Responsibilities:

• Generated and debugged complex stored procedures and functions for performance tuning and optimization.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created complex functions, stored procedures for complex sub queries and views based on the business requirements.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs and resolve the problems.
• Created SSIS packages that would transfer data between servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Worked closely with business users in defining and documenting reporting requirements to design, develop and maintain SQL Server 2008 reporting services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and MS Excel format using Reporting Services (SSRS).
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Created and configured cubes using SQL Server 2008 analysis services.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Developed and maintained various cubes using MDX complex queries in SSAS.

Environment: MS SQL Server 2008/2005, T-SQL, Windows Server 2008, Toad, SSAS-2008/SSIS-2008/ SSRS-2008, SSIS

Confidential

Database Developer

Roles & Responsibilities:

• Coded Stored Procedures, functions and triggers at a high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Closely worked with the end users to analyze, understand and gather report requirements.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• Merging data into a single server for achieving better control, consistency & security of data.
• Worked on the Logical and Physical design of database for projects on basis of user requirements.
• Extraction, transformation and loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Extensively used SQL Server Reporting services and report builder model to generate custom reports.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• DBA activities like creating users, roles and granting and revoking privileges.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel, SSIS, SSRS