SUMMARY

• A Microsoft Business Intelligence Professional with 9+ 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.
• Extensive experience in database design, development, and administration with MS SQL Server versions … using MSBI (SSIS, SSAS, SSRS).
• Extensive experience in MS SQL Server … Business Intelligence technologies MSBI (MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS))
• Extensive experience inOracle … databases using SQL & PL/SQL.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008, 2012.
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP as per business needs.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Views, Sub queries and SQL joins to simplify complex queries involving multiple tables.
• Very strong in creating and maintaining database objects like Indexes, User DefinedFunctions, Triggers, recursive queries using CTEs in SQL Server.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge Replication.
• 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 ReportingService (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using (SSRS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in designing complex reports including sub reports and formulas with complex logic using SSRS.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in data extraction, data integration, data modeling and data rendering in Tableau.
• Responsible for analyzing customer’s clinical and business data, designing new analytics solutions and proposing new dashboard visualizations.
• Extensive experience on building dashboards using Tableau.
• Knowledge on working with cubes in Tableau.
• 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.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Experience in Agile (Kanban and Scrum) and water-fall methodologies.
• Strength in problem solving and effective team player with excellent analytical, troubleshooting, and conflict resolution.
• Strong experience in mentoring team members and writing documentation.
• Good analytical, written, communicational and interpersonal skills.
• Have proven track record working with various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.

TECHNICAL SKILLS

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

PROGRAMMING: T-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, MicroStrategy, QlikView, tableau

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, Irving, TX

Sr. MSBI Developer (SSIS, SSRS, SSAS) / Sr. Data Integration 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.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS
• Implemented data validations using script task and script components.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.
• 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.
• Creating and managing schema objects such as tables, views, joins, indexes, CTE’s, triggers & maintaining Referential Integrity.
• Coordinatedwithfront-end for implementing logic in stored procedures and functions.
• Improved query performance by adding covered indexes, adding file groups etc.
• 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.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Create Oracle Stored Procedures to implement the ETL Process control logic.
• Developed and maintainedOracleTable Partitioning and Partitioning Indexes.
• Designed Oracle views that generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
• Involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
• Worked closely with MicroStrategy team for reporting requirements.

Environment: SQL Server 2008/2012, SQL, Oracle Database 10g, PL/SQL Developer Oracle Forms 10g, Oracle Reports 10g, Enterprise manager, JavaScript, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry,DTSXchange, MicroStrategy9.2.

Confidential, TX

Sr.BI Developer (SSIS, SSRS, SSAS) / Tableau Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Coordinatedwithfront-end for implementing logic in stored procedures and functions.
• Developed web application for reporting portal using C#.
• Used VB.Net Code to create embedded functions in SSRS.
• Fetch the data from Oracle 11g by creating a linked server and useSQLServer to query Oracle database.
• Designed the packages in order to extract data fromSQLDB, flat files and loaded into Oracle database.
• 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 withSSAS 2008 and in adding calculations using MDX.
• Worked on developing Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SSRS 2008.
• Created Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Implemented best practices to improve dashboard visualizations
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Provided 24/7 production support for Tableau users. Executed and tested required queries and reports before publishing.

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

Confidential, Miami, FL

Sr. BI Developer (SSIS, SSRS, SSAS)

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 moduleof the project as a developer on MS SQL Server 2008 (using SSRS, T-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 T-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 T-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, Cincinnati, OH

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 T-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.
• Involved in debugging and Tuning the PL/SQLcode, tuning queries, optimization for theOracledatabase.
• Modified existing codes and developed PL/SQLpackages to perform certain specialized functions / enhancement onoracleapplication.
• Developed SSIS master package which include number of child packages.
• Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
• WroteComplex 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, Oracle9i, BIDS, Team Foundation Server (TFS), Windows server 2003, Internet Information Server (IIS), Microsoft Office 2010.

Confidential

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 at the backend at 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 T-SQL.
• Performed unit testing, regression testing.

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