SUMMARY

• 7+ years of IT Experience in Microsoft SQL Server 2012/2008R2/2008/2005, ASP.NET Business Intelligence (BI) tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Worked on development tool Visual studio 2008, 2012, 2013
• Experience in Design, Development, Maintenance, Testing and Production Environments with various business domains including Healthcare, Finance and Energy.
• Expertise in working with Web Server Controls, HTML Controls, User Controls, Custom Controls using C# and VB.NET.
• Excellent in writing T - SQL queries (DDL and DML).
• Expertise in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Common Table Expressions (CTEs), Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Proficient in understanding Execution plan, SQL Server Profiler to trace the slow running queries and optimize SQL Queries for improved performance and availability.
• Experience in monitoring and tuning MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler and SQL server Database Engine Tuning Advisor for optimal Performance.
• Proficient in developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous data sources such as Oracle, DB2, Excel and MS Access CSV, Oracle, flat file.
• Experienced in development of content and visually rich reports in SQL Server Reporting Services (SSRS) like tabular, matrix, list, chart, gauge, and map.
• Good experience in working with QNXT and related databases and data to create complex store procedures.
• Worked on monthly TAT reports of Medicaid reviews, claims and developed related SSIS packages and SSRS reports.
• Deploy packages to file system and schedule the jobs using SQL Server Agent.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for Data Warehousing using SQL Server Integration Services (SSIS).
• Expert in designing complex reports using SQL Server Reporting Services (SSRS).
• Designing, creating, and managing multidimensional cubes that contain data gathered from other data sources (relational databases) and Online Analytical Processing (OLAP) by using SQL Server Analysis Services (SSAS).
• Experience in different type of reports including Tabular forms, Matrix (cross/tab) form, Cascading parameters, Drill-Through, Drill Down, and Parameterized Reports.
• Experience in writing of T-SQL queries (DDL and DML) which is utilized in construction of tables and normalization techniques to database tables.
• Experienced in usage of Microsoft BI tools like Power View, Power Pivot, Power Query, Power Map which are utilized to retrieve, analyze, and to finally display the data in a well-defined visual form.
• Proficient in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema.
• Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008/2008 R2/2005, Oracle, Access

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Excel

ETL Tools: SQL Server Integration Services, Data Transformation Services (DTS)

Development Tools: Visual Studio 2012/2008/2005 , SQL Enterprise ManagerSQL Profiler, Query Analyzer, Security Manger, Service Manager

Programming Languages: T-SQL, PL SQL, C#, XML, .NET 3.5, 4.0, ASP.NET, WCF, Web Services

Operating Systems: Win Server 2008/2003, Windows 8/7, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential

MSBI Developer/ Analyst

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.
• Worked on SAS Queries to convert them into PL-SQL to develop ETL package to import the data from Oracle source to SQL server
• Worked on QNXT database and data for generating daily and monthly reports.
• Good experience in Medicaid data and reviews. Developed robust ETL packages to pull required data for daily and monthly reports.
• 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.
• Good knowledge and worked under HIPPA rules.
• 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.
• Worked on development tools SQL server 2008, 2008R2, visual studio 2008, 2012 and oracle 11g and Teradata.
• Worked on Complex MS-Excel reports by applying different formulas to do aggregations on data.
• Worked on creating the user interface (UI) using Java scripts and HTML and to deploy the reports on internal web application.
• Worked in agile methodology.
• Worked on OOP’s Concepts in SSIS Package to write some validations scripts.

Environment: 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, Greensboro, NC

MSBI Developer/ Analyst

Responsibilities:

• Analyzing system requirements, understanding the scope and clarify requirements for client’s business
• Further transform all requirements to generate attribute mapping documents
• Extensively worked with SSIS tool suite, designing and creating mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, and multicast and derived column.
• Providing estimations for design and development based on the requirements and change requests.
• Development of SSIS packages and SSIS reports using SQL Server, Visual Studio and Report Builder and E&M for Existing systems
• Involved in designing interfaces with ASP.NET 3.5, implementing code with C#.NET, and deploying the application in different environments.
• Worked with an Agile, Scrum methodology to ensure delivery of high quality work with monthly iteration.
• Familiar with OLAP cubes and fact table, star and snowflake schemas, building multi-dimensional cubes and KPIs for decision makers using SQL Server Analysis services (SSAS).
• 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.
• Develop complex ETL Stored Procedures for data extraction, transformation and loading
• Create Databases, Tables, Views and Indexes.
• Developed.NET pages in C# to meet the business requirements using Visual Studio. NET
• Support for Existing DTS Packages for multiple Client Systems
• Migrate / Convert DTS packages to SSIS packages
• Reviewing mapping specification documentation, query tuning to increase performance of SSIS packages and SSRS reports
• Created complex reports related QNXT database data and had good experience in working with QNXT
• Involved in data analysis with different systems like Medicaid
• Review development and test specifications, perform data analysis, provide development and QA support for existing systems.
• Troubleshoot data and/or system issues within the data warehouse environment as well as upstream systems, as needed.
• Data profiling for demanding requirements
• Production Implementation and Warranty Support related activities
• Feasibility study for any change requests and providing gap analysis
• Work in close collaboration with the customer team in order to strengthen the business partnership.

Environment: Microsoft SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), Visual Studio 2010, ASP.NET SQL Server Configuration Utility, SQL Query Manager.

Confidential, SFO CA

MS SQL DEVELOPER/BI/SSIS/SSRS

Responsibilities:

• Migrated data from QNXT application database to Essette application database.
• Create / Update database objects like tables, views, stored procedures, function, and packages.
• Developed complex ETL Stored Procedures for data extraction, transformation and loading for applications.
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Translated business logic to transformation logic to generate pseudo code for the ETL process.
• Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2008 R2/2012).
• Designed and developed automated processes for generation of data files to be sent to Trading Partners.
• Re-designed Confidential 's internal processes as part of process improvement program.
• Developed SSIS packages for data migration from various kinds of source files (.txt, .tab, .xls, .xml, and .csv) received.
• Created SSIS Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Used TFS (Team Foundation Server) for Source Control.
• Utilized Tidal scheduler tools for schedule the jobs in production.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.

Environment: Microsoft SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Access, Red Gate utility, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe.

Confidential

SQL / BI DEVELOPER

Responsibilities:

• Involved in various stages like development, System Analysis and Design for new applications.
• Created and Migrated DTS packages from SQL Server 2005 to SQL Server 2005/2008 Integration Services (SSIS).
• Gathered requirements for the creation of data flow processes for the SSIS packages.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse.
• Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for different applications.
• Used various tasks and Control flow techniques in the development of various complicated packages.
• Designing reports on daily basis using Performance Monitor.
• Monitored SQL Server Error Logs and Application Logs.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structure.
• Performed analysis and design of the application.
• Logical and physical database design modelling using Erwin.
• Responsible for Design and Normalization of the database tables
• Developed and coded applications in T-SQL.
• Involved in support, development, QA, UAT and knowledge transfer.
• Experienced in performance tuning using SQL profiler of SQL server.
• Importing and exporting Database objects using DTS utility.
• Created database objects like tables, indexes, stored procedure, triggers, function and views.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Parameterized Reports, adhoc reports, published reports.

Environment: SQL Server 2005, T-SQL, Windows Server, Erwin, Visio, Performance Monitor, SQL Server Profiler.

Confidential

SQL Server Developer

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients’ requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000.