SUMMARY

• Over 8+ years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2012/2008R 2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications.
• Experienced in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well-developed skills in SQL Server Integration Services 2005/2008/2012 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experience in developing and monitoring ETL Packages using SQL Server Integration Services (SSIS), creating cubes for analysis using SQL Server Analysis Services (SSAS), developing reporting solutions using SQL Reporting Services (SSRS).
• Experience in Logical Modeling using Dimensional Modeling techniques such as Star Schema and Snow flake Schema. Created Multidimensional cubes using SQL Server Analysis Services (SSAS).
• Proficient in SSAS functions like Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security roles within a cube.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
• Expert in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out.
• Ability to quickly adapt to new environment and work with variety of people at various levels.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• Excellent communication skills, bridging Client Interaction and Team player.
• Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

TECHNICAL SKILLS

RDBMS: SQL Server 2000/2005/2008/2012 , MS Access

Languages: C, VB.NET, C#, VB, ASP.NET

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows NT/98/2000/windows 7/Vista/ Windows 8

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL Database/BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
• Project-manage Oracle MDM implementations for Oracle customers
• Set Customer best practices expectations revolving around MDM.
• Advise Oracle MDM usage and design to best fit customer business process requirements
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Developing reports on SSRS on SQL Server (2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period of time.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work and process.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler, Microsoft SharePoint 2010

Confidential, Parsippany, NJ

MS SQL Data Warehouse Developer

Responsibilities:

• Created technical documents for data mapping and database migration.
• Developed and designed the whole process to load data into DataWarehouse (DWH).
• Involved in designing the data model for the Data warehouse tables.
• Involved in creating partition function and schema for the table partitioning.
• Responsible for creating SSIS packages to load the data into Type 1 and Type 2 dimension tables and created SSIS packages to load the data into Fact tables after transformation.
• Created the Date Dim to keep the track of Start Date and End Date.
• Used script task to update row counts and insert row counts for the Type 2 Dimension tables.
• Wrote C# scripts in the script task to calculate the final update and insert row counts for the table. Used XML Configuration to make the package dynamics.
• Used SQL server table for logging of the SSIS packages and maintain the details of the run time and rows affected and update row counts and insert row counts.
• Implement Event Handlers and Error Handling in SSIS packages and notify process results to various user communities.
• Test, Clean and Standardize data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Convert Actuate reports to SSRS reports using SQL Server Reporting Services.
• Applied various features in SSRS to get the same reports as Actuate reports.
• Maintained the documentation for the all reports to keep track of users of the reports and to get sign off from them to move the developed reports to Production.
• Perform quality assurance checks and update databases to ensure data integrity.
• Performance optimization of the data warehouse by identifying and assisting in BI performance bottlenecks and debug database, application or data content related issues.
• Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Environment: Microsoft SQL Server 2008R2, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, Microsoft Visio 2007, MS Access, Excel.

Confidential, Parsippany, NJ

MS Database/BI Developer

Responsibilities:

• Responsible for gathering requirements for the database designing for the middle office with the Data Architect.
• Involved in understanding the current system and analyzed the overall compatibility of the all systems with the proposed Middle Office Database design.
• Created new database schema and tables for the Middle Office.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008.
• Involved in creating new and modifying the existing stored procedures and functions.
• Cleaned the data using SQL Server Integration Services (SSIS).
• Created reports using SQL Server Reporting Services (SSRS) as per user requirements.
• Deployed reports and configured security and subscriptions for the reports.
• Created User Defined Tables (UDT’s) and used for the creation of stored procedures.
• Involved in creating Indexes and tuned the performance of SQL Queries.
• Used various SSIS transformations for loading the data into the Middle Office tables.
• Created table driven configuration for SQL Server Integration Services (SSIS) packages.
• Designed various reports like chart, drilldown, drill through and matrix reports based in the user requirements using SQL Server Reporting Services (SSRS).
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Followed agile methodology and delivering fast iterations to the users.
• Used Visual Source Safe (VSS) to check in the project work to maintain the version control.
• Created various jobs using SQL Server Agent.
• Extensively used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Automated and updated daily tasks on IT Service Management System (ITSM).
• Documented the project work and process.

Environment: Microsoft SQL Server 2008R2, SQL Server2008,T-SQL, SSIS, SSRS, Embarcadero, Visual Studio 2008, SQL Server Agent, Windows server 2008, Visual Source Safe 8.0, SQL Profiler, Team Foundation Server(TFS), ITSM 6.3.4, C#, Erwin, MS Access.

Confidential, Philadelphia, PA

SQL/SSIS Developer

Responsibilities:

• Involved in gathering and analysis of Business Requirements by interacting with end users.
• Front End was designed using VB 6.0.
• Managing all stages of the application from design, development and testing on both development & production environments.
• Involved in creating of T-SQL Stored Procedures, Triggers, View.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes and triggers.
• Various Reports were generated including the Purchase Order Form.
• UsedSQL ServerAnalysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved in Planning and Monitoring and creating reports in Performance Point Server.
• Worked on current information systems (MicrosoftDAX, MicrosoftSQL.
• Expertise in performing various calculations usingDAXin SSAS
• Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Environment: SQL Server2005 Enterprise Edition,SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Performance Point Server 2007