SUMMARY

• Over 8+ years of experience in design, development, testing, performance optimization and reporting using SQL Server Database Engine and Studios.
• Extensive experiences in developing Stored Procedures,Views,Triggers and Complex Queries, generating cubes on SQL Server …
• Extensive SQL Development experience in Healthcare, Financial, CJIS,Banking and Insurance industries with a strong understanding of data, analytics and involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of various projects.
• Created lot of Dashboards using Tableau.
• Worked on Maps, different type of charts, Drilldown hierarchies with Tableau.
• Worked on lot of Complex reports using SSRS.
• Worked on Report Designer to import reports from MS Access database and thus converting to RDL files.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Worked on Reverse engineering code with RDL files by evaluating the Xml code.
• Developed the entire layout and parameters of the entire bunch of reports hosted in MS Access
• Excellent experience and understanding of database design, migrating data using SSIS, relational integrity, Constraints, OLAP, OLTP, Cubes and normalizations.
• Expert in development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS with MS SQL 2008.
• Experience in working with SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Reverse engineered a share point integrated mode SSRS report for use in BIDS.
• Used TFS to open the RDL files in BIDS and then evaluated the code.
• Proficient in Database performance optimization, debugging and tuning using the SQL Editor, SQL Profiler and SQL Server Debugger.
• Expertise in upgrading and migrating SSIS packages, resolving complex issues and Error Handling in SSIS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS …
• Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
• Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access
• Knowledge regarding cubes and developed measures and dimension members using Multi-Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• Excellent experience as a Crystal Reports Developer working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Expertise in developing reports like Parameterized, Chart, Graph, Linked, Dashboard, Drill-down, Drill-through, Cascading reports
• Have good knowledge on MS Azure
• Proficient in using Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Experienced in capturing data changes made to the tables.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

ETL Tools: SQL Server Data Tools(SSDT), Business Intelligence Development Studio (BIDS), Reporting Services Migration Tool

Databases: SQL Server …, DB2, Oracle, Netezza, Hadoop, SAP HANAReporting/Analytic Tools SQL Server Data Tools(SSDT), Business Intelligence Development Studio (BIDS), Reporting Services Migration Tool.

Languages &Scripting: SQL, PL/SQL, UNIX Scripting, SQL PLUS, Java, HTML, CSS

Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Analytics Services (SSAS), SQL Server Reporting, Services (SSRS), Tableau, Power BI, Looker

Operating Systems: RedHat LINUX, Solaris, Windows, MacOS

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee,WI

MSBI Developer

Responsibilities:

• Developed, published and automatedreportsusing SSRS.
• Trained Business analysts and power users to create ad-hocreportson their own usingReportBuilder3.0, Excel.
• Creating reports using Power BI.
• Experience using the Report Builder data model for report creation.
• Power Query etc.
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Build SSAS Tabular Data Models.
• Build and deploy end to end ETL Process to load data into Data warehouse from flat files and source SQL databases using SSIS.
• Implemented security on SharePoint 2013.
• Create and modify various SQL queries, stored procedures and database views.
• Working with key stakeholders to gather business requirements forreportsand dashboards.
• Implementing Security and distribution of automatedreports.
• Works closely with the Data Warehouse development staff to develop new databases to support reporting needs and to identify and resolve database performance problems.
• Created SSIS packages to import data from Excel, flat files and other OLEDB sources.
• Developed and scheduled variety ofreportslike cross-tab, parameterized, drill through and subreportswith SSRS.
• Used SQL Server 2008R2/2012/2014 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Configured Reporting Services in SQL Server 2014.

Environment: SQL Server 2014, SQL Server Management Studio, Enterprise Manager,Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, SSRS, Visual Studio, Performance point server, Excel Power BI, Tableau.

Confidential, Menomonee Falls, WI

MSBI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Created Dashboards in Tableau.
• Created Various Chart reports using PowerBI(DAX).
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc.) in SSIS as per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked with different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• SSRS 2012.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: SQL Server 2012, SQL Server Management Studio, Enterprise Manager, Erwin, Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, SSRS, PowerBI, Tableau.

Confidential, Syracuse, NY

MSBI/SQL Developer

Responsibilities:

• Gathered requirements and designed solutions.
• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Performed data analysis and reported the findings to the business team
• Versioning of SSIS packages with TFS tool.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Production Support of Existing SSIS/ETL Packages.
• Designed and Implemented the SSIS Process to load data from FLAT FILES, EXCEL, XML Files and other Databases.
• Designed the ETL packages to support the incremental, historical data loads using SSIS.
• Created complex Stored Procedures, functions, views for application using T-SQL.
• Responsible for Scheduling and Maintenance of Jobs using SQL Agent.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Designed and implemented facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2012.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Responsible for creating Reports and Dashboards using Power BI Desktop tool.
• Used SSIS Advanced components like scripting, Email, Event handling etc., while building SSIS Packages
• Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Working with QA team on the Defects assigned and Test Case review.
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Production Support and coordinating with different teams across organizations during post implementation validations.
• Participate in UAT with end users to provide them technical guidance and data set up needs.

Environment: TSQL, MS SQL Server 2012, SSIS, SSAS, Power BI, MS Excel, Windows 7, TFS., Power BI

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2005, 2008, 2012,2014
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Adhoc reports using Import and Export Wizard.
• Handled Tableau admin activities granting access, managing extracts and Installations
• Used Tableau to visually analyze data and create concise and actionable dashboards
• Deployed and maintained Applications/systems/databases/stored procedures development on FACETS.
• Created backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau.
• Updated and migrated the data into to and from the FACETS application database.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Pulled the data from multiple database sources such as UDB/DB2/Teradata/SysBase and flat file sources that includes CSV, Excel, Mainframe (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Strong experience in creating and publishing packages in Framework Manager.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Used SQL Server 2008R2/2012/2014 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Configured Reporting Services in SQL Server 2014.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created different Power Pivot reports as per the client requirement.
• Worked on pre-defined facets included by SQL SERVER
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.

Environment: SQL Server 2012/2014, SQL Server Management Studio, Enterprise Manager, Erwin, Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, DMX, SSRS.

Confidential, San Diego, CA

MSBI 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.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, trigger to implementing the business rules and transformations.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management.
• Designed and built the dimensions and cubes with star schema using SQL Server Analysis Services.

Environment: SQL Server 2012/2008/2005 Enterprise Editions Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.s