SUMMARY

• An accomplished SQL server with 6+ years of extensive experience in database design, development and administration with MS SQL Server versions 2012/2008/2008 R2/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in various business domain like financial, insurance and healthcare.
• Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expertise in Extraction, Transforming and Loading (ETL) data using BI/SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities(Data Warehouse, Data mart).
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in creating SSRS report by adding parameter and passing parameter to a drill through report.
• Experience in writing Distributed Queries between SQL Servers and Hands on Experience in Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2000.
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Handled vast financial data, expert level query optimization and performance tuning experience.
• Familiar with version control Team Foundation Server.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various Adhoc reports through Report model creation using BI/ SSRS.
• Proficiency in Developing BI/SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Worked extensively on system analysis, design, development, testing and implementation of Projects (Complete SDLC), Agile Methodology, RDBMS, Data Warehouse & Data Modeling concepts.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Very good team player with ability to perform under stress and excellent presentation and technical documentation skills.
• Expertise in Object Oriented Analysis and Design.
• Excellent analytical, problem solving, communication skills and team player.
• Strong research and analytical skills, computing abilities, problem solving, dynamic leadership quality.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential integrity by using Triggers and Primary and Foreign Keys.
• Very good communication skills, good interpersonal skills desire to excel, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/ 2008/2005/2000
• MS SSRS 2008/2005/2000
• MS SQL SSAS 2008/2005/2000
• MS SSIS 2008/2005/2000
• DTS
• Erwin Designer 2000
• Power designer
• DB2 SQL syntax
• MS-Access 2000
• C
• C++ java
• JDBC
• Tomcat
• JBOSS
• JSP
• VB 6.0
• Developer 2000
• Erwin 7.3/4.2/4.2/4.0
• Oracle 9i/10g
• T-SQL
• PL/SQL
• ASP.NET
• HTML
• XHTML
• XML
• XSL
• DOM
• Visual Studio 2005
• Eclipse
• RAD
• TOAD
• T-SQL
• PL-SQL
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP
• UNIX/LINUX
• Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Webster, NY

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Responsibilities include were data analysis, reporting, issue tracking/management, status reporting/management and other analysis to support the ongoing Supply Chain Analytics initiative.
• Reverse engineering with legacy old system for Income statement, create a automated system.
• Create SSIS package to load data from Oracle database to SQL data warehouse.
• Developed SSIS packages for one time data load from legacy applications (Mainframe) to the Centralized database.
• Created complex SQL queries by joining (Inner, Outer) multiple tables, dynamic SQL and sub queries in TSQL. Created views, functions, stored procedures and constraints to create relationship between tables and to perform required tasks in the applications.
• Implemented SQL Server OLAP services for building the data cubes. Created dimensions using SQL Server Analyses Services (SSAS). Created Fact Table, Role playing dimension table and measure as per requirement. Assisted in defining Query for generating drill down reports in SSRS. Work on dynamic SQL.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Created parameterized, drill down and aggregation reports in MS SQL using SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and helped in deploying on to report server.
• Use MDX functions such as Link member to get specified member data for particular hierarchy member.
• Use Performance Point service with SharePoint 2010 to create dashboard and created scorecard and KPIs.
• Work with MS Acess using linked tables from Oracle and various append, update queries and VBA modules.
• Work with MS Excel 2010 to create report using Power Pivot.

Environment: Microsoft SQL Server 2008/, Share Point 2010, T-SQL, Oracle 10g/ 9i,SSIS, SSRS, VB Scripting, Visual Studio 2008, MS Access 2010, VBA, Excel, Power Pivot.

Confidential, Providence, RI

SQL Server Developer/ SSIS/ SSAS (BI) Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Define strategy for ETL processes, procedures and operations. Worked on several transformations in Data Flow including Derived-Column, copy column, merge, Lookup, Data Conversion, Conditional-Split and many more.
• Actively involved in creating SSIS packages to transform data from OLTP database to data warehouse. Loading data from various sources from flat files to SQL Server database Using SSIS Package performed validation and loading of the Flat files received from business users
• Implemented SQL Server OLAP services for building the data cubes. Created dimensions using SQL Server Analyses Services (SSAS). Created Fact Table, Role playing dimension table and measure as per requirement. Assisted in defining Query for generating drill down reports in SSRS. Work on dynamic SQL.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS. Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries. Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema. Worked on Stored Procedures, Functions and Triggers.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases.

Environment: MS SQL Server 2005, Oracle 9i, DB2, Access, XML, VB 6.0, ASP, .Net, Reporting Services (SSRS), Integration Services (SSIS), T-SQL, MS Office, Visio

Confidential, Stamford, CT

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Confidential, Bergen Field, NJ

MS SQL Server/ SSIS/ SSRS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2008 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2008 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2008 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Designed drilldown, drill through, and parameterized report using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
• Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Defined referential relationships with the measure groups and fact tables.
• Documented the development work and production release for future reference.

Confidential, Hartford, CT

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS SQL server 2005.
• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.
• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.