SUMMARY:

• 12+ years of experience in Database design, development, maintenance and support of high quality Database, Internet, Client - Server and Reporting applications primarily using Microsoft products.
• My core competencies include MS SQL Server 6.5/7.0/2000/ 2005/2008/2012 , SSMS, SSIS and SSRS.
• Experience in all phases of SDLC of Project Development life cycle - Requirement Specification, Analysis, Technical Design, Development, Testing, Production Support and Implementation.
• I also have hands on experience in Sybase, MS-Access, DB2, MySQL, Teradata, and Oracle databases.
• Experience in developing Internet/Client-Server applications using Visual Basic, C#, ASP.Net, VB.Net, VSS, COM/DCOM, MTS/COM+, Crystal Enterprise/Crystal Reports Server and Crystal Reports.
• Expertise in:
• Design, Development, Deployment, Testing and Maintenance of tables, triggers, views, user defined functions, indexes, stored procedures (XML driven), defaults, constraints and keys.
• Update statistics, performance tuning of T-SQL queries and procedures using execution plans and CTEs, data purging in replicated environments, normalization, and control access rights.
• Perform sanity checks, Deployment, Maintenance and Tracking of T-SQL scripts across Dev, Test, QA, Model and Prod environments, Release co-ordination and production support.
• Create/Maintain/Schedule jobs via SQL Agent.
• Data Analysis, Database design and Data Modeling.
• Release Automation via shell scripts.
• Optimized system resource utilization and people time by Orchestrating, Parallel Processing, Error logging, generating package configuration files, Event Handlers in SSIS packages according to the dynamic changes at data source(s).
• Designed/Developed new package using SSIS Control components like Execute SQL Task, Data Flow Task, Task Factory components Execute Package Task, File System Task, Script Task, FTP Task, containers and transformations to read heterogenous sources like text/XML/Excel, Oracle, SQL Server, Web Services etc.
• Expertise in Extraction, Transformation and Loading (ETL) processes using DTS Import/Export, DTS Packages, Bulk Insert and Utilities like BCP.
• Use SSIS to perform Source Dependent Extracts, Source Independent Loads using Derived Column, Aggregator, Merge, Data Conversion, Look up, Script Task, Container, Condition Split, Row Count, and Data Conversion.
• Deployed the package with File System and Catalog deployment methods
• Tuned SSIS packages and implemented best practices
• Migrating/Upgrading from SQL Server 2000 to SQL Server 2008/SQL Server 2012.
• Expertise in creating simple and parameterized reports using SSRS 2005 / 2008 and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs, Conditional Formatting.
• Designed the interactive dash boards using linked, drilldown, drill through, sub reports, cascading parameters, matrix, Indicators and Gauges in a Gauge Panel, Maps etc.
• Configured and maintained Report Manager and Report Server for SSRS.
• Scheduled report subscription using data and time driven report subscriptions
• Developed Crystal Reports with cascading prompts using BOXI.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills, team-player, creative with a desire to learn the Business and understand Client requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Languages: T-SQL, Visual Basic 6.0, ASP 3.0, VB.Net, C#.Net, ASP.Net, PL/SQL, XML, HTML, C, C++

DataWareHouseTools: DTS, SSIS 2005/2008/2012

DATABASE: MS Access, MS SQL Server 7.0/2000/ 2005/2008/2012 , Oracle8i/9i/10g, Sybase 11.2, DB2, MySQL version 5.6.23 Community, Teradata, MS Access 97/2000

Tools: /Utilities: Enterprise Manager, Query Analyzer, SQL Server Management Studio, Database Tuning Advisor, DTS, BCP, SQL Profiler, Visual Studio 2005/2008/2010/2012 , ER Studio Data Architect, TOAD

Other Tools: MS Office, Visio, Ms Excel, MS-Project 2000,Informatica 7.1.1

Reporting Tools: Excel, SQL Server Reporting Services 2005/2008, Crystal Reports, BO XI R2

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Developer / Flowsolution Workbenches - Dallas TX

Responsibilities:

• Maintain/Enhance the Flowsolution Workbenches functionality as per the Business requirements.
• Develop and Deploy complex SSIS packages that fetch data from multiple sources and transform the data as per the business rules.
• Create and Maintain complex stored procedures to cleanse, massage, and standardize the data and load it in to Workbenches database.
• Send error/status notification emails via stored procedures.
• Perform required enhancements/modifications to SSIS packages (full load and incremental load) and stored procedures.
• Create/Maintain and monitor SQL jobs that are scheduled to run on a daily basis.
• Move and track changes across Dev, Test, QA and Production environments and testing the correctness of migration of new features/enhancements/fixes between the environments.
• Create/Enhance/Modify/Maintain of SSRS reports and deploying them to Sharepoint and scheduling them as per requirement.
• Create adhoc queries/reports to meet business user intermittent needs.
• Develop complex stored procedures, CTEs, dynamic SQL, views, triggers, functions, cursors, alerts.
• Optimized the performance of existing SQL queries.
• Involved in DBA activities like scheduling backup’s and restores, created partitions and implemented partition switch, set up replication, created maintenance plans, created linked servers, implemented security via user/login creation and associated desired roles to logins.
• Tuned SSIS packages and implemented best practices.
• Generated SSRS reports viz. pipeline orders, orders by specific vendor, Regional Value reports

Environment: SQL Server 2012/2008/2000 , SQL Server Management Studio, SSIS, DB2, Teradata, MySQL, SharePoint, SQL Enterprise Manager, T-SQL, SSIS, Windows 2000/7

Confidential

Sr. SQL Server Developer / EIT - Technology & Tools - Boston, MA/ Dallas TX

Responsibilities:

• Development of stored procedures, tables/views, triggers for sample pulls for different LOBs, and auto code check out
• Develop scripts for extraction of population data and provide the sample file based on the input from six sigma calculator, perform Production Support, raise and implement PCNQs.
• Performance Tuning of existing queries.
• Optimize the load on the HALS server by re-writing the existing scripts/procedures to point them to the downstream sources to reduce the load on the main server
• Analysis and identification of fields to map the main source fields with downstream fields.
• Develop SSIS packages for archiving data in to flat files and to fetch meta data information of different servers and databases to check the updated tables on a daily basis.
• Validation of changes done to scripts pointing to downstream servers by performing different tests using SSIS packages.
• Develop SSIS packages to perform nightly loads to database tables and to monitor the tables that are updated daily.
• Unit Testing and Integration Testing.
• Updating Test data dictionary with the latest modifications to the existing fields.
• Scripting in T-SQL in constructing user defined functions, views and indexes.
• Development of Adhoc queries to meet the requirements of the users.
• Working with ARM, System Inventory, TDD, TL, and other Sharepoint sites.

Environment: SQL Server 2012/2008/2000 , SQL Server Management Studio, SSIS, DB2, Teradata, MySQL, SharePoint, SQL Enterprise Manager, T-SQL, SSIS, Windows 2000/7

Confidentia

Sr. SQL Server Developer / Agency Interface, Consumer Interface - Boston, MA

Responsibilities:

• DDL Scripting (T-SQL) for tables, user functions, views, indexes, triggers, user profiles.
• Perform sanity checks, deployment and tracking of changes across Dev, Test, QA and Prod environments, release co-ordination and production support
• Index creation, update statistics, performance tuning of T-SQL queries and procedures using execution plans, Query Analyzer, purging old data (maintained audit trail) in replicated environments, normalization of tables, using CTEs
• Create/Maintain stored procedures with XML parameters for better performance
• Design, Develop, Troubleshoot and Deploy DTS/SSIS Packages to transfer data between servers, Extract, Transform and Load data into Target databases.
• Document Business Requirements, prepare technical and functional specifications, estimate and track project development work and validate project deliverables against specifications, code reviews to implement standards and improve efficiency
• Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
• Use SSIS to perform Source Dependent Extracts, Source Independent Loads, work with transformations viz. Derived Column, Aggregator, Merge, Data Conversion, and Look up to extract, transform and load data OLTP to OLAP databases
• Create/Enhance SSRS reports, Use Charts and Gauges, Work with Data Sources/Data Sets, Set up report publishing and execution settings, Manage Report Server content with Report Manager, Distribute reports with subscriptions
• Designed databases with requisite relationships and system checks for integrity and consistency of data
• Provided technical support to internal developers and Business Analysts
• Use shell scripts to automate releases, and to generate flat files from huge Ecxel data and BCP that data in to SQL Server tables

Environment: SQL Server 2008/2000, SQL Server Management Studio, SQL Enterprise Manager, T-SQL, DTS, SSIS, Windows XP/2000/2003/7

Confidential

Sr. Developer / Loan IQ Web Services - Westlake Village, CA

Responsibilities:

• Understand Business Requirements
• Generate evolutionary prototypes to understand complex business requirements.
• Design, Develop, Deploy and Maintain LoanIQ Webservices application.
• Design, Develop and Modify reports using Crystal Reports.
• Unit Testing and Integration Testing.
• Hands on experience with scripting in T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, optimized indexes and statistics in relation to reporting data model.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
• Designed database/tables and the requisite relationships, designed partition tables and partition views
• Provided technical support to Developers and Business Analysts
• Performance tuning of queries and stored procedures, eliminated redundant and inconsistent data, normalized tables and created indexes whenever necessary
• Maintained parallel multi databases for different environments like Development, Testing and Production.
• Worked on DTS and BCP of SQL Server to populate the data from various sources in various formats

Environment: SQL Server 2000/2005, SQL Enterprise Manager, T-SQL, DTS, ASP.net, C#, Crystal Reports.Net, Infragistics Net Advantage 2006, .Net framework 1.1, Windows XP/2000.

Confidential

Consultant / Service Point Info, Dashboard Manager - Simi Valley, CA

Responsibilities:

• Understand Business Requirements
• Prepare/Review/Modify functional specifications.
• Generate throwaway prototypes to understand complex business requirements.
• Estimate Effort required for the modification/development of reports.
• Participate in Data model design review.
• Design, Develop and Modify reports using Crystal Reports XI R2.
• Unit Testing and Integration Testing.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Developed complex SQL queries and DTS packages
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Worked on optimization and tuning of SQL queries and indexes
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications
• Dynamic SQL Scripts to create modify after triggers to record any changes in any table into a single table etc.
• Active involvement in supporting the users

Environment: SQL Server 2000, SQL Enterprise Manager, T-SQL, DTS, VB.net, Crystal Reports XI R2, DB2, Informatica, Business Objects Enterprise (Crystal Reports Server) XI Release2, Infoview11.5, Erwin and Windows 2000

Confidential

SQL Server Developer / Loan Accounting System - McLean, VA

Responsibilities:

• Gathering requirements via evolutionary/throwaway prototypes and preparation of Requirement Specifications.
• Analyze requirements to project the estimated Level of Effort for enhancements.
• Perform impact analysis to identify impact prone sections.
• Create Enhancement and Deployment (one for each environment) tickets for deployment of application and database changes.
• Analyze and Design tables for the RFS.
• Developed conventional fat client architecture with C# and VB.net, as well as thin client architecture with Microsoft ASP.net, Web Forms, and C# components.
• Developed Complicated Dynamic WebPages with Error handling using ASP.Net.
• Used ADO.net to access the database.
• Created/developed/maintained stored procedures and triggers.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Tuning the queries to improve performance
• Designed, tested DTS packages required for data transfer from consolidated files to database tables
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index de-fragmentation
• Set up database backup and recovery strategies
• Provided technical support to developers and users
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting

Environment: SQL Server 2000, SQL Enterprise Manager, T-SQL, DTS, Visual Basic 6.0, VB.Net, ADO.Net, XML, ASP.Net, Visual C#.Net, Crystal Reports 9.0/8.5, MS SQL Server 2000, ClearCase, ClearQuest, Windows 2000 s

Confidential

Programmer Analyst/Cheetah Release - Hrendon, VA

Responsibilities:

• Design and Development and Testing of complex reports using Crystal Reports 9.0/8.5
• Publishing reports in the Intranet using Crystal Enterprise 8.5/8.0
• Implementation of quality process.
• Preparation of Change Release Documents.Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server environment, and deploy the data
• Scheduled the jobs to do these tasks Periodically
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports

Environment: SQL Server 2000, SQL Enterprise Manager, T-SQL, DTS, Crystal Reports 9.0/8.5, Crystal Enterprise 9.0/8.5, Oracle 9i, Windows 2000.