SUMMARY:

• 5 plus years of experience in designing and developing database solutions using MS SQL Server 2005/2008 and other RDBMS, designing and developing business intelligence solutions.
• In - depth knowledge of T-SQL (DDL, DML, DSL, and SQL CMD),
• Extensive experience in designing and developing Data Migration Systems between Homogeneous and Heterogeneous Sources using SQL Server Data Extraction and Transformation (ETL) tools (SSIS, DTS, Bulk Insert, and BCP).
• Thorough understanding of SQL Server Reporting Services (SSRS) Architecture to deliver on-demand and scheduled reports in multiple platforms in a secured manner.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).
• Skilled in creating user interactive report dynamic parameters using Drop Down, Multi-Valued, Cascading, Date/Calendar tools.
• Expertise in implementing backend business solution and batch processing using T-SQL/CLR Stored Procedure, Function, Trigger, Views, Service Broker, Cursor.
• Proficiency in Database Performance Monitoring by using SQL Profiler and Windows Performance Monitor, and Performance Tuning using Indexes, Statistics, File Groups, DBCC, and structure modification.
• Expertise on analyzing code/design defects, debugging, and tuning SQL queries, Stored Procedure, Functions and Triggers.
• Well experienced with various phases of SDLC (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client-server based applications).
• Well-organized, goal-oriented, highly-motivated key team leader/member with excellent analytical, troubleshooting, and problem solving skill to deliver high quality product.
• Strong business knowledge in Medical, Financial and Insurance Industry.

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

SQL Server Developer/ Business Intelligence Developer

Responsibilities:

• Designed and developed SSIS packages to integrate data from multiple systems into new trading and risk managementsystem - Zainet.
• Designed dynamic SSIS package with multiple configurations to allow data load from heterogeneous data sources (oracle and sql server) with varying schema.
• Developed SSIS package to apply business rules driven by market using dynamic sql script.
• Developed .Net Windows Form application to supply parameters for on-demand execution of SSIS packages for the end user.
• Performed performance analysis of SSIS packages and tuned data source queries, SSIS tasks (blocking to non-blocking transformation).
• Designed and applied checkpoint on SSIS packages for Auto recovery on package failure.
• Lead plan to migrate current ETL components from sql server 2005 to sql server 2008.
• Converted multiple SSIS packages from SSIS 2005 to SSIS 2008 tackling .net script changes.
• Designed and developed reconciliation reports to reconcile price data from multiple sources.
• Performed performance analysis of report queries for varying data ranges and data sets and tuned them to meet customer satisfaction.
• Developed VBA applications to copy data from excel and generate CSV files.
• Developed Vb.net application to extract xml data from LIM vendors and transform and process them into relational model.
• Developed C#.net application to consume xml data from commodity market data provider, Global View, through Restful Web service, extract data from xml and transform into SQL database.

Confidential, White Plains NY

Sql Server Developer / Data analyst

Responsibilities:

• Run DTS package to process the data and normalize it to standard form and create tables for analysis.
• Generate balancing report and analyze the reports to find any anomalies.
• Developed SQL queries to collect the required data for analysis and analyze the data anomalies on generated report.
• Modify the codes to in corporate with the change in data.
• Reviews, analyzes and modifies analytical methodologies to include coding, testing, debugging, and documenting to support organization’s reporting and statistical analysis requirements.

Confidential, New York NY

Sql Server Developer

Responsibilities:

• Worked closely with data business analyst to understand the database differences between old and new system, and client’s custom enhancement to develop migration plan.
• Routinely communicated with offshore client to report data quality and possible solutions for data discrepancies.
• Wrote sql scripts complement existing Migration Load packages and fill in gaps.
• Wrote sql routines (stored procedures and user defined function functions) to apply custom business logic for data transformation on client’s data on staging area.
• Created sql script to implement test unit cases and ensure data quality.
• Created data comparison and reconciliation reports to validate data transformation.
• Performed performance tuning of sql scripts to cut down run time and minimize resource uses.
• Performed database administrative responsibilities to backup database on schedule or adhoc basis, and restore them as needed by team.
• Worked closely with QA Team to perform front end testing and report generation to make sure the migrated data is compatible with front-end application.
• Created support document and maintained source code versioning in svn through Eclipse.
• Provided on call support during live migration run and help analyze and resolve adhoc issues.

Confidential, New York NY

Sql Server Developer

Responsibilities:

• Worked closely with internal and offshore teams to analyze and define data requirement and processing across Accounting and Finance systems.
• Designed and implemented data migration strategy from live web application into staging area using sql stored procedures and triggers for Grant approval and adjustment processes.
• Migrated accounting and financial data from old GBS System to new GP system after business processing and transformation using sql routines.
• Created backend routines to identify processed data by GP system and apply status back to the master data for further processing.
• Developed sql scripts to identify data issues defined by quality control team and automated scrubbing and cleansing logic with audit control.
• Created integration routines to tie existing GP information with historical data and trigger extra data processing to synchronize data across heterogeneous systems.
• Implemented cross servers data processing and migration using linked servers and extraction transformation and load (ETL) tools (bcp, bulk insert, as SSIS)
• Identified source of performance bottlenecks in existing sql routines using sql server profiler and sql server explain plan.
• Applied performance tuning techniques on sql routines by creating clustered, non-clustered, covering indexes, updating statistics, replace transaction loops with sql functions or intermediary table, and using proper sql expression for joins and filter criteria.
• Created test cases and performed unit testing to identify bugs in sql routines and exercised trouble shooting skills to apply quick and effective solutions.
• Applied sql server best practices on sql routines for easy code review, performance, and auditing to deliver high code quality.
• Actively participated in technical discussions with technical leads and database administrators to identify and resolved sql server related technical issues.
• Automated sql server processes using sql server jobs and result notification through emails.

Environment: SQL Server 2008, T-SQL, SSIS, SSRS, Excel, MS Access, Windows Server 2003/XP, MS Visio 2003/2007,SharePoint 2010, StarTeam.

Confidential, Rochester, NY

SQL Server Developer/ Business Intelligence Developer

Responsibilities:

• Actively participated in gathering and understanding of business requirements creating technical specifications with business analyst, project management, and end users.
• Analyzed the heterogeneous data sources (excel sheet, text file, access database) from multiple vendors and created dynamic SQL Server Integration Services (SSIS) packages to import them into Staging Area.
• Created scalable data cleaning process using dynamic stored procedures and user defined functions driven by standard business rules in stored in sql server tables.
• Developed invalid data identification process using pattern matching and report them for correction.
• Incorporated third party Melissa component in SSIS package to validate and standardize Name and Address from data tables.
• Applied waterfall suppression business rules to suppress data selection and create waterfall report in SQL Server Reporting Services (SSRS) for analysis.
• Created stored procedures to perform standard ranking on basis of performances provided by clients.
• Created waterfall and Pre NCOA reports in SQL Server Reporting Services to help business client analyze data.
• Pre NCOA netdown after the client selection.
• Standard NCOA process for the address change and name change.
• Created sprocs to handle ranking and suppressions and match with the mailing history.
• Create POSTNCOA report.
• After POSTNCOA net down create proc to do cell design.
• Create cell design reports to send to the lettershop for final DM mailing.

Confidential, Jersey City, NJ

SQL Server Developer/Business Intelligence Developer

Responsibilities:

