SUMMARY

• Around 8 years of in - depth experience in database design, development, administration maintenance and Analysis of SQL Server 2 / 2000 large scale databases for both OLTP and Data Warehousing System applications like SSIS, SSAS, and SSRS in Finance, Banking, Education and Health Insurance domains.
• Hands on experience in developing and writing T-SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2005/2008 and MS SQL Server 2005/2008 respectively.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Good command in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2012/2008 (SSRS).
• Accomplished in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008.
• Strong experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Knowledge of migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2008.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member and managing the data quality issues.

TECHNICAL SKILLS

• MS SQL Server 2000/2005
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• Data Stage
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Rational Rose
• Oracle 9i
• TOAD 6.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• JavaScript
• SharePoint
• Unix ODBC
• MS Visio 2008.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

MS SQL BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2005/2008.
• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 7.2 data modeler tool.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Queries, Triggers, User-defined functions as per the business requirements.
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• 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, 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.
• Designed and developed 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.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• 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.

Environment: MS SQL Server 2012/2008R2,Reporting Services (SSRS), Integration Services(SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, .NET, C# MS Access and Excel.

Confidential, Mount Laurel, NJ

MS SQL Server Developer/BI Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple TSQL.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• 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, Tableau Reports using SSRS
• Designed and developed Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes,
• Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012, MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2008, Win NT /2000/ 2003, MS Office 2003/2007, PL/SQL, Microsoft Office Share Point - 2008, C#, VB.Net.

Confidential, Pittsburgh, PA

MS SQL/BI Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Created SSIS package to extract, transform and load data fromFlat Fileto Flat File and Flat File into the Data warehouse and to Report-Data mart, usingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used VB.Net Scriptfor Data Flow and Error Handling using Script component in SSIS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated Tabular reports, Cross Tabs, Drill down, Drill Through, Cascading and Parameterized Cascading Reports, Sub Reports, Summary Reports, Charts, Functions and Maps using SSRS, Tableau reports.
• Managed Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005
• Developed measures and dimension members using multi-dimensional expression (MDX) to
• Meet additional needs that were calculated from existing measures.
• Used to integrating different Microsoft BackOffice Components like SharePoint with MS SQL Server.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.

Environment: MS SQL Server 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2008, Win NT /2000/ 2003, Scope Queries, SQL Azure, Scope Studio, C#, Erwin, MS Office 2003/ 2007, SCCM, MS Visio, Data staging, Microsoft Office Share Point - 2008.

Confidential, Bridgewater, NJ

MS SQL/ ETL Developer

Responsibilities:

• Developed Technical Design specifications and Source to Target Mapping (STTM) specifications for each legacy system interface with Enterprise system.
• Designed and developed physical and logical Data Models using Erwin and developed SQL Server Database objects including Tables, Views and Indexes.
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database (SSIS).
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly (SSRS).
• Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
• Analyzed and designed disaster recovery and replication strategies based on business requirements.
• Design, build, execute and monitor data intake processes.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Microsoft DTS, MS SQL Server 2000, T-SQL, ER-Win v4.0, MS Visual Studio .NET, MS .NET Framework, J2EE technology, Windows 2000 Advanced Server, MS SQL Server 2000,ITIL, Microsoft Visual Basic 6, MS Access, Crystal Reports, PL/SQL, C#.

Confidential, Redding, CA

MS SQL Server Developer/ETL Developer

Responsibilities:

• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Configured linked servers in SQL Server 2000 and modified them to work in SQL server 2005.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.

Environment: Windows XP Professional (SP 2), SQL Server 2005, SQL Profiler, SSIS, SSRS.

Confidential

MS SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer, Oracle Hyperion EssBase.