SUMMARY

• More than 12+ years of IT Industry supporting SQL Server databases
• Supported applications, revising, updating, creating and improving stored procedures, problem solving and providing documentation as required, including root cause analysis.
• Special Projects, implementation of new software, patching servers, troubleshooting, light project planning.
• Diagnosed and corrected all application code issues for software written in Coldfusion
• Handled 3rd party products (Genesys products, IBM products) and worked with vendors(Genesys, IBM)
• Wrote Oracle SQL, MS SQL (TSQL) for ad hoc and monthly reports requested by upper management or users.
• Implemented and executes the disaster recovery scheme.
• Resolved user tickets for front - end issues.
• Worked in Compliance Documents maintenance and updating.
• Worked extensively in projects estimation process.
• Experience writing complex SQL Queries and Procedures.
• Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
• Created Stored Procedures, Triggers, and Functions, Indexes, Views, Joins and T-SQL code for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.

TECHNICAL SKILLS

SDLC Models: Agile Development (SCRUM), Water Fall, Iterative Model

Databases: MS SQL Server 2005/2008/2012/2014 , Toad, Oracle, MS-Access

Version Control: Subversion(SVN), Smart SVN

Language: TSQL, PL/SQL

Ticketing Tools: Webtrax, BMC Remedy

Reporting Tools: Report Viewer, SSRS, Power BI

Agile Management Tools: Rally Dev (CA Agile tool)

Operating System: Windows Server, Windows 2000 Professional, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Lead Service Engineer

Responsibilities:

• Gathered requirements from the business users and defined and elaborated the requirements by holding meetings with the users.
• Involved in defining the source to target data mappings, business rules, business and data definitions according to the software development life cycle.
• Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications
• Supported applications, revising, updating, creating and improving stored procedures, problem solving and providing documentation as required, including root cause analysis.
• Worked with internal and external clients for import and normalization of third-party data.
• Monitored and provided front-line support of daily processes.
• Regular connects with Business, Engineering & Support relating to Pending, Ongoing & Future releases that includes bug fixes & feature releases as part of Daily Triage, Scrum, Sprint & Iterations.
• Created Power BI Report-Models for ad-hoc reporting and analysis.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Created new reports based on requirements and document various Data Quality mapping document.

Confidential, Alpharetta GA

Application Support Analyst

Responsibilities:

• Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications
• Supported applications, revising, updating, creating and improving stored procedures, problem solving and providing documentation as required, including root cause analysis.
• Worked with internal and external clients for import and normalization of third-party data.
• Monitored and provided front-line support of daily processes.
• Made effective and much appreciated suggestions for changes in the system applications, and gave expert advice as to proper operation.
• Created and executed SQL statements in both SQL production and Test environments.
• Provided SQL Support to front end users and resolved user tickets
• Resolved issues within production database using T-SQL queries.
• Executed daily batch processes, and researched file share for a duplication project.
• Implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Optimize existing T-SQL code.
• Analyzed Execution Plans to troubleshoot potential performance issues.
• Supported SQL clustered environments that is Active-Active nodes & maintained which supported several applications
• Troubleshot database-related issues for clients during implementation, maintenance, upgrade, and migration processes.
• Providing on-call support for production systems with rotation basis.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.

Confidential, Alpharetta GA

Production Support Analyst

Responsibilities:

• Analyze application data to assess performance and uncover problems.
• Work in team environment to complete all testing activities according to schedule.
• Coordinate resolutions with development team and project managers.
• Complete root cause analysis of defects.
• Monitor data processing quality assurance and development activities.

Confidential, Richardson TX

Application Support Analyst

Responsibilities:

• Troubleshoot and resolve application issues escalated from end users.
• Processed large batches of data on daily and weekly basis.
• Conducted user regression and other tests on products and components.
• Opened and documented defect tickets.
• Participated in daily weekly and bi-monthly status meetings.

Confidential

Application Support and Development

Responsibilities:

• Created Tables, Views, Constraints, Index
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques