SUMMARY:

• 7 years of total IT experience in Database Design, Modeling, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2008 R 2/2012/2014/2016/2018
• Created multiple customized SQL Procedures & Packages for various business needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Management of high-performance production CLUSTERED SQL Server database instances using Active-Passive nodes, and Active-Active nodes clustering .
• Handled all SQL administration related issues which includes, Installing, Configuring and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues .
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience with Microsoft Azure ETL to move the data from several source to destinations.
• Created pipelines and migrated data from SQL, Oracle to Azure Datawarehouse.
• Extensive knowledge on PowerBI.
• Experience with Data Migration, Data Formatting and Data Validations Hand on experience on developing and maintenance of SSRS and SSIS reports for QNXT.
• Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design.
• Proficient in Technical and Business writing, Business Process Flow, Business Process Modeling and Testing.
• Emphasis on requirements gathering through research, formal-informal sessions, JRP sessions and JAD sessions with SMEs (subject matter experts), Teams, Stakeholders and end users.
• I nvolved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Proven record of Team Management and Leadership skills. Excellent Presentation skills in regards to communicating with both business and technical teams .
• Experience with managing users and their authorizations.
• Highly experienced in whole cycle of DTS/ SQL server integration services (SSIS 2005/2008/2012/2014 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience with system and user defined Variables, Package, and Project Configurations for SSIS packages.
• Experience in managing Control flow and Data flow transformations for SSIS packages.
• Experience with Performance tuning of SSIS packages using Synchronous and Asynchronous Transformations.
• Experience in Job Scheduling and Package Automation of SSIS packages.
• Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2013 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2013 and Crystal Reports.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP , Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression ( MDX), Perspectives and Roles.
• Experience in performance tuning , processing and deploying the cubes.
• Experience in cube partitioning for better database performance.
• Experience in Performing Data Mining features like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.
• Experience in Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in integrating Dashboard on SharePoint Server that use different types of web parts and excel services like Power View and Power Pivot.
• Created Scoreboard/Dashboard pages in Performance point server (PPS).
• Experience in Microsoft Power BI Tools such as Power Pivot, Power Map and Dashboards. Comfortable using Tableau.
• Experience working with production and 24 x 7 on call environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Extensively used ASP.NET Data Grid, Data List, Repeater controls and Telerik controls for displaying the data in a clear format.
• Develop solutions and tweak business processes as needed using SQL Stored Procedures, VB. NET, C#, and VBA.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, C++ XML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , SharePoint, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server 2014/2012/2008 R2/2005 Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS (SQL Server 2005/2008/2008 R2, 2012,2015 Integration Services), SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP)

MS Office: 2010/2007/2003/2000 , MS Project Adobe Professional.

Operating Systems: Windows (updated to 2016), MAC OSX Tiger/Leopard, Unix, Linux (Ubuntu updated to 12.04)

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Sr. SQL BI developer

Confidential, St. Louis, MO

Responsibilities:

• Working with IT Analytics team on the client side for gathering requirements from users for Data Analysis.
• Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration using. SSIS.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Supporting the SSIS Packages.
• Generating Complex Transact SQL (T- SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the Stored Procedures, User-defined Functions and Views.
• Developing Linked services, Data Sets , Pipelines to establish connections, collect required data and cleansing processing the data.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008R2/2012.
• Good experience in SSIS packages to load the Data from Text File to staging server and then from staging server to Data warehouse.
• Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.
• Involved in SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in data Warehouse using SSIS.
• Good understanding of Relational Database Design, OLAP concepts and methodologies.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Creating T-SQL code for manipulate data for the business needs.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created the data visualization charts using Power BI.
• Provisioning SQL data warehouse for loading data from source databases.
• Developing complex queries to pull data according to business logics.
• Optimizing and fine-tuning the existing SQL queries to enhance the performance of the applications by analyzing execution plans and implementing indexes.

Environment: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008 MS SQL Server Integration Services (SSIS) 2017/2015/2012 MS SQL Server Reporting Services (SSRS) 2017/2015/2012 , SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), T-SQL.

SQL/SSIS/ETL/Data Wearhouse Developer

Confidential, New York, NY

Responsibilities:

• Working with IT Analytics team on the client side for gathering requirements from users for Data Analysis.
• Studying and analyzing the existing systems and involved in planning and designing data models to acquire data from Operational Data Source (ODS) into Data Warehouse on cloud by using Azure SQL Server, Azure SQL data warehouse, Azure data factory, and SQL Server Integration Services.
• Designing ODS and Data Warehouses environments to store data from various sources.
• Developing ETL packages using SSIS to extract & load from Source Azure SQL Server and SAP HANA.
• Developing Linked services, Data Sets , Pipelines to establish connections, collect required data and cleansing processing the data.
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and API's in Azure SQL.
• Creating T-SQL code for manipulate data for the business needs.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database .
• Provisioning SQL data warehouse for loading data from source databases.
• Developing complex queries to pull data according to business logics.
• Optimizing and fine tuning the existing SQL queries to enhance the performance of the applications by analyzing execution plans and Implementing Indexes.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008R2/2012.
• Good experience in SSIS packages to load the Data from Text File to staging server and then from staging server to Data warehouse.
• Used Python and Spark to scrape, clean, and analyze large datasets
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created the data visualization charts using Power BI.
• Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database .
• Provisioning SQL data warehouse for loading data from source databases.
• Developing complex queries to pull data according to business logics.

Environment: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008 MS SQL Server Integration Services (SSIS) 2017/2015/2012 MS SQL Server Reporting Services (SSRS) 2017/2015/2012 , SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), T-SQL.

