SUMMARY:

• Around 5 years of experience in Development, Testing, Maintenance and Implementation of database solutions as MSBI Developer with exceptional skills in design and data analysis using Microsoft Business Intelligence Suite (SSIS, SSRS)
• Experience in extracting, transforming and loading data using SSIS, Import Export Wizard and Bulk insert.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Developed and Maintained Microsoft SSIS packages including database design, ETL and analysis integrations to meet business requirements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Experience in designed Data conversions from wide verity of source system using SSIS.
• Experience in generating Table report, Matrix report, Chart report, Pie charts, Drill Down, Drill Through, Sub reports, Multilevel Cascading and parameterized reports using SQL Server Reporting Services (SSRS)
• Extensively worked on Power BI (Power Pivot, Power query, power view, Power map) for reporting needs.
• Experience in generating reports for OLTP and OLAP data bases.
• Created SSRS report projects in BI Visual studio and created, modified, and managed various report models with multiple objects, source fields and expressions.
• Used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SQL Server Reporting Services (SSRS).
• Experienced in T - SQL Development like derived tables, stored procedures, user defined functions, triggers, views, indexed views, indexes, logins and users.
• Experience and knowledge in T-SQL Transactions, Joins, Stored Procedures, Triggers and Functions involving multiple tables.
• Experience in creating and developing Power BI Dashboards into rich look,
• Expertise in developing application using SQL Server.
• Full System Development Life Cycle (SDLC) experience including Requirement Gathering, Analysis, Design, Development, Testing, and Implementation of various medium in a structured development environment.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizations and other making use of actions, other local and global filters according to the business/client requirement.
• Experience in implementing Data blending, replace references, Customized queries and advanced visualizations in Tableau.
• Strong leadership, communication, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working under pressure.

TECHNICAL SKILLS:

Business Intelligence/Reporting Applications: BI Development Studio, Visual Studio 6.0 - 2008, Tableau, Intelligence Development Studio (BIDS), Power BI,VISIO, Crystal Reports XI/X/9/8, Excel Pivot tables

Languages: Python, R Programming, Hadoop, .Net, C#, NoSQL, T-SQL, SQL,HTML

MS SQL Server 2000: 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), 2016/2014/2012/2008 R2/2005, MS Office, SQL Developer, ETL, Data Warehouse, Mongo DB

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MSBI Developer (SSRS, SSIS)

Responsibilities:

• Agile methodology was used throughout the project, performed a pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used SQL Server profiler for troubleshooting, monitoring and optimization of SQL Server and non-production data base code as well as T-SQL code from developers and QA.
• Experienced on working with SQL Joins, Common Table Expressions (CTE), sub queries.
• Developed SSIS packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into the SQL table.
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Generated periodic reports based on the statistical analysis of the data using SSRS.
• Developed SSRS reports like drill through reports, drill down reports, linked reports.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• Used various to pull data into Power BI such as SQL Server, SAP BW, oracle etc.
• Deployed the reports on SSRS server and make them available to departments of interests. Scheduled cache for better access performance, and snapshot for logging purpose.
• Responsible for performing UAT on the reports after checking in the code into Team Foundation Server (TFS)/ Visual studio services and deploying the reports to production environment.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Environment: SQL Server 2017/2008 R2, Report Builder 2016/2008R2,MS visual studio, SQL Server Integration Services, Microsoft Office, Raw files, XML, Windows Server 2008, LINUX, Tableau 2018.3, SQL profiler, Database Tuning Advisor, Office 365, Smart Sheets, Share Point.

Confidential, Chicago, IL

SQL BI developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SQL server jobs to execute SSIS packages according to the load type of the data.
• Involved in writing stored procedures to create table structures in stage and pulling data from metadata.
• Developed reports models using report builder, Power BI tools and distributed reports in multiple formats using SSRS in Business Intelligence development studio.
• Involved in creating marts and developing mart views used for the report building.
• Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
• Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Involved in creating data base objects like tables, views, procedures, triggers and functions using T-SQL to provide definition.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Created the SQL server users and file server users with required permissions by including them in the scripts.
• Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
• Created Master SSIS templates for Dimensions and Facts.
• Used various control flow tasks such as FTP, bulk insert task, transfer job task and different data flow tasks.
• Configured Server for sending mails when a SSIS process fails.
• Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.

Environment: SQL Server 2012, SSIS (2012), SSRS (2012), SSAS, T-SQL, SSMS, Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer

Confidential

Jr. SQL BI Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Created stored procedures to load data in different tables and created views to reduce database complexity for end users.
• Participated in Business Analysis & requirement collection.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, developed, tested, tuned, and implemented Microsoft SQL Server 2012 database objects and T-SQL scripts using stored procedures, functions, triggers, views, window function and data manipulation scripts and ETL/SSIS packages.
• Created Stored Procedures, functions, triggers, Views and Indexes.
• Responsible for Stored Procedure optimization, Performance tuning and Index Tuning.
• Scheduled and Created SQL Server Agent jobs with SSIS packages.
• Designed, Created and deployed various SSIS Packages (for ETL - Extraction, Transformation, Loading).
• Involved in designing the template of SSIS packages to approach the business requirement.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both Development and Production environments.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Document designs and architect data maps develop data quality components and establish and/or conduct unit tests.
• Create/maintain design related artifacts i.e. data models, Mapping documents, architecture diagrams, data flow diagrams.
• Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.

Environment: SQL Server 2008 R2, SQL Server Reporting Services, MS visual studio, SQL Server Integration Services, Microsoft Office, Raw files, XML, Windows Server 2008, LINUX, SQL profiler, Office 365, Smart Sheets.

Confidential

MSBI/SQL Intern

Responsibilities:

• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized Queries.
• Developed several drill down and drill through reports using SSRS as needed by clients.
• Add package configuration and package parameters to ensure the package execution in another server.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Implemented SQL queries, sub-queries, Database Components, Database Tables, views, Constraints, simple to complex Stored procedures and Functions involving multiple tables from different databases to integrate the data as business requirements.
• Worked with business/functional analysts on project intake, and requirements gathering.

Environment: SQL Server 2008 R2, SQL Server Reporting Services, Microsoft Office, Raw files, XML, Windows Server 2008, LINUX, Office 365.