SUMMARY

• 6 years of experience with design, development and implementation of SQL Server based Application methodologies in the field of commercial and business applications.
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server 2005 to MS SQL Server 2008
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Strong Transact - SQL query writing skills (DDL, DML, and DCL).
• Good experience in creating objects such as Databases, Tables, Stored Procedures,Triggers and Cursors, Constraints, Indexes, Views, Indexed Views in Microsoft SQL Server 2000/2005/2008 .
• Good understanding of Normalization/De-normalization, Database design, Entity- model and application oriented design.
• Hands on experience in designing, Installing, Creating, Maintaining of Databases, Performance Tuning, Backup and Recovery, Optimization and Database Security.
• Expertise in generating reports using SQL ServerReportingServices (SSRS)2008/2005.
• Experience in configuration of reportserver and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Knowledge of Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling.
• Maintaining, creating / Designing and monitoring databases (SQL server, Oracle),
• Experience in Designing and Building the Dimensions, Fact Tables with star and snow flake schemas using SQL Server Analysis Services (SSAS).
• Monitors database for potential problems and creates end user reports. Also Security Administration and Replication, Database mirroring & clustering.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/20, MySQL, Oracle 9i/10g

Operating System: Windows 2000/2003, Linux, HP-UNIX

.NET Technologies: ASP.net, C#, VB.net

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS, Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL, Jobs, Replication tools, Data visualization (Composite tool).

Programming Languages: C, C++, Java

DBA: Database Administration of MS SQL Server 2008,2008R2, 2005, 2000

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Sscript, XML, SOAP, IIS

Database Access Technology: ADO.NET, DTS

Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

SQL/SSIS Developer

Responsibilities:

• Created complex Stored Procedures for Quality Checking.
• Created SSIS packages, Stored Procedures, auto schedule the SQL profiling
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Created SSIS Package to transfer data from various locations using the FTP task.
• Created SSIS and used the task to import and export files.
• Created, modify, schedule, test and or trouble shoot SQL Server Integration Services (SSIS) packages, stored procedures, Tables and Views.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of schemas.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Internal, External, retailing, and Prime Clients and requests reports for the trading of their business.
• Designed SSIS packages to migrate the data from PDX files to the Staging Area in SQL server 2008.
• Created Database Objects like Tables, Linked Servers, Indexes, Views; User defined functions, Cursors, Triggers, Stored Procedure, and Constraints Roles in SQL Server 2005/2008.
• Created and maintained various database in MS Access to track activities and progress.
• Produced Metrics for reporting to Senior Management. Used Extract, Transform, Load, (ETL) Concepts to Transform Data into MS Access database to produce reports in MS Excel.
• Enhanced the business logic and maintain integrity in end to end logic from UI to Backend database through Oracle PrimeOne DB to SQL primeDB servers through SQL Server Integration services.
• Created SSIS Packages using Lookup, Merge, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and expressions etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access, Oracle Servers to different data Marts.
• Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports using SSRS.
• Designed and developed DTS packages for data import and export.
• Developed different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Configured Connection Manager files and CMD Batch files for SSIS packages to dynamically execute on DEV, QA, UAT and Production server
• Migrated SSIS 2005 packages to SSIS 2008 packages used Event Handlers for Exception Handling in SSIS packages deployed, Tested and Scheduled SSIS packages using SQL Agent.
• Created several views and Stored Procedures to be accessed by the new front-end applications PAT, Trade Manager and Portal.

Environment: SQL Server 2005/2008R2, MS Access, SQL Server Integration Services 2005, SQL Server Reporting Services 2005 and 2008, and 2008, Windows Scheduler, SQL Server Agent, SQL Navigator, SQL Developer, Clear Case, CVS tortoise, Team Foundation Server and Data base administration of MS SQLSERVER 2008, 2008R2, 2005, 2000

Confidential, Denver, CO

