SUMMARY

• 7+ years of experience in professional application and database development with thorough knowledge of different phases of software development life cycle including analysis, design, development, maintenance, documentation, deployment and system support.
• Experienced in designing of database in SQL Server 2012, 2008R2, 2008, 2005 and 2000, Toad for Oracle 12.5, Oracle 11.2, Rapid SQL 8.7, Teradata SQL 13.10 and BigData Hadoop.
• Hands on experience in writing Transact - SQL (DDL, DML and DQL) queries, PL/SQL, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views and Triggers.
• Expert in Performance Tuning and Optimization of SQL scripts and Stored Procedures.
• Advance knowledge in RDBMS concepts, logical/physical data models.
• Able to install, upgrade and configure of Microsoft SQL Server and Databases.
• Experienced using different ETL Tools SQL Server Integration Services (SSIS), IBM Info Sphere Data Stage, Informatica Power Center (IPC) and Tidal Scheduler.
• Experienced in Extraction, Transformation and Loading (ETL) in SQL Server database from different platform.
• Experienced in designing Data Model and Building reports using SQL Server Reporting Services (SSRS).
• Experienced on creating Requirement, Scope, Mart Mapping, project Overview documents and uploaded to the SP.
• Extensively used IBM Rational DOORS for maintaining and managing Scope and Requirement documents,
• Strong working experience in HP ALM for writing test cases, test plans and Test case executions. Also Created RTM for various releases as required.
• Experienced in working on Production Support 24x7 coverage
• Worked as a Team Lead of Onsite and Offshore resources.
• Extensively used GlobalScape server, IBM Sterling solution, FileZilla, Putty, FTP Schedulers, PGP etc.
• Created overall automated Workflow of the overall project including Inbound, FTP & Extracts.
• Provided Knowledge Transfer (KT) Sessions to the new onsite and offshore resources.
• Coordinated live meetings, D2D, Smart Cloud, WebEx, Cisco Jabber and Lync meetings with clients.
• Leaded the LAM (look ahead meeting), Daily status and Handshake meetings with the team.
• Strong analytical, problem solving and troubleshooting skills.
• Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving corporate goals.
• Good verbal and written communication skills. Positive attitude towards superiors & peers.
• Ability to work independently and in large team environment.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Database Technologies: SQL Server 2012/2008R 2/2008/2005/2000, Oracle 11g, Teradata sql 13.10,Big Data(Hadoop), MS Access, Toad for Oracle, Rapid SQL, IBM Rational DOORS 9.6

Languages: T-SQL, PL/SQL, BTEQ, Unix, XML, HTML

BI Tools: SSRS, Query Studio, SSIS, IBM Info Sphere Data Stage, Informatica Power Center, Tidal Scheduler, Control M, SQL Loader

Operating Systems: Windows NT/2000/XP/Vista/Window 7

Web Technologies: HTML, FTP, SFTP, HTTP. WinZip, Ultra Edit, Filezilla, PGP, Putty

Applications: Alloy Ticketing tool, Business Information Management (BIM) Operational Portal, Team Foundation Server (TFS), DAAS(Desktop as a Service), Tivoli Service Request Manager (TSRM), Service Now (SNOW), VSS, ClearCase, Clear Quest, HP ALM 11.52, MS Visio, Share Pointetc

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Technical Team Lead

Responsibilities:

• Created stored procedures, views,functions, triggers, tables and T-SQL script for application and to meet the requirements of the business.
• Installed and Configured of SQL Server 2012, Toad for Oracle 12.5, Rapid SQL 8.7 and Oracle 11.2.
• Created Data Dictionary (DD), mapping document, Requirement document, scope document and uploaded them to SP.
• Analyzed and created the Impact Analysis (IA) document and tracked to the SP for different upstream and downstream releases.
• Directly coordinated with the client and addressed the critical issues in the business. Understood the client’s requirement and updated to the system and team as needed.
• Created and Executed the Test Cases usingHP ALM and tracked defects using Clear Quest.
• Entered and maintained Scope document and Requirement documents to the IBM Rational DOORS application and linked them based on the requested export reports.
• Created RTM (Requirement Traceability Matrix) using ALM for different releases.
• Very good knowledge on data modeling. Actively worked with Data modelers for finalizing the logical and physical table and new attributes name as a part of the release.
• Used Informatica Power Center (IPC) to migrate the data in different platformsas required.
• Mentor new resources and guided them on the project requirements and access requests and other issues.
• Actively analyzed and addressed any fallouts on recon reports and production issues.
• Created the Project Execution Plan for different Releases.
• Created and Updated the Overview documents of the project and uploaded to the SP.
• Performed Data Integrity testing on an Oracle Database to validate and test data using TOAD and Rapid SQL.
• Prepared and executed unit tests on all new and modified code
• Prepared technical design specifications, flow charts and data flow diagrams as needed for new and existing applications.
• Worked with Development team for query optimization for better performance.
• Coordinated urgent issues meetings and provided inputs wherever needed.
• Coordinated with the different team to gather all the information for the ongoing releases and prepared for upcoming changes.

Environment: MS SQL Server 2012, Windows Server 2003, Windows 2000 / XP, Windows 7, Visual Studio, Snow, ClearCase, Clear Quest, MS Visio 2013, HP ALM 11.52, IBM Rational DOORS9.6, Toad for Oracle12.5, Rapid SQL 8.7, Oracle 11.2,Informatica power center (IPC),Share point etc.

