SUMMARY

• Around 10 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Testing and Development
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
• Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2 and 2012.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient inSQLServer and T-SQL(DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up theSQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Install and Configure SQL Server 2005, 2008, 2008R2 on Virtual Machines.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS onSQLServer 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2000/2005/2008.
• Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Experience in Data Modeling using Erwin Design Tool
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good interpersonal, Analytical and Communication skills
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.

TECHNICAL SKILLS

Languages: VB6,SQL, Web Services - C#, C, C++, Java, Perl

Operating Systems: Windows (XP NT 3.x- 4.0 ) and UNIX

Databases: MS SQL Server (2008, 2005, 2000, 7.0, 6.5, 6.0), MS Access, FoxPro, DTS, DB2

Reporting: Crystal Report, SQL Server 2005 Reporting Services (SSRS)

DBA Tools: SQL, Erwin, TOAD, PL/SQL, T-SQL, VMware

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

Senior SQL Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database viewsto implement the business logic and also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports usingSQLServer 2008 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#,SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010,IIS, VB.Net, Erwin

Confidential, New York

Senior BI Developer

Responsibilities:

• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential, Washington DC

SQL Server Developer/DBA

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2008 for CMH Project.
• Source Controlling using IBM Rational Clear Case
• Developing and Management Database for Collateral Management and Hedging
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages
• Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
• Produce CSV, utilize CSV files as part of ETL Process
• Used .Net Scripts in SSIS
• Produce XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations/ config management in various environments
• Implement Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhance existing applications to meet new business requirements
• L3 Production Support on Rotation basis
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Capacity Planning DBs, Disk Requirements
• Deploy the code in various environments i.e. DEV/SIT/UAT
• Create and maintain DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environment: SQL Server 2008 R2, 2012, VB.NET, Oracle 10g, Microsoft Visual studio 2010, Clear Case 7.1, Autosys, Share Point, SQL Server 2008 Integration Services, Quality Center 10.0, Compass Point

Confidential, Charlotte, NC

Senior SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project.
• Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),
• Actuarial Data Mart (ADM), Reference DB according to the user requirements.
• Source Controlling, environment specific script deployment tracking using TFS
• Export the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.
• Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference
• Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart
• Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain
• Physical Structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Analyze the Legacy Data, Import the data into Reference DB that was verified and published by DMRB (Data
• Management Review Board)
• Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Creating ETL mappings using Informatica Power Center
• Day to Day maintenance of databases, Staging, Backup / Restores of databases.
• Deployment of Scripts in different environments according to Configuration Management, Playbook requirements
• Create / Manage Files/File group - Table/Index association
• Query Tuning, Performance Tuning
• Defect tracking and closing by using HP Quality Center
• Maintain Users / Roles / Permissions.
• Capacity Planning DBs, Disk Requirements
• Creating Range and Hash(by using MOD function) Table Partitioning, Index management
• Create and maintain DB Change Log to track the state of the DB in each environment(Dev, UAT, T02, T03,
• Conversion, Pre-Prod, etc.)

Environment: SQL Server 2008 R2, Team Foundation Server, Erwin 7.3, Model Mart 7.3, Share Point Server, Informatica 8.6, Cognos, Quality Center

Confidential, Glen Allen, VA

Senior SQL Server Developer

Responsibilities:

• Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services and Dundas Reporting
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Development, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2003
• Deploy various reports on SQL Server 2005 Reporting Server
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Working with SQL, and T-SQL
• Design Reports as of Internal User needs
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2005
• Creating Jobs, Job Notifications
• General Day to Day Database Administration
• Importing Data from various sources like DB2, Oracle, Excel, XML
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services(SSRS), Integration Services(SSIS)

Confidential, Virginia Beach, VA

SQL Developer

Responsibilities:

• Create and maintain database for Server Inventory, Performance Inventory
• Working with SQL, and T-SQL, VBA
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Develop, Deploy SSIS Packages with WMI Queries
• Importing Data from various sources like Excel, SQL Server, Frontbase
• Collecting Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005
• Creating Linked Servers to other ODBC databases like Frontbase, and import data
• Using Linked Servers
• Ensuring Data Consistency, Analyzing the Data
• Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services
• Backing up the Database
• Rack/Stack HP Proliant Servers, installing base operating system
• Deploy various reports on SQL Server 2005 Reporting Server
• Design Reports as of User Requirements
• Involved in migrating servers i.e. physical to virtual, virtual to virtual
• Installing and Configuring SQL Server 2005 on Virtual Machines
• Migrated hundreds of Physical Machines to Virtual Machines (P2V) by using VM Converter, P2V Assistant, Ghost and Virtual Machines (2.x) to Virtual Machines (3.x) - V2V by using ESX Migrator
• Conduct System Testing and functionality after virtualization
• Monitor the migrated System for next 48 hrs.
• Closely work with UAT team

Environment: SQL Server 2005, Windows 2000, 2003 Server, MS Access, Excel, Frontbase, InfoPath 2003/2007, ESX 2.X, 3.X, SSIS, Reporting Services (SSRS)

Confidential

SQL Developer/ DBA

Responsibilities:

• Create and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries in SQL Server and Sybase system.
• Maintenance of clustered and non-clustered indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Develop DTS Packages to transform data from excel/Access file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Analyzing the Data
• Develop backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Restore Development and UAT databases as and when needed.
• Design and implementation of database maintenance plan
• Performance optimization and normalization of database
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintain Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
• Migrate data using PL/SQL T-SQL and DTS.
• Design and Develop reports in Crystal reports 8.5 for the various in-house systems.

Environment: SQL Server 2000 7.0, Windows 2000,2003 Advanced Server,.Net (Vb.Net, C#), Visual Source Safe, Excel Macros (VBA), IIS 5.0 6.0, VB 6,MS Access, Web services, Active Directory, VBScript, TCPIP,FTP,COM,COM+.