SUMMARY:

• Over 8 years of strong experience in SQL Business Intelligence with demonstrated success in the Database Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) in Health and banking services.
• Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008/2005/2000.
• Effectively Involved in all the phases of Software Development life cycle Such as Analysis, Design, Development, Testing, Implementation and maintenance of project
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experienced in Creating and Updating Clustered and Non - Clustered Indexes to keep up the SQL Server Performance.
• Experience in database programming in writing T-SQL Stored Procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Proficient in OLTP, OLAP and Data warehousing Design concepts .
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL Server 2008R2, 2012, 2014 and 2016.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms, SQL Server Analysis Services ( SSAS ), SQL Server Integration Services ( SSIS ), and SQL Server Reporting Services ( SSRS ) in SQL Server.
• Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.
• Solid knowledge of Relational Database Management Systems and Data Warehouse Concepts.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems
• Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports .
• Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Bill Inmon and Ralph Kimball, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures and disaster recovery.
• Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)Experience in working with large databases in SQL.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Involved in implementing the Power BI Report Server
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Excellent interpersonal and analytical skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 7.0/2000/2005/ 2008/2, MS Access, Oracle8i/9i/10g, DB2

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

BI Tools: Data Transformation Services, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), Server Analysis Services (SSAS), Performance Point Server, Self-service.

Web Technologies: HTML, DHTML, XML, XSLT, XMLA, IIS, Apache.

Protocols/Middleware: TCP/IP, HTTP, FTP, UDP/IP, DOM, ODBC

Database Design Tools: Erwin 5.1, MS Visio 2007/2003, Rational Rose(UML)

Reporting Tools: MS Excel, Oracle Report Builder, Tableau, Power BI

T: SQL, PL/SQL, MS SQL, MDX, C/C++, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr.SQL BI/Power BI Developer

Responsibilities:

• Designed and developed various SSIS packages ( ETL ) to extract and transform data and involved in Scheduling SSIS Packages.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Extensively used SSIS transformations such as Lookup, Derived Column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.
• Constructed OLTP and OLAP Databases
• Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging.
• Created Partition Tables based upon Partition Functions and Partition Schemas.
• Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2014/2012 R2 versions in a clustered and standalone environment.
• Created reports based on the format specified in the design document.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drill down, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS .
• Involved in creating Dataset in the MS reporting services ( SSRS ) for calling the stored procedures and passed the parameters to the dataset.
• Actively participated in gathering of User Requirement and System Specification.
• Designed SSAS Tabular model for summary reports.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using ( SSAS ) and produced ad-hoc, standard and super user reports using SSRS.
• Involved in implementing the Power BI Report Server
• Created customized reports using various chart types like Text Tables, Bar, Pie, Line Charts, Pivot Tables, Combination Charts in Excel and Tableau
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
• Transformed and combined the data using Query Editor in the Power BI
• Created detailed dashboards utilizing Microsoft BI desktop to improve analysis and decision making with various sources Azure, SQL server, Excels.
• Managed reports/data sources, schedule report execution, and delivery.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI,Tableau, Visual Studio 2017, Business Intelligence Development Studio (BIDS), Team Foundation Server(TFS), MS Excel, Microsoft Windows Server 2016

Confidential, Rolling Meadows, IL

Sr.SQL BI/Power BI Developer

Responsibilities:

• Involved in analysis, design, development and enhancement of the application that applies business rules on the data on weekly basis.
• Install and configure the servers and clients using SQL Server 2012/2014. Create and upgrade SQL databases.
• Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views, CTE’s and other T-SQL scripts
• Ensure best practices are applied and integrity of data is maintained through security, documentation and change management.
• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Developed SSIS packages to Extract, Transform and Load (ETL ) data into the data warehouse database from heterogeneous databases/data sources.
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Created various dynamic reports using SSRS and Crystal reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Inspected the reports and fixed bugs in stored procedures and also tuned Reports.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Created reports and Data access from MDX, OLAP and cubes.
• Converted existing DTS packages to SSIS Packages
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Built Data marts (Fact and Dimension tables) from the warehouse tables.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
• Created gauge, funnel, slicer, stacked area chart, line chart utilizing Power BI
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models
• Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model..
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created Power BI Visualizations and Dashboards as per the requirements.

