SUMMARY

• Around 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/2005/2008/2012 , 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

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

Database Access: ADO.NET, DTS Technology Design and Visual Studio 2008/2005/2003 , Visual Studio 6.0

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

PROFESSIONAL EXPERIENCE

Confidential, Rock Island, IL

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, Java, and 2008, Windows Scheduler, SQL Server Agent, SQL Navigator, SQL Developer, Clear Case, CVS tortoise, Team Foundation Server.

Confidential, Columbus, OH

SQL/ SSIS Developer

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the work flows 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, jdk tools, C#. NET, VB.NET, Windows Sever 2000/2003/2008 , SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Smithfield, RI

MS SQL Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Scheduling Jobs and Alerting using SQL Server Agent
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Developed various reports for managing various securities and assets to meet specified investment goals.
• Worked Extensively with Business System Analysts who has drafted the requirements for me and helped me in testing the report results.
• Extensively involved in high level design of OLTP and OLAP based Databases.
• Used Extensively MS SQL Server Reporting Services 2008 to develop various kinds of reports and test them with users and finally deploy them.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Formatted the report layout for the requirement of the end users and deploy the developed Linked, history and sub reports on to the server for the end users.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008,T-SQL

Confidential

SQL Developer

Responsibilities:

• Provided support to 75 database Servers. Support included Production, QA and Development
• Worked on Migration from SQL Server
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Wrote complex T-SQL Scripts for generating reports
• Wrote stored procedures and designed triggers
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output
• Ensured Security by defining access control to data
• Generated reports using SSRS
• Designed and developed DTS packages for data import and export
• Configured Linked Servers
• Worked on OLAP and OLTP
• Interacted with development and testing team
• Importing and exporting of Databases using various techniques like BCP, DTS
• Analyzed and Installed Security patches as required

Environment: SQL Server 2005, SSRS,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS, .net Framework, Visual Studio, Visual Source Safe.