SUMMARY:

• Over 9+ Years of experience in IT involving development, testing and production support Including around 8 years of experience in analyzing, designing, tuning and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server DTS/SQL Server Integration, Reporting & Analysis Services
• Expert in Data visualization and Data analyze using Power BI.
• Strong experience in Agile Methodology
• Experience in creating Groups and measures using KPIs.
• Expertise Mobile dashboard creation and implementation using Power BI.
• Worked with Microsoft Power BI, Data Zen, DAX expressions, Power View and Power Query integrated with share point
• Experience in using SQL Profiler, Database Engine Tuning Advisor, Performance Monitor, and Index Tuning Wizard to improve the performance of queries.
• Strong experience in Agile Methodology
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, designing logical and physical data models
• Used Microsoft Azure platform for the building, managing applications and deploying web applications. Created Azure virtual machines.
• Strong experience with SQL Server and T - SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity
• ETL implementation using SQL Server Integration Services (SSIS)
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT, and Dimensions Table suing Analysis Services
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS)
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc.) using SQL Server Reporting Services 2012
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes, which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service
• Proficient in building Cubes, defining Referenced Relationships, and creating Hierarchies, Perspectives, Partitions, and Designed Aggregations in cubes using SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Self-motivated and possess ability for critical thinking, analysis, team-oriented, technically motivated, and creative, good interpersonal and communication skills. User oriented with a desire to learn client and business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Database: SQL Server 2005/2008/2012/2014, MS Access 03/07, Oracle9i/10g

Operating Systems:: Windows XP/2000/2003/Win XP/Win 7

Programming Languages:: T-SQL, HTML, C#, VB.Net

BI Suite: SSIS, SSAS, SSRS, Power BI, Power Pivot.

Database Tools: SSMS, MS Visual Studio, Toad, Ankhs 2.5, BIDS Helper 2008 v1.5

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

SR.SQL/BI/POWER BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Involved in UI Design for Power BI Reports and designed effective layouts.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Experience moving data from on-Prem Power BI to Azure
• Created Roles and implemented Row level security for user Authentication in Power BI.
• Developed windows services to store SQL Server data in to Cloud base data warehousing by using Azure.
• Implemented Security in Web Applications using Azure and Deployed Web Applications to Azure.
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all
• Creating and maintaining complex stored procedures, Extended System SP, Triggers, views, Tables, and user-defined functions.
• Created a cube using multiple dimensions and established the Relationship between Measure group and dimension tables using Star Schema in SSAS.
• Converted logical Database Design into Physical schema using the balanced normalization in 2nd and 3rd Normal form for highest performance.
• Wrote Stored Procedures to implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Improve the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
• Developed many Table Reports, Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided.
• Production support responsibilities

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SQL Profiler, Visual Studio (2012)Power BI, Windows 7, MS Office 2013, Team Foundation Server.

Confidential, Dublin, OH

Senior SQL Server BI Consultant/ETL (SSIS), SSRS, SSAS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into TEM database
• Worked extensively on creating Complex T-SQL Queries, Stored Procedures, User Defined functions and implementing Error Handling using Try & Catch Block
• Created SSIS packages to clean and load data to data warehouse and populate data from various data sources
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server
• Created SSIS Packages 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
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, QA, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis
• Automated the SSIS Packages using the SQL Server Agent Jobs
• Involved in performance tuning and query optimization.
• Responsible to generate reports based on the company's performance in every quarter using SSRS.
• Strong experience in data modeling (Star Schema/dimensional modeling), data marts
• Created the deployment scripts for every change management process and sprint deployments
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio
• Generated Reports using SQL Server Reporting Services
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports per business requirement

Environment: SQL Server 2012 and 2014, SQL Server Data Tools for Visual Studio 2013, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt, Agile Methodology

Confidential, Minneapolis, MN

SQL ETL (SSIS), SSRS, SSAS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database
• Created the Stored Procedures, tables, Views depending upon the project requirement
• Created the deployment scripts after the development is done for every project
• Automated the SSIS Packages using the SQL Server Agent Jobs
• Developed, monitored and deployed DTS packages
• 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
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Involved in performance tuning and monitoring of T-SQL blocks
• Imported the various files provide by the clients into the relational database systems
• Used the BCP to load the large volumes of data from files into tables
• Worked with Business Analysts and Users to understand the requirement
• Created SSIS Packages 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
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports per business requirement
• Documentation for all kinds of reports and SSIS packages
• Used Visual Source Safe as Version Control Tool

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt

Confidential

SQL Server Developer ETL (DTS), SSRS, SSAS Developer

Responsibilities:

• Worked with SQL to create Tables, Views, and Triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures, and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Application support for ETL, Data transformation and Data Analysis
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and created linked server with different access files used across various departments
• Extensive use of T-SQL DDL and DML commands for various applications
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data

Environment: T-SQL, SQL Server 2008 Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003 and Erwin Data Modeler

Confidential

Quality Analyst / QA Test Engineer

Responsibilities:

• Overall accountability for planning, developing, maintaining, and executing the project Test Plan, Test Scripts, Test Execution, defects tracking and release
• Reviewed and Analyzed the System Requirements and Use Case Documents
• Prepare Test Plans, Test Scenarios, and Test Scripts
• Execute Test Cases, set up test results and Status Reporting
• Wrote SQL Queries to check for relationship between tables within a database as well as for the communication/data flow between those tables
• Wrote SQL queries between source and target for validating ETL jobs
• Tested complex ETL jobs based on Business requirements and Business rules to load data from source Mainframe files, Views, and Stored Procedures to target tables
• Involved in extensive data validation using SQL queries and back-end testing
• Performed SQL testing for data accuracy using TOAD
• Documented defects and followed throw out the defect life cycle using Quality Center.

Environment: and Tools: SQL Server, TOAD, Oracle, Win Runner, HP Quality Center, SQL, Visual Basic, MS Office, HTML, JavaScript, Windows, UNIX, and Test Director