Environment: SQL Server 2008/2012/2014, R2/2012 Enterprise Edition, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, DAX, MDX

Confidential, Long beach, CA

SQL BI Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database and checked constraints to maintain data integrity.
• Query optimizations ( T SQL or Query Analyzer ) using query analyzer and Index tuning wizards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Used Data Modification Language ( DML ) to insert and update data, satisfying the referential integrity constraints and ACID properties
• Implemented and enhanced existing reports like Group by, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters .
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Created jobs to collect status information from various servers and feed them to the Master Server
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2012 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
• Created jobs to collect status information from various servers and feed them to the Master Server
• Created ETL SSIS packages both design and code to process data to target databases
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Created various visualizations and reports using Power BI.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: MS SQL Server 2008 R2/2012, Visual Studio 2008/2010, Micro Strategy Desktop 10/9, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, SQL Server Agent, MS Excel, Power Pivot, TFS.

Confidential, Phoenix, AZ

SQLSSRS/ SSIS/SSAS Developer

Responsibilities:

• Created audit events for master and child packages to track the status of the package execution.
• Created notifications, alerts to let support team know in case there are any failures.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, TRY and CATCH blocks
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services ( SSAS ) and Reporting service ( SSRS ).
• Worked on Mercurial source control to manage code.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor ( DTA ) and Performance monitoring.

Environment: SQL Server 2008, SSRS, SSIS, T-SQL, Script, Microsoft Office, Windows XP, SQL server profiler, SQL Server Management Studio (SSMS).

Confidential, TX

MSBI Developer

Responsibilities:

• Developed, monitored and deployed SSIS packages.
• Modified queries and stored procedures to improve the performance.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Developed normalized Logical and Physical database models to design OLTP .
• Created indexes both non clustered and clustered indexes in order to maximize the query performance.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
• Modified queries and stored procedures to improve the performance
• Generated multiple enterprise reports like SSRS and Crystal reports
• Data management and data processing solutions using SSIS , this includes Error Handling and Slowly Changing Dimensions
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
• Experienced in Data Marts, Data warehousing, Operational Data Store ( ODS) , OLAP , Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in creating Cubes and Tabular models using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008, T-SQL, Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Windows 7, Crystal Reports, Data Migration, Toad

Confidential

SQL/ETL Developer

Responsibilities:

• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2008R2.
• Created DTS/SSIS packages involving automated tasks for ftp, remote backups/restore, data exports.
• Performance tune and Optimize frequently used SQL Queries, Indexes and Stored Procedures.
• Migrate DTS packages from SQL Server 2005 to SQL Server 2008 Integration Services ( SSIS ).
• Data migration from other data storage like Oracle and DB2 using SSIS
• Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Maintained data integrity by performing validation checks.
• Created T- SQL queries for data retrieval.
• Fine-tuned the database objects and server to ensure efficient data retrieval.
• Formatted the reports using Global variables and expressions.
• Design and Implement Disaster Recovery Procedures like Log Shipping as well as Backup and Restore Strategies.
• Coordinated with front-end programmers in writing stored procedures, implemented referential integrity by using triggers.
• Created views as per design needs for security reasons.
• Created other database objects like tables and indexes .

Environment:: MS SQL Server 2008, SQL Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008, Windows 2007 Enterprise, MS Office 2007.

Confidential

SQL Developer

Responsibilities:

• Involved in analysis and design of the system specification and gathering requirements and prepared the document for proposed system.
• Involved in the Design of Interactive User Interface and Coding of the application.
• Involved in Designing and creating of Database Tables and Views.
• Facilitated simplified access of database for end users using de normalized views and created triggers on them to maintain to database integrity.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Performance tuning of SQL queries and stored procedures using Index Tuning Wizard
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels

Environment: SQL Server 2000/2005, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Visual Source Safe, SQL Server Management Studio (SSMS).