PROFESSIONAL EXPERIENCE

• Around 7 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/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).
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS).
• Experience in designing, developing, 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.
• Experience in providing Logging, Error handling by using Event Handler.
• Excellent 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, Processing SSAS objects, and Creating named calculations and named queries.
• Good experience with SSRS through deploying reports, creating report schedules and subscriptions, managing and securing reports.
• Skilled 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/DML Triggers, 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.
• Expertise in defining the business process flow and gathering business requirements.
• Experience working in Agile and Waterfall methodologies in SDLC.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2017/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 2014/2012/2008R2, Oracle 11g/10g/9i, My SQL

Programming Languages: SQL, PL/SQL, Transact- SQL, C

ETL Tools: BIDS/SSDT, SSIS, SSAS, SSRS and Informatica (Entry-Level)

OLAP/Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2014/2012/2008R2, Power BI.

SQL Server Tools: SSMS, Query Analyzer, BCP, SQL server profiler, SQL Server Agent

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX

Web Development: HTML, XML, Microsoft.NET framework, Visual Studio

Data Modeling Tools: Visual Studio 2010, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

MSBI/ ETL Developer

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 data flow and sequence of events.
• Worked as a contact between the Business Users and BI technical team to convert the business requirements into technical requirements.
• Designed ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• 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.
• 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.
• Designed the Templates, work-flow and standards for SSIS Packages
• Migrated Measuring Bridge Application and its dependent objects from SQL Server 2008 R2 &/2012 to SQL Server 2014.
• 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 independent.
• 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, 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, ETL, Windows 10, Visual Studio 2015/2012, SSIS, SSRS, SSAS, MS-Visio, Microsoft-Office 2016.

Confidential, Maple Grove, MN

MSBI Developer

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 stakeholders, 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 Data flow 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 Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.
• Worked in the complete Data Warehouse 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 database servers.

Environment:

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

Confidential

SQL/ BI Developer

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.
• Designed, created & implemented complex ETL Strategies using SSIS packages.
• Extract the data from various heterogeneous sources like flat files, Excel, Db2 and dumped into centralized DataMart.
• 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 drill down, 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), ETL, Microsoft Visual Studio 2014/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS).

Confidential

SQL/ BI Developer

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 OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2012.
• 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 SQL Server 2008 to achieve the efficiency of SSAS.
• Created multiple reports (SSRS) in Drill mode using tables, cross tabs 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 database 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),T-SQL, MS Excel, Windows 7

Confidential

SQL Server Integration Developer

Responsibilities:

• Responsible for generating requirement specifications and daily reports.
• 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.
• Worked on SSIS Package, Import/Export for transferring data from Database (Oracle and Flat File data) to SQL Server.
• Created SSIS packages for File Transfer from one location to the other using SQL Server, Oracle, Excel, CSV and Flat files from Client servers.
• Successfully transferred data from various sources like MS Access, Fat Files, Oracle and Excel into MS SQL Server using SSIS.
• Designed and developed reusable SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data type Conversion using data conversion transformation.
• Constructed cubes based on data volumes mostly adhering to Star Schema through SSAS.
• Designed and applied entity and attributes description and definition for the data models.
• Monitored Scheduled jobs and alerts.
• Migrated SSRS 2005 reports to SSRS 2008R2.
• Designed Drill down, Parameterized Reports, Linked, and Cascaded Parameterized reports using SSRS business needs and involved in report deployment.
• Managed SSRS report subscriptions for end users and optimized the performance of reports.

Environment:

MS SQL Server 2008 including SSMS, SSIS, SSRS, and SSAS, Windows 7.Oracle RDBMS