SUMMARY

• 9+ years of experience in IT industry with 5+ years of experience in Microsoft Business Intelligence - SSIS/SSRS/SSAS and SQL Server database development.
• Relational Database Management System (RDBMS) Database design, Data Migration and Database upgrade.
• Experience in writing complex T-SQL queries, stored procedures, triggers, views and functions. Performance Tuning of T-SQL queries, Index Performance tuning was also part of responsibilities.
• Good experience in Extraction, Transformation and Loading (ETL) using SQL Server Integration Services(SSIS) tool. Used multiple transformations in SSIS to meet the business requirements by collecting data from heterogeneous sources to destination database.
• Created SSIS jobs, which run on daily/ weekly/ monthly basis to update fields in reporting files.
• Optimized the performance of SSIS packages using features like Auditing, Checkpoints, Transactions, Loggings and Event-Handlers.
• Skilled in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor.
• Sound knowledge on data warehouse concepts like Analysis Services (SSAS), Cubes, Data mart. Also, good understanding on Data Warehousing methodologies and concepts including Star Schemas, Snowflake Schema using fact and dimensional tables.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Created calculated measures using MDX/DAX implementing business requirement.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Experience on reports development using SQL Server Reporting Services (SSRS).
• Experience in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SSRS.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SSRS.
• Administered report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.
• Experience in Troubleshooting Report Processing, Subscription, Delivery, and Configuration Problems.
• Proficient in Microsoft Office Excel-Power Pivot, Power View, Word and PowerPoint with good knowledge on Power BI.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Good knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in designing interactive dashboards using Tableau desktop.
• Exceptional problem-solver with keen ability to resolve technical issues, provide for system enhancements, analyze/define business processes for improvements in processes.
• Excellent team player who listens, thrive on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action.

TECHNICAL SKILLS

Data Warehousing ETL Tools: SQL Server Data tools for visual studio 2013 & 2015 SQL Server Integration Services (SSIS 2014 / SSIS 2008R2)

Operating Systems: Windows NT/ XP, Windows 95 / 2000 / 2003 / 2008 R2, Linux, Mac

Programming and Query Languages: C, Visual Basics, T-SQL, C#, COBOL, MDX, DAX

Databases: SQL Server 2014/SQL Server 2012/ 2008 R2 MS Access

Reporting Tool: SQL Server Reporting Services (SSRS), Excel, Tableau, Crystal Reports, Power BI

Version control Tools: Microsoft Team Foundation Server (TFS 2010)

Data Modeling Tool: MS Visio

File Transfer Tool: FTP/SFTP

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

MSBI Developer

Environment: Windows XP, MS SQL Server 2008R2/ 2014, SQL Server (SSIS, SSRS, SSAS), SQL Plus, Windows 2008, Visual Studio version 3.5, Power BI.

Responsibilities:

• Extract data from multiple sources like Flat files, Oracle database and transforming, cleansing, validating data and loading into final Destination SQL Server 2014 using SSIS.
• Generated reports based on the statistical analysis of the data from various time frame, Geographical region and division using SQL Server Reporting Services (SSRS).
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Database server upgrade from SQL Server 2008R2 to SQL Server 2014 Project: This project was to upgrade SQL environment from 2008R2.
• Upgraded and configured database servers (Development, Test/staging, Sand Box and Production servers) from SQL Server 2008R2 to SQL Server 2014.
• SSRS reports upgraded to 2014 using SQL Server Data tools.
• Upgraded SSIS packages (multiple projects) using SQL Server Data Tools.
• Used new SQL feature of deployment using SSIS DB.
• SQL agent Jobs backup and restore on new upgraded 2014 server.
• SQL logins backup and restore on new servers.
• SQL Operators backup and restore.
• Database backup plans on file server. Setting up the alerts. Worked with system administrator.
• Analysis report on non-compatible applications to SQL 2014.
• Created and modified stored procedures, functions, views.
• Created indexes, Tuning the time consuming SQL queries.
• Daily database full and transactional backups.
• Transfer scripts using FTP, SFTP.
• Extract data from multiple sources like Flat files, Oracle database and transforming, cleansing, validating data and loading into final Destination using SSIS.
• Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup, Multicast, Execute SQL Task to load data into data warehouse.
• Implementing slowly changing dimensions to maintaining Historical data in Required Dimension Tables.
• Implemented check points, Break Points and logging for each SSIS package.
• Created Event Handlers for the Packages for Error Handling.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views and functions.
• Created and Deployed packages successfully.
• Monitoring the SQL Server Performance using SQL Server Profiler and Performance Monitor, implement best practices to maintain optimal performance.
• Experience in Designing, Building the Dimensions, cubes with Star schema using SSAS for analyzing purpose.
• Developed Aggregations, partitions and calculated members for SSAS cube as per business requirements.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Work with business units to scope and define analytic requests.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Used Power BI to create self-service BI capabilities and use tabular models.
• As per requirements, developed the reports in the form of Matrix, Table and Chart Using SQL Server 2008R2 Reporting Services.
• Generated Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports from queries in SSRS as per the Client Requirements.
• Used cascaded parameters to generate a report from two different Data Sets.
• Created data-driven subscriptions.
• Developed ad-hoc reports for business end users using Report Builder.
• Developed Cascading Reports for Employee Reports.
• Worked on Team Foundation Sever 2008 to store (check in or check out) the sql queries, packages, and reports to share them with the team members.
• Deployed SSRS reports in SharePoint for web based access for multiple end user.
• Configured and maintained Report Manager and Report Server for SSRS.

