SUMMARY

• 10+ years of experience wif MS SQL Server 2008/2005/2000 /7.0 as a backend Developer/Database Administrator, involved in System Analysis, Design, Development, Testing and Implementation of various projects in Retail, Financial and Health domains.
• Expert in RBMS and DBMS Concepts, Database Physical and Logical design, Data Modeling using Erwin / MS Visio and Data Warehouse.
• Expert noledge in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and performance prospect
• Skilled in SQL Server 2008/2005 Business Intelligence tools, Data Warehousing and ETL processes
• Experienced in Data Modeling - Relational, Multi-Dimensional Modeling such as Star Schema and Snowflake Schema in Data Warehousing
• Expertise in using SSIS, SSRS for Authoring, Managing and Deploying reports (Full Report Cycle), Managing and Security of Reports (Full Report Cycle)
• Extensive experience in report writing using SQL Server Reporting Services. Created Table/Matrix/Chart reports and Web reports using customized URL Access, Ad-hoc reports, Drill down / Drill through and Cross tab reports
• Experience in report generation using Crystal Reports and Excel reports as per teh client Requirement and for teh periodic analysis
• Implemented & supported Business Reporting System using Brio/HPSU infrastructure.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications
• Experience in creating SSIS packages to automate teh Import and Export of data to and from SQL Server 2008/2005, Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Experience in creating jobs/alerts, schedule SSIS/DTS packages using SQL Server Agent
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML)
• Knowledgeable in designing XML documents using DTD, XML Schemas, XSLT and XPath queries for its integration in database
• Involved in migration from heterogeneous sources including Oracle to MS SQL Server
• Experience in tools like Index Tuning Wizard, SQL profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Good Knowledge in developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Experience in programming wif ASP.NET, Web Forms, XML Web Services, Windows Forms and ADO.NET
• Supported teh development, implementation and daily administration of SQL Server databases, performed database design, modeling and implementation of new database structures.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• A well-organized, goal-oriented, highly motivated and effective team leader/member.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2008/2005/2000 , Oracle 10g, MS Access

Database Tools: SQL Server Profiler, Query Analyzer, Database Tuning Advisor, Toad, Oracle 9i Forms & Reports.

Reporting Tools: SSRS, Crystal Reports IX/X, MS Access, Brio/HPSU

ETL Tools: SSIS, DTS, SSAS, Import Export Data, Bulk Insert, BCP

Data Modeling Tools: ERWIN, MS Visio

Version Control: Visual Source Safe, Team Foundation Server (TFS)

Operating Systems: Windows 2003/2000/XP/NT, UNIX, Sun Solaris

Languages: T-SQL, PL/SQL, .Net, Visual Basic 6.0, C, C++

Web Technologies: IIS, Apache Server, HTML, XML, VB Script, .Net 2.0

Paramount Technologies: Requisition System

ERP: Microsoft Dynamics GP 9, Integration Manager, Baan V

PROFESSIONAL EXPERIENCE

Confidential, Carlstadt, NJ

SQL Server Developer/DBA

Responsibilities:

• Performed Enterprise wide SOX Audit and validated users IDs for secured access to enterprise applications, generated reports to teh management on access privileges to each application using SQL Server Reporting Services (SSRS).
• Created databases, tables, stored procedures, views and used in SQL Server Integration (SSIS) and Reporting services (SSRS).
• Loaded tables by creating SSIS package to load data from Excel to SQL database wif User Id’s and their roles wif access privileges for all applications at Confidential .
• Actively involved in supporting teh production applications and wrote SQL scripts to Insert/Update and Delete data in MS SQL databases
• Involved in code review and prepared unit test cases and documented teh implementation process and updated teh project plan to provide for reviews wif teh business.
• Assigned permissions to users, roles, and objects and administered security for server’s logins (Windows and SQL Server account)
• Monitored SQL 2008/2005/2000 Servers; install, maintain and applied patches on all SQL Servers in Production, QA and development environments.
• Maintained/administered SQL Server backups and recovery; routine maintenance of servers; performance monitoring and tuning using Performance Monitor, SQL Server Profiler; Implement and maintain security rules and security audits; documentation and problem resolution.
• Involved in configuring Reporting Services and deployed SSIS packages and scheduled using SQL Server Agent.
• Actively involved in documenting SQL Run books for all Production servers.

Environment: SQL Server 2008/2005/2000 , SSIS, SSRS, SSMS, SQL Server BI Development Studio, T-SQL, SQL Profiler, SQL Server Agent, ASP.net, IIS 6.0, MS Access, MS Office, Windows 2003 Server.

Confidential, NYC, NY

SQL Server Developer/DBA

Responsibilities:

• Involved in administering SQL Server 2005, applied service packs, patches and hot fixes and also maintained database changes from Development, QA to Production.
• Administered MS SQL Server by creation of user logins, groups wif appropriate roles, monitored teh user accounts, and granted teh privileges to users and groups.
• Interacted wif Business Analysts and Developers to identify requirements for designing and implementing teh Database schema.
• Created and modified stored procedures, views, and indexes, used in SQL Server Reporting (SSRS) and Integration services (SSIS).
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS Packages to reload tables from Excel data files.
• Mapped business requirements and translated requirements into application logic, functional specifications and detailed test plans.
• Administered, Customized, Troubleshoot and Maintained 40 user Great Plains ERP system. Maintained 100% system uptime and full system integrity. Remediate performance issues. Area of work includes Great Plains System Manager wif Report Writer, General Ledger, Bank Reconciliation, Fixed Assets, Receivables Management, Payables Management, Sales Order Processing, Adv. Purchase Order Processing and Human Resources (Payroll).
• Performed Great Plains System Administrator functions including backup / disaster recovery, updated, security, policies, procedures, trouble shooting, SQL maintenance and server administration etc.
• Developed and modified Web-based Quotes for teh sales team wif complete management visibility using Drawloop and DocuDesign on teh SalesForce Platform.
• Installed and configured web-based eRequisition system and defined teh routing rules, System Configuration, Roles, Approval lists, Users security, and User-Defined field templates in teh system.

Environment: SQL Server 2005, SSIS, SSRS, T-SQL, SQL Server Agent, MS Visual Studio, SSMS, Crystal Reports 10, VB Script, MS Access 97/2003, Ticketing Systems: Altiris/JIRAMS Dynamics GP 9.0, Integration Manager, FRx Reports, Liaison Messenger 3.0, Windows 2003 Server, Salesforce, Drawloop, Paramount Technologies - Requisition system, IIS 6.0.

Confidential, Kissimmee, FL

SQL Server Developer/Reports Specialist

Responsibilities:

• Responsible for working wif in-house development staff and functional analysts to review code and integrate SQL Reports wif Oracle Systems using Web Services.
• Created and modified stored procedures, tables, views, indexes on various databases for critical data involving profit and loss, net revenue, forecasting etc.
• Developed, tested, implemented and scheduled ad-hoc reports dat enable data driven decisions.
• Tuned quires, T-SQL stored procedures to enhance teh performance of applications.
• Created various reports using SSRS (Drill Down, Matrix, Sub reports and Navigating), Crystal Reports 10 and converted existing crystal reports to SSRS reports.
• Created and maintained SSIS and DTS packages and used most of teh tools in SSIS like looping, data formatting, error handling, email notification, web service task.
• Developed SSIS packages to extract/transform data, develop Business Intelligence.
• Utilized extensively SSIS packages functionality to create and complete ETL process using scripts, stored procedures, functions, transformation of data.
• Worked on Clustered and Linked server environments
• Used TFS (Team Foundation Server) for project management and source control
• Created and modified custom applications using VB script and ASP.net.
• Supported MS Access Applications by changing teh logic, adding/modifying tables as per teh business needs.

Environment: SQL Server 2008/2005/2000 , SSRS, SSIS, SSMS, DTS, TFS, T-SQL, SQL Profiler, SQL Server Agent, SQL API, PL/SQL, Crystal Reports 10, VB Script, Windows XP, MS Visio, IIS 6.0, MS Access 97/2003, ASP.net 3.5, XML, Timeshare Ware Application, TortosieSVN, Oracle 11i, Oracle CRM Applications - Day Break, Microsoft Office SharePoint Services (MOSS), Performance Point Server 2007.

Confidential, Fort Washington, PA

Microsoft SQL Developer/ Reporting Specialist

Responsibilities:

• Prepared Technical and Functional specifications based on teh project requirements and documented test cases for each phase in development cycle
• Responsible for data analysis, loading data from Data feed through IBM Mainframe interface to Data Warehouse tables
• Developed queries’ using various joins and sub queries in Data Warehouse in OLTP/OLAP environment and created complex stored procedures, views, user defined functions, triggers, T-SQL queries
• Implemented extraction, transformation, and load (ETL) processes between SQL and mainframe environments
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Modified stored procedures to meet current design and used them in SQL Server Reporting Services directly to generate reports on teh fly.
• Configured and maintained Report Manager and ReportServerfor SSRS.
• Created Reports and Dashboards using Performance Point 2007/SharePoint.
• Modified web pages to do database inserts, deletes, modify using ASP.net and VB Script
• Modified current database by adding tables, altering referential integrity to support online system.
• Monitored database performance and space requirements and analyzed and resolved database performance issues.

Environment: SQL Server 2005, SSIS, SSRS, SSMS, T-SQL, Microsoft Visual Studio, VB Script, SQL Profiler, SQL Server Agent, SQL API, XML, ASP.Net, Windows Server 2003, Erwin, IIS 6.0, MS Office SharePoint Services (MOSS), Performance Point Server 2007.

