PROFESSIONAL SUMMARY:

• Over 9+ years of extensive experience and hands on working knowledge in various domains of IT industry like Health care, financial and as SQL/MSBI Programmer
• Hands on experience in MS SQL Server 2014, 2012, 2008, 2005 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Experience in writing TSQL Queries (DDL and DML) involving various tables to create and maintain database objects like Stored Procedures, Triggers, user defined functions, Views, Cursors, Indexes.
• Experience in client requirement Analysis, Logical design, and development, Testing, Deployment, Support and Maintenance of business applications using SQL Server DTS, SSIS, SSAS and SSRS.
• Strong experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance using MS - SSIS, DTS and Converting DTS packages to SSIS packages.
• Strong experience in design, develop and deployment of the SSIS packages and SSRS reports using SQL Server DATA Tools.
• Extensive knowledge in designing on-demand and scheduled reports for business analysis or management decision reports using cascading parameters, Parameterized reports, report models for Ad-hoc reports using SSRS.
• Hands on experience in creating various types of reports like drill down reports & drill through reports, Cross-Tab reports, Matrix reports, sub reports and charts using SSRS based on Relational and OLAP databases.
• Experience in MS SQL Server installation, configuration, performance tuning, error handling, SQL Profiler, query optimization, client/server connectivity, back-up/recovery, running Database Consistency Checks (DBCC).
• Provided 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule
• Proficient at Documenting all Database Architecture according to established standards, capacity to balance both short and long term issues effectively and handle many simultaneous and often changing priorities.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Design, Development and Implementation. Knowledge on SCRUM/AGILE development methodologies.
• Ability to quickly adapt and learn, works well in team environment as well as independently with minimum supervision.
• E xcellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS:

ETL Tools: SQL Server Integration Service (SSIS), Server Reporting Services (SSRS)SQL Server Analysis Service (SSAS)

Database: MS Access, Oracle 9i, MS SQL Server 2012/2008R 2/2008/2005/2000

BI Tools: Business Objects.

Data Modeling: Erwin, Visio 2003

Reporting Tools: SSRS, Business Objects 6x, Crystal Reports, Report Builder 3.0

Languages: SQL, T-SQL, PL/SQL, HTML, C#.Net, VB.Net, Java script, CSS

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, Alabama

Sr. MSBI developer

Responsibilities:

• Collecting the requirements from end users and report owners to build the SSIS packages and SSRS reports.
• Created the SSIS packages to retrieve the data from MS ACCCESS DB, Oracle 11g, SQL server, flat files and excel files.
• Wrote queries in PL-SQL to retrieve the data from Oracle data sources using SSIS package and Teradata.
• Wrote the store procedures, Functions, views in SQL server according to the requirements.
• Creating Packages for data load process using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Created monthly Turnaround time reports on claims and measure productivity quotient on reviews of the cases which are getting from Providers and end users.
• Created complex reports in SSRS for the data retrieved from the different data sources through SSIS packages.
• Wrote complex store procedures for SSRS reports and SSIS packages.
• Redesigned some of the complex reports and store procedures.
• Involved in UAT and Deployment stages of SSIS Packages and SSRS reports.
• Worked on SSIS package Configurations and scheduling the jobs in SQL server Agent.
• Usage error handling, coding, trouble shooting, Event handlers for performance tuning of SSIS package.
• Worked on version control TFS.

Tools: Visual studio 2008,2012,2013,2014, SQL server 2008, 2013, 2014, Oracle 11g, Teradata, Share point SSIS, SSRS, SSAS, Java scripts, HTML, XML Java, C#, C, Oops concepts

Confidential, San Francisco, CA

MSBI Developer

Responsibilities:

• Collaborated with the project manager and design architect to outline business requirements utilizing JRD sessions.
• Participated in JAD sessions to discuss business requirement documents and drafted a functional/non-functional requirements document.
• Designed an advanced ETL architecture for the overall data transfer between the OLTP to OLAP with the help of SSIS.
• Developed SSIS packages for data profiling and data cleansing.
• Resolved SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
• Enhanced the performance of SSIS packages by configuring several properties / features at control and data flow level.
• Incorporated parameters to configure package properties to migrate SSIS packages from development/testing to production environments.
• Created SQL agent jobs for automating execution of SSIS packages on production server.
• Designed and developed SSAS cube with KPIs, aggregation, calculated members, and partition for reporting.
• Created various type of financial reports, drilldown reports, summary reports, and matrix reports in SSRS in SSRS with features such as document map, actions, conditional formatting.

Tools: SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Power View, TFS, DTA, SQL Profiler

Confidential, Plymouth Meeting, PA

ETL/SSRS Developer

Responsibilities:

• Collaborated with business users and project management to gather system specification requirements for the project via JRD sessions.
• Designed SSIS packages to transfer data from various heterogeneous sources such as SQL Server, Excel, CSV, etc. onto SQL server staging database.
• Created views for ETL requirement to ensure the data does not contain any redundancies within the staging database.
• Created SSIS packages to perform incremental load using merge and SCD techniques.
• Designed reusable SSIS Packages to ensure similar development practices are followed by all SSIS developers for logging, configurations, checkpoints, and error handling.
• Optimized the performance of slow executing SSIS packages by making changes to control flow and data flow such as avoiding blocking transformations and increasing buffer size.
• Configured SSIS packages using XML files and deployed in MSDB database for execution.
• Implemented report delivery with the use of the subscription function in SSRS.

Tools: and Environment: MS SQL Server, BIDS, SSIS, SSRS, Erwin, SQL Profiler, SQL Debugger, SharePoint, Power Pivot, TFS, Excel, Windows Server

Confidential, Warren, NJ

SQL/SSIS Developer

Responsibilities:

• Organized JRD meetings for gathering and analyzing requirements to develop BRD for BI applications.
• Modified the existing database by adding tables and relationships to support the billing system.
• Encapsulated frequently used SQL Statements into stored procedures, thereby reducing the query execution time.
• Developed and designed complex SSIS packages to extract data from multiple data sources, to include: Oracle, Flat Files, and Excel workbooks.
• Manipulated various advanced SSIS features such as error handling, transactions, checkpoints, loggings, and package configurations; successfully deployed the package into the project and package deployment model.
• Designed and implemented a variety of SSRS reports such as parameterized, drilldown, ad-hoc, and sub-reports using report designer as per the outlined requirements.
• Designed and created report templates, bar graphs, and pie charts based on financial data.
• Involved in report generation using Excel services and Power Pivot; deployed the generated reports onto the SharePoint Server.
• Created various data driven subscriptions on a monthly and a quarterly basis for multiple reports per the client’s outlined requirements.

Tools: SQL Server 2008 Enterprise Edition, SSIS, SSAS, SSRS, Query Analyzer, T-SQL, Excel, Visio, DTA, SQL Profiler

Confidential

SQL Server Developer

Responsibilities:

• Actively participated and 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 2005(using SSRS, TSQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Used DTS/SSIS and TSQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.