Confidential, Richmond, VA

SQL Server/SSIS /SSRS/SSAS Developer

Environment: Windows XP, MS SQL Server 2012, SQL Server (SSIS, SSRS, SSAS), Excel 2003

Responsibilities:

• Provided assistance for development teams on tuning data, indexes and queries and created indexes on the tables to remove unnecessary columns and to eliminate redundant and inconsistent data.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different types of transformations using SQL Server Integration Services (SSIS).
• Extensively worked on transformations like For each Loop Container, Execute SQL Task, Conditional Split, Derived column.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created and deployed different types of reports such as Tabular, Drill down Reports, Drill through Reports, Sub-Reports depending on requirements using SQL Server Reporting Services (SSRS).
• Creation of ETL Mappings to load data from Files and SQL Server Databases to Data Warehouse Data Marts.
• Created transformations and mappings using data flow tasks.
• Creation of tabular, Matrix, Chart types of reports in SSRS.
• Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using Integration Services & SQL Server.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Creation of different kinds of reports in SSRS.
• Implemented Package Configuration, Message Logging and Auditing.
• Generated the Reports Weekly and Monthly basis as per the Client Requirements.
• Involved in unit testing.

Confidential, Topeka, KS

SSRS Developer

Environment: Windows XP, MS SQL Server 2012, SQL Server (SSIS, SSRS), Excel, Crystal Reports.

Responsibilities:

• Extracted data from internal data warehouse system to SSRS.
• Migrated Crystal Reports to SSRS.
• Tracked trouble ticket request for request made by end users.
• Created ad-hoc reports.
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.
• Analyzed data models, data relationships, and dependencies for greatest optimization.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Confidential

Procurement Operations Team Lead

Environment: SAP R3, SAP SRM, SAP BW, Citrix, Microsoft Office tools

Responsibilities:

• Extract the data related to Vendors, requisitions, Purchase orders, Commodities, catalog orders from Business Warehouse (SAP BW) at frequent intervals.
• Create SLA reports in Excel (used Pivot table, VLOOKUP) and report KPI’s to Management.
• Extract RZ 20 error report from SAP/R3, Analyze and take appropriate action to reduce the error percentage.
• Analyzing and tracking unprocessed and unfulfilled requisitions or monitoring PO input ratios.
• Providing the number of PO’s (Hands-on, Hands Free, Invoice in Hand) created and open PO’s on weekly, monthly and quarterly basis and articulate findings to management.
• Work on tickets - Analyze & Identify the issues & resolve the Issue (If required allotting to the appropriate team for the resolution).
• Ensure that all orders are completed by the expected deadline by monitoring individual workload statistics and assessing needs in advance.
• Involved in User Acceptance Testing (UAT) in EBP.
• Create operational and ad-hoc reports and data extracts to support business processes.
• Create a variety of highly complex reporting solutions such as operational reports, dashboards to visualize business unit performance and trends.
• Create and maintain documentation of processes, reports, applications, and procedures.