SUMMARY

• Over 7 years of professional experience on Design, Development and Maintenance of Database objects using tools of MS SQL Server 2012,2008 R 2/ 2008/2005/2000 as a Developer.
• Expert in designing ETL frameworks to create SSIS package to integrate the systems with support controls in place to track the status of all the ETL packages with support documentation in place for quick troubleshooting and handling change requests
• Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension (SCD), Multicast, Merge Join, Lookup, Sort, Conditional Split, Aggregate, Derived Column, Bulk Insert, Merge and Union All and Data Conversion Transformations.
• Extensive experience in creating inbound and outbound data feeds of data warehouse in various formats of files such as fixed width, XML, Excel and CSV.
• Expert in MS SQL Server DTS, SSIS and BCP to perform ETL operations of data from various sources to several destinations like SQL Server, Oracle, Access and Excel.
• Proficiency and Experience in using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports and formatting.
• Created datasets using stored procedures and reports using multi value parameters.
• Experienced in working on MS SQL Server 2008 and creating several reports and SSIS Packages using MS Visual Studio BIDS 2008.
• Highly proficient and Experience in the use of MS SQL Server and T - SQL in constructing Stored Procedures, Triggers, Tables, User Functions (UDF’s), Views, Indexes, Data dictionaries, SQL joins and performance based query writing.
• Troubleshootingperformance issues andfine-tuningqueries and stored procedures.
• Excellent in using database tools such as Red-Gate, Apex SQL, Toad and Erwin to reduce the time to take for typical database tasks.
• Excellent knowledge in Object Oriented Programming in C#, VB.NET and C++, and Software Development Life Cycle (SDLC).
• Expert in working on windows 2000 NT, windows 2003 server and XP, Linux, Unix OS Environments.
• Knowledge on informatica.
• Good team player, extremely adaptable, solution achiever and a fast learner.

TECHNICAL SKILLS

• MS SQL Server 2008R 2/ 2008/2005/2000 7.0
• Windows 2008/2003/2000 Advanced Server
• Windows Exchange Server 2003
• Windows NT 4.0/3.5
• Windows9.x
• Windows XP
• Unix
• Linux
• Red Gate
• MS-Access
• Oracle 10g
• Windows PowerShell
• IIS 6.0
• MySQL
• C#
• T-SQL
• PL/SQL
• HTML
• DHTML
• ASP.Net
• VB.NET
• XML
• Java Script and VB Script
• MS Visual Studio 2005
• Crystal Reports 8 9 10
• Microsoft Reporting services 2008/2005/2000
• BizTalk Server2006 2004
• Microsoft Visio 2003.

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Sr. MS SQL Server BI Developer (SSIS, SSRS)

Responsibilities:

• Working on MS SQL Server 2008 R2 (Fast track Data Warehouse), Oracle 10g in Windows Server 2008 and Linux (ubuntu and redhat) environments.
• Developed stored procedures, views, and user defined functions and created / altered tables for data extraction and transformation, and data loading using TSQL statements for handling complex business logic.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Designing, Deploying and maintaining high level complex ETL processes using SQL Server 2008 Integrations services (SSIS 2008) to perform daily and weekly loads to enterprise Data Warehouse.
• Troubleshooting, Optimizing the SSIS - ETL processes while implementing highest level of portability with Package configurations and environment variables.
• Extracting and exporting the terabytes of data from existing Data Warehouse to load into the new Aster DWH.
• Creating documentation on existing ETL processes and database applications and designing mappings documents to be implemented in new DWH.
• Performed large volumes of data exports and imports in the process of the data migration
• Created object mapping documents, centralized ETL metadata tables, and load control tables in the process of designing new Data Warehouse.
• Designed and automated new ETL outbound feeds based on new Data warehouse and configure the job on Autosys for these feeds.
• Created daily, weekly and monthly SSRS dashboard reports for sales and profit analysis.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Working with Product managers, Business users and EAI managers to implement product info changes and new data feeds into data warehouse.
• Providing 24/7 on call production support for enterprise Data Warehouse jobs and ETL processes.
• Worked closely with end users, testers, business people and product managers in identifying and resolving the production on demand data issues.

Environment: MS SQL Server 2008, 2005, MS Windows XP Professional, Linux Ubuntu, Linux red hat, Aster data nCluster, Oracle 10g, Visual Studio 2008, C#, ASP.ET, VB.Net, XML, IIS 7.0,Autosys,Perl script,Shell Script,MS Visio, FileZilla FTP, FilecryptSB.

Confidential, Woodbridge, NJ

Sr. MS SQL Server Developer/ BI Developer

Responsibilities:

