SUMMARY

• Over 8 years of experience in design and development of data warehousing applications with experience in Microsoft business intelligence (SSIS, SSRS, SSAS).
• Worked extensively on SQL server 2005/2008 suite of products SSIS, SSRS and SSAS
• Experienced in writing SQL, T - SQL, stored procedures and functions in MS SQL Server 2012/2008R2/2008
• Very strong T-SQL skills in creating and maintaining database objects like Indexes, Views, Stored Procedures, User Defined Functions in SQL Server
• Experience in ETL (Extraction, Transformation and Loading) using Data transfer services (DTS), Service Broker and SQL Server Integrated Services (SSIS) from various Data sources.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2005 databases and scheduled them according to requirements.
• Created reports like Matrix, Crosstabs, Charts and Performance Dashboards using SSRS 2012.
• Developed (Monthly) trust level Performance Management Framework dashboard for executive management team and presented at EMT board using SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008/2012.
• Designed calculated measure and dimensional members using multi-dimensional expressions (MDX).
• Experience in data load process by Scheduling packages, Maintenance plans and alerting SQL- jobs using SSDS.
• Experience in designing and building dimensions and cubes with data warehouse star schema/snowflake schema using SQL Server Analysis Services (SSAS).
• Experience in development and presenting Microsoft data visualization tools Power pivot and Power View.
• Provided Detailed Documentation for Enterprise Data warehouse Design and Development.
• Excellent skills in preparing Project documentation and Use Cases, using MS Office and MS Visio. Expert in creating and maintaining Documents for future needs.
• Provided on- call support to mission critical environments and expertise with disaster recovery mechanisms.
• Worked in agile development methodology (SCRUM) environment.
• Good Experience on QlikView server architecture and buildingqvd’sandqvw’sapplying business rules and data validations.
• Develop,maintainanddebugseveral QlikView applications usingSet Analysis,VBScript, QlikView Enterprise Server and Windows Task Managerto automateextractionof data from QlikView documents.
• Strong Experience in maintaining QlikView Server,Load Balancing,Auto reloads& organizing QlikViewLicenses. Expert in reducing thefile sizeandreload times by 60%.
• Experience in setting up security at different levels using User access (Section Access) & Access to data (Section Application).
• Ability to manage and deliver results on multiple tasks by effectively managing time and priority constraints.
• Strong Interpersonal and communication skills, ability to work in a team as well as independently

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008/2008R2/2012,SQL Source Control, DTS, SSIS, SSRS

Database: MS SQL Server 2012/2008/2005 , MS Visual Studio 2008/2012, MS-Access

Language: C, C++, T-SQL, PL/SQL,HTML, C#, ASP.NET

