SUMMARY

• Over 7+ years of hands - on-experience as a SQL Server developer in Retail, Banking, Financial and Healthcare.
• Experienced in developing and Implementing SQL Server 2008/2005/2000 , Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS)and MDX for Data warehouse and data mart solutions.
• Solid experience in database development and support, Database migration, SQL Server 2005 upgrade to SQL Server 2008.
• Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
• Strong knowledge in creating Indexes, Views, Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Expert in writing T-SQL, working on SSIS, SSRS, SSAS, and Data Migration projects.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and SSIS Packages.
• Knowledge of Database tools like SQL Profiler, Database Engine Tuning Advisor, Erwin, and Visio.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports, and Excel spreadsheet.
• Used Table partition on large tables for better performance.
• Applied various Transformations like Slowly Changing Dimension, Aggregate, Merge, Union All, Fuzzy lookup, Fuzzy Grouping, Conditional Split.
• Expert in database activities like Database creation and Maintenance, Performance Monitoring, Tuning and Troubleshooting.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc using the SQL Server Reporting Services.
• Experience in scheduling and deploying reports on report manger.
• Thorough understanding of SDLC activities (analysis, design, development and implementation) and Development methodologies.
• Team player, energetic, result-oriented and excellent communication skills.
• Strong troubleshooting and problem solving skills and strong ability to prioritize multiple tasks.

TECHNICAL SKILLS

• MS SQL Server 2008/2005
• SQL
• Transact-SQL
• MS Access
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• Visual Studi2008/2005
• MS VISIO
• UML
• Windows vista/
• XP
• MS DOS
• Unix.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL Server Developer/ SSIS Developer

Responsibilities:

• Expertise in creating physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.
• Developed several SSIS packages and data flow tasks by using SSIS.
• Created several tables, views and stored procedures using SQL Server.
• Strong experience Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Success several Ad-hoc reports by using MS Excel and automate some of these Ad-hoc reports based upon business demand.
• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Created all the SSRS report using Cube as data source.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2008R2, Excel 2010.
• Created different data points and pulling those using SSIS package.
• Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.
• Analyzed the error output and error log of an automated process in case of failure of the process.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Expert in loading data from any email attachment to SQL database.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.

Tools: & Technologies: MS SQL Server 2008R2, SSRS, SSIS, SSAS, MS Office 2007, Excel 2010, ERWIN

Confidential, Jersey City, NJ

ETL Developer

Responsibilities:

• Created SSIS package to export and import data from SQL Server to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Modified the existing SQL queries according to the requests and executed them to check the performance.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS.
• Created data flow model using MS Visio.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Scheduled Jobs and Alerting using SQL Server Agent.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created SSRS reports to retrieve data using Stored Procedures that accept parameters.
• Performed daily tasks including backup and restore by using MS SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Tools: & Technologies:Microsoft SQL Server 2008R2, T-SQL, Query Analyzer, Microsoft Excel, SSRS 2008, SSIS, SSAS,Visio

Confidential, Philadelphia, PA

SQL Server Developer/SSIS/SSAS Developer

Responsibilities:

• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Incorporated the SSIS Packages into MS SQL Server 2008R2 Integration Services by using Package Migration Wizard and Execute SSIS 2005 Package task.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Extensively involved in migration of data from MS SQL 2005 to MS SQL 2008.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler.
• Involved in gathering and analyzing business requirements for reporting purpose.
• Created dashboard pages that use Excel Web Access Web parts and Reporting service Web parts.

Tools: & Technologies: MS SQL Server 2008R2,MS SQL 2005, SSRS, SSAS, Windows Server 2008, MS Office 2007, ERWIN.

Confidential, Charlotte, NC

SQL Server Developer /SSIS Developer

Responsibilities:

• Expertise in creating physical and logical structure of the new data warehouse (SQL database) and process work flow by using Visio.
• Created several tables, views and stored procedures using SQL Server.
• Developed several SSIS packages and data flow tasks by using SSIS.
• Experience Creating SSIS packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations such as Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2005, Excel 2003
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created partition using partition scheme and functions of SQL server to achieve better performance in retrieval of data from database.
• Schedule Jobs to run SSIS package.
• Load data from database to Data warehouse using SSIS packages.
• Monitored the CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test.
• Extensively involved in maintaining and updating the database documentation

Tools: & Technologies:MS SQL Server 2005, SSRS, SSAS, MS Office 2003, Visio, Excel2003

Confidential, Bloomfield, CT

SQL Server Developer SSIS/SSAS Developer

Responsibilities:

• Created database objects like tables, views, indexes, indexed views, stored procedures UDFs.
• Created and modified stored procedures, triggers, cursors and views on support of DBA day to day duties or reports.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specification.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created complex views and scripts to convert business logic for different reports.
• Used SSAS and SSIS to create process and partition cubes.
• Created complex stored procedures to customize the report data and to make data analysis efficient.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Worked with SSIS to load text files to SQL Server.
• Configured SQL mail agent for sending automatic emails when a SSIS process failed or succeed.

Tools: & Technologies: MS SQL Server 2005,SSIS, SSRS, SSAS, MS Office 2003

Confidential, Middletown, CT

Database Developer

Responsibilities:

• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Transformed data from various data sources using OLE DB connection by creating various packages.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Proactive and Reactive tuning of databases in every stage of the project.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Developed Reports using Crystal Reports.

Tools: & Technologies: Microsoft SQL Server 2000, Microsoft Excel