• Designed and implemented a variety of SSRS reports such as Parameterized, Drill Down, Snapshot, Cached, Drill Through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements using both Tabular and Matrix report formats.
• Created a Dynamic SQL queries to load the data in to SSRS reports
• Created different Parameterized SSRS Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Designed and maintained complex ETL processes for enterprise Data Warehouse incremental and full loads using MS SQL Server Integration Services.
• Created and automated portable SSIS packages for inbound and outbound data feeds of Data Warehouse.
• Worked on Systems integration project to merge the data into Data warehouse coming from different source systems while performing the data validation and Analysis.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed ETL structures for data imports from various sources such as Oracle, Tera Data, Excel, Access and DB2.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variable such as Package Name, PackageStartTime, etc.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Extensively used C# and VB.net to design script components and script task design while designing the SSIS packages.
• Trouble shoot the server jobs and fixed the errors occurred during job execution.
• Worked on SSIS Package performance Improvements by analyzing various attributes of package and Dataflow task buffer tuning.
• Worked with Pl/SQL queries to pull the data from Oracle source systems for analysis and loading purposes.
• Debugged and optimized various critical load procedures by analyzing execution plans and step by step test execution analysis of complex T-SQL code segments and UDF’s.
• Prepared technical documentation of existed and newly designed ETL processes and Database Applications, and share these documents through SharePoint for users/developers reviewing.

Environment: MS SQL Server 2008, 2005, 2000, MS Windows XP Professional, Oracle 10g, IBM AS-400, Visual Studio 2005,C#, ASP.ET, VB.Net, XML, IIS 7.0,6.0,MS Visio, FileZilla FTP, PGP Encryption, FilecryptSB.

Confidential, Charleston, WV

Sr. MS SQL Server Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Ware houses using SSIS.
• Created SSIS packages to extract transform and load data to data warehouse databases.
• Designed and developed SSIS packages and dynamically deployed them into Development, Testing and Production Environments using Package configuration.
• Used various SSIS transformations such as conditional split, derived column and look up for data scrubbing and data validation checks before loading the data into Data Warehouse.
• Used various data transformations in SSIS including importing data from files, moving data from
• One database platform to another and building star schema data marts from OLTP.
• Used Bulk copy program (BCP) to import and export data in and out of tables into data files.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Creating Tabular, Matrix reports, Charts and graphs as per customer requirements using SSRS.
• Involved in analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Extracted data from larger fixed length files and XML files with XSD definitions and loaded into enterprise Data warehouse.
• Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Created various views to be used in various stored procedures as pointed to new Database system while maintain the exact business functionality in the process of ERP implementation.
• Modified the Stored Procedures to point to new Data system and resolved the performance issues and created various views to be used in procedures.
• Developed win-forms using C# and .net.

Environment: MS SQL Server 2008/2005/2000 , SQL Server Integration Services(SSIS),SQL Server Reporting Services 2005(SSRS),Analysis Services(SSAS),MS Windows server 2003, Oracle 9i, Red Gate, Visual Studio 2005,C#, ASP.ET, JAVA, XML, IIS 7.0,6.0, DTS Xchange, Tidal Job Scheduler, ERWIN.

Confidential, Jersey City, NJ

Sr.MS SQL Server Developer (SSRS, SSIS)

Responsibilities:

• Interacting with users to gather Business requirements andAnalyzing, Designing and Developingthe Data feed and Reporting systems.
• Developed complex programs in T-SQL, writingStored Procedures,TriggersandQuerieswith best execution plan.
• Extensively worked onViews, cursors, CTE’s, schemas,permissions and performance issues with client/server database design.
• Involved in creatingDatabases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE’s for complex queries involving multiple tables from different databases.
• DefinedCheck constraints, Business Rules, Indexes, and Views.
• Worked withException handling using Try Catch Blocks and Logging the Exceptions in the Database Application error logs.
• Created SSIS package to load data from staging environment to production environment using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension (SCD).
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Generated Reports using global variables, expressions and functions for the reports.
• Created drill-down SQL Server Reports using SSRS 2005.
• Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005(SSRS),MS SQL Server Integration Services 2005 SSIS(SSIS), Oracle 9i / 10g, MS Excel, MS Access, Toad, Data Modeler, XML, RedGate, ABS v6.0 / 5.8.5, MS Office, Windows XP/NT.

Confidential, Columbus, OH

MS SQL Server Developer

Responsibilities:

• Created and executed several SSIS packages to perform ETL operations of data from OLTP to OLAP systems.
• Created complex Stored Procedures, views, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Optimized the Stored Procedures and T-SQL queries by analyzing Queries, Execution plans and Indexes on specific tables.
• Performed ETL operations in various environments like MS SQL Server, Oracle, DB2, and My SQL and MS Excel.
• Created several reports on Analysis data using SSRS 2005 and migrated several reports from Crystal reports to SQL Server reports (SSRS).
• Developed rich client applications using C#, ADO.NET, SQL Server 2000 using Visual Studio.Net IDE tools.
• Led the offshore team consists of five members and coordinate them to perform their tasks in way of providing effective data warehouse solutions.

Environment: MS SQL Server 2005, SQL SSAS 2005, MS SQL Server Integration Services 2005(SSIS), MS Reporting Services 2005(SSRS), C#. NET, Front Office 8.3 / 10.2 / 10.3 , Windows XP / NT / 2000, MS Office 2003, Apex SQL, Red Gate.