SQL BI Developer

Confidential, Boston, MA

Responsibilities:

• Created several extracts using SSIS. Responsible for data mapping from QNXT to other implementation documents.
• Responsible for performing overlays in different environments.
• Worked with analysts on team and helped them on creating several workflows using Visio for all the implementations.
• Performed data conversions from SQL server to flat file using SSIS.
• Created packages that implements tasks like Execute SQL Task, Data Flow Task.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Analyzed reports and fixed bugs in stored procedures.
• Created Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Responsible for generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Designed and created Report templates, bar graphs and pie charts based on the providers data.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created the data visualization charts using Power BI.
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expertise in merging data from various heterogeneous data sources like Excel, text files, SharePoint Lists, data extracted through Cosmos (Big data) and merging, populating dimension and fact tables, data warehouse, Cleansing and Standardizing data loaded into OLTP and DW databases using SSIS.
• Expert in DAX functions.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes ( MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Used Python and Spark to scrape, clean, and analyze large datasets
• Experience in Cube designing in Business Intelligence Development Studio (SSAS ) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationship, calculations.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Developed reports using global variables, expressions and functions using SSRS.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Developed SQL Queries and Procedures for storage and retrieval of data using ADO.NET and LINQ to SQL Developed Web Services for user authentication and file transfer.

Environment : SQL Server Management Studio 2012, Integration Services, Analysis Services, Reporting Services, SQL Server Data Tools, MS Visio, Cisco Tidal Scheduler.

SQL BI Developer

Confidential, Milpitas, CA

Responsibilities:

• Created several extracts using SSIS. Responsible for data mapping from QNXT to other implementation documents.
• Scheduled jobs using Cisco Tidal scheduler for inbound/outbound files transfer.
• Responsible for performing overlays in different environments.
• Worked with analysts on team and helped them on creating several workflows using Visio for all the implementations.
• Performed data conversions from SQL server to flat file using SSIS .
• Created packages that implements tasks like Execute SQL Task, Data Flow Task.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Worked on Always ON Environment and configured Always on in SQL 2012 version with 5 replicas which included 1 primary replica and 4 secondary replicas.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Designed and created Report templates, bar graphs and pie charts based on the providers data.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created the data visualization charts using PowerBI .
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Agent for scheduling jobs and alerts.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model ( DAX), Cubes (MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Developed reports using global variables, expressions and functions using SSRS.

Environment : SQL Server Management Studio 2012, Integration Services, Analysis Services, Reporting Services,

Sr. SQL BI Developer

Confidential

Responsibilities:

• Designed relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between foreign and primary keys in the tables.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Created stored procedures, Cursors, Joins in T-SQL.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, Triggers, Clustered & Non-clustered Indexes, Views, Indexed Views, and User-Defined Functions (UDFs).
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server.
• For ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.

Environment: MS-SQL Server 2012/2008R2/2012, MS-SQL Server Reporting Services, MS-SQL Server Integration

SQL BI Developer

Confidential

Responsibilities:

• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Performed ETL using SSIS by extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations.
• Designed and developed Star and Snowflake Schema as a data analyst.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS). Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2008/2008R2 Reporting Services.

Environment: SSIS, SSRS, SSAS, MS SQL Server 2008 R2, OLAP, ERWIN, Front Office 8.3 / 10.2 / 10.3, Windows