ETL Tools: SQL Server 2012/2008/2005 Integration Services (SSIS)Data Transformation Services (DTS, Import Export Data, Bulk Insert

IDE & Application Server: Microsoft Visual Studio 2008/2005, SharePoint Server 2010, Qlikview

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• Developed logical and physical data model using ERWIN and mapped the data into database objects.
• De- normalized existing normalized schemas to support quick data retrieval in reporting and OLAP workloads.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Created alerts for successful and unsuccessful completion of scheduled jobs into Enterprise Data warehouse.
• Used SSIS to implement slowly changing transformation, to maintain historical data in data warehouse.
• Used various SSIS tasks such as conditional split, derived column, which were used for data scrubbing, data validation checks during staging, before loading the data into data warehouse.
• Created SSIS packages to export and import data from different sources like CSV files, text files and load data into data warehouse.
• Problem identification, troubleshooting and index tuning databases.
• Designed and developed Meta Data Service (MDS) and Data Quality Service (DQS) logic to maintain data integrity in data warehouse and transactional databases.
• Created functions to provide custom functionality as per the requirements.
• Utilized scripting technologies to clean data, move files from FTP locations to server file locations
• Created Ad-Hoc reports, summary reports, sub reports and Drill-down reports using SSRS.
• Scheduled SSRS reports for daily, weekly, monthly reports for executive management team and customer representatives for various streams of the organisation.
• Deployed SSRS reports in to SharePoint portal and Report Builder 3.0.
• Utilized Microsoft team foundation server and its features for code sharing and updates from other members.

Environment: MS SQL Server 2008R2/2012, Visual Studio 2008/2012, and BI tools SSIS, SSAS, SSRS. MS Office 2010/2013, MS Access, MS Excel, Framework, Visual Studio Team Foundation Server (VSTS), SQL Source Control

Confidential

Business Analyst/ BI Developer

Responsibilities:

• As a member of Database team, involved in gathering Requirement, Design, Development, Testing and Implementation of BI Analytics needs.
• Designing and implementingStored Procedures, Views, Indexes (Clustered and Non-Clustered), Functions and Triggersfor automating tasks.
• Developed (Monthly) trust level Performance Management Framework dashboard for executive management team and presented at EMT board.
• Trained business users and executive management teams in new BI tools power pivot and power view.
• Provided Quality/Assurance documentation to commissioners on weekly and monthly reports.
• Reported national level Ambulance Quality Indicators, Quality assurance reports and Adhoc reports.
• Developed various Drill-through reports, parameterized reports and linked reports using SSRS. Deployed SSRS reports in to Confidential SharePoint portal and Report Builder 3.0.
• Extracted Data from MIS data source provider on daily basis setup SQL server agent jobs to populate enterprise data warehouse using SSIS.
• Used SSIS Fuzzy matching transformation to match Ambulance Data sets with PDS data sets.
• Used SQL Profiler for troubleshooting, monitoring,optimizationof SQL Server and SQL code.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc.
• Designing and implementingETLprocesses to make data available for reporting purpose within a data warehouse.
• CACI are technical partners. Had to liaise with them in Installing and setting up Qlikview server version 11.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed dashboards withmulti-tabbedapplications with multiplechartsper tab, lots of drilldowns to new views,calculationson-the-fly, the ability to slice and dice around specificdimensionsetc.
• Developedadvanced backupsystem through QlikView Publisher to allow forautomaticsaving of multiple versions of all QlikView applications and supporting files.
• Successfully loaded data from Excel, Access andFlat Files(.txt) into a SQL Server database Table.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Environment: MS SQL Server 2008R2/2012, Visual Studio 2008/2012, MS Office 2007/2010, MS Access, MS Excel, Visual Studio Team Foundation Server (VSTS), SQL Source Control, and BI tools SSIS, SSAS, SSRS, Power pivot, Power view, Qlikview 11Version R3.

Confidential

Senior BI Developer

Responsibilities:

• Analyze the need of Data for various applications and design database objects.
• Develop Object designs and work flow with approval from the higher management.
• Load/Migrate data from various flat files and data centers into database tables using SSIS.
• Condition Split, Pivot Transformation, Fuzzy Lookup, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleansed data from Excel Spreadsheets, Text file, MS Access and XML files to data warehouse.
• Performed Quality assurance analysis on organizational data sets provided by Data center ( Confidential ) England.
• Analysed existing SSIS packages and Re-developed the data load solutions, which helped in enhancing existing data load process.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Test and Production Environments.
• Created packages to load the data which I have used to generate ad-hoc SSRS reports, Generated reports using global variables, expressions and functions for the reports.
• Regular processing of Cubes (A&E, Budgets, Inpatients, Outpatients and Population) restore, backup and re-deploy to live using SSAS.
• Extracted and reviewed data from heterogeneous sources (Text files, Excel and Access Files) from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008R2.
• Applied various data transformations like SCD (Slowly Changing Dimension) - to maintain the history of the data, aggregate, sort, multicasting, conditional split and derived column.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Create stored procedures to make data presentable via views and tables catering data to various front end applications and Access databases.
• Created reports for business via SSRS.
• Involved in reusable documentation of processes for end users.

Environment: MS SQL Server 2008R2, SSIS/SSRS 2008, Visual Studio 2008, Windows 2003 Server, MS Office 2007, MS Access, MS Excel, Framework

Confidential

SQL BI Developer

Responsibilities:

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• CreatedSSISpackages to clean and load data to data warehouse
• Created packages to migrate data from different data sources to data warehouse.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc.,
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
• Created Stored Procedures, User Defined functions, Views and 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.
• Executed the test cases in Quality Center to ensure the quality of the data migration.
• Designed and executed the test cases for Data Migration in Quality Center.
• Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments
• Built different types of chart reports usingSSRSfor the business requirement like Designed and deployed reports with Drill Down, Drill Through, Drop down menu options, Sub-reports in SSRS using BIDS.
• Report parameters included single valued parameters, multi-value parameters that also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created complex stored procedures to use as the datasets for the Report Design, to generate Ad hoc reports using SSRS
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts)
• Developed SSRS Report Models.

Environment: MS SQL Server 2008R2, SSIS/SSRS 2008, Visual Studio 2008, Windows 2003 Server, BIDS, MS Office 2007, MS Access, MS Excel, Framework, VB, ASP.NET

Confidential

BI Analyst/ SQL Developer

Responsibilities:

• Involved in all phases of System Development Life Cycle (SDLC).
• Creating Database objects - Tables, Views and developing procedures for implementing application functionality at the database side for performance improvement.
• Managed the Bulk Supply of Data from operational system and involve in packaging and presenting to end users to meet the specific management needs.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• 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 Cross-Tab, Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).
• Performed DBCC checks and fixing data corruption in Application databases.
• Created the Best Coding Practices Document for stored procedures & functions for the Developers.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports
• Designed and developed SSIS packages, MDX Scripting stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS)

Environment: MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services.

Confidential

SQL BI Developer

Responsibilities:

• Expertise in database design and systems integration
• Gathered Business rules and implemented functional and technical specifications
• Expertise in SQL Server database architecture and SQL server systems integration.
• Used various ETL Tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and Views to other databases or files
• Interacting with Business Analysts and administrators in identifying the requirements and designing and implementing the Database Schema.
• Created stored procedures and DTS packages to load data.
• Migrate DTS packages on legacy Servers to SQL Server Integration(SSIS)
• Created several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules.
• Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Analysed requirements of users by interaction with the Business and the Data Management teams to the closure of Critical Tickets.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Environment: MS SQL Server 2005 SSRS 2005, MDX queries

Confidential

Information Analyst

Responsibilities:

• Involved in gathering requirements from the end users and document them for development
• Involved in creating tables, Views, Procedures and linked servers
• Worked on data imports and exports.
• Part of the QA analyst team- implemented testing scenarios between each module implementation and version uploads before the prerelease from design to development and production.
• Tested the functionality of the Event, Programs, sessions, attendees and Activities and Expenses within the project limitations
• Planned and executed Back-End and conversion testing using numerous SQL Queries to verity the dataflow from the Siebel database
• Created a standard Audit Trail methodology during data loads to verify the data and hits on the screens.
• Created a Mail management system to notify users at every step of data loads.
• Authorize new promotes of database objects into production systems
• Excelled as a part of the successful implementation and migration team from SQL

Environment: SQL 2000/2005, Windows XP, IIS, MS Access, SQL, Oracle, TOAD