SUMMARY

• 6 years of professional experience in Health Care Reporting/ SQL Database Development/Tableau Dashboards and Software testing. In depth knowledge of Software development life cycle, testing methodologies. Proficient in System, Functional, Regression, Database and Performance testing of Client/Server and Web based applications.
• Over 6+ Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2014/2012/2008 R2/2005, SSIS and SSRS.
• Expertise in SQL Server 2012/2008R2/2005 Reporting Services (SSRS), SQL Server 2012/2008 Integration Services (SSIS) and in SQL Server 2012/2008 Analysis Services (SSAS) in Business Intelligence (BI).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating reports using SQL Server Reporting Services, like Crystal Reports, parameterized reports, sub reports, drill down reports, drill through reports, MS Excel spreadsheets and PowerPivot for client requirements in SSRS 2005/2008.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features.
• Created Tableau Data Extracts for making visualizations perform better and improve the dashboard.
• Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader.
• Expertise in writing SQL Queries , Dynamics, sub - queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors .
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
• Experience in Homeless Reports for grants.
• Involved in CMS/UDS Measure submission for 2016/2017.
• Good experience in working various Web parts in SharePoint portal like Excel web access,
• Expertise in Analyzing Business Specifications, Use cases and develops Test Scenarios, Test Cases and Test Scripts and executes them.
• Experience in QA processes and standards, Software Testing Methodologies, Development of Test Cases, Design and Execution of strategic Test Plans and Test Scenarios.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations.

AREAS OF EXPERTISE

• Data Modeling
• Agile/Scrum Methodologies
• Data Warehousing
• Offshore/Onsite Models
• Business Intelligence
• Tableau Dashboards
• SQL/PLSQL.
• Quality Analyst /Performance Tester

TECHNICAL SKILLS

Tools: & packages: SQL Server Management Studio(SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio(BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007, Enterprise Manager, Team Foundation Server

Databases: MS SQL Server 2012/2008R2/2008/2005, MS Access, Oracle 11g/10g/ 9i.

Language: T-SQL, ASP.net, VB.net, C#

Operating Systems: Windows 7/ Vista /XP professional. Windows Server 2008/2003/2000 , UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Seattle WA

MSBI Developer

Responsibilities:

• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Created drill through reports using Tableau Desktop.
• Involved in creating data blending in case of merging different sources.
• Worked on data extraction, transformation and loading of data directly from different source systems like flat files, Excel etc.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2012.
• Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse .
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server.

Confidential, Redmond WA

MS BI Developer

Responsibilities:

• Requirement gathering and understanding the trends that is to be shown in the reports.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Written complex stored procedures and SQL queries.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Using various SSIS data transformation tasks like SCD, Look-ups, Fuzzy Look-ups, Merge Union-All, Conditional Splits, Multi cast, Derived column etc.
• Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis.
• Involved in design of SSIS Package configuration, logging, deployment & job scheduling.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Create Tabular, Drill down, and Parameter reports using SSRS and configured Reports Snapshots, Report Caching for reporting performance.
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL Server Management Studio.
• Developed SSRS Reports weekly and monthly for business requirements.
• Designed and developed custom .NET components and user controls using ASP.NET.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.
• Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD.
• Created Dashboards using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio.Net 2008 (C#.NET), ASP.NET, Web service.

Confidential, CA

MS BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service (SSRS) 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures .
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Tracking and closing the defects by using TFS.
• Manually executed the test cases and logged the defect in Clear Quest.
• Used share point to see the documents related to QA and project documents.
• Conducted Functionality testing during various phases of the application.
• Tested web services.
• Participated in Agile Development Cycle.
• Performed on Agile to emphasize face-to-face communication over written documents.
• For regression testing used QTP.
• Imported and exported data from and to Excel to and from QTP.
• Used Parameterization in QTP extensively to perform Data-Driven testing.
• Performed browser compatibility testing using different browsers like IE, Fire Fox etc.
• Performed database testing using SQL, executed various DDL and DML statements.

Environment: SQL Server 2008/2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)