EXPERIENCE SUMMARY:

• Around 7+ 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, Data Stage PX 8.5/8.1,7.5.3, Team Foundation Server (TFS)Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Crystal Reports, Qlikview 11.0/12.0, Power BI

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.NETDesign Tools: Erwin 7/4, MS Visio 2007/2010

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

Management Tools: Anaplan, Jira, Daptiv, Easy Vista, Facets, ITSM

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

Sr.BI Developer

Responsibilities:

• Installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
• Involved in the migration of databases from SQL server 2012 to SQL server 2014.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Assign permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implemented High Availability in SQL 2012/2014 by configuring Always on Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• 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 2008/20012).
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008/2012
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2008/2012).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.
• Designed STAR, SNOW FLAKE Schemas.

Environment: SQL Server 2008R2/2012/2014 Enterprise Edition, SQL BI Suite (SSIS, SSRS, SSAS), Enterprise manager, XML, MS PowerPoint, MS Project.

Confidential, Boston, MA

Sr BI Consultant

Responsibilities:

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS 2012).
• Involved in writing DAX queries and manipulating the multidimensional data in Tabular Model 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 some SSIS packages to import and export data from various data sources using SSDT.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Created few new reports for internal usage using SSRS 2012.
• Responsible for deploying the reports, cubes and packages on all environments.
• Scheduled the jobs for SSIS packages under SQL Server Agent.
• Deployed SSIS packages using Integrations Service Catalog and also through XML configurations.

Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS Tabular Model), T-SQL, SQL* Profiler, TFS, DTS, Windows 2008/XP, MS Visio 2010, ALM, DeskSite 8.5

Confidential, Houston, TX

Sr. BI Developer

Responsibilities:

• Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation
• Translating business requirements into technical design specifications
• Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server2008/2012
• Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models
• Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
• Wrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Qlikview.
• Created user interface reports using QlikView sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
• Created QVDs and developed Dashboard style of reports as per business needs
• Created and schedules tasks for reloading and distribution of Data in QlikView Publisher
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2012
• Created reports to retrieve data using Stored Procedures and parameterization
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.
• Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations
• Performed daily tasks including backup and restore by using SQL Server 2012 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, ALM, Anaplan, Qlikview 11.0

Confidential, Grand Rapids, MI

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, Facets

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