Confidential, Richmond, VA

Technical Team Lead (SQL Server Developer - Lead FTP & Extracts)

Responsibilities:

• Created database, functions, triggers, stored procedures, views, tables and T-SQL script for application and to meet the requirements of the business.
• Installed and Configured of SQL Server 2008 andSQLServer 2008R2.
• Actively participated in creation of logical database model, physical database design and implementation of large database models.
• Setup FTP/SFTP connections with PGP encryption for internal and external clients.
• Extensively used FileZilla to test the connectivity with the internal/external client accounts.
• Successfully supported during Production Releases, planned and unplanned server outages and the failures.
• Worked on Release Management environment and coordinated with the different team for RM activities. Created Change tickets and implemented release tracker with full responsibility.
• Successfully worked on Global Scape Server, DMZ server and Changed the Server IP address and trouble-shoot the connection issue right after the changes with external clients.
• Successfully fixed the Connectivity Issues,FTP Failure and GlobalScape Server Errors.
• Fine monitored and maintained the FTP Shared Mailbox.
• Supported on Special Projects and sent the status report to the business on regular basis.
• Migrated data across different data sources and SQL server environments.
• Extensively used Visual studio for running SSIS packages for refreshing the SQL DB on monthly basis.
• Used Informatica Power Center (IPC) to migrate the data in different platforms as required.
• Developed and tested business and IT process automation jobs, agents and processes.
• Wrote, executed and updated stored procedures,wrote complex queries, correlated sub queries and joins.
• Worked on Production Support 24x7 coverage plan successfully.
• Extensively used TSRM, ServiceNow (SNOW) and Alloy ticketing tool.
• Coordinated and lead urgent live meetings with the different clients to solve critical issues, like data issues, connections issues etc.
• Provided Knowledge transfer sessions to the new resources on onsite and offshore as SME.
• Lead the LAM (Look Ahead Meeting), Daily status and Handshake meetings with the team.
• Innovated and implemented different ideas for improvements, Automated reports.
• Worked to automate the manual processes to improve the business manual workload.
• Monitored SQL and Tidal jobs successfully supported on their first prod migration run and handled on failures.
• Created Overall project automated WorkFlow (FTP, Inbound, Extract), Application support documents, Escalation metrics, coverage rosters and other process hands on documents and uploaded to the share point and VSS, Clear case.
• Well-coordinated with Business architect, DBAs, Network people, Help desk, Project Managers, Business analysts, QA team, Clients and other Competitive Contractors.

Environment: MS SQL Server 2008R2, Windows Server 2003, Windows 2000 / XP, Windows 7, Visual Studio 2008, MS Excel, MS Office, Microsoft Visual Source Safe (VSS), FTP/SFTP Server, PGP, FileZilla, Metadata Framework, BIM Ops Portal, Alloy Ticketing tool, TSRM, Snow, Clear Quest, Tidal Schedulers, IPC, Teradata,ClearCase, Share point etc.

Confidential, Herndon, VA

SQL Server Developer

Responsibilities:

• Created database, functions, triggers, stored procedures, views, tables and TSQL script for application and to meet the requirements of the business.
• Installation and Configuration ofSQLServer 2008.
• Fine tuning of the database queries. Creating appropriate indexes for better performance plans.
• Created complex Stored Procedures and performed code reviews.
• UsedData stage jobs broadly to migrate and transform data from legacy database system.
• Actively participated in creation of logical database model, physical database design and implementation of large database models.
• Supported on production migration activities to push the tested files to the production server.
• Migrated data across different data sources and SQL server environments.
• Tested data / stored procedures with complex queries, correlated sub queries and joins.
• Performed Unittesting and code reviews frequently.
• Used Scrubbing rules to manipulate data as per the business requirement.
• Developed and tested business and IT process automation jobs, agents and processes.
• Assisted QA team to create Test Plans, Test Cases and execute the test cases for End to End testing.
• Extensively used EDI, Fixed width and flat files data and migrated them to sql server tables.
• Used test Manager to export the test cases and track bug fixed activities log after fixing the defects raised by QA team.
• Actively participated in Sprint planning, defect triage, code review, test case/execution review and daily standup meetings.

Environment: MS SQL Server 2008, Windows Server 2003, IBM Info Sphere Data Stage, Windows 2000 / XP, Visual Studio 2008, MS Excel, MS Office, Team Foundation Server (TFS), Test Manager, Agile Etc.

Confidential

MIS Officer

Responsibilities:

• Installation and configuration of SQL server 2005 in development, Production, Testing environments
• Managed the Management Information System (MIS) and all 45 districts data appropriately.
• Created databases, tables, views, triggers, stored procedures, functions.
• Experienced with Large and Complex queries.
• Migrated data from SQL Server 2000 to SQL Server 2005.
• Created Database Maintenance Plans and Scheduled SQL Jobs.
• Scheduled the full backup, differential, transaction log backup of database
• Planned and modified the permission issues in the server.
• Maintaining SQL Script for creation of Database Objects.
• Derived data from different sources to SQL server environment using import/export wizard and DTS packages.
• Fine tuning of the database queries. Creating appropriate indexes for better performance plans.

Environment: SQL Server 2000/2005, Excel, Advanced Windows 2000 Server, MS Access