SUMMARY

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Confidential SQL Server 2016/2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains.
• Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Developed PL/SQL Triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored Procedures, Functions and Packages for moving the data from staging area to data mart.
• Good knowledge on Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Created data base on Confidential Azure, setting up connection strings and connecting SQL server AZURE databases from locally installed SQL Server Management Studio(SSMS) for developers
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development, ETL development using Confidential SQL Server Integration Services (SSIS), Business Intelligence delivery using Confidential SQL Server by Play Now Radio">Analysis Services (SSAS) and Reporting solutions using Confidential by Play Now Radio">SQL Server Reporting Services (SSRS).
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports, Power BI, Tableau

Relational Databases: SQL Server 2016/2014/2012/2008 R2/2005, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Ticketing Tools: Incident Management (ICM)

Other Tools: Confidential Office 2003/2007/2010 and 2013, Power pivot.

Data Modeling Tools: Confidential Visio 2003/2007/2010, Erwin and Power Builder.

SQL Server Tools: SQL server Management Studio, Confidential Visual Studio 2010/2013/2015

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Confidential, WASHINGTON

APPLICATION SUPPORT ENGINEER

Responsibilities:

• Providing 24X7 production support for critical ETL processes and strategic financial reports.
• Created new database objects like procedure, functions, packages, triggers and views using T-SQL in development production environment for SQL server.
• Scheduling theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent.
• Creating complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Creating Power BI reports and Dashboards based on the requirement of the client.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Created and maintained the data sources in On Premises Gateway.
• Involved in troubleshooting, resolving, and escalating Power BI issues.
• Used Incident Management (ICM) to create tickets for various productivity issues to ensure transparency and prioritize work flow.
• Created monthly reports in Power BI based on the tickets for reducing the issue count in the future.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Informatica, SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Excel, Windows XP, Power BI Desktop/Service.

Confidential, COLORADO

Power BI/MSBI DEVELOPER

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports dat run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes theirby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.

Environment: MS SQL Server 2008R2/2012/2014, Oracle 9i/10g/11g, SSIS, SSRS, Management Studio, Visual Studio,DTS, Windows 7,MS Office 2010/2013,Windows Server 2008 and Windows Server 2008 R2,Visio 2010/2013,Power BI Desktop, Power BI Service.

Confidential

SR.SQL DEVELOPER

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Performed tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2012
• Installed and configured SQL Server 2008R2/2012 in Test environment with latest service packs and migrated few databases
• Created indexes, Constraints and rules on database objects
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Developed physical data models and create DDL scripts to create database schema and database objects
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
• Created Customized and interactive dashboards using multiple data sources
• In depth knowledge in Tableau Advance Analysis features like Actions, Calculations, forecasting, Parameters and Trend lines
• Worked on Dual Axis concept while working with reports with Tableau
• Created conditional filters and Action links to filter the data on dashboard with Tableau.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Oracle 9i/10g/11g, Informatica, SQL Server Analysis Services (SSAS), Tableau, Visual Studio 2010, MS Excel, Windows XP, Tableau desktop 7.0/8.1/8.2/9.0 .

Confidential, New Jersey

MSBI DEVELOPER

Responsibilities:

• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Planned, designed, and implemented processes to receive, transform and load valuable data from external sources into local databases.
• Designed SSIS Packages to load data from different sources like excel, flat file, csv etc.
• Designed Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, mail task, Derived Column, and For Each Loop, Data Conversion etc.
• Provided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes
• Developed perspectives to simplify the process of browsing the cubes
• Used Lookups Transformation to get the data from reference data sets

Environment: SQL Server 2008R2/2012 Enterprise Edition, Business Intelligence, SSIS, T-SQL, MDM, SSRS, Windows Server 2008, Oracle 9i, MS excel 2008, Confidential Visual Studio 2008.

Confidential

SQL/ BI DEVELOPER

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus making them user friendly
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS
• Worked on several complex drilldowns, parameterized reports and on reports dat call sub reports using SSRS
• 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
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs

Environment: MS SQL Server 2008R2, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SSDT, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation
• Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source database and loading on to the target database
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting
• Designed ETL strategies using Visio showing Data Flow to peerdevelopersand Lead
• Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently
• Scheduled theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent
• ConfiguredSSISpackages to move the same between different Environments and for optimal performance.
• Designed error tolerantSSISpackages and logged the execution details
• Work directly with users and business partners to gather reporting requirements and provide solutions
• Prepared documents to show the details of packages and Reports created for future reference
• Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them
• Implemented the core business process using T-SQL, Stored Procedures and Functions
• Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues
• Ability to analyze and resolve performance issue with database code involvingSSISand MSSQL Server 2005/ 2008

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.