SUMMARY

• Over 7 years of experience through all software development phases from requirements definition, analysis to design, implementation, testing, maintenance
• Strong experience in SQL Server 2005 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Hands on Experience in Dimensional Modeling, ER Modeling, Data Marts, Star Schema/ Snowflake Schema, FACT and Dimensional tables.
• Excellent Experience in generating on - demand and scheduled reports, sending alert mails, Jobs for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Excellent Experience in creating stylish Report Layouts using Global expressions, functions, Subtotals, Sorting the data in SSRS 2005, SSRS 2008.
• Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Experience working in various domains verticals like Health, Insurance, Pharma, Transportation, etc.
• Good experience in the use of SQL Server and T-SQL in creating Tables, Stored Procedures, Cursors, Triggers, User defined functions, Views, Indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience in defining queries, generating drill-down reports, complex formulas, sub-reports, and on-demand reports and also expert at basic and advanced report creation (table, chart, matrix report, web reporting) using SSRS along with excellent experience in report serving architecture.
• Thorough understanding of how to design and develop cubes using SQL Server 2005 Analysis Services and leverage the advanced BI functionality of SQL Server 2005.
• Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Familiarity in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in deploying and enhancing the SSIS Packages from dev server to production server.
• Experienced in sorting the data, defining data source, using global variables, expressions, functions and subtotals for the reports. And exposure to Dimensional and ER Modeling.
• Good exposure to Database and Data Warehousing concepts (OLTP & OLAP). Involved with logical and physical data modeling and database design.
• Highly motivated, committed and a natural team player with capability to work independently, strong analytical ability coupled with excellent written and verbal communication skills.

TECHNICAL SKILLS:

• MS SQL Server 2005/2000/2008
• MS SQL Reporting Services 2005
• MS SQL Server Analysis Services 2005
• MS SQL Server Integration Services 2005
• Windows NT
• Windows 2000/ XP/Vista
• Unix
• UNIX
• HTML
• DHTML
• MS-Access
• Erwin
• MS-Office
• Bulk Copy Program (BCP)
• Database Engine Tuning Advisor
• SQL Agent
• Service Manager
• Visual Studio
• ASP.NET
• C#
• Team Foundation Server(TFS)
• JavaScript
• MS Office suite

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked closely with Business Analysts to produce all required documentation.
• Had migrated various reports from SSRS 2005 to SSRS 2008 version. And created new reports based on business requirements.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Worked on the Team Foundation Server(TFS).
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using DTS Packages.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Developed, monitored and deployed SSIS packages.

Environment: MS SQL Server 2008, MS Access 2000, DTS, SSIS, SSRS 2005/2008, T-SQL, SQL Analyzer, TFS, MS Access, MS Excel

Confidential, Secaucus NJ

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Created stored procedures, scripts, views in Oracle database design and create SQL Database, tables, indexes and views.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports as well as interactive reports according to business requirements in time restricted environment.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.
• Designed, developed and deployed reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS and also configured the Cache execution, report execution time out and scheduled Snapshot reports to increase performance.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008 by using Detach/Attach, back up & recovery
• Scheduled the monthly/weekly/daily reports to run automatically.
• Create User Defined Functions, Stored Procedures and Triggers.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2008, MS Access 2000, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003, Toad, ERWIN

Confidential, Cleveland, OH

MS SQL Server Developer SSRS/SSIS/SSAS

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Formatted the reports using the Global variables and expressions.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Fine tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, ASP.Net, MS Excel, Window XP, Toad.

Confidential, Wilmington, DE

MS SQL Server Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
• Worked closely with Business Analysts to produce all required documentation.
• Had migrated various reports from SSRS 2005 to SSRS 2008 version. And created new reports based on business requirements.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Extensively used TSQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple tables.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Used indexes to enhance the performance of individual queries and enhance the stored procedures.
• Created various DTS packages for data transfer and migration.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment: MS SQL Server 2005, MS Analysis Services 2005,MS SQL Reporting Services, T- SQL, Windows XP, Query analyzer, SQL Profiler, MS Excel.

Confidential, Pittsburgh, PA

MS SQL Developer

Responsibilities:

• Responsible for requirements gathering from business users.
• Customized data by adding Prompts Filters, Calculations, Summaries and Functions.
• Wrote user requirement documents based on functional specification.
• Designed data models using Erwin.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Developed, monitored and deployed SSIS packages.
• Developed complex stored procedures and triggers in T-SQL.
• Created different types of prompts like Type in, Pick list, Cascading prompts etc.
• Formulated joins strategy, query optimization and weighing the tables.
• Responsible for maintaining and updating databases.
• Developed reports using ReportNet according to Business user requirements.
• Modified existing reports to Tabular SQL reports when the report performance was found to be below par.
• Created ad-hoc reports in Query-studio with incorporated filters, sorting etc and presented them at the client side to note the changes they may need.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.

Environment: SQL Server 2000/2005, MS Access, Oracle 8i, MS Excel, Visio 2000, Windows 2000/NT, Erwin, C++, XML, Webservices, HTML

Confidential, Hartford, CT

MS SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures).

Environment: MS SQL Server 2005, MS Access, MS Excel, Windows 97/2000/XP, ER-Win v4.0.

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Developed stored procedures and views for managing efficient data retrieval.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to Access, text and Excel files.
• Worked closely with developers, end users and Administrator in designing database.
• Designed and built the Data Access Layer Components and Business Classes in C# and performed unit testing, path testing of web forms and code to test their functionality.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: MS SQL Server 2000 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, C#, ASP.NET, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.