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 wif 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 noledge and experience on SQL Server 2008, R2 and 2012 also.
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data 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 wif good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Very good Experience in Data Modeling including Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, ERWIN
• Used XML wif in Stored Procedures and in complex queries.
• Having experience on Database administration like taking teh backups and creating teh users and giving teh permissions for teh database, tables, functions etc.
• Designed DTS/SSIS Packages to Extract, Transform and Load data into Database, Archive data file from different legacy systems using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy teh data, scheduled teh jobs to do these tasks periodically.
• Very good experience in Custom List, Document Libraries using SharePoint.
• Excellent experience in SQL Server Programming, Data Transformation Services (DTS), Integration services (SSIS), Analysis Services, Notification Services and Reporting services in SQL 2000/2005/2008/2008 R2.
• Strong experience in Data Analysis Skills and Data Intigrity.
• Profound noledge of utilizing tools in data analysis and SQL Server Enterprise Manager
• Strong noledge of Database Development and Release Management Concepts, Practices and Procedures along wif Performance Tuning Database Code in OLTP and OLAP environments.
• Experienced in Data Loading using T - SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization
• Proficient noledge of Creating Feeds from OLTP to OLAP systems.
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
• Expertise in SQL Query Performance Analysis skills and Ability to Redesign for Optimal Efficiency.
• Knowledge wif 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 Training/Supporting end users.

TECHNICAL SKILLS

Database: 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

Languages: 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 teh data which is coming from different ERP systems to teh staging tables and from staging to data warehouse tables.
• Designed and developed few ETL packages for teh data transformation from teh ERP systems to all teh way to teh Data warehouse systems.
• Resolved teh bugs in teh existing ETL packages.
• Created ad-hoc reports based on teh business requirements.
• Written stored procedures for teh ETL packages for teh data validation and also for teh data transformation.
• Taken care in daily batch loads (Full & Incremental) into Staging and Data 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 (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source safe.

Confidential, Austin TX

SQL/BI Developer

Responsibilities:

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

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

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 teh business requirements.
• Modified existing SSIS packages by fixing teh 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 data analysis and extraction
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution wif SQL Server 2008 and 2012.
• Modified and fixed teh issues in C# for CLR SQL Server Stored Procedures.
• Created Database Maintenance Planner for teh Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Extensively used SSIS transformations such as Lookup, Derived column, Data 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 Studio 2010, SharePoint, SSRS, TFS

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 data from universal data source (ODS) and Load Next Gen server wif various transformations. This data 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 teh .Net applications in production environment.
• Developed an Internal Rule engine to simulate teh exceptions that are triggered at external agencies.
• Used inner joins, CTE, Left Outer Joins, Cross Tabs and also cross joins in teh stored Procedures.
• Co-ordinated wif offshore development activity, Reviewing teh code and make sure it
• Confirms to standard programming and also teh bug fixing, adding up new features.
• Involved in developing interface for sourcing of Data sources from various transactional data for building of Operational Data 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 teh code for teh existing internal reporting (IR2) application based on teh requirements from teh BRD.
• Documented application user guide for end users.

Environment: Windows 2005, Windows XP, MS SQL Server 2008 R2, T-SQL, SSRS, SSIS, Flat Files, .NET, SharePoint, Visual Studio 2010, TFS 2010

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 teh 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 teh drilldown, drillthrough, Parameterized and linked reports using teh SSRS.
• Done so many ad-hoc reports for one time purpose according to teh customer requirement.
• Developed some SSRS Reports in teh Production Environment also.
• Modified existing stored procedures and some functions.
• Prepared technical specifications for teh development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Implemented SSIS wif SQL Server stored procedures for data manipulations.
• Created logical and physical data 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 data for enterprise data warehouse.
• Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
• Created sub reports in some reports like to get teh summary from teh detail report data.
• 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 teh stored procedures that I have created.
• Scheduled teh SSIS package services to run at different intervals to fetch teh data and for transferring teh data into other database.
• Done teh performance tuning which includes maintenance optimizing SQL statements and Stored Procedures and monitoring teh server.
• Done teh code reviews, maintained teh version control and done teh documentation for all teh work I have done.
• Monitoring teh 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 Files, Oracle, .NET

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Used XML wif 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 teh source data coming from different sources and working wif business users and developers to develop teh 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 data from flat files into SQL server database using SSIS for Each loop task to move all files into SQL Server Database
• Generated different reports using MS SQL Reporting Services.
• Worked wif xp cmdshell which is used to move Flat Files and to receive teh files also.
• Involved in performance tuning of teh database which includes index maintenance optimizing SQL statements and monitoring teh server.
• Development support, production support, and design review in a complex environment.
• Analyzed teh 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 teh required PL/SQL stored procedures, triggers and database functions.
• Created scheduled jobs for daily process to migrate data from other servers.
• Generated teh 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 database backups and given permissions for teh tables, functions, Views and restoring teh database and moved teh database 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 teh Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Wrote Stored procedures and triggers extensively and working very closely wif 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 teh queries.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Sever 2005 database.
• Transferred real user data from production SQL Server to testing database and development database wif SSIS packages and bulk insert which were configured as agent job scheduled at particular times
• Involved in Data Integration by identifying teh information needs wifin and across functional areas of an enterprise database upgrade and scripting/data Migration wif 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 Data.
• Build efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 changes
• Developed over 100 reports using SSRS and Extensive data cleansing.
• Created automated TSQL scripts to process summary database 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, Database Triggers and Packages.
• Worked wif 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 data into SQL Server, Scheduled and monitored teh Application jobs.
• Interacted wif Program Managers and Test Engineers to contribute and Review functional Specifications and Test Cases.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Enterprise Manager, Database 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 teh 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 database scripts, stored procedures, triggers, tables, views, indexes using T-SQL in SQL Server 2000.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Worked on storing DTS packages, implementing package passwords, and tracking package metadata and data lineage.
• Involved in design and generation of various reports using Crystal Reports.
• Used all Declarative Constraints for maintaining Data Integrity.
• Implemented OLAP cubes wif MS Analysis Services.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Created teh SQL-MDX query syntax and client logic to allow customization of user reports
• Involved in managing teh replication environment.

Environment: MS SQL Server 2000, Windows 2000 server, Windows NT 4.0, DTS, SQL Server Analysis Services (OLAP), JAVA

Confidential

Programmer/Analyst

Responsibilities:

• Involved in teh Design, Coding, Testing and Implementation of teh application.
• Developed teh Application using ASP Technologies.
• Created and Developed teh COM components.
• Designed and Generated Reports based upon teh request provided by teh 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 data 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 Database 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