PROFESSIONAL SUMMARY:

• Around 8 years of experience in IT with Database applications and Business Intelligence/ETL design & development, and Data Analysis in Production, Development, Testing and Staging Environments.
• Expertise in MS SQL Server 2017/2016/2014/2012/2008R2/2005 Full - stack of MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Contributed in the Organization’s/Client’s adaptability, agility, and ability to manage constant change through innovative ideology that made me success in the project.
• Expertise in defining the business process flow and gathering business requirements and analyzing user data processing needs to develop/enhance appropriate reporting systems.
• Actively participated in functional unit testing, integration testing, systems testing and user acceptance testing.
• Worked in developing technical solutions to business problems, and defining, analyzing and documenting and managing the requirements at the project level that can help to fulfill business needs.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Built relationships with vendors to manage all technology partners and Integrated several third party technologies.
• Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MSSQL Server using SQL Server Integration Services (SSIS).
• Experience in designing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
• Pro-actively worked with other ETL developers in solving complex data mappings and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Experience in providing Logging, Error handling by using Event Handler.
• Created Code Snippets using Apex Coding that were used to quickly insert often-used SQL statements as well as generate whole procedures and pages of code.
• Experienced in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Worked in Normalizing and De-normalizing the tables & maintaining Referential Integrity.
• Skilled in developing SSAS Cubes, Dimensions, Facts and data source views, SSAS-Data Mining Models and Deploying cubes, Processing SSAS objects, and Creating named calculations and named queries.
• Good experience with SSRS through developing, troubleshooting deploying reports, creating report schedules, subscriptions, managing and securing reports.
• Experienced in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterized reports and Ad-Hoc reports.
• Created Reports, Scorecards, KPI’s, and Dashboards using Performance Point Server 2007/SharePoint Server.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DMLTriggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.
• Expertise in SQL Server and T-SQL (DDL and DML) in constructing Tables, Indexes, Stored procedures, Views, Normalization techniques on database Tables.
• Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.
• Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.
• Experience in MS Access and Excel skills with Power Pivot, PivotTable, Pivot Chart, Power View, V Lookup functions
• Experience working in Agile and Waterfall methodologies in SDLC
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2017/2016/2014/2012/ 2008R2/2005.
• Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

• Databases: MS SQL server 2017/2016/2014/2012/2008R2, My SQL
• Programming Languages: SQL, PL/SQL, Transact - SQL, C,.Net,C#.
• ETL Tools: BIDS/SSDT, SSIS, SSAS, SSRS.
• OLAP/Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2017/2016/2014/2012/2008R2, Power BI (Basics).
• SQL Server Tools: SSMS, Query Analyzer, BCP, SQL server profiler, SQL Server Agent.
• Data Modeling Tools: Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).
• Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio
• Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS.
• Web Development: HTML, XML, and Visual Studio 2015/2017

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

BI SSIS Developer

Roles and Responsibilities:

• Gathering and design strategies for database management system by understanding the report design requirements and Constraints.
• Established scope, planned and prioritized multiple deliverables based on data dependencies and business needs.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS) using Report Builder 2016.
• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Developed several drill down and drill through reports using SSRS as needed by clients.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages. Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data so0urces using SSIS.
• Created multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services).
• Worked with team to Design, deployment and maintenance of various custom and standard reports along with parameterized & cascading parameterized reports using SSRS.
• Developed stored procedures, functions, database triggers and views.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non-production database code as well as SQL code from developers and QA.
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Wrote complex SQL batches with Views, Common Table Expressions (CTE's) for recursive operations.
• Created package 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).
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• VB.Net and SQL Reduced resource pooling time significantly through optimized sub-querying techniques.
• Developed client applications using VB.Net and SQL Server.
• Migrated VB 6.0 to VB.Net as the existing modules functionality are developed using VB 6.0.
• Designed and developed several Windows forms and Web Forms using VB.NET.
• Used MS Excel, CSV files and Oracle Database as data source and copied data to the target.
• Wrote complex SQL statements, Stored Procedures, functions, view and triggers to retrieve the data as per the requirement.
• Used C#.Net asp web pages to show the deployed reports as required by the user
• Provided governance around the Power BI platform architecture and operations.
• Maintained up to date on Power BI desktop, Power BI Service and related technology enhancements.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and wrote complex stored procedures with parameters while generating various reports.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: Microsoft Report Builder2016 (SSRS), Microsoft Visual Studio 2017/2016, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Power BI.

