SUMMARY

• Microsoft certified Over 5 years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2019/ 2014/2012/2008 R2
• Experienced in Business Intelligence (BI) using Visual Studio 2017/2015/2013/2010
• Created, Built, and deployed successfully dynamic SSIS packages into SQL Server 2 /2008 R2/ databases and scheduled them according to requirements.
• Experience in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using Bulk Copy Program (BCP).
• Experienced in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Experience in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, and Drill-through and Cascading reports using SSRS.
• Experience in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying, and processing SSAS objects.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in Performance Tuning and Query Optimizations using different database third party tools like Solar Wind
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience wif Agile (SDLC) software development life cycle methodology.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Good interpersonal, Analytical and Communication skills
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, XML, JavaScript, ASP.NET, VB, C#

Databases: Microsoft SQL 2014/2012/2008 , MySQL, SYBASE, MS ACCESS

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Pervasive Data Integrator, Adept SQL diff, Oracle SQL, Microsoft Visual Studio2010/2012, Congo’s 10.2

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012 , Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, ProClarity, Tableau

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Operating Systems: Microsoft Windows, UNIX, LINUX

Tools: and Utilities: Business Intelligence Development Studio (BIDS), Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint

Version Control Tools: VSS

PROFESSIONAL EXPERIENCE

MS BI developer

Confidential, San Francisco, CA

Responsibilities:

• The scope of the project is to perform ETL Process and generate customized reports to determine customer’s eligibility.
• Handling the design, development, testing and deployment of customdatawarehouse systems.
• Applying understanding of Kimball Methodologies Data warehousing concepts & noledge of dimensional modeling using different Schemas (Star and Snow-Flake) to fit reporting, query and business analysis requirements.
• Developed various reports like charts, tables, matrix, and sub reports.
• Created different kinds of Tabular reports like Drill down, Drill through, cascaded parameters.
• Experience in developing BI applications using Power BI as reporting tool.
• Experience in Power BI Report and Dashboard development.
• Developed reports using single value parameter, multi-value parameters wif queried and non-queried parameters.
• Deploying and Scheduling reports to generate daily, weekly, monthly and quarterly reports.
• Developed stored procedures using T-SQL to retrieve data and used it to generate ad-hoc reports.
• Created SSRS report templates for report development.
• Comfortable mentoring others in my team for complex SSRS report experience in Data Analysis, Design, Development, and Implementation of Data Warehousing & Data Integration
• Applications using SQL Server Integration Services
• Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good noledge on SQL Server Analysis Services (SSAS).
• Created SSIS Packages to load data from sources like flat File, Excel, OLEDB,XML, and Oracle to SQL Server
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Created SSIS Packages wif different control Flow options and data flow transformations such as conditional Split, Multicast, Union all and Derived Column etc.
• Created Views and worded on slow running SQL to improve performance.
• Experience in creation indexed views, complex stored procedures and useful functions.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Designing an OLAP System wif the halp of ER-WIN to visualize data structure.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse database and data marts.
• Expertise in designing, debugging and testing of reports in SSRS.
• Experience in creating and developing Power BI Dashboards into rich look and configuring data gateways to have an automatic refresh of the dataset.
• Used Power View and created various analytical reports andDashboards from Tabular
• Analyze collaborate wif our DBA Teams to improve database strategies and maximize performance, capacity and security.

Environment: SQL Server 2019/2016/2012 , Microsoft SQL (T-SQL), SSIS, SSAS,SSRS,POWER BI, XML,MS EXCEL, and MS OUTLOOK.

SQL \BI Developer

Confidential, Alexandria, VA

Responsibilities:

• Installation and configuration ofSQL Server 2019, 2017, and 2014
• Migration - Performed database migration from SQL Server 2019 and 2017 to SQL Server 2019.
• Involved wif DBA in creating schema and related privileges and roles.
• Created indexes, Constraints, and rules on database objects for optimization.
• Performed database backups and restore from Production server to test server as refresh backup as part of testing whether backup is restorable or not.
• Applied Service Packs patch and hot fixes
• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files, and SQL Server database to centralized IT destination.
• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.
• Experience wif logical and physical data modeling, data warehousing, data querying languages and data strategy
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and tan into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Coordinated and attended everyday standup/scrum/Agile meetings and weekly Sprint meetings to evaluate completed work

Environment: MS SQL Server 2019/2017, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office

MSBI/Report Developer

Confidential, Philadelphia, Pennsylvania

Responsibilities:

• Gathering the Business Requirements from the Business Users and performing an extensive Data Analysis on the internal host system.
• Understood the requirement specifications, prepared the functional and technical design documents.
• Creating functional, technical design, and data mapping documents by interacting wif customer's subject matter expert (SME).
• Determined and wrote SQL quires and reviewed data to ensure data integrity, accuracy, and validity.
• Identified data quality issues and worked wif appropriate teams to resolve them.
• Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data, and loading it into the destination.
• Developed new mapping documents and used transformations like Look Up, Aggregation, Derived Column, Data Conversion, etc., to match the business case's needs.
• Performed Ad-hoc Reporting functions for special needs and requests, Designed and formatted Data Reports utilizing T-SQL
• Developed reports (Table, Matrix reports, Chart, drill down, Drill through, Parameterized, Cascading, Conditional, Dashboard, and Sub Reports, etc.) used by management group and clients to retrieve information.
• Used Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance databases' performance.
• Used T-SQL for creating various complex objects like Tables, views, functions, stored procedures for storing and processing data in the required form.
• Extensively used Impala SQL for Query parallel processing database.
• Designed ad-hoc reports and complex enterprise reports, including drill down, drill through reports, cascading reports, sub-reports, linked reports using SSRS.
• Experience designing, developing, and maintaining custom SSRS reports and Provide reporting to customers and management to support business decisions.
• Used Visual Studio and SQL Server Report Builder to modify or enhance an extensive repository of existing SSRS reports and develop new SSRS reports from data in replicate.
• Design and develop user-friendly dynamic reports and dashboard using parameter, expression, conditional formatting, and grouping to reduce ongoing ad hoc requests
• Hands-on experience in developing reports and dashboards using Power BI Desktop and publish them to Power BI services and Power BI Report Server.
• Clean and transform data in Power BI Query editor.
• Utilized Power BI gateway to keep dashboards and reports up-to-date wif on premise data sources.
• Build calculated fields in DAX (Data Analysis Expression) for necessary reports and analysis
• Administered Power BI admin portal to manage Office 365 and Tenant Setting; Run Capacity usage matrix data to capture usage information and track reports and dashboard usages in Power BI.
• Manage users' interactions in Power BI tenant by creating a dashboard using activity log Data for Power BI Administrators to no who does what, at what time, and other activities.
• Implement the full cycle of power BI visualizations such as extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards
• Perform data analysis wif appropriate programming and analytic methodologies; present data or reports in a meaningful fashion; work collaboratively wif teams and leadership; formulate recommendations for further initiative refinement based on current data evidence.
• Experience in working wif SSAS in creating cubes, data source views, named queries, dimensions, and deploying analysis services projects.