Experience Summary:

• Around 8 years of IT experience in the Analysis, design, development, testing and Implementation of ETL Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, UNIX OLAP.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge of entire Software Development Life Cycle SDLC methodologies like waterfall model and Agile methodology
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Experience in OLTP/OLAP environment and Data Warehouse.
• Extensive experience in SQLServer Analysis Services OLAP Cubes, and Data Mining.
• Work experience on MS SQL Server 2012/2008R2/2005/2000, Oracle, VB 6, crystal reports 6.
• Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS
• Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
• Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Involved in migration of legacy data by creating various SSIS packages
• Expert in Data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , DTS, Bulk Insert and BCP
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down ,Drill-through And Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert in generating drill down reports in SSRS 2008.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Exceptional Computer Science background with programming skills in VB as a Junior Programmer.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in using Team Foundation Server TFS and Visual source safe VSS as a tool for repository of codes and version control, branching and merging into production.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Proficient with automated testing tools Win Runner, Load Runner and QTP for testing Client / Server and Web based applications
• Test Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

Technical Skills:

RDBMS/DBMS: MS-SQL Server 2012, 2008R2, 2005, 2000, Oracle 11g/10g

Database Tools: SQL Server Entreprise Manager, SQL Server Int gration Services SSIS , SSAS, Microsoft Management Console, SQL, T-SQL, Data Transformation Services DTS , DTSX, Datastage PX 8.5/8.1,7.5.3, Team Foundation Server TFS ,

Reporting Tools: Microsoft SQL Server Reporting Services SSRS , Crystal Reports

Operating Systems: Windows 7, Windows XP, 2000, Windows 2003 server, Windows 98

Programming Languages: SQL,T-SQL,PL/SQL,XML,HTML,VisualBasic6,VBScript, C ,.NET,VB.NET,ASP.NET,ADO.NET,

Design Tools: Erwin 7/4, MS Visio 2007/2010

BI Tools: SQL Server Management Studio SSMS , SQL Server Business Intelligence Development Studio BIDS ,

Professional Experience:

Confidential

SQL Server BI Lead

Responsibilities:

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension SCD to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Planned, defined and designed data based on the business requirement.
• Documented Up-gradation, Procedures from SQL Server 2008 to SQL Server 2012.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different type of reports including Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription Data Driven and Standard to publish reports
• Conducted data import and export operations using the DTS wizard.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability
• Worked with QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components

Environment: SQL Server 2012, SQL BI Suite SSIS, SSRS, SSAS , T-SQL, C . Net, XML, SQL Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010

Confidential

Sr. Reporting Analyst

Responsibilities:

• As a Report Writer, I was responsible for defining Report Requirements, Design, Develop, Test and validate the new report requests from users.
• Developed reports using SSRS and crystal reports and used table control, matrix control for cross tab reports.
• Validated all Clinical Reports and Decommissioned which are not in use.
• Have a very good overall exposure to clarity reporting Inpatient, Ambulatory, ADT Reports.
• Working with various user groups from Hospitals, Medical and Hospital service departments.
• Strong experience in building numerous reports from scratch.
• Strong SQL skills in creating stored procedures, views, functions and developing complex SQL commands to use in crystal reports
• Developed inpatient related reporting workbench reports and modified clinical epic released templates.
• Developed an automated report subscription process using SSRS.
• Used JIRA a ticketing system to track and document the progress and status of the reporting requests.
• As part of my job, built different reports using tools like Epic Hyperspace for understanding the requirement, Data Models to understand where the chronicles data is stored in clarity tables, Data Dictionary - to understand the definitions of the tables, Crystal Reports for building the report as per the requirement, SQL Server writing SQL queries, Views Stored Procedures.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Designed and developed various SSIS packages ETL to extract and transform data and involved in Scheduling SSIS Packages.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Performed the query tuning to optimize the procedures and triggers to be used in production.
• Created Lab test results reports. Developed yearly, quarterly, monthly test reports, TAT and volume reports

Environment: SQL Server 2008R2, SQL BI Suite SSIS, SSRS, SSAS , BO XI 3.1, Crystal Reports 2008, Enterprise manager, Oracle 11g, Rhodes, Sun Quest, Power Path, EPIC, MS office 2010, JIRA, ITSM

Confidential