Confidential, Linthicum, MD

SQL SSRS Developer

Roles &Responsibilities:

• Gathered business requirements from business firms to understand and formulate the design of the EDW & Leather Market Forecast.
• Participated in the meetings between Business Users and EDW team to gather the Technical/functional requirements.
• Involved in JAD sessions with users explaining the dataflow and sequence of events.
• Worked as a contact between the Business Users and BI technical team to convert the business requirements into technical requirements.
• Worked in developing technical solutions to business problems, or to advance a company's sales efforts, begins with defining, analyzing and documenting and managing the requirements at the project level that can help to fulfill business needs.
• Created functional requirement specifications and supporting documents for business systems.
• Created Apex Code Snippets and used snippet managing window to represent a list of macro variables to implement code snippets for the dynamic code generation.
• Migrated Measuring Bridge Application and its dependent objects from SQLServer2008R2&/ 2012 to SQLServer2014.
• Created SSIS packages to move data from BPCS (ERP System) to SQL Server and to move data from Sources to Staging and to EDW
• Built various SSIS packages having different tasks and transformations for various business areas
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment in dependent.
• Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created Dashboards using SSRS and Power BI where needed.
• Analyzed the gaps, streamlined the existing process, proposed and implemented new processes to build reporting platform moving away from citric reports
• Reverse engineered the existing applications to evaluate GAPS and recommended solutions in light of new requirements in order to support the new Leather Market Forecast Initiative.
• Developed reports in SSRS charts, graphs and maps for better visualization.
• Designed drill-down and drill-through reports in SSRS, drill-through reports that can navigate to other reports or to other URL

Environment: SQL Server 2014/2012, T-SQL, Windows 10, Visual Studio 2015/2012, SSIS, SSRS, SSAS, MS-Visio, Microsoft-Office 2016, Power BI Dashboards.

Confidential, Maple Grove MN

MSBI Developer

Roles &Responsibilities:

• Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
• Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stake holders, facilitators and partners.
• Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.
• Worked with SSIS Dataflow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.
• Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.
• Designed and implement DataMart, Facts, Dimensions and OLAP Cubes using dimensionalmodeling standards in SQLServer2012 that maintained data .
• Worked in the complete DataWarehouse development life cycle and actively supported business users for change requests during the project development.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed several drill down and drill through reports using SSRS as needed by clients.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of data base servers.

Environment: SQL Server 2012 and 2014, SSIS, SSAS, SSRS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, and Windows10.

Confidential, Dayton OH

SQL / BI Developer

Roles and Responsibilities:

• Gathered and design strategies for database management system by understanding the report design requirements and Constraints.
• Established scope, planned and prioritized multiple deliverables based on data dependencies and business needs.
• Created SSIS packages to import the data into SQL server. Involved in Troubleshooting of the already existing SSIS packages.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Generated Reports in SSRS using Expressions and Functions for the various reports.
• Designed drilldown, drill through, sub-reports and ad-hoc reports on large scale.
• Worked on analysis of data in Power Pivot by connecting to various data sources.
• Created Cube in Tabular mode, hierarchies in visual studio 2012 for Cube.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Wrote complex T-SQL batches with Common Table Expressions (CTE's) for recursive operations.
• Used MS Excel, CSV files as data source and copied data to the target.
• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers to retrieve the data as per the requirement.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and wrote complex stored procedures with parameters while generating various reports.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: MS SQL Server 2014/2012, SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2014/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Confidential, Pittsburg, PA

SQL/BI Developer

Roles and Responsibilities:

• Worked with team in gathering user requirements and system specifications.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLEDB Source (Oracle), Excel spreadsheet to SQLServer2012.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQLServer2008 to achieve the efficiency of SSAS.
• Created multiple reports (SSRS) in Drill mode using tables, crosstabs and charts.
• Worked with team to Design, deployment and maintenance of various custom and standard reports along with parameterized & cascading parameterized reports using SSRS.
• Developed stored procedures, functions, database triggers and views.
• Worked with SQL 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.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability as part of quality testing.

Environment: SQL Server 2012/2008/R2, SQL Server Business Intelligence Development Studio (SSIS), MySQL, MS Excel, Windows 7.