SUMMARY:

• Highly skilled and results driven software professional bringing more than Ten years of experience in Application Support, Process And Project Management.
• More than 5 years of banking domain experience in Mortgage (Origination and Default),Consumer Lending and Capital Markets area related to Mortgage/Treasury
• More than 2 Years of experience in Investment Banking which involves data processing and reporting
• More than 2 Years of experience in Pharma which involves supporting research oriented applications
• Experience in Requirements analysis, coordinating User Acceptance Testing, Functional Testing and System Testing
• Strong expertise in analyzing and documenting Business requirements and System Functional Specifications by visual modeling using Case diagrams, Sequence diagrams, Activity diagrams and process flow diagrams
• Experience in creating Source to Target Mapping Documents for the ETL Teams, based on the requirements
• Strong experience in back - end programming and understanding of database concepts
• Proficient in performing Data Analysis, Gap Analysis and Impact Analysis
• Experience in Agile and Waterfall software development methodologies
• In depth knowledge of various phases involved in Software Development Life Cycle(SDLC)
• Excellent in organizing, planning, presentation, consensus building & interpersonal skills
• Experience in project management activities like resource allocation, invoicing, scheduling and estimation, monthly metric reporting etc.
• Excellent Analytical, problem solving skills along with exceptional communication skills
• Supporting 400+ Critical servers involved in Capital Markets & Mortgage
• Experience in Microsoft vulnerability & Risk remediation process
• Project lead for hardware end of life remediation, AWS Migration etc.
• Strong expertise in SQL 2014 batch processing which handles more than 100 Jobs, SSIS package, Feeds, etc. which are Key financial
• Experience in SOX auditing in Key financial application
• Automation of Manual efforts to reduce dependency
• In depth knowledge on ITIL Process Management to measure service delivery
• Lead calls for troubleshooting, status updates etc. in case of Priority 1 or Priority 2
• Experience in modifying Stored Procedures, SSIS Package, and Configuration file etc.
• Management of the server back up for Key Financial Application on the schedule, type, frequency, etc.
• Access auditing on the SQL server to remediate elevated access

TECHNICAL SKILLS:

Databases: Oracle 9i/10g, SQL Server 2014/2008/2005, Sybase

Database Tools: TOAD, SQL server management Studio, Aqua data studio

Defect Tracking: ALM, HP Quality Center

Applications and Programming Languages: SQL, PL-SQL, C, C++, HTML

Operating Systems: UNIX, Windows (2003,2008,2012)

MSSuite: MS Word, MS Excel, MS outlook, MS Power-point, MS SharePoint, MS Access, MS Visio

Monitoring Tools: HPBSM, SCOM, Netcool

Other Tools: Autosys, eMason Clarifire, HP Peregrine, QRM(Quantitative Risk Management)

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Technology Analyst

Responsibilities:

• Troubleshooting web application which are based on .net and SQL server 2003,2008,2014
• Responsible for System functional and non-functional Requirements
• Extensively used SQL queries to retrieve data from SQL Server database to analyze Loan Origination data
• Participated in release management activities for monthly releases
• Supported Client acceptance testing, Performance testing and Regression testing
• Chaired Requirements walkthrough with Development and Testing team and made sure the system requirements are properly mapped to technology solutions
• Involved in Manual/Functional testing and monitoring of system.
• Worked on application enhancement which involves modifications to Stored Procedures, SSIS Package, Configuration file etc.
• Management of code using tools like Harvest tool
• Migrating application which are in the old hardware like windows 2003,2008
• Document management lead for managing TDD, SDD, Business work flow etc.
• The project involved dealing with business users at onsite to support them on business issues
• Worked directly with business users to understand their requirements and document them and present it to management for their consideration for further enhancements in the business system
• Analyzed the gaps in the business process and reported that to business management on client side on a regular basis
• Coordinated with the vendor on a regular basis for requirement analysis, daily status on changes being implemented, scope for further system enhancement etc.
• Lead calls for troubleshooting, status updates etc. with clients, and ensured a 24*7 support to production jobs
• The project involved dealing with business users at onsite to support them on Technical issues
• Handling more than 400+ servers (Analytical, web, Terminal, OLAP and SQL Servers)
• Weekly maintenance of the servers which includes reboot, space monitoring, utilization etc.
• Automation of monitoring using tools like SCOM, HPBSM etc.
• Administration of the application from QRM vendor software which includes server maintenance, access, Jobs etc.
• Installation of QRM Software which includes Central Admin, HPC, Office, etc.
• Daily health check of the application to confirm the performance
• Application log debugging to identify the issues with the batch process

Confidential

System Engineer

Responsibilities:

• Managed UNIX batch which runs on Sybase, Autosys
• Managed Processing 100’s of feeds from various system and generating reports to traders
• Reporting Ready for business daily before Market opening
• Event Management of processing using Netcool
• Management reporting of service delivery on regular basis
• Analysis of Store Procedure, JIL (Autosys), Data, etc.

Confidential

System Engineer

Responsibilities:

• Managed Application related to Pharma R&D with Confidential
• Weekly/Customized data reporting using SQL
• Application Enhancement based on the business requirement which involves modification of code, Stored Procedure etc.
• Exposure to tools like TOAD, VSS, HP peregrine etc.
• Monitoring of server/Application health using HPBSM, Netcool