SUMMARY

• Around 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008/2012 , 2014 , R2 in Development, Test and Production Environments, C#, .NET framework and on various business
• Experience in comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, Power BI) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server and ProClarity analysis server.
• Experience in developing reports on SSAS & SSRS on SQL Server.
• Experience and understanding of SSAS , OLAP cube and Architecture
• Experience in Database Design, Data modelling, Development, Implementation, ETL and Reporting in SQL Server.
• Experience in Developing and Tuning T - SQL , PL/SQL Complex Queries, Stored Procedures, UDF'S, triggers, views, Indexed views and error handling using Try-Catch blocks
• Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems
• Experience in Implementing, Normalization, Transactional, Snapshot replication and Performed log shipping as Disaster recovery solutions.
• Experience with Kimball's' theory, KPIs, Perspectives, Translations and SQL 2008 Architecture.
• Experience with data modeling, logical and physical database design using Erwin.
• Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008 R2/2012/2014 , PowerPivot (Excel 2010)
• Experience in designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes. Utilized Power BI (Power Pivot/View) and DAX functions to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Experience in Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012 .
• Experience in using Power Shell / Power BI.
• Experience in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, Oracle, Teradata, MongoDB, flat file) by using multiple transformations provided by SSIS like Data Conversion, Conditional Split, Bulk Insert, merge, union all.
• Experience in data interface layer using ASP.NET and C# for data access.
• Experience in performance tuning, query optimization, client/server connectivity and Database Consistency Checks using DBCC utilities.
• Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot.
• Experience to CMMI, ISO and QA processes, change control management, source safe, version controlling.

PROFESSIONAL EXPERIENCE

Confidential, New Albany, OH

SQL Developer/Power BI Developer

Responsibilities:

• Deliver high quality, innovative BI solutions in a fast - paced environment Data mining and modelling, regression analysis, process documentation, profitability analysis, lead/list generation, customer attrition and direct mail campaign analysis
• Responding to requests from partners for customer information reports, lists etc.
• Identifying/recommending potential data sources.
• Responsible for performing assigned database-related analyses and projects.
• Ensures adherence to compliance regulations and policies.
• Design and develop ETL solutions for multiple source systems
• Design, develop, and support BI-related database applications spanning multiple lines of business
• Proven Power BI development experience with desktop and pro versions, familiarity with Direct Query functionality within Power BI.
• Development of Microsoft Power BI dashboards and dashboard templates also used DAX functions and MDX queries.
• Worked on Azure Active Directory. Microsoft Azure date storage and Azure Data Factory, Data Lake, Big Data on Azure.
• Migrated SQL server to MS Azure cloud. And extending domain services to Azure.
• Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot, Power BI, Power View, and SSRS) & implementing enterprise software solutions.
• Provide analytical, complex and specialized client service analysis using Power BI dashboards.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Developed custom Azure Runbooks and connections to the REST API which will send email/text messages whenever there is a failure in scheduled pipelines at every stage.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Used DAX studio to extract data form different Azure analysis services cubes.
• Calculated Tables, Custom transformations (M-language) and Dynamic KPI (DAX) are used.
• Used basic statistics functions that are available in DAX to provide insights on descriptive analytics.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, DAX, Partitions, KPI’s & MDX Queries and DAX using SSAS 2012.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Experience in Provisioning, Configuring and Publishing Web and Worker Roles in Azure PAAS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.
• Used various functions in DAX to build running totals, YTD and MTD Values
• Created and maintained various databases in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS (move two points up).
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
• Provided daily support to the client/technical teams for system wide tasks such as monitoring, alerting, testing, bug fixing/problem resolution & documentation

Environment: SQL Server 2016/2014/2012 , OLTP, PL/ SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T- SQL, QTP, J Unit, Selenium and Excel.

Confidential, ATLANTA, GA

SQL BI Developer

Responsibilities:

• Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and Administration in Development, Test and Production Environments.
• Extracting and transforming data within Business Intelligence environment.
• Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
• Designed and developed SQL programming objects, including stored procedures, user defined functions, and common table expressions
• Used Performance Point Server (PPS) to create interactive reports with an ability to drill down into details
• Perform unit level analysis on all work done before handing over to the testing team
• Create and optimize complex T - SQL queries and stored procedures to encapsulate reporting logic
• Create SSRS reports according to user requirements and technical standards
• Customize output formats from SSRS to Excel, PDF, and CSV.
• Creating Report-Models for ad-hoc reporting and analysis.
• Developed Query for generating drill down reports in SSRS 2008 R2
• SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Used T- SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user's requirement. All kinds like ad-hoc reports Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQLServer Reporting Services 2012.

Environment: SQL Server 2016/2014/2012 , OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Teradata. Power BI, Windows Server 2008, VS 2010/2012, Power BI, T- SQL, and Excel.

Celgene, NJ

SQL BI (SSIS) Developer

Responsibilities:

• Delivered high quality, innovative BI solutions in a fast - paced environment
• Designed and developed ETL solutions for multiple source systems
• Designed, developed and supported BI-related database applications spanning multiple lines of business with loan and leasing applications.
• Performed complex data analysis to identify trends, patterns, and opportunities
• Created SSIS packages to extract, load and transform the data from flat files to database tables, API to database
• Strong SQL Server Development skills including writing Transact- SQL (T- SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Responsible in performance tuning, query optimization, Database Maintenance plans
• Performed Unit & IT testing& conducted UAT sessions with end users.
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Use Cosmos products in developing internal applications and presentations.
• Developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries on SQL Server 2012/2014.
• Developed BTEQ and multiload scripts to load Teradata tables.
• Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle DB, SQLDB, MS Azure.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design. Created multiple databases with shared collections and choosing shard key based on the requirements. Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.
• Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
• Used SQL Server Profiler to monitor the performance, Debug Transact- SQL statements and stored procedures in existing application, to identify slow running query etc.
• Creating reports with SQL Server Reporting Services (SSRS) and Powe BI
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Used SSRS and Power BI to create reports, Parameterized Reports, drilldown & Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Using the above query results from Cosmos, creating reports in PowerBI, Ads pulse to show the metrics by server and procedure name, by server etc.
• Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis
• Developed the T- SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval.
• Involved in performance tuning of SSIS Packages.

Environment: SQL Server 2016/2014/2012 , OLTP, Informatica 9.1, PL/ SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power Shell, Power BI, Windows Server 2008, Teradata, VS 2010/2012,Power BI, T- SQL, and Excel.

Confidential

SQL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC)
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• 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 Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Wrote T - SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function.
• Use Window azure to deploy the application on cloud and managing the session. Worked on Azure Data Factory for Extract& Load data.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Extracting data from Azure HDInsight and publish the transformed data into AzureSQL Data Warehouse and build reports on BI platform.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX)
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS)
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
• Developed a High-level dashboard using SSRS 2008.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Responsible for writing T- SQL code for creating cursor and handling data validations.

Environment: SQL Server 2008/2005 Enterprise Edition, T- SQL, Teradata, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.