SUMMARY

• 13+ years of experience in IT, this includes 10+ years as Developer in MS SQL Server, Oracle and ETL/BI/Data warehouse technologies.
• Expert in MS SQL Server suite of products like SSIS, SSRS and SSAS
• Extensive experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment, Production Support, Help Desk support and Maintenance.
• Experience in installing, configuring, managing, monitoring, administering, migrating, securing and troubleshooting SQL Server 2012/2008/2005 .
• Expert in utilizing ETL tools for data loads, database integration/conversions, including SQL Server Integration Services, Data Transformation Services (DTS).
• Extensive experience in writing T - SQL, stored procedures/triggers, Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization, Indexing and Tuning.
• Expertise in SQL Server Database creation, backup and recovery, performance issues, Error Handling and Experienced with troubleshooting database problems.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS/SSIS Packages.
• Developed Unix Scripts and Oracle Pl/SQL, Package, Procedure and functions
• Worked with handling high volume data on oracle and Sql server database on Unix and Windows OS respectively
• Well versed in defining/creating and handling Data Sources, Data Source views, parameterized Reports in SSRS 2005 and integration with Share Point.
• Worked with supporting large customer base and worked directly with end-users and supported all the requirement changes, issues tracking systems request and data related issues
• Extensively worked in Financial, Media and Pharmaceutical Domains
• Knowledge of NoSQL - Mongo DB.
• Expert in writing shell scripts, Perl scripts and power shell scripts for automation.
• Expert in using SQL Server tools like Business Intelligence Development Studio (BIDS), Management Studio, SQL Profiler, Enterprise Manager, Query Analyzer, Index Tuning Wizard, Windows Performance Monitor and SQL Server Configuration Tools.

TECHNICAL SKILLS

Languages: Java, C, C++, C#, XML, .Net, VB

Database Technologies: SQL Server 2012/20, DTS, SSIS, SSAS, SSRS, Oracle 11g, PL/SQL, T-SQL, MySQL, DB2, Sybase, Oracle Warehouse Builder, NoSQL, MongoDB

Internet: JavaScript, Jscript, VBScript, JSP, Servlets, JHTML, Perl, shell scripts, powershell

Web & App Servers: IIS, JRUN, iPlanet, WebLogic, Apache, Web Sphere, Lutris EAS, ATG Dynamo

Version Control: Team Foundation Server, Visual Source Safe, CVS, Clear Case, Dimensions

Operating Systems: Windows 8/7, NT/XP/Vista, Win2k/03, UNIX, SOLARIS, Red Hat Linux, HP-Unix, IBM-AIX

Other Tools: OEM, Rational Tools, MS Project, MS Visio, TOAD, Erwin, Cold Fusion, Remedy, i2 Products, Ariba, MQ series, TIBCO.

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Server Database Developer

Responsibilities:

• Writing complex T-SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Business Requirement Gathering, prepare design documents, technical workflows, design ETL processes.
• Create SQL / Integration scripts as part of ongoing product support and customizations to modify business logic as per the requirements.
• Designed, developed SSIS Packages, Stored Procedures, Configuration files, tables, views & functions.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Understands existing complex reporting queries, develop new queries wherever necessary and fine-tune SQL Queries.
• Developed power shell scripts for automation.
• Performed data conversions from flat files into a normalized database structure
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services
• Involved in database migration from SQL Server 2005 to SQL Server 2008
• Developed various types of complex reports such as Drill Down, Drill through, Cross tab reports.
• Optimize existing ETL process to increase efficiency and performances.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Had experience of integrating database applications with external/internal applications.

Environment: MS SQL Server 2012/2008/2005, SSIS, Visual Studio 2012/2008/2005, Windows Server 2003/2008, DTS, VBScript, .Net3.5, Cold Fusion, Oracle, ER Studio, Red Gate, XML, SSRS, SSAS, IIS, ERWIN & MS Access, MDx.

Confidential, NY

Database Consultant (Architect/Developer)

Responsibilities:

