SUMMARY

• Over 7+ years of IT experience in BI using MS SQL 2012/2008 R2/2008/2005, Experience manipulating various data sources to support senior management decisions, Ability to accomplish tasks under minimal direction and supervision.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Skilled in writing and reviewing T - SQL code and maintaining coding standards.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Cursors, Views and User Defined Functions to implement business logic.
• Excellent experience in MS SQL Server 2005/2008 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Sound knowledge in implementing complex transformations like lookup, merge, merge join, derived column etc.
• Excellent knowledge in maintenance and change management to existing reports and in optimizes report performance.
• Hands on experience in ETL (Extract, Transform and Load) development processes using BCP, DTS and SSIS.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS.
• Experienced in handling change data capture, late arriving facts and complex mappings in SSIS
• Strong experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Proficiency in deploying and enhancing SSIS Packages from development to production server and creating Databases based on Functional Requirements and System Design.
• Expert in writing Parameterized Queries for generating Tabular reports, drill down, drill through, click through, matrix, chart, snap shot reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Outstanding oral and written communication skills.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services, Management Studio, Visual Studio, Project Management 2007, Microsoft Visio, Microsoft Office, Crystal Report.

Database: MS SQL Server 2000/2005/2008/2012 , DB2 UDB, MS Access 2000/7.0, Sybase, and Teradata V2RX

Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX UNIX 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Novell Netware 4.1, Sun Solaris 8 and DOS

Language: C, C++, Perl, SQL, PL/SQL, Transact SQL, Unix Shell scripting, HTML, XML, Java script Mercury Interactive

PROFESSIONAL EXPERIENCE

Confidential, South Brunswick, NJ

Sr. Business Intelligence Developer

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Created Stored Procedures for complex business, SQL Agent jobs, and designed tables by following RDMS rules.
• Administering SQL Server 2012 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Working with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2012.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Data integration into MS SQL Server 2012 using SSIS from various sources such as xml, flat-file, excel, other data sources. XML data source were multidimensional in nature and have to use extensive Data Transformation tools such as Merge Join, multi sorting of data of data at various sub-stages and data transformation before loading into staging table
• Implemented and customized Slowly Changing Dimensions (SCD Type 1, Type 2 and Type 3) and LookUp transformation on Data Warehousing Project.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Working with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Working with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Understanding the OLAP processing for changing and maintaining the Data Warehouse, Optimizing Dimensionsand adding new Aggregations to the Cube.
• Working with Calculations, Key Performance Indicators and Aggregations on SSAS Cubes.
• Analyze, design, develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and Analysis Services cubes.
• Worked with Report Manager to configure Web URLs, E-mail for reports.

Environment: SQL Server 2012, SSIS, Web Services, SSRS, SSAS, Crystal Reports 10, HTML, JavaScript, XML, Visual Studio 2008, Visio 2010, Visual Source Safe, ASP, VB 6.0

Confidential, St Petersburg, FL

Sr. SQL Server Developer (SSIS/SSAS/SSRS)

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).
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Created Store Procedure using T-SQL to evaluate result for the repots to implement using Management Studio.
• Used DTS/SQL Server Integration Services and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created stored procedures to build the Fact tables in the data mart cubes for Multi-Dimensional analysis.
• Worked on different kinds of transformations in SSIS as per the client’s Requirement.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Analyzed existing Stored Procedures & Triggers and took actions to increase the performance in modularization.
• Wrote stored procedures to get the fields required for the reports.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Performed system testing and debugging, creating test case and reporting the bugs.
• Deployed the reports in to the report server.
• Deployed the databases from old servers to new servers using Replication, based on the business goal.

Environment: SQL Server 2008/2005, SSAS, SSIS, SSRS, Management Studio, XHTML, XML, Windows

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
• Created stored procedures for the business logic using T-SQL.
• Performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Designed and developed Data Transformation Process.
• 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.
• Generated E-R diagram using MS Visio 2000.Defined relationship between tables.
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
• Installed and maintained MS SQL Server 2000.
• Built and performed user acceptance testing on new and modified reports.

Environment: MS SQL Server 2008, T-SQL, Office 2010, MS Visio 2010.

Confidential, Atlanta, GA

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Created OLAP cubes and dimensions for the analysis using SSAS.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL Server 2000, DTS, SQL Profiler, Index Tuning Wizard, MS Access, MS Excel, Crystal Reports 10

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential, Atlanta, GA

Database Developer

Responsibilities:

• Participated in Business Requirement Gathering and Development of BRDs for new and upgrade implementations.
• Designed physical development databases on SQL 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in developing database for contract maintenance system.
• Enhanced database structures as per the business requirement which is applicable for Contract Accounting Maintenance in an efficient way.
• Developed and maintained data, procedures and performed Data Impact Analysis
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Implemented distributed transaction using MS Distributed transaction coordinator on replication and Linked servers.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Coordinated and assisted with the Front-End Developers in handling & solving bugs.

Environment: SQL Server 2000 Enterprise Edition, Windows NT, XML, SQL Reporting service, DTS.

Confidential

MS SQL Developer

Responsibilities:

• Developed logical and physical database.
• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager on SQL Server 2008 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Made sure that standards and best practices in database development were followed and maintained.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Tuned SQL Statements using Indexes and designed and implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated reports, test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2008, T-SQL, SQL Server 2008 Reporting Service, Windows 2008 Server, Enterprise manager,, .Net Framework, Visual Studio 2008, Silver Light Tools.