SUMMARY:

• Over 7+ years of experience as Microsoft SQL Server developer using Microsoft Business Intelligence (MSBI) tools such as SSIS, SSRS, SSAS and SQL Server data tools (SSDT) .
• Good hands on experience in writing complex SQL Server procedures, functions, views, triggers etc. and several advanced features.
• Involved in performance tuning of complex SQL queries and their optimization techniques.
• Experience in gathering requirements, design, development and deployment of SSIS (SSIS 2008R2 and SSIS 2012) packages.
• Highly proficient in integration of data from different sources like SQL Server, Oracle, DB2 and Flat Files into Enterprise Data Warehouse (EDW) .
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server Agent
• Experience in SQL Server Analysis Services OLAP Cubes .
• Expertise in writing MDX queries and building Key Performance Indicators (KPI) in cubes.
• Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports and Dashboards.
• Good knowledge of SSRS architecture. Involved in testing of Web services using WSDL files.
• Validated the SOAP requests and responses using the tool called SOAPUI.
• Involved in creation of mock responses using SOAPUI tool.
• Inserted assertions in SOAPUI to validate the expected response from the Web services .
• Configured and installed various software and Add - Ins on Windows, as well as conducted all upgrades
• Hands on experience in developing, deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports and Crystal Reports .
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008 R2/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008 R2/2012.
• Expert in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Experience in Data Warehouse concepts and on different schemas like Star Schema and Snow Flake Schema .
• Involved in designing of a Data Warehouse from the requirements phase.
• Good knowledge in Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience working in Agile and Waterfall model working methodologies.
• Knowledge on Health Care, Finance, Banking and Energy Domain .
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills .
• Quick learner and proactive team member with good Communication skills and Leadership capabilities.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Reporting Services. SQL Server Integration Services, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008/2005 ), Microsoft Access 2013, MS Excel, Microsoft -Access, Excel

Database: MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

MS SQL/MSBI Developer

Responsibilities:

• Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.
• Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into data warehouse.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created and Managed OLAP Cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
• Participated actively in client meetings daily and produced detailed level design document for the customer portals.
• Created parameterized reports, drill down, drill through, Sub reports, linked reports, Snapshot, Adhoc reports using SSRS2008 R2.
• Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Performance tuning and optimization of stored procedures Designed and written the queries in the query builder for retrieving the data.
• Involved in testing of Web services using WSDL files.
• Validated the SOAP requests and responses using the tool called SOAPUI.
• Involved in creation of mock responses using SOAPUI tool.
• Inserted assertions in SOAPUI to validate the expected response from the Web services.
• Configured and installed various software and Add-Ins on Windows, as well as conducted all upgrades.
• Used report items like tables, sub report and charts to develop reports in SSRS.
• Worked with various delivery mechanisms of reports including Email /PDF/Schedules
• Managed and troubleshoot report server related issues.
• Created dimensions with the cube wizard and generated named calculations /queries.
• Involved in defining referenced relationships with measure group and fact tables.
• Defined Granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSRS, BIDS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

Confidential, Cleveland, OH

MS SQL/MSBI Developer

• Involve in complete Software Development Lifecycle (SDLC).
• Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.
• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Created Matrix, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. Deployed RDLs to Report Server (Share Point).
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Managed indexes and optimized queries using execution plan.
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Used C#.Net and Vb.Net in Script tasks in order to validate the files and to get the latest files.
• Used Script component using C#.Net to perform row by row transformations in data flow tasks.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Upgraded SSIS 2005 packages to 2008 packages.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Used script task to produce HTML reports and mail using SSIS.
• Created SSRS reports by Report designer for the users and deployed onto the report server.
• Parameterized and cascaded reports are also used to make the reports interactive with the users.
• Supported multiple projects at a time.

Environment: Microsoft SQL Server 2008 R2/08, BIDS, SSIS, SSAS, SSRS, SQL Profiler, DTA, Erwin, WindowsServers.

Confidential, Chicago, IL

SQL/MSBI DEVELOPER

• Understanding the report design Requirements and Constraints.
• Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Performance tuning of Stored Procedures and T-SQL Queries
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart database.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
• Created Calculated members in MOLAP cube using MDX in SSAS 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.

Environment: Microsoft SQL Server 2005/2008/2012, T-SQL, SSIS, SSRS, MS Excel, Word

Confidential

ETL & SQL Developer

• Design & Develop ETL packages at different Stages (Acquire, Stage, ODS).
• Contribution in the Design & Development of Audit Balance control frame for ETL.
• Design & Develop Error handling & Email notification components.
• Involved in Enhancements and Fixing Issues.
• Experienced in identifying detailed analysis of data sources.
• Experienced in preparing data mapping document from source to target.
• Involved in preparing business transformation rules that should be applied to source data.
• Designed Data Migration Logic between source and Target Systems.
• Experience in Identifying data issues with data in the source systems.
• Loading data from the various data sources like Flat files, CSV's, SQL Server, MySQL etc.
• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, data conversion and Execute SQL Task to load data into Database.
• Extensive experience in performance tuning of SSIS packages.
• Implementing new functionality in the existing ETL packages.
• Monitoring the jobs and providing production support.
• Communicate effectively to management, business and technical roles to meet the deliverables and schedule
• Created Functional and Technical Specification document.

Environment: Windows 2008 R2, SQL Server 2008 R2, SSIS

Confidential

MS SQL/MSBI developer

• Analyze the functional specification and prepare the technical specification.
• Understanding business requirements and mapping with SSRS tool
• Creating stored procedures, user defined functions, SQL queries and views.
• Involved in performance tuning and re-factoring of the SQL scripts.
• Optimize T-SQL queries and stored procedures for logical accuracy and faster execution.
• Design, develop and unit test SSIS packages as per requirements.
• Design, develop and execute unit test cases for reports.

Environment: Windows 2003, 2008 R2, SQL Server 2005, 2008 R2, SSIS, SSRS