SUMMARY

• Over 7 years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server applications using Microsoft SQL Server 2000/2005/2008 and BI Suite.
• Extensively worked on SSIS/SSRS/SSAS, SQL, Stored Procedures and Triggers, performed debugging, troubleshooting and performance tuning.
• Experience in developing Custom Reports and different types of Chart, Tabular, Matrix, Ad hoc reportsand distributed reports in multiple formats using SSRS.
• Hands on experience in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Excellent command on subscriptions, report snapshot and report cache.
• Expert in High Level Design of ETL Packages for integrating data from heterogeneous sources (Access, Excel, CSV, Oracle, flat file, Text Format Data).
• Skilled in Database programming for Data Warehouses (Schemas), proficient in Star Schema modeling, and Snowflake modeling, reporting tools, proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).
• Proficient in Data Modeling as well as reverse engineering using the tools Erwin, ER/Studio and MS Visio.
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Bulk Copy Process(BCP), Data Transformation Services(DTS) and SSIS with MS SQL 2005/2008.
• Experienced in Data analysis, Data modeling, Database design and Data migration.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Experienced in providing logging, error handling by using Event Handler.
• Highly motivated, excellent leadership, interpersonal and communicational skills.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Server Integrated Services (SSIS)
• SQL Server Reporting Services
• (SSRS)
• SQL Server Analysis Services (SSAS)
• Microsoft Visual Studio 2005/2008
• Crystal Reports
• Erwin
• T-SQL
• DTS
• BCP
• VB Script
• .Net
• C#
• JAVA
• Progress 4GL
• HTML
• CSS
• XML
• Visual Basic
• Shell Scripting
• MS Office
• Excel
• Oracle
• DB2
• Informix
• MS Access Database
• QTP
• QC
• .Net 2.0/3.5/4.0.
• Unix OS
• Linux
• Solaris

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

MS SQL Server /ETL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translated them into ETL Design Specifications and SSRS Datasets.
• Designed ER Diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Created a batch process using SQL Server Agent to upload data previous day’s trading activities information from flat files into SQL Server Database using FTP task in SSIS.
• Used Control Flow elements in SSIS like For Each loop Container and Sequence container to cross check parallel trading activities for each trader.
• Developed complex stored procedures, Views, Functions, Constraints and rules on database objects.
• Developed triggers using TSQL to prevent commodities/equities traders from violating SEC rules.
• Created Multi Cast Transformations in SSIS to store equity data into different platforms like OLE-DB, and Excel files.
• Used Slowly Changing Dimensions Type 1 and Type 2 to store data for maintaining trading activities.
• Created Execute SQL tasks, Execute package tasks, File System tasks, and Send Mail Tasks in SSIS.
• Extensively used package variables, package configurations, logging.
• Used Configuration files to locate test file which had testing data on daily trades and to ease the process of moving the packages across servers.
• Designed stylish reports like dash board reports, gauge reports, Score Cards and deployed Reports for Compliance Department users using SSRS Report Server.
• Created customized parameterized reports, cascading reports, and drill down reports for each trader..
• Created SSAS Cubes from various data sources, Dimensions with star schema, and Measures (Facts) tables with ROLAP/MOLAP methods and stored them in SSIS for later use for reports.
• Created Excel Pivot reports using SSAS Cubes as an external data import.
• Created KPI’s within SSAS for different time dimensions and trader dimensions and wrote complex MDX queries to aggregate measures.

Environment: s: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ASP.NET 3.5/3.0, T-SQL, Visual Studio 2008

Confidential, Newark, DE

MS SQL Server /BI Developer

Responsibilities:

• Migrated DTSX packages from MS SQL Server 2005 to MS SQL Server 2008 by using Detach/Attach, Back up & Recovery and by Replication.
• Migrated credit card data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server database using SQL Server Integration Services (SSIS).
• Successfully executed DTSX packages in SQL Server 2008 by using SSIS Tasks such as Execute Package, Execute SQL Task and SQL Server Agent jobs.
• Wrote complex T-SQL functions and stored procedures to update existing APR (Annual Percentage Rate) information and also using Derived Column, Copy Column, Sort Columns, Merge rowsets, MultiCast, Metadata functionalities within ETL of SSIS.
• Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.
• Created SQL Server Agent job to load daily APR Customer Group data into SQL Server Database promotional tables for generating reports in SSRS.
• Generated stylish and complex reports such as Dashboard Reports, Gauge Reports, Drilldown Reports, Parameterized Reports, Cascading reports by creating different Datasets deriving information from various Data Sources in SSRS.
• Successfully prepared, planned, and installed new reports using Report Manager/Report Server with Snapshot and Cache reports capabilities.
• Set up the Report Server and moved the existing and new reports to batch process.
• Created Alerts for successful or unsuccessful completion of scheduled jobs/reports, called SSIS Packages, and Stored Procedures.
• Created complex MDX queries to extract data from Data Marts related to different groups.
• Implemented SSAS Cubes, Facts and Dimension tables using star-schema to perform analysis after promotional offers were over.
• Created different group KPI’s to be used for Dashboard and to analyze promotional performance over period of time.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), Windows, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), .Net, Visual Source Safe

Confidential, White House Station, NJ

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Transferred data from various sources like Excel, MS Access, and SQL Server using SSIS OLEDB Connection managers, Transformation, and Destination using SSIS in one centralized location.
• Developed Execute SQL Tasks that would invoke to load Dimensions and Fact Tables and also for Error handling during the ETL process.
• Utilized SQL Query Optimizer to optimize queries.
• Created complex stored procedures to gather information for different datasets for generating various reports like Dashboard Reports, Cascade Reports, Linked Reports, Sub Reports, Gauge Reports, and Drill Down Reports.
• Setup batch jobs to run SSRS reports job using Report Server.
• Created Snapshot reports and Cache Reports for ad-hoc viewing for business users.
• Created (ROLAP and MOLAP) cubes, and dimensions using star schemas.
• Created Data Source Views to optimize the retrieval of data for Data Mining from multidimensional tables from the Data Warehouse.
• Migrated and recreated existing dimensions and cubes using star schemas on SQL Server to achieve the efficiency of SQL Server Analysis Server.
• Setup SQL Server Agent jobs to execute SSAS packages overnight.
• Created new MDX queries to extract data from the Data Mart to create complex cubes and dimensions, and to calculate totals using MDX aggregate functionalities.
• Designed KPI’s with new target and goal indicators within SSAS.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), T-SQL, .Net, Visual Studio 2005/2008, SQL Profiler, ASP, NET 3.5/3.0

Confidential, Red Bank, NJ

MS SQL Server Developer

Responsibilities:

• Worked with Auto Insurance Department Business users to understand, gather, document project requirements.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access DB Tables) to SQL Server.
• Created Views/ Functions for the Data Warehouse using SQL Server for SSIS - Extraction and calculations of data and storage of data.
• Worked with Execute SQL Task, Script Task, Sequence Containers, For Each Loop containers etc.
• Involved in Error Handling, creating configuration files and Log Details using SSIS Logging.
• Created stylish Report Layouts (Drill Down Reports, Sub Reports, Matrix Reports, Gauge Reports) and Deployed the Reports using SSRS and scheduled batch jobs for Reports using Report Server.
• Created SSAS Packages including Dimension and Fact Packages to feed the Data Warehouse using one Master Workflow Package (Sequence Container from SSIS) which included series of steps/tasks.
• Migrated software to various environments which includes development, testing, User acceptance Tests (UAT) and then to Production Environment.
• Created several Documentations for the users including Development Test Results, UAT results, Operations Documentation, System Design, System Functionality features, etc.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), SQL Profiler.

Confidential, Charlestown, WV

MS SQL Server Developer

Responsibilities:

• Gathered Requirements from the end user and created the structure of the schema and data for database tables.
• Wrote Complex Stored Procedures, Triggers (to invoke mail task), Views, and Constraints on database objects.
• Configured SQL mail Task for sending automatic emails on errors.
• Created different User defined functions (Scalar defined functions, In-table valued functions and Multi Table Valued functions).
• Involved in fine-tuning of complex SQL queries and Stored Procedures to increase performance.
• Used Transformation tasks such as Derived Column, Copy Column, Data Conversion, and Conditional Split and used Execute SQL task, Script task, File System task, Send Mail Task.
• Migrated packages from SQL Server Testing environment to SQL Server Production Environments.

Environment: MS SQL Server 2000, DTS, Crystal Reports, TSQL, .Net, Visual Source Safe.