• Part of initial analysis of the proposed application and understanding business requirements
• Worked as database architect in designing, developing and implementing the logical and physical model for the Database.
• Designed database in SQL server 2005 as per the business requirements
• Developed Stored Procedures, Functions as per the application needs using SQL Server 2005/2008.
• Worked closely with content management team in getting the right content (profiles, images etc) and store it in SQL Server database.
• Incorporated core business logic in the SQL Server rather than in application layer.
• Integrated with external applications to pull and publish the content on website
• Implemented Transactional Replication and Mirroring with SQL Server 2005
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Designed and developed SSIS Packages, Stored Procedures, Configuration files, tables, views and functions.
• Created and Scheduled jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitor performance and optimize SQL queries, Stored Procedures and import /export utilities for maximum efficiency.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Worked closely with development team (.Net), dashboard application team, SharePoint team and business teams.
• Good knowledge of Team Foundation Server (TFS), BI Tools and .Net Framework used in the application.
• Implemented shell scripts and Perl scripts for automation.

Environment: MS SQL Server 2005, 2008, SSIS, Visual Studio 2005/2008, Windows Server 2003/2008, DTS, VBScript, .Net, Share Point, Oracle, ER Studio, Red Gate, XML, SSRS, MySQL, IIS 6.0, ERWIN & MS Access, Shell Scripts, Perl Scripts.

Confidential, NJ

Database Developer

Responsibilities:

• Loading invoices, contacts into Ariba MS SQL Server Database
• Developed SSIS packages, T-SQL Scripts, Triggers, Views and functions.
• Involved in integrating with external systems
• Good knowledge and experience of SRM.
• Bug fixes related to payment terms, remittance issues, inactive supplier issues, approval flow issues etc.
• Involved in implementing new exception types for invoices and contracts.
• Developed stored procedures for invoices
• Customized invoice push to staging tables there by to external interface and sending reports to business users on daily basis
• Implemented customizations for Analysis Loads (from external system, from buyer)
• Involved in customizing contracts.

Environment: MS SQL Server 2005, Oracle, Integration Services, Red Gate, MS SQL 2000 (DTS), Windows Server, DTS, Shell and Perl scripts, Ariba, Toad, XML, SSRS, IIS and MS Access

Confidential, NJ

Database Developer/ Integration Consultant

Responsibilities:

• Designed data models using Erwin.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed and maintained data, procedures and performed Data Impact Analysis
• Developed stored procedures, functions, views and triggers.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability.
• Developed scripts to load data from Oracle tables and flat files into Enterprise data warehouse.
• Created different user level groups, and assigned appropriate permission level to the database, to ensure access to the information for the right persons with authorizations
• Worked closely with Investments, Trading, Clearing and Capital Markets teams
• Monitoring and loading events related to Sourcing/ACM/ACP
• Processing of timesheets, generation of processed data and export
• Created Indexes, Constraints and Rules on database objects.

Environment: MS SQL Server 2005, Erwin, SQL Query Analyzer, Cognos, Ariba, XML, SOAP, Perl, Shell scripts, Unix, ASP.NET, JD Edwards, Sybase, Red Gate.

Confidential, NJ

Database Support & Maintenance

Responsibilities:

• Participated in Design and Architecture meetings and proposed technical solutions to resolve business requirements.
• Customizations to existing MDR application using Java, JSP
• Developed stored procedures for invoices
• Customized invoice push to staging tables there by to external interface and sending reports to business users on daily basis
• Worked closely with the architect and team in designing, developing and implementing the logical and physical model for the Data mart.
• Migrated Organization, Orders, Adjustments, Objectives and Ariba data in various formats like text based files, Excel spreadsheets, to SQL SERVER databases using SQL SERVER Integration Services (SSIS) to overcome the transformation constraints.
• Migration from SQL Server 2000 to SQL Server 2005
• Scheduled and maintained daily and monthly loads of Orders, Objectives and Adjustments data through jobs, tasks, and alerts.

Environment: SQL Server 2005/SQL Server 2000, BIDS, Ariba Buyer, Sourcing, ACM, T-SQL, XML, DTS, SSIS, SSRS, ERWIN, JavaScript, Red Gate, Shell and Perl Scripts, IIS, VB, Oracle