SUMMARY

• 7+ years of IT experience in database design, development and support of Microsoft SQL Server 2005/2008 for Production/Development environments.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Viewsand advance query concepts.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server by Play Now Radio">Analysis Services (SSAS) and Reporting solutions using Microsoft by Play Now Radio">SQL Server Reporting Services (SSRS).
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Experiencedin providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access, oracle

Programming Languages: T-SQL, HTML, XML, C, C#, Pl Sql

Software Applications: MS Project Professional, MS Project Server, Share Point, Excel, Access, Word, Visio, PowerPoint, Outlook, Internet

Reporting Packages: SQL Server Reporting Services, Crystal Reports, MS Excel, Cognos

Tools: /Methodologies: MS Visio, Erwin, Star Schema/Snowflake Schema modeling, FACT&Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies, Testing tools, UAT, VB.net

Operating Systems: Windows NT/98/2000/XP/7, Windows Server 2003/2008, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

MS SQLServer Developer

Responsibilities:

• Developed free-form reports using MS - SSRS tool for consolidating multiple reports into single report delivered in .pdf format to the power users. Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Successfully redesigned and migratedcomplex applications from Access to Sharepoint and SQL Server 2008 by evaluating database structures and data movements.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.
• Implementation of Microsoft Project Server including system design, maintenance, standards, processes, automation, audits, reporting and all MSPS configurations.
• Used MSPS for data integrity and continuity, standards creation and control with subsequent evaluations, process initiation with documentation and continuous improvement, use of a global template to prevent duplication of effort across teams, a requirements template to facilitate solicitation, evaluation of (test matrix), and to control change, OLAP cube builds to facilitate URL based reporting and the production of executive dashboards via web parts, documentation versioning and control

Environment: MS SQL Server 2012/2008 R2,Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS Project Server, MS-Excel, Windows 7, Agile, Scrum, Visual Studio 2008/2012.

Confidential, Reston, VA

MS SQL Developer (SSIS/SSRS)

Responsibilities:

• Plan, design, and implement application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Reported financials to the management with variety of SSRS reports and dashboards for better and effective decision making.
• Good experienceinteracting with end users for understanding bussiness processesand implementing the same through T-SQL for process automation.
• Designed complex and custom reports using SSRS with drilldown features, sub reports, charts.
• Compressed data files by removing empty database pages and updating index statistics.
• Created SSIS packages to transform data from different data sources into application required formats for e.g. Unpivoting.
• Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
• Testing software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the programme until it produces the correct results.
• Working knowledge of MSPS system, schedule development, individual project plan audits, cross collateral predecessor/successor integration, master project plans, schedule publishing, metrics, reporting, schedule analysis, as well as all Microsoft Project Server related Standards, and Processes.
• Working with trainers and technical writers to develop user support materials.
• Automated redundant and repetative tasks using different tools and objects available in SQL Server.
• Timely support and maintenance of the application to ensure uninturepted business deliverables.

Environment: MS SQL Server 2008/2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MSPS, SQL Server Management Studio (SSMS), MS-Excel, Windows 7, Share Point

Confidential, Columbus, GA

MS SQL DEVELOPER (SSIS/SSRS)

Responsibilities:

• Involved indaily batch loads (Full & Incremental)intoStaging andODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Planned, designed, and implemented processes to recieve, transform and load valuable data from external sources into local databases.
• Structured the entire ETL process using SSIS in a systematic way, right from tracking the files for availibility to extracting the files to and loading them to their appropriate destinations.
• Designed SSIS Packages to load data from differnt sources like excel, flat file, csv etc.
• Designed Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, mail task, Derived Column, and For Each Loop, Data Conversion etc.
• Provoided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Coordinated with the offshore teams on the requirement gathering and enhancements to the existing DataMart and model.
• Replicated the entire ETL process from Production to Development environment for debugging production issues and demoing results of new requirements to business users.
• Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
• Justify required changes to packages and redeploy to various environments.
• Created SQL Server reports using SSRS,tasks included defining requirements, design, develop, test, implement and maintain reports.
• Developed parameterized reports, linked reports, matrix and tabular reports with drill down and drop down menu option.
• Deployed the generated reports on to the Report server and fine-tuned the database objects to ensure efficient data retrieval.
• Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.

Environment: MS SQL Server 2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Vb.net, Windows Server 2003

Confidential, Phoenix, AZ

MS SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management.
• Developed complex T-SQL Stored Procedures, Functions, Tables, Views, Indexes and other SQL joins and statements to extract required data from servers across loactions and load them into local databases.
• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key. Extensively Involved in Designing (Logical and Physical) of Databases.
• Created database objects like tables, views, indexes etc using T-SQL statements. Created and modified stored-procedures, triggers, cursors. Created & managed the Database Users, Login Ids and Security.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS).
• Used DTS to created jobs to populate some of the tables with data from other servers.

Environment: MS SQL Server 2005, Transact-SQL, HTML, SQL Server Management Studio (SSMS), Vb.net, Windows Server 2003, MS Access, Erwin, DTS, SQL Profiler, Query Analyzer, T-SQL, Windows 2000 and XP