Confidential, Boston, MA

Microsoft SQL Developer

Responsibilities:

• Responsible for Dimension Data Modeling based on teh client requirements.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to Data Warehouse.
• Developed, deployed and monitored SSIS Packages and also upgraded DTS to SSIS.
• Migrated data from different sources (text based files, Excel, and MS Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application.
• Created index for increasing teh performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing
• Uploaded MS Reporting Services (SSRS) RDL files to SQL Server 2005
• Created Reports wif MS Reporting Services 2005. Importing data for Data Warehouse and Reports wif Integration Services using SQL SERVER 2005 Integration Services
• Created graphical representation of reports such as bar charts, pie charts as per teh end user requirements in SSRS
• Involved in developing MDX scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Generated reports using SSRS for different SSAS Cubes
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data
• Maintain database changes from Development, QA to Production.

Environment: SQL Server 2005 Enterprise Edition, Microsoft Visual Studio, VB Script, SSIS, SSRS, SSAS, SSMS, DTS, T-SQL, SQL Profiler, SQL Server Agent, SQL API, Windows Server 2000, MS Visio, MS Excel, Unix, IIS 6.0.

Confidential, NY

SQL Server Developer/ DBA

Responsibilities:

• Gathered teh business requirements and developed/ modified stored procedures and functions to provide efficient query performance against very large tables for reporting.
• Played an active role in migration of teh Database from SQL 2000 to SQL Server 2005.
• Worked closely wif teh Supply Chain/Logistics team to align teh design, implementation approach and overall timing for WMS (Warehouse Management System) implementations.
• Supported and implemented Brio/HPSU (Hyperion Performance Suite) based business solutions to resolve serious database performance issues.
• Developed queries to retrieve data from teh databases based on teh added functionality.
• Developed several complex reports using SSRS according to teh user requirements, standardizing report format according to teh user for different divisions in teh business.
• Refined and advised existing reporting specifications and developed new tables and schemas for reporting purposes.
• Supported teh development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS/SSIS packages.
• Strong experience wif SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning, using sp Indexoptions & DBCC Showcontig, etc
• Involved in production support 24*7. Based on teh priority of teh requirement changes, developed teh code and deployed on teh production server, troubleshoot and provided solutions to teh application as and when required.

Environment: SQL Server 2005 Enterprise Edition, Microsoft Visual Studio, VB Script, SSIS, SSRS, SSMS, SQL Profiler, SQL Server Agent, SQL API, Hyperion Brio (8.5)/HPSU, SAP (Warehouse Management), Windows Server 2003, IIS 6.0.

Confidential, San Jose, CA

Database Administrator

Responsibilities:

• Installed and upgraded MS SQL Server 2000 on Test, Development, Production boxes.
• Involved in ER Diagrams and Mapping teh data into Database Objects.
• Interacted wif Business Analysts and Developers to identify requirements for designing and implementing teh Database schema.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
• Administered MS SQL Server by creation of user logins, groups wif appropriate roles, monitored teh user accounts, and granted teh privileges to users and groups.
• Worked extensively on DTS Package design to Import/Export data from various Sources like Flat file, Excel, MS Access to/from MS SQL Server.
• Involved in Linked Server setup, which allowed access to teh distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS, Text files.
• Monitored Server Level Blocks/deadlocks & Maintained teh OLTP Servers wif maximum Database Availability, Reliability & Investigated to resolve any Database or performance related issues wif Minimal Downtime & Maximum Reliability.
• Reviewed, tested and applied all database changes to all environments including QA, Development and Production Servers.

Environment: MS SQL Server 2000/7.0, VB Script, T-SQL, Crystal Reports, Erwin 3.5.2, DB2, UNIX, Windows2000 Advanced Server.

Confidential

Systems Analyst/ Administrator

Responsibilities:

• Maintained and Supported Baan ERP V and Baan IVc4 ERP applications.
• Involved in all phases of implementation - project preparation, requirements gathering, business blueprint, realization, go-live preparation and support.
• Mapped business requirements and translated requirements into application logic, functional specifications and detailed test plans.
• Customized Application Software according to teh functionality and developed new Sessions, Reports and Forms. Optimized components and performed primary testing and Fixed Bugs during testing.
• Created procedures, triggers, functions and packages using PL/SQL
• Performed Database Backup, recovery of Database from Media Failure, recovered accidentally dropped tables, Data files and Block Corruption.
• Exported data from other databases to Oracle 9i using Baan Exchange Schemes.
• Scheduled application and database backups into LTO tape drives on a daily and weekly basis. Produced: daily, weekly reports to provide information on a wide variety of aspects based on user requests.
• Maintained in-house network system (LAN, WAN comprising of 450 systems).

Environment: Baan IV, Baan V ERP, Oracle 9i, PL/SQL, Windows 2000/NT Server.