Sr.SQL Server BI Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed software and database solutions.
• Worked closely with database to design and implement database components in timely manner..
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services SSAS .
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Identified and defined Fact relationships in SSAS, Created cubes, dimensions, KPI, Measures and calculations.
• Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Created partition using partition scheme and functions of SQL server to achieve better performance in retrieval of data from database.
• Schedule Jobs to run SSIS package.
• Load data from database to Data warehouse using SSIS packages.
• Involved in designing Parameterized Reports and also cascaded Parameterized Reports.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis SSAS
• Created security roles and perspectives in the cube using SSAS.
• Created SSIS packages to load the daily transactional data into the database.
• Created reports from complex SQL queries and MDX queries in Agile Scrum methodology
• Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services SSAS to allow the execution of sophisticated reports and complex queries.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Created calculations of queries with MDX in SSAS, developing reports using MDX and T-SQL.
• Worked on troubleshooting, performance tuning, performance monitoring and enhancement of Datastage jobs.
• Create and execute unit, functional and integrated testing.
• Responsible for maintaining UAT User Acceptance Testing and Production Environment
• Provided 24/7productionsupport for the production database and also to the code deployed into the production environment

Environment: SQL Server 2012, SQL BI Suite SSIS, SSRS, SSAS , Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2007, MS office 2013 pro plus , TFS, Agile

Confidential

Sr.SQL Server BI Developer

Responsibilities:

• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Involved in installing and migrating legacy databases to SQL Server 2008.
• Designed and developed SSIS Packages .dtsx files to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Created SSIS packages to integrate the data coming from flat files
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Performed database backup and deployment to the production server.
• Involved in modifying existing Datastage Jobs for better performance.
• Created detail Technical documentation of various staging area operations for future reference and guidance.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports SSRS 2005/2008 .
• Installation and configuration of SQL Server Reporting Services SSRS 2005/2008
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports SSRS 2005/2008 .
• Involved in SIT System Integration Testing and UAT testing, bug fixing and documentation for the project.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Designed STAR, SNOW FLAKE Schemas.

Environment: SQL Server 2008R2 Enterprise Edition, SQL BI Suite SSIS, SSRS, SSAS , Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 Windows Server 2008.

Confidential

Sr. SQL Server Developer

Responsibilities:

• Involved in designing Enterprise Data Warehouse Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Participated in designing Logical and physical data models for datamarts.
• Designed SSIS packages to migrate the data from Oracle flat files in SQL server
• Designed SSIS packages to load data from CSV and excel files to the Staging Area in SQL server
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to different environments System Integration Testing, User Acceptance Testing and Production Environment from Development Environment.
• Developed cubes using Partitions added the Key Performance Indicators KPI , partition aggregations, Perspectives, slow changing dimensions etc and created various user roles.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Created sophisticated SQL Server database to responsively handle complex queries triggers, stored procedures, views, functions and .NET data access components.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers
• Optimized the performance of various SQL stored procedures using Sql profiler to improve the latency of reports.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created PLSQL statements to join, update and insert in Datastage jobs.
• Write Ad-hoc queries for Business analysts to extract required data from datamarts.
• Created reports that call Sub reports in SSRS
• Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
• Created Stored Procedures and T-SQL code for complex business logic.
• Extract data from database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.
• Capture invalid data while processing the input flat files and inform responsible individuals from business group.
• Capture process performance logs and analyze them for better performance and redesigning of the packages.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications

Environment: Microsoft SQL Server 2008, T-SQL, SQL Server Integration Services SSIS , SSAS, Microsoft SQL Server Reporting Services SSRS , MS Excel, MS Word, Clear Case, Oracle, Terada, DTS, SQL Plus, SQL Server Management Studio,VB.NET.

Confidential

SQL Server Developer

Responsibilities:

• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Involved in installing and migrating legacy databases to SQL Server 2008.
• Designed and developed SSIS Packages .dtsx files to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Installation and configuration of SQL Server Reporting Services SSRS 2005/2008
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Involved in designing Parameterized Reports and also cascaded Parameterized Reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports SSRS 2005/2008 .
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services SSRS .
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite SSAS, SSIS, SSRS , Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 Windows Server 2003

Confidential

Software Engineer

Responsibilities:

• Worked as Test Engineer
• Developing test plan and test strategy
• Review of the test cases written for unit and integration level
• Integrating the test scripts written for individual units
• Writing Test scripts and functions wherever necessary for various units of the business modules
• Effective coordination between development team and testing team
• Writing RTMs before the test planning phase Analysis of the specifications provided by the users
• Generating reports using crystal reports
• Coding in VB6.0
• Writing SQL Server database procedures, functions and triggers
• Responsible for overseeing the Quality procedures related to the project

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft Word, Visual Source Safe