SUMMARY

• 8.7 years of IT experience in Data Design and Development on Microsoft SQL Server 2014/2012/2008 , T - SQL, Sybase, Aqua Data Studio, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration and Data-warehousing.
• Strong experience in MS SQL Server 2012/2014 with Business Intelligence in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Good knowledge in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and functions
• Hands on experience in installing, configuring, managing, upgrading, monitoring, and troubleshooting SQL Server 2008/2012/2014 .
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experience in deploying created reports in various sources like Web browser, XML and PDF
• Experience in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins
• Expertise in creating and testing Stored Procedures, Triggers, Reports and Packages and writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results
• Developed a Test case automation using VBA to complete the testing effectively
• Experience working on Project deployment and Package deployments
• Experienced using in FTP and SFTP servers to upload files
• Experience in developing and monitoring SSIS Packages
• Migrated data from SQL 2012 to 2014 and solved all the related issues
• Migrated Windows 2003 32-bit platform to Windows 2012 64-bit enterprise edition and solved all the related issues
• Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Excellent T-SQL Programming skills. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Good knowledge in implementing Log Shipping, Database Mirroring
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Worked on ticketing systems like CQ, ISM and ServiceNow
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments

TECHNICAL SKILLS

Languages/Technologies: Visual Basic 6.0, VBA, VB Script, C, C++, HTML, CSS, Java Script, Visual Basic for Applications

Database: T-SQL, Sybase, SQL Server 2008 R2, SQL Server 2014, Aqua Data Studio, Oracle, MS Access, SQL Explorer, DB2 Visualizer

Operating System: Windows 2003, Windows 2012, Windows XP, Windows 7, UNIX

Test Case Management & Automation Tools: QTP/UFT (HP Unified Functional Testing), Rally, HP Application Lifecycle Management, Parasoft SOAtest

Other Tools: Oracle, SQL Server 2008, SQL Server 2014, Microsoft Visual Studio, SSMS, SSIS, CQ, ISM, ServiceNow, Rally, Selenium, Jenkins, Agile, JDA Category Knowledge Base 2017.2/2016/9.1/8.1 , Pivotal Tracker, Slack, Microsoft Teams, Postman, IBM Passport tool

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Enhanced Tool Rental, Repair & RLC

Responsibilities:

• Enhanced Tool Rental system is store software system widely used in Home Depot to rent and sale tools to Individual or company customers. By adopting new technologies existing services need to upgrade that are consumed by Tool Rental system in order to make application relevant to correctly do business process
• Some of the external systems upgrade need to perform in tool rental system to work like Customer search system, Documentum / ECM (Saving and retrieving customer contract/sales copies), addition to new cloud services into existing services replacement etc.,
• Involved in requirement gathering with business team and Design the system
• Involved in technical discussion and meeting with other external service team to design system
• Code development based on business requirements for the design systems and resolution on development issues
• Create/review the unit test cases and involved to follow all project processes
• Changes ETR components based on business requirements
• Involved in system test for develop functionalities along with UTS
• Involved in process audit and client meeting during user acceptance testing/defect discussions
• Deploy code in production and functional validate in pilot with Client
• Work on Production tickets raised by stores and fixed it with in SLA agreement. Share the fix and report to business for the known and unknown reported issue and fixes
• Work for business ad-hoc request and provide support as per the request raised by business
• Generate daily, weekly, and monthly reports and share with all business stack holders

Environment: SQL Server 2012/2014 Enterprise Edition, ServiceNow, Microsoft Teams, Windows 2012, SQL Explorer, DB2 Visualizer, Slack, Postman, IBM Passport tool

Confidential - Atlanta, GA

Space Planning

Responsibilities:

• The JDA planogram system helps in planogram life cycle for Confidential . To maximize the value, we gain from the JDA tools by leveraging more features and enhancing the system based on business needs
• Furthering the integration/automation efforts between Assortment Planning and Planograms including the necessary portal improvements
• Leveraging JDA lifecycle management to ensure planogram quality
• Improvements to inbound data to JDA such as product data available from the PAM work and store/SKU sales data
• A variety of security, data & batch job optimization work
• Analyze the requirements and prepare business blueprint of the system
• Identify and manage changes to project scope
• Prepare functional and technical design of the system using the business blueprint
• Analyze the requirements and work on design part. Identifying areas for improvements in the design/coding and implementing the same
• Building and constructing applications as per the functional and technical specifications. Tuning the performance of the developed code
• Performing quality related activities such as Code Walkthrough, IQA to provide defect free delivery
• Performing implementation and code migration activities
• Post-Implementation support
• Evaluate business requirements, perform Impact analysis, create detail design specifications and manage the Enhancement activities
• Understand and applies organization’s processes, procedures, design, coding and quality standards
• Experienced in installing, configuring, managing, upgrading, monitoring, and troubleshooting SQL Server 2014
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Performed job monitoring
• Created SSIS jobs/packages using SQL Server Data Tools (SSDT)
• Used Import/Export wizard to move data into multiple servers
• Scheduled SSIS packages to run on a scheduled basis using Windows scheduler
• Lead for 7 Offshore (India) and 1 Onshore associate. Helped all my teammates in completing their tasks at various stages and was managing/tracking all their works to complete the tasks/project on time
• I take full responsibility of them by completing tasks while adhering to company's policies and procedures. I always show respect to my coworkers and inform my team members about what is coming and what needs to be done related to projects/tasks. Also, I used to track all their work activities as well as work notes in ServiceNow.

Environment: SQL Server 2012/2014 Enterprise Edition, SSIS, Visual Studio 2008 & 2005, ServiceNow, Skype, Visual Basic for Applications, Windows 2012, JDA Category Knowledge Base 2017.2/2016/9.1/8.1 , SQL Explorer, DB2 Visualizer, Pivotal Tracker, Slack

Confidential - Columbus, OH

Production Support

Responsibilities:

• Provide consulting services to regional natural gas utility provider serving 500,000 customers in 7 states in USA
• Prepare the application enhancement strategy and prepare the existing applications maintenance strategy
• Prepare testing strategy and test plans, evaluate business requirements, and perform impact analysis.
• Create detailed design specifications, manage enhancement activities, and deliver artifacts per timelines
• Understand and apply company and industry processes, procedures, design, coding and quality standards
• Verify and validate the application front end and back end functionality for more than 15 applications
• Conduct feasibility studies for each of the solutions, alternatives and options developed
• Develop suitable solutions, alternatives and troubleshooting the application environment issue
• Experienced in installing, configuring, managing, upgrading, monitoring, and troubleshooting SQL Server 2008/2012/2014
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Performed job monitoring for multiple applications
• Validated the application back end (SQL Server and Oracle) functionality for more than 15 applications
• Created SSIS jobs/packages using SQL Server Data Tools (SSDT)
• Worked on SSIS Package and coordinated with ETL developer’s team to ensure data extracted, transformed and loaded according to the specified requirements
• Used Import/Export wizard to move data into multiple servers
• Scheduled SSIS packages to run on a scheduled basis using Windows scheduler.
• Provided support to HP Application Lifecycle Management (ALM) application. It is a web-based test management tool used to structure, organize and document all phases of the application testing process
• Provided support to Skype for business application by providing license access and adding user into the AD groups. It is an instant messaging tool and useful for video conferencing and conducting virtual meetings
• Developed multiple automation tools using VBA to complete application process on time

Environment: SQL Server 2008/2012/2014 Enterprise Edition, Oracle, MS Access, SSIS, MS PowerPoint, MS Access 2003, XML, Visual Studio 2008 & 2005,ISM Tool, HP ALM, ServiceNow, Skype, HTML, CSS, Java Script, Visual Basic for Applications, Windows 2003, Windows 2012, Windows XP, Windows 7, UNIX, JDA Category Knowledge Base 2017.2/2016/9.1/8.1 , DB2 Visualizer, Pivotal Tracker, Slack

Confidential - Monroe, LA

ISAT Application for Activation of In region orders

Responsibilities:

• Managed configuration of ISAT-L2VPN application to activate services in the Datalink layer necessary for customer requests to the routers and switches
• Developed and executed software test plans to identify software problems and their causes
• Developed testing programs that address areas such as SQL database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability
• Documented software defects, using a bug tracking system, and report defects to software developers
• Planned test schedules or strategies in accordance with project scope or delivery dates
• Attended the design review meetings and prepared diagrams depicting business process flow
• Developed code/software as per the approved design document and checking the standards
• Evaluated business requirements and appraised the project status to project manager on regular and need basis
• Determined impact of new functionalities introduced in the application from business flow perspective
• Verified and validated the application front end and back end functionality of the applications
• Validated the application back end (SQL Server and Oracle) functionality for all ISAT applications
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
• Provided application back end (SQL Server and Oracle) fix when issues raised and deployed the same in different environments
• Conducted feasibility study for each of the solutions, alternatives and options developed
• Developing suitable solutions, alternatives and troubleshooting the application environment issue
• Accomplished design test cases in BDD Gherkin format and upload to CA Agile Central
• Developed a Test case automation using VBA to complete the testing effectively
• Completed testing using Test Automation Tools QTP/UFT
• Completed application testing with multiple interfaces using Parasoft SOAtest

Environment: SQL Server 2005/2008 Enterprise Edition, Oracle, XML, Visual Studio 2008 & 2005, Rally, Parasoft SOAtest, Windows XP, Windows 7, UNIX, Agile, QTP/UFT (HP Unified Functional Testing), Rally, HP Application Lifecycle Management, Parasoft SOAtest

Confidential

AIWCS Windows Server 2012 and SQL Server 2014 Migration

Responsibilities:

• Coordinated migration of complex workers compensation policy underwriting system from Windows 2003 32-bit platform to Windows 2012 64-bit enterprise edition.
• Ensured that the SQLs that are stored as metadata, system objects (Stored procedures, Triggers, Views) and embedded SQLs are syntactically compatible with SQL 2014 and yield same results as they would in SQL 2008
• Ensured Web services, SQL agent jobs and Data stage jobs work as expected in SQL server 2014
• Migrated SQL server databases from 2008 to 2014 versions and upgraded from FTP to SFTP for file transfer.
• Ensured applications and services worked in SQL server 2014 and Windows server 2012 environments.
• Ensured batch reports/tools work in SQL server 2014 and Windows server 2012 environment post-migration.
• Performed release and build management functions as well as packaging and delivering functions
• Offered support to end users and administrators during the testing and implementation phase

Environment: SQL Server 2008, SQL Server 2014, Windows 2003, Windows 2012, VB 6.0, VBA, XML

Confidential

Production Support

Responsibilities:

• Oversaw production support for underwriting, claims and financial systems for Confidential Europe
• Responsible for requirements gathering, analysis, understanding the impact of the change on other related systems, code design, unit testing, and root cause analysis/fix
• Prepared defect analysis documents (DAD) to help testers in QA and UAT
• Performed enhancements and change requests (CR) to the applications functionality
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
• Prepared priority lists showing the order in which client expect work to be performed
• Developed Excel macro-based tool for automating daily tasks, to transform the brokers’ EDI to OMEGA system’s source format (XML), and to automate daily activities by financial operational support team
• Prepare the application Enhancement Strategy
• Prepare the existing applications Maintenance Strategy
• Evaluate business requirements, perform Impact analysis, and create detail design specifications, manage the Enhancement activities.
• Understands and applies organization's processes, procedures, design, coding and quality standards
• Verifying and validating the application Front end and back end functionality for more than 5 applications
• Studying existing system and reviewing the same
• Developing suitable solutions, alternatives and troubleshooting the application environment issue
• Written T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures
• Provided support to multiple inbound and outbound applications
• Developed test case automation using VBA to complete the testing successfully

Environment: T-SQL, SQL Server 2008 R2, SQL Server 2014, Sybase 15.5, Aqua Data Studio, Oracle, VB 6.0, HTML, CSS, Java Script, Visual Basic for Applications, Windows 2003, MS Access, Excel