INTRODUCTION:

Consistent high performer and result oriented Information Services Professional, having 6+ years of experience, demonstrated through continuous growth. qualification includes master’s degree in Sciences. Strongly committed towards achieving individual and departmental goals.

PROFESSIONAL SUMMARY:

• 7+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SQL Server Agent, SSRS and Data-warehousing.
• Experience in using Business Intelligence tools (SSIS & SSRS) in MS Visual Studio 2013 and SQL Server 2012.
• Experience with Scrum Agile & SDLC Waterfall development methodologies.
• Extensive experience with T-SQL in Designing Tables, implementing stored Procedures, Functions and Views.
• Extensive knowledge of Normalization and Relational Databa0se Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS) and Reporting Services (SSRS).
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, and user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008 R2 and MS SQL 2012.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.
• Data Loading Experience in SQL Server 2012 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Deployed and Scheduled SSIS Packages to update information by using SQL Server Agent.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in Building Tableau dashboards.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

SKILL SET OVERVIEW:

Microsoft: Visual Studio 2013, SQL Server 2012, SQL Server 2012 Management Studio, DTS, SSIS, SSRS, SQL Profiler, Query Analyzer., Tableau

Database: MS SQL Server 2008,2008R2,2012

Language: T-SQL, VB.Net

Operating System: Windows XP/VISTA, Windows 10

Tools: Microsoft Visual Studio 2013, Microsoft Office Suite, TFS, VSS and Visio.

Architecture: Relational DBMS, Client-Server Architecture, OLTP, Data warehousing.

Reporting Tools: SSRS (SQL Server Reporting Services)

ETL Tools: SSIS (SQL Server Integration Services), DTS,SQL Server Agent

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

MSBI Developer

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment, and user of Analytical and transactional reporting system.
• Manage current and future needs of the data design and content.
• Design, develop, test, implement, and maintain SQL code for ETL.
• Design, develop, test, implement, and maintain SSIS packages to perform ETL processes.
• Design, develop, test, implement, and maintain SQL Server stored procedures, functions, and triggers to be used during the ETL process.
• Capture audit information throughout all phases of the ETL process
• Write and maintain documentation of the ETL processes
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Convert Legacy Crystal Reports & Mainframe System Reports into SSRS reports.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS), provide report output (data set) to Business for validation and guidance
• Perform root cause analysis on processes, resolve production issues, validate data, perform routine tests on databases and provide support to assigned ETL applications.
• Conduct appropriate functional and performance testing to identify data quality issues
• Collaborate with business partners to understand evolving needs of the data warehouse
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Maintain Exception Handling, Logging and Error Handling in SSIS Packages.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Used Lookup Transformation to get the data from data sets
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).

Project Environment: MS SQL Server2012, Team Foundation Server, Microsoft SharePoint Server (MOSS 2007), (SSIS) SQL Server Integration Services, SQL Server Agent, (SSRS) SQL Server Reporting Services, Visual Studio 2013, Windows XP, T-SQL, C#.

Confidential

Title Database Developer

Responsibilities:

• Developing functional specifications for business process refinement and automation, data modeling, system Architecture, conducting feasibility studies, scope, process flow and quality assurance and methodologies.
• Created Stored Procedures, Functions, Indexes, Tables, Views, T-SQL code, and SQL Joins for applications.
• Wrote Structure Query Language (SQL) queries to check proper data population in application table and for data verification to perform Backend Testing against SQL Server Database.
• Acted as a liaison between Domain SME and Development Team ensuring smooth work flow. Worked closely with project managers, SMEs and staff to understand and brief the requirements and specifications for new applications along with re-engineering the existing applications, evaluate the cost/benefit analysis on requirement requests and change requests.
• Used Quality Center to store all testing results, metrics, created Test Cases, and Reporting.
• Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Maintain Exception Handling, Logging and Error Handling in SSIS Packages.
• Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
• Daily update and managed Onshore team.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Used Lookup Transformation to get the data from data sets
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).