SUMMARY

• A Microsoft Business Intelligence Professional with 7 plus years of strong experience in all phases of SDLC, including gathering Business Requirements, Design, Development, Testing and Implementation of large - scale enterprise applications in Healthcare and Financial domain.
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP as per business needs
• Highly proficient in the use of Confidential -SQL for developing complex Procedures, Views, Sub queries and SQL joins to simplify complex queries involving multiple tables.
• Expert in using tools SQL profiler and database tuning Advisor (DTA).
• Very strong in creating and maintaining database objects like Indexes, Stored Procedure, User Defined Functions, Triggers, recursive queries using CTEs in SQL Server.
• Experience in Change Data Capture (CDC), Change Tracking (CT).
• Expert in Query Tuning activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance based issues on the server.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology.
• Expertise in developing complex SSIS Packages including C# scripting to extract data from heterogeneous data sources.
• Developed SSIS packages for processing fact and dimension tables with complex transforms and Slowly Changing Dimensions type 1 and type 2 changes.
• Hands on experience in Microsoft Reporting Service (SSRS) 2005/2008/2012 with Report authoring, Report management, Report delivery and Report security.
• Experience in analyzing Data ware house by building cubes using SSAS.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SSAS.

TECHNICAL SKILLS

DATABASES: MS SQL Server 2005/2008/2008 R2/2012, Oracle

PROGRAMMING: Confidential -SQL, PL/SQL, C, C#, HTML, MDX.

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS).

ETL TOOLS: DTS, SQL Server Integration Services (SSIS).

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SSRS, Report Builder, Micro Strategy, QlikView

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS).

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin 4.x/7.x, MS Visio 2000/2003

AGILE TOOLS: Jama 4.0 and Rally

SQL SERVER TOOLS: SSMS, Enterprise Manager, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. DI Developer

Responsibilities:

• Responsible for requirement gathering from Business users.
• Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
• Improved query performance by adding covered indexes, adding file groups etc.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Created packages in SSIS with error handling using various data transformations.
• Created and deployed Reports utilizing SSRS to design complex reports.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
• Created dashboard, scorecards, and KPIs.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Worked closely with Micro strategy team for reporting requirements.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server 2008/2012, SQL, Enterprise manager, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry, DTSXchange.

Confidential, OH

Sr.BI Developer

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server database using SSIS package.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Worked on developing Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SSRS 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, Confidential -SQL, SSRS, Windows Server 2003, Oracle 11g,Hyperion 11.1,Performance Point Server 2007, Report Builder 2.0.

Confidential, FL

BI Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, Confidential -SQL, scripts, stored procedures and views).
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Involved in building of OLAP cubes with SSAS and in adding calculations using MDX
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Use DTS/SSIS and Confidential -SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Wrote custom Confidential -SQL stored procedures, indexes, cursor, functions and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, XML, Windows 2000/2003 Server, Erwin, Performance Point Server 2007.

Confidential, TX

SQL Server Developer

Responsibilities:

• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Created new database objects like Procedures, Functions, Packages, Indexes and Views using Confidential -SQL in SQL Server 2005.
• Worked on Client tools like SQL Server Management studio to administer SQL Server.
• Data conversions and data loads from various databases and file structures.
• Created SSIS Packages to load the data from different carriers like Confidential, Confidential and Confidential & Confidential .
• Developed SSIS master package which include number of child packages.
• Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
• Wrote Complex SQL Queries to generate Reports based on the business requirement.
• Designed and developed Drill down and Drill through reports using SSRS.
• Created Parameterized reports and Linked reports which navigates to other report.
• Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services (SSRS)
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.

Environment: Microsoft SQL Server 2005, BIDS, Team Foundation Server (TFS), Windows server 2003, Internet Information Server (IIS), Microsoft Office 2010.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Involved in design of the database and tables.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Wrote procedures to check some of the rules Confidential the backend Confidential the time of entering data.
• Imported and exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded Different database objects Views, Triggers in Confidential -SQL.
• Performed unit testing, regression testing.

Environment: SQL Server 2000, SQL Query analyzer, SQL Enterprise Manager, Confidential -SQL, Windows 2003, Visual Studio.