• Actively participated in gathering and defining technical requirements for Enterprise Data Warehouse.
• Analyzed the existing data sources and their formats to create common interface for data imports into a common staging area.
• Implemented physical database designing into SQL Server for staging area and data warehouse in SQL Server 2008 on basis of logical designed by database architect team to accommodate huge amount of information.
• Implemented data consistency and integrity on physical layer using constraints and triggers.
• Used SQL Server Integration (SSIS) to import data from multiple vendors’ heterogeneous data sources (excel sheet, text file, access database, sql server database) into Staging Area.
• Used SSIS transformations (derived columns, conditional Split, lookup, fuzzy lookup, unions, aggregate, conversion, sort, merge join, and sql script) to integrate data from various sources into common staging area.
• Wrote extensive sql routines (sql stored procedure, user defined functions, and triggers) to apply various business logic on staged data to normalize and standardize data into common form.
• Created numerous user defined function (UDF) to apply various business logics to format and validate data from heterogeneous sources.
• Performed data analysis to understand data pattern from various sources and created automated data correction routine to simplify the correction procedures for users.
• Created vendor specific heterogeneous data feeds (delimited/fixed length text file or excel sheets) using SSIS packages and automated the feed generation and transfer through SQL jobs.
• Created materialized and non-materialized data views to for easy data retrieval for user interface.
• Created data source views with named calculations and named query from the enterprise data warehouse for data warehouse cube.
• Designed and created various conformed, role-playing and regular dimensions from snow-flake schema and star schema with attributes and informative properties for reports.
• Created geographical, time, and product based parent-child and regular hierarchies to analyze data in various dimension granularity.
• Designed and created MOLAP data warehouse cube with logical measure groups having stored measure and calculated measure using scripts
• Used execution plan and SQL profiler to analyze query and stored procedure performance bottleneck and tuned those sql queries by creating indexes, updating statistics, adding sargable where clause, removing correlated sub-queries, and dividing big queries into small CTEs.
• Created data maintenance SSIS packages to update stats, re-index and defrag data for optimal data retrieval and query performance from large databases (5TB).
• Authored balance and control report to balance data sources, staging areas, and Enterprise Data Warehouse using business intelligence development studio (BIDS).
• Designed and developed multiple drilled down and drill through reports to integrate summary and detail data alongside using SSRS Report Designer.
• Created graphical representation of data in reports by using graphs (such as Bar, Column, Pie) for quick data analysis and trending using SSRS.
• Used dynamic parameters and expression to create interactive user reports using SSRS.
• Automated report generation and report delivery to business using standard subscription and data driven subscription in SSRS.
• Prepared detail technical documentation of data warehouse integration process and report generation process for future and support.

Environment: SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, Report Designer, Excel, MS Access, Windows Server 2003/XP, MS Visio 2003/2007,SharePoint 2010.

Confidential

SQL Server Developer/ Business Intelligence Developer

Responsibilities:

• Actively participated in interacting, understanding, and delivering the needs of Business Analysts, Project Managers, and Teams members from multiple departments.
• Extracted, transformed and loaded data from heterogeneous data sources (MS Access, Lotus Notes, Siebel, and MS Excel) into SQL Server 2008 de-normalized Staging Area using SQL Server Integration Service (SSIS) packages
• Performed complex business logic and business intelligence to scrub and standardize data from various sources in staging area with sql routines (stored procedures and user defined functions).
• Designed and created Data Source Views with Named Calculations and Named Query from the de-normalized database.
• Designed and created various conformed, role-playing and regular Dimensions from Snow-Flake Schema and Star Schema and created geographical, time, and product based parent-child and regular hierarchies to analyze data in various dimension granularity.
• Designed and created MOLAP Cube with Logical Measure Groups having stored measure and calculated measure using scripts.
• Created numerous static, dynamic, parameterized, drill down/up, hyperlinked, and ad-hoc reports using SQL Server 2008 Reporting Services to provide prompt and quality analysis of data.
• Enhanced the functionality of reports by embedding VB.NET Scripts to dynamically change the properties of report objects.
• Created numerous database objects like tables, views, functions, stored procedures, and scripts to satisfy the requirement of upload files creation, and complex report generations.
• Created and scheduled multiple reconciliation reports to synchronize multiple heterogeneous data sources using SQL Server Reporting Services (SSRS).
• Deployed SSRS reports to Microsoft Office SharePoint Server (MOSS) to create Dashboard or create report central for centralize reporting portal experience.
• Created multiple output feeds (deliminated and fixed length) for various outside vendors.
• Created standard and data driven Subscription, and used report manager for securities.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Properly documented entire DW Population process and report generation for future supports.