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 in Financial, Insurance, Banking and Health industries.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Adept in RDBMS concepts and constructs along wif 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 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 wif .NET, Import/Export data, Bulk insert and BCP.
• Expert in SSIS script transformations using C# Script 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).
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced inSSASstorage and partitions, and Aggregations, calculation of queries wif MDX.
• Experienced wif aggregation using OLAP analysis services cube.
• Proficient in implementing surrogate key generation strategy in the Data warehouse.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Organized professional wif excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology wif ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

• MS SQL Server 2012/2008 R2/2008
• T-SQL
• SQL Server Management Studio
• Business Intelligence Development Studio (BIDS)
• SQL Server Agent
• Data Transformation Services (DTS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services(SSAS)
• Erwin Data Modeler
• MS Visio
• SQL Profiler
• Bulk Insert
• BCP
• Visual Source Safe Code management tools 6.0.
• Sub Version
• PL/SQL
• Oracle 10g/9i/8i
• XML
• UNIX
• Windows Server 2008/2003
• BIRT 4.3
• Crystal Reports
• MS Access

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

BI Developer

Responsibilities:

• Worked wif business analysts in gathering and understanding reporting requirements
• Investigate and creatively resolve problems related to apparent inconsistencies and irregularities in data
• Development and maintenance of stored procedures, functions, and views to facilitate reporting
• Acquire and abstract primary or secondary data from existing internal or external data sources
• Perform ad hoc queries and develop reports using Microsoft SQL Server and SQL Server Reporting Services.
• Created SSIS packages for different applications - to Truncate & load data, Appending data to the existing data, update existing records before inserting new records for different packages daily at specific EST for different environments (DEV,UAT & PROD)
• Responsible for querying, cleansing, troubleshooting, and migrating data.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Developed reports in FCI which is a JPMC reporting platform
• Developed reports in BIRT and deployed reports using Tomcat server
• Configured & Deployed applications in all Environments

Confidential, Jersey City, NJ

MS Database Developer/BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, PSV, FTP Server, Excel, DB2 and SQL 2008R2).
• 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.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involves in creating counter logs and trace logs using windows server 2008 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.
• Modified C# scripts to update the inter department portal.
• Created Documents of understandings and Remedy Tickets for Deployment process.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings wif Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work and process.

Confidential, Parsippany, NJ

MS SQL Data Warehouse Developer

Responsibilities:

• Developed and designed the whole process to load data into IDEAS Data Warehouse.
• Attended meetings wif business analysts and business users to understand the existing OLAP cubes.
• Involved in designing the data model for the Data warehouse tables.
• Create process load documentation using MS Visio.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Schedule and maintain packages by daily, weekly and monthly in SQL Server Agent.
• 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 applied various transformations accordingly.
• After uploading the data into dimension tables, created SSIS packages to load the data into Fact tables.
• Created the Date Dim to keep the track of Start Date and End Date.
• Used script task to get the 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 effected 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 look ups 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 correcting EDW/BI performance bottlenecks and debug database, application or data content related issues.
• Actively participate in review meetings wif Project Manager to ensure that the development of projects meet business and system requirements.

Confidential, Arlington, TX

MS Database Developer/BI Developer

Responsibilities:

• Responsible for gathering requirements for the database designing for the middle office wif the Data Architect. Involved in understanding the current system and analyzed the overall compatibility of the all systems wif the proposed Middle Office Database design.
• Created new database schema and tables for the Middle Office.
• Involved in creating new and modifying the existing stored procedures and functions.
• Cleaned the data using SQL Server Integration Services (SSIS).
• Understanding the user requirements and created reports using SQL Server Reporting Services (SSRS).
• 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.
• Used Team Foundation Server (TFS) to create Build tickets for testing and deployment.
• Extensively used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings wif 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.

Confidential, Pitts burg, PA

MS SQL Server Developer/BI Developer

Responsibilities:

• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets intoSQL Server2008 database using SSIS package.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked wif T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Involved in creating views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups wif backup devices, database maintenance plans and recovery.

Confidential, Purchase, NY

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2005.
• Created ad-hoc reports Using Report Builder 1.0.
• Interacted wif the Business Admin and gather the requirements and analyzed.
• Interacted wif the Project Managers and the Field Managers who would be using the application the most.
• Wrote and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Involved in creating Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Built the SSRS reports from Different Databases like Oracle andSQL Server.Configured and deployed SSRS reports.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wifSSAS2005 and in adding calculations using MDX.
• Created SSIS packages using Pivot transformation, Derived Columns, Condition Split,Aggregate, Execute SQL Task,Data Flow Task, etc to generate underlying date for the reports and to export data from Oracle and SQL server .
• UsedSQL ServerAnalysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved inSSASstorage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL
• Involved in Planning and Monitoring reports in Performance Point Server.
• Used Performance Point Server to create interactive reports wif an ability to drill down into details.
• Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated in review meetings wif Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the development work.

Confidential, Philadelphia, PA

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Developed logical and physical data models for schemas using MS Visio.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Coordinated wif DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for designing SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Invloved in designing and developed OLAP cubes using MDX queries.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Involved in creating reports using MDX and SQL.
• Added calculations to cubes using MDX queries and was involved in performance optimization of MDX.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in preparing training document for application development and QA/UAT teams.