SQL/SSIS Developer

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the workflows for the new functional piece.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
• Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
• Performance tuning of stored procedures and functions to optimize the query for better performance.
• Transformed complex business logic into database design and maintaining it by using Sql objects, stored procedures, user defined functions, views, T-SQL scripting and jobs.
• Successfully implemented indexes on tables for optimum performance.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided using SSRS.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Scheduled SSRS reports for end users and managed the security of the reports.
• Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.
• Strong analytical and problem solving skills coupled with interpersonal and leadership skills.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.
• As SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements

Environment: MS SQL Server 2008R2/2012, SSIS 2008/2005, SSRS 2008/2008R2, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008 , SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Richfield, OH

SQL/SSIS Developer

Responsibilities:

• Perform all SDLC phases related to extract, transform, and load (ETL) processes usingSQL Server Integration Services (SSIS) andSQLServer stored procedures within MSSQLServer 2008 environments
• Participate in on-call support rotation for nightly ETL batch cycles
• Assist in the definition of the database requirements; analyze existing models and reports looking for opportunities to improve their efficiency; and resolve technical problems
• Develop optimizedSQLServer stored procedures, functions, and database views
• Translate business requirements intoBIapplication designs and solutions
• Worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data.
• Performance monitoring, tuning and capacity planning
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholdsWorked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines.
• Worked on searching and sorting, dynamic and mathematical programming and finite state machine
• Created stored procedures to use as datasets for the Report Design.
• Written scripts using C # programming to customize the reports in SSRS environment.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Worked on .Net framework and Asp.net as a programming part
• Maintained and implemented technical specification and documentation.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports

Environment: MS SQL Server Management Studio 2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Confidential, Phoenix, AZ

SQL Developer

Responsibilities:

• Designed details of UI/Reports for Sales Performance tracking
• Designed and implemented datasets and layouts for various reports with SSRS
• Identified aggregation from business requirements and designed cubes with SSAS
• Created cubes, did performance optimization and generated OLAP reports with SSAS
• Involved in logical design and physical design of the data mart, forward engineering and reverse engineering with Erwin
• Created data dictionary for the overall database
• Identified interfaces to the Data mart, design and implemented data mappings with SSIS
• Developed stored procedures to retrieve and transform data in T-SQL
• Provided Full Reporting Life Cycle support using SSRS
• Understood complex reporting requirements and define functional requirement
• Designed, developed, and deployed new reports and enhanced existing Reports
• Identified and worked with parameters for parameterized reports using SSRS
• Retrieved data from cubes and generated OLAP reports using SSRS and SSAS
• Developed complex Stored Procedures for the reports
• Maintained data integrity by performing validation checks
• Optimized queries, tuned and monitored server performance
• Fine tuned of database objects and server to ensure efficient data retrieval
• Tested applications for performance, data integrity and validation issues
• Developed front-end/UI for easy data access and submission in C#

Environment: SQL Server 2005, SSRS, SSIS, SSAS, Erwin 4.1, Oracle 10g, C#

Confidential

SQL Developer

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Expertise in designing databases and capacity planning.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Archiving the Data onto Backup tapes
• Upgraded SQL Server 2000 to SQL Server 2005 server for high volume processing databases.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i. Also created DTS package for data transfer between the two environments.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
• Used SSIS to extract, transform and consolidate data from different sources into Data Warehouse.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Experience with the .NET framework including C#, ASP.NET and Web Service.
• Implemented 2-node Active/Active & Active Passive Clustering.
• Successfully implemented Database Mirroring in SQL Server 2005.
• Configured Central Publisher/Distributor Transactional Replication Model (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Rebuilding the indexes at regular intervals for better performance.
• Developed complex stored procedures, T-SQL functions, Joins, triggers and views using SQL Server Management Studio.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Performed database backup and deployment to the production server.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Involved in configuration of Team Foundation environment along with Share point Services and Reporting Services.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults
• Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility.
• Reviewed all code prior to production and moved team from Visual Source Safe to Subversion.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Environment: MS SQL Server 2000/2005/2008 , SQL server 2008 R2, NETEZZA SQL, Windows Enterprises 2003 servers, VERITAS, SSMA, SAN, Index Tuning Wizard, Database Maintenance Plan Wizard, SQL Server Integration Services (SSIS), SSAS, Transact-SQL, Net Framework, Visual studio, Visual Source Safe.