SUMMARY:

• 11 Years of experience in Information Technology, out of which 10 years as an SQL Developer (7.0, 2000,2005,2008 and 2012 ) in Production, Development and Test Environments under Windows platforms.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008.
• Having very good knowledge and experience on SQL Server 2008, R2 and 2012 also.
• Experience in D Confidential Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Experience in d Confidential Extraction, Transformation and Loading (ETL) processes. Worked extensively on d Confidential extraction, cleansing and d Confidential integration, and loading from different d Confidential sources using SSIS.
• Very good experience in designing and developing of SSIS packages.
• Expertise in Creation and Maintained of Procedures, Triggers and Functions.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Very good Experience in D Confidential Modeling including Dimensional D Confidential Modeling, Star Join Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical D Confidential Modeling, ERWIN
• Used XML with in Stored Procedures and in complex queries.
• Having experience on D Confidential base administration like taking the backups and creating the users and giving the permissions for the d Confidential base, tables, functions etc.
• Designed DTS/SSIS Packages to Extract, Transform and Load d Confidential into D Confidential base, Archive d Confidential file from different legacy systems using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the d Confidential, scheduled the jobs to do these tasks periodically.
• Very good experience in Custom List, Document Libraries using SharePoint.
• Excellent experience in SQL Server Programming, D Confidential Transformation Services (DTS), Integration services (SSIS), Analysis Services, Notification Services and Reporting services in SQL 2000/2005/2008/2008 R2.
• Strong experience in D Confidential Analysis Skills and D Confidential Intigrity.
• Profound knowledge of utilizing tools in d Confidential analysis and SQL Server Enterprise Manager
• Strong knowledge of D Confidential base Development and Release Management Concepts, Practices and Procedures along with Performance Tuning D Confidential base Code in OLTP and OLAP environments.
• Experienced in D Confidential Loading using T - SQL, Fine Tuning of D Confidential base and improving Performance, Creating new D Confidential base, Creating and Modifying Table space and Optimization
• Proficient knowledge of Creating Feeds from OLTP to OLAP systems.
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of D Confidential .
• Expertise in SQL Query Performance Analysis skills and Ability to Redesign for Optimal Efficiency.
• Knowledge with HTML, XML, VB Script, C#, ASP.Net, IIS, Website Design, FTP, Telnet, Uploading, Software Development Life Cycle.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts. Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and /Supporting end users.

TECHNICAL SKILLS:

MS Access, MS: SQL Server 7.0, Oracle, 2000, SQL Server 2005, 2008, 2008 R2 and 2012.

O/S: Linux, Windows 2000, 2003, XP and Window NT

SQL, PL/SQL, T: SQL, ASP, HTML, JAVA, VB, VB Script and .Net, C#.

Tools: DTS, IIS, MS OFFICE 2000/2003, OLAP, OLTP, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Jobs and task creating and scheduling.

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

SQL/BI ETL Developer

Responsibilities:

• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS
• Validated the d Confidential which is coming from different ERP systems to the staging tables and from staging to d Confidential warehouse tables.
• Designed and developed few ETL packages for the d Confidential transformation from the ERP systems to all the way to the D Confidential warehouse systems.
• Resolved the bugs in the existing ETL packages.
• Created ad-hoc reports based on the business requirements.
• Written stored procedures for the ETL packages for the d Confidential validation and also for the d Confidential transformation.
• Taken care in daily batch loads (Full & Incremental) into Staging and D Confidential warehouse systems, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio

Confidential, Austin TX

SQL/BI Developer

Responsibilities:

• Designed SSIS Packages to transfer d Confidential from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in D Confidential Analysis, Requirements gathering, Development and Testing
• Extensively used SSIS transformations such as Lookup, Derived column, D Confidential conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and D Confidential base Engine Tuning Advisor to optimize queries and enhance the performance of d Confidential bases.
• Created schema objects including tables, indexes and applied constraints, connected various applications to the d Confidential base and written functions, stored procedures.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries which take longer time in execution with SQL Server 2008/2005.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the d Confidential .
• Created Complex ETL Packages using SSIS to extract d Confidential from staging tables to partitioned tables with incremental load.
• Created check constraints to maintain d Confidential integrity
• Created SSIS Reusable Packages to extract d Confidential from Multi formatted Flat files, Excel, XML files into D Confidential base

Environment: Windows 7, MS SQL Server 2008 R2, T-SQL, SSIS, Flat Files, .NET, C#, Visual

Confidential, Grapevine, TX

SQL/BI Developer

Responsibilities:

• Created new tables, views, indexes and user defined functions.
• Created new Store Procedures and modified few existing Stored Procedures based on the business requirements.
• Modified existing SSIS packages by fixing the identified bugs and created new packages.
• Involved in performance tuning which includes maintenance optimizing SQL statements/queries and Stored Procedures.
• Build and maintain SQL scripts, indexes, and complex queries for d Confidential analysis and extraction
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008 and 2012.
• Modified and fixed the issues in C# for CLR SQL Server Stored Procedures.
• Created D Confidential base Maintenance Planner for the Performance of SQL Server, which covers D Confidential base Integrity checks, D Confidential base Statistics update and Re-indexing.
• Extensively used SSIS transformations such as Lookup, Derived column, D Confidential conversion, Aggregate, Merge join, SQL task, Script task and Send Mail task etc.
• Developed ad-hoc reports using SSRS.

Environment: Windows XP, MS SQL Server 2008 R2 and 2012, T-SQL, SSIS, Flat Files, .NET, C#, Visual

Confidential, Addison, TX

SQL Developer/BI Developer

Responsibilities:

• Developed web based application for Next Generation of Single Family Default Monitoring system (SFDMS) for reporting delinquent and default loans to HUD.
• Designed, Developed and Unit tested SSIS interface to extract d Confidential from universal d Confidential source (ODS) and Load Next Gen server with various transformations. This d Confidential in turn is used to create various attributes for reporting to HUD.
• Coding of complex Stored Procedures (SP’s), Views and User Defined function (UDF’s) based on business requirements for reporting applications.
• Created CLR Stored Procedures and Functions using C# programming.
• Supported for the .Net applications in production environment.
• Developed an Internal Rule engine to simulate the exceptions that are triggered at external agencies.
• Used inner joins, CTE, Left Outer Joins, Cross Tabs and also cross joins in the stored

  Procedures.

• Co-ordinated with offshore development activity, Reviewing the code and make sure it
• Confirms to standard programming and also the bug fixing, adding up new features.
• Involved in developing interface for sourcing of D Confidential sources from various transactional d Confidential for building of Operational D Confidential Store (ODS).
• Involved in troubleshooting and performance tuning of ETL Applications.
• Involved in migration of DTS 2000 to SQL Server Integration services (SSIS) 2008 packages.
• Analysis, Design, Develop, Unit Testing, Implementing. Deploy and Documenting of
• Extraction Transformation Loading (ETL) and Reporting applications using SQL Server
• Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server 2005\2008.
• Supported and modified the code for the existing internal reporting (IR2) application based on the requirements from the BRD.
• Documented application user guide for end users.

Environment: Windows 2005, Windows XP, MS SQL Server 2008 R2, T-SQL, SSRS, SSIS, Flat

Confidential, Virginia Beach, VA

SQL Developer/ETL Developer

Responsibilities:

• Written Stored Procedures, complex queries, Views and Functions in SQL Server 2005 and 2008 environment.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of TSQL Statements.
• Generated tabular and matrix reports in MS SQL Reporting Services.
• Generated the drilldown, drillthrough, Parameterized and linked reports using the SSRS.
• Done so many ad-hoc reports for one time purpose according to the customer requirement.
• Developed some SSRS Reports in the Production Environment also.
• Modified existing stored procedures and some functions.
• Prepared technical specifications for the development of SSIS (ETL) packages to load d Confidential into various target tables and defining ETL standards.
• Implemented SSIS with SQL Server stored procedures for d Confidential manipulations.
• Created logical and physical d Confidential models using Erwin.
• Created Entity Relationship (ER) diagrams based on requirements.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide d Confidential for enterprise d Confidential warehouse.
• Created mappings to load d Confidential extracted from flat files, XML files to staging area using SQL Server SSIS.
• Created sub reports in some reports like to get the summary from the detail report d Confidential .
• Created mappings using row transformations, row set transformations, business intelligence transformations, split and join transformations and some other transformations like export column, import column, audit and SCD transformations etc.
• Involved in component and integration testing of stored procedures. Wrote test conditions and test scripts for all the stored procedures that I have created.
• Scheduled the SSIS package services to run at different intervals to fetch the d Confidential and for transferring the d Confidential into other d Confidential base.
• Done the performance tuning which includes maintenance optimizing SQL statements and Stored Procedures and monitoring the server.
• Done the code reviews, maintained the version control and done the documentation for all the work I have done.
• Monitoring the event logs and Server error logs for troubleshooting purposes.

Environment: Windows 2003, Windows XP, MS SQL Server 2005/2008, T-SQL, SSRS, SSIS, ERWIN, Flat

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Used XML with in Stored Procedures in different complexes queries in SQL Server 2005 environment.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• SQL Development & Troubleshooting included indexes, stored procedures, triggers and table structures for application behavior manipulation.
• ETL implementation using SQL Server 2005 Integration Services (SSIS)
• Analyzing the source d Confidential coming from different sources and working with business users and developers to develop the Model.
• Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Created SSIS Packages to move d Confidential from flat files into SQL server d Confidential base using SSIS for Each loop task to move all files into SQL Server D Confidential base
• Generated different reports using MS SQL Reporting Services.
• Worked with xp cmdshell which is used to move Flat Files and to receive the files also.
• Involved in performance tuning of the d Confidential base which includes index maintenance optimizing SQL statements and monitoring the server.
• Development support, production support, and design review in a complex environment.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Used SSRS to create customized reports and adhoc reports.
• Designed and developed the required PL/SQL stored procedures, triggers and d Confidential base functions.
• Created scheduled jobs for daily process to migrate d Confidential from other servers.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary reports, Cross Tab reports using MS SQL Reporting Services 2005 & 2008
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan
• Taken d Confidential base backups and given permissions for the tables, functions, Views and restoring the d Confidential base and moved the d Confidential base from one server to another server.

Environment: Windows 2003, Windows XP, MS SQL Server 2005 & 2008, T-SQL, SSRS, SSIS, Oracle ERWIN, Flat Files, .NET

Confidential, Somerset, NJ

SQL Developer

Responsibilities:

• Involved in the Migration of D Confidential bases from SQL Server 2000 to SQL Server 2005.
• Wrote Stored procedures and triggers extensively and working very closely with developers, Business Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems. Supported VB, ASP, COM, MTS Application environments.
• Wrote Inner joins, Outer joins, Cross Joins and other Complex joins and used XML in the queries.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Sever 2005 d Confidential base.
• Transferred real user d Confidential from production SQL Server to testing d Confidential base and development d Confidential base with SSIS packages and bulk insert which were configured as agent job scheduled at particular times
• Involved in D Confidential Integration by identifying the information needs within and across functional areas of an enterprise d Confidential base upgrade and scripting/d Confidential Migration with SQL server Export Utility
• Involved in Performance tuning, optimization of stored procedures and queries.
• Developed number of complex SSIS Mappings for different types of tests in Customer information, Monthly and Yearly Loading of D Confidential .
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
• Developed over 100 reports using SSRS and Extensive d Confidential cleansing.
• Created automated TSQL scripts to process summary d Confidential base transactions that run off-hours.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Providing support to developers in Performance Tuning and Query Designing.

Environment: Windows 2003/2000, MS SQL Server 2005/2000, T-SQL, DTS, SSIS, SSRS, JAVA

Confidential, Bridgewater, NJ

SQL Developer

Responsibilities:

• Successfully Upgraded from SQL Server 2000 to SQL Server 2005 on development and Testing Environment.
• Coded Stored Procedures, D Confidential base Triggers and Packages.
• Worked with developers on creating, debugging and deploying Stored Procedures, Custom DTS Jobs, tables, indexes, triggers etc.
• Scheduled stored procedures and wrote a batch processes.
• Creation of user interface and specialized tools for configuration management, system integration. Converted legacy Mainframe d Confidential into SQL Server, Scheduled and monitored the Application jobs.
• Interacted with Program Managers and Test Engineers to contribute and Review functional Specifications and Test Cases.
• Evaluated d Confidential storage considerations to store d Confidential bases and transaction logs. Created d Confidential bases using SQL Server Enterprise Manager, D Confidential base Wizard and Transact SQL Statements
• Wrote DTS Packages to transform daily and monthly jobs.
• Used Notification Services Available in SQL Server 2005 to create alerts and email notification.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2005 backend.

Environment: Windows 2000/20003, MS SQL Server 2000/2005, T-SQL, DTS, JAVA,.NET

Confidential, Cincinnati, OH

SQL Developer

Responsibilities:

• Created d Confidential base scripts, stored procedures, triggers, tables, views, indexes using T-SQL in SQL Server 2000.
• Created and maintained D Confidential Transformation Service (DTS) packages for migrating d Confidential .
• Worked on storing DTS packages, implementing package passwords, and tracking package metad Confidential and d Confidential lineage.
• Involved in design and generation of various reports using Crystal Reports.
• Used all Declarative Constraints for maintaining D Confidential Integrity.
• Implemented OLAP cubes with MS Analysis Services.
• Actively involved in hardware and network specification, installation and configuration, and participated in d Confidential base design, architecture and SQL scripting.
• Involved in scheduling backups of d Confidential bases and logs and restoring them when necessary.
• Created the SQL-MDX query syntax and client logic to allow customization of user reports
• Involved in managing the replication environment.

Environment: MS SQL Server 2000, Windows 2000 server, Windows NT 4.0, DTS, SQL Server Analysis

Confidential

Programmer/Analyst

Responsibilities:

• Involved in the Design, Coding, Testing and Implementation of the application.
• Developed the Application using ASP Technologies.
• Created and Developed the COM components.
• Designed and Generated Reports based upon the request provided by the admin.
• Created tables, views and indexes.
• Created Stored Procedures and triggers to perform automated rules, up dating to related tables.
• Installation and configuration of MS SQL Server and Clients.
• Designed DTS packages to refresh d Confidential on Development and QA/Staging.
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor.
• Wrote dynamic stored proc to create D Confidential base Roles and grant permission to roles and adding logins to specified roles.

Environment: ASP, MS-SQL Server 7.0/2000, Dhtml, VBScript, Windows 2000, IIS