Professional Summary:

• 7+ years of IT Experience as MS SQL Server Database Developer in Database Design, Testing and business intelligence of Microsoft SQL Server 2000/2005/2008(R2) in Development and Production Environments with various business domains like Financial, Healthcare, Manufacturing and Insurance services.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).
• Excellent Report creation skills indeveloping reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) inBusiness Intelligent Development Studio (BIDS).
• Experience in creating snapshots of reports to reduce the load on the server. Managed subscriptions to provide timely reports to the clients and end users and also worked on integration ofSharePoint with SSRS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Experience in enhancing and deploying the SSIS Packages from development server to production serverby using package configurations.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Technical Skills:

Database: MS SQL SERVER 2008 / 2005 / 2000, MS Access 97/2000/2003.
Operating Systems: UNIX, Windows XP/2000/2003.
Programming Languages: Transact SQL, C. 
Web Technologies: HTML, XML.
Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage.
DB Tools: SQL Server Management Studio, SQL BIDS, SQL Enterprise Manager, 
Query Analyzer and SQL Profiler.
ETL Tools: DTS, SSIS.
Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Crystal Reports, 
Microsoft Excel. 
Data Modeling Tool: ERWIN, Visio.

Professional Experience:

Confidential
Saddle river, NJ July2011 –Present
SQL Server SSIS/SSRS Developer

Description: Confidential provides revenue cycle management technology solutions and healthcare consulting services to cover the full spectrum of a provider\'s revenue cycle needs from improving patient access processes to reducing claims denials.All of which could potentially help toimprove your net patient revenue byone to threepercent.Myposition is responsible for retrieving and manipulating data within SQL Server 2005/2008R2.Analyzes samples of client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes.

Responsibilities:

• Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Used Vb.net and C# in Script task of SSIS 2008 Packages.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed drill-through and drill-down reports using SSRS. Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Created snapshots of reports to reduce the load on the server using SSRS 2008.
• Deployed SSRS reports to Share Point Server 2007/2010.
• Created Dashboards and Scorecards using Share Point Server 2007/2010
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2005, SQL Server 2008 R2, MS Excel 2003-2007,Share Point Server 2007/2010 SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services.

Atlanta, GA. 
SQL Server Developer / BI Developer 

Description: Confidential provides senior clients with the opportunity to maintain independence in their own home while aging with grace and dignity. We will accomplish our vision through our mission which is to build a great reverse mortgage company differentiated by envied customer service and unsurpassed teamwork.

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries forReports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Created SQL Jobs to schedule SSIS Packages
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Used Lookup Transformation to get the data from reference data sets
• Discussed business requirements and mapped business needs.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using Chart experts

Environment: Windows 2000/2003 Advanced Server, MS SQL Server 2005/2008, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential Jan2009 - Dec 2009
Louisville, KY.
SQL Server SSIS/TSQL Developer

Description: Confidential drives strategy, solutions, revenue and ultimately success. It is only logical that you would want it to come from superior source. Confidential is the company financial services and real estate professionals turn to for comprehensive data, analytics and services. And my position is responsible for mainly focused on conversion and created stored procedure for proper conversion of data from city. For that created stored procedures and deployed those packages and created jobs for the packages

Responsibilities:

• Experience in creating reports on SQL server reporting services 2005.
• Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
• Experience in creating reports using REPORT MODEL and applying row level security filters.
• Experience in designing CRYSTAL REPORTS visualizing them Exploring and delivering the reports via the web.
• Designed, Developed OLAP Cubes in SSAS
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal (SSRS).
• Experience on creating drilldown reports from analysis services cubes.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Designed, Build the Dimensions, cubes with star schemausing SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Migrated DTS packages from SQL Server 2000 to 2005 and scheduled their execution time.
• Created SSIS packages using Script tasks and with Error Handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.

Environment: SQL server 2005, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, SQL Diagnostic Manager, SSIS, SSRS, SSAS.

Confidential July 2008-Jan 2009
Richfield, OH 
SQL Server Developer

Description:Confidential designs productivity solutions that provide practical access to actionable information. We design and deliver electronic parts catalogs, accessory sales tools, warranty process management solutions, and manufacturer network development services. We are focused on helping vehicle and equipment manufacturers and their dealership networks increase sales, reduce structural costs, and improve customer experiences. SBS designs information tools that center on improving productivity in franchised dealerships and the supply chain. 

Responsibilities:

• Requirement gathering – Solution design
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install andConfigured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.

Confidential July2005- June2008
SQL Server Developer

Confidential is a business and technology service company. Logica deliver business consulting, systems integration and outsourcing across all industries and business functions.

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries forReports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Created DTS packages for transforming data from various data sources.
• Discussed business requirements and mapped business needs.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using Chart experts

Environment: MS SQL Server 7.0/2000, Windows 2000/NT/XP, DTS, Query Analyzer, SQL Profiler and Enterprise Manager.