OVERVIEW:

• Software Engineer with over 6 years’ experience in designing, supporting and implementing successful software projects and solutions for domains including Human Resources, HealthCare Management, Banking, and Non Profit Sectors.
• Extensive experience in SQL Server and in depth knowledge in Database Design, creating Databases , and Designing Queries using T - SQL.
• Have performed Performance Tuning with in Presentation, Application and Database levels. Have used Data Partitioning, Indexing and Optimized Design as a part of performance tuning.
• Implemented Stored Procedures, to migrate result sets to other platforms like SharePoint.
• Developed and handled Data Warehouses with size of GB .
• Extensive experience in ETL methodology and used data flow transformations like Aggregate tables, Derived Tables, Merge and Data Conversion using SSIS (SQL Server Integration Services).
• Developed OLAP Models with wrote Multi-Dimensional Expressions (MDX) , mathematical formulas, and user-defined functions.
• Created multi-dimensional cubes using SSAS (SQL Server Analytical Services) and created Named Queries and Calculations to obtain more specific result sets.
• Expert at creating reports using SSRS (SQL Server Reporting Services) in BIDS and SQL Server Data Tools .
• Performed Gap Analysis , compared the data from As Is Model to To Be, and identified the columns to be extended, transformations to be made, and created new logical columns.
• Proficient in Power Pivot for performing Data Analysis and created Measures using DAX.
• Proficient in Microsoft Office suites including MS Infopath, MS Sharepoint, MS Word, MS Excel and MS -Access.
• Proficient and well experienced in UAT, Unit and Regression Testing.
• Comprehensive knowledge of Business Analysis and Software Development Life Cycle (SDLC) processes, using, Agile SCRUM methodologies including in depth knowledge of Unified Modeling language (UML).

TECHNICAL SKILLS:

Database: OLAP and OLTP Databases, SQL Server 2008, 2010, 2012, MS Access

Database Tools/Technologies: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), OLAP Data Modelling, Business Intelligence Development Studio, SQL Server data Tools, Excel Reporting, DAX, MDX, Power Pivot.

Web Technologies: HTML 4.01, SharePoint Designer

Website and Blogging Tools: WordPress

Programming Languages: T-SQL, SAP ABAP, C, C++

Utilities/Applications: MS-Word, MS-Excel, MS-PowerPoint, MS Visio, MS InfoPath

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

IT Consultant

Responsibilities:

• Worked with the business analysts and translated the business requirements into technical specifications.
• Created 60 Tables, to house the campaign, donor and fund tracking information.
• Created Views and Indexes to achieve Query Optimization to manage a vast membership database.
• Employed Aggregate Tables and Partitioning to improve performance.
• Designed Multi-Dimensional Cube Model to maintain donor and membership data using SSAS.
• Developed star and snowflake schemas as part of data modelling, to support the reporting requirements.
• Developed several Hierarchy models for drilling down into details.
• Used MDX, to query data from Cubes.
• Developed reports for campaign tracking and fund collection processes.
• Used DAX Queries for data manipulation, in PowerPivot, to validate and synchronize data from the Cube with the reference data in Microsoft Dynamics CRM database.
• Designed queries and Advance Finds, using Daxko and Microsoft CRM Databases, to get the reference data.

Skills Used: T-SQL, SQL Server 2010, SSIS, SSAS, SSRS, MS Excel, DAX, Power, MDX and Database Design.

Confidential, Seattle, WA

IT Consultant

Responsibilities:

• Designed and created custom forms with Microsoft InfoPath 2010.
• Implemented data connections between InfoPath forms and SharePoint Server, to auto fill the fields, when an employee enters the corresponding employee id into the form.
• Designed and optimized queries to automate the migration of data from SQL Server 2010 Database into SharePoint Server 2010 using Stored Procedures and SSIS.
• Created SharePoint libraries to accommodate the InfoPath forms and designed the SharePoint workflows, using SharePoint Designer, in Windows environment.

Skills Used: T-SQL, SSIS, SharePoint Designer and Workflows, MS InfoPath Designer and Filler

Confidential, Seattle, WA

IT Consultant

Responsibilities:

• Designed and created a database to house, update and track the demographic data of the 3600 participants, and financial data of the program, using SQL Server 2010.

Skills Used: SQL Server 2010, TSQL, MS Visio, Database Design.

Confidential

Independent Consultant

Responsibilities:

• Actively participated in the gathering Business Requirements from system users and writing test cases.
• Designed the data model of OLAP Database in SQL Server 2008.
• Involved in Data scrubbing/Cleansing/validating with the data from the OLTP Database.
• Designed and Scheduled SSIS packages to import data into the Target Database. Used data flow and control flow transformations in SSIS to perform custom integration.
• Performed Performance Tuning by creating Indexes and optimizing queries for reports which take longer time in execution with SQL Server 2008R2 using Execution Plan and on necessity SQL Profiler too.
• Designed reports using SQL Server Reporting Services (SSRS 2008) to categorize the number of patients visiting the hospital on emergencies, walk-ins and appointments, in a day .Generated drill down reports, to retrieve information with least granularity to find the average number of doctor hours spent for each patient, for a specific medical condition.

Skills Used: Database Design, T-SQL, SQL Server 2008, SSIS, SSRS.

Confidential

Assistant Systems Engineer

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Oracle) to centralized SQL Server databases using SQL Server Integration Services (SSIS).
• Implemented OLAP Cubes, Facts, and Dimensions to house the capacity, availability and assignments of the organization’s employees and used Multi-Dimensional Expression (MDX) to access the data.
• Maintained the physical database and optimized SQL queries using SQL Profiler Index Tuning Wizard.
• Created Stored Procedures, to migrate data from SQL Server to SharePoint, where the availability of the corresponding employees in each region was available. Created triggers to automate the process of updating the information, where there is a modification in the database.
• Wrote test plans from Business Requirement Documents

Skills Used: SSIS, SSAS, MDX, OLAP Structure Design, SQL Profiler, Performance Tuning.

Confidential

Systems Analyst Trainee

Responsibilities:

• Created Test Cases based on the System Requirement Specification Documents.
• Designed T-SQL Queries, using various joins and views, to obtain data and validate them against the expected result set.
• Created different Logins and Users using T-SQL, to test and verify the security features of the developed application.
• Created Aggregate Tables to break down the Time dimension into Quarter, Months and Weeks.
• Performed Unit and User Acceptance Testing.
• Created reports to draw the number of customers performing specific transactions, in a day, week and a month, using MS Excel.

Skills Used: T-SQL, Unit and User Acceptance Testing, MS Excel