SUMMARY:

• Information Technology Analyst with over 16 years of experience implementing technology - driven solutions for major corporations.
• Persuasive communicator, dynamic leader and team player with the ability to work and connect with individuals at all levels of an organization.
• Possess excellent client service, analytical, and people management skills.
• Result oriented application development lead with 16 years of experience in software design, development, testing, enhancing, maintaining and production support in various lines of business.
• Diverse global experience in engaging with clients, customers, partners and working with globally distributed teams.
• Proficient in project planning, milestone management, scope management, resource forecasting, financial management, RAID management and change management thorough out the project cycle.
• Worked on multiple projects in both Agile and Waterfall methodology and ensure high quality delivery with schedule adherence.
• Extensive experience in Oracle (PL/SQL) programming, NoSQL Database design, Object Oriented Programming using Java/J2EE, UNIX Shell Scripting, Job automation and Production Support.
• Rich experience in Banking & Finance, Offers & Referrals, Payment and Trade Finance Domain.
• Strong leadership and people management skills with proven ability to effectively manage scrum team to meet critical timelines.
• Played a lead role in migration of application from Oracle DB to CQL - Cassandra DB and Sybase IQ to Oracle 12c DB platform.
• Effective collaboration with all the stakeholders, i.e. Development team, Business team, Product Owners, Quality Assurance / Performance / Security testing groups, Release management etc.
• Experience in Production Support activities viz. incident/problem management, change control procedures, Service Level Agreement (SLA) based L2/L3 support as part of a Global Delivery Model.
• Research-oriented, motivated, proactive, with strong technical, analytical and interpersonal skills.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, CQL, Java / JEE

Web/XML Technologies: HTML, CSS, JavaScript, Servlets, JSP, XML

Frameworks: Hibernate, Struts, Junit, Log4j, SOAP

DBMS: Oracle 9i, 10g, 11g, 12c, Cassandra / CQL 1.x, 2.x, SOLR, Sybase IQ

Tools: & Utilities: Toad, SQL Developer, SQLPLUS, SQL Loader, CQLSH, DevCenter, OpsCenter, RAD, Eclipse, WSAD, Autosys, SSH Tectia, Putty, WinScp, Citrix, DevOps, App Watch, Wily Introscope, Site Scope, Remedy, JIRA, Maximo, Peregrine, HP Quality Center, Splunk, SOAP UI, SharePoint, MS Office, Lotus Notes, MS Visio, Actuate Report, Business Object 3.1/4.2, Teamcity, uDeploy, Sonar.

Application/Web Servers: IBM WebSphere Application Server, Apache Tomcat

Source Control: Perforce, Clear Case, CVS, MS VSS, Tortoise SVN, Bitbucket

Operating Systems: Windows 2000/XP, UNIX, Linux, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager

Responsibilities:

• Worked on proposal to create solution design with estimation for the given client requirements.
• Participate in business and system requirements session, perform requirement elicitation and translate them into technical specification.
• Anchor proof of concept development to validate proposed solution and reduce technical risk.
• Provide inputs on solution architecture based on evaluation, understanding of solution alternatives. Framework and products.
• Working with DBA to come up with canonical model which help to fine tune the database logging.
• Worked with client to elicit functional and non-functional requirements like performance, scalability, reliability, availability and maintainability.
• Working with UX team to finalize the wireframes and prototype of the application screens.
• Perform high and low level design, implement prototype and conducts design reviews.
• Create reports and share the weekly progress with all the stakeholders.

Confidential

Project Manager / DB Specialist

Responsibilities:

• Lead the project for migration of existing Sybase IQ platform to Oracle 12c platform with enhanced business functionalities as per business needs.
• Manage the project end to end with includes project planning, team management and onboarding, project execution, risk and issues management and stakeholder management.
• Re-architecture of rollup layers as per the Oracle standard and to have minimum rollups to satisfy the needs. This in turn required SQL tuning with proper indexing, partitioning and Hints.
• Create a reusable framework using Talend to perform the migration of small to very large sized table which include static, historical, archived and current data from Sybase IQ to Oracle 12c DB.
• Migrate the Rollups, Static and Transactional Tables, Tools/Utilities (Web API) procedures, Upstream and Downstream API’s feeds procedures.
• Data Sync up from Sybase to Oracle DB tables and ensure the data integrity.
• Data reconciliation between Sybase IQ and Oracle for all the procedures migrated.
• Coordinate with various teams to have phase wise migration for Go Live and run both the Sybase and Oracle system in parallel for few weeks before final cutover.

Confidential

Project Manager / DB Specialist

Responsibilities:

• Manage the project end to end which includes project planning, milestone management, scope management, resource forecasting, on boarding, financial management, RAID management and change management across the project cycle.
• Coordinate and manage SDLC phases including requirements gathering, development, unit testing, provided support for system integration(SIT) and user acceptance testing (UAT) for business applications
• Perform business process improvement and re-engineering by identifying system reuse and simplification steps in workflow
• Participate in architecture review sessions to provide inputs and feedback from clients and doing analysis, high level design and prototype specifications
• Perform knowledge management by building a repository of information and leveraging knowledge acquired
• Establish and manage client relationship through issue resolution, status updates and deliver high customer satisfaction.
• Follow ITIL framework in processes and standards for service management
• Perform application management transition that includes participation in knowledge transfer sessions, prepare and review process control manuals, document dependencies, perform shadow support to complete transition
• Lead deployment of applications/infrastructure and post production support activities
• Lead the team for integration/system/performance testing to ensure defect free programs / modules
• Gather requirements from clients to enhance value add and plan to identify gaps/issues
• Trains team members on project processes and provides inputs on process tailoring and quality goals to finalize project quality plan.
• Manage project risks through comprehensive assessment, planning and mitigation
• Generate and report to stake holders, management, compliance and audit on Key performance indicators (KPIs) in relation to business applications and projects
• Manage centralized documentation of all business applications managed, operational workflow (SOPs) and knowledge base
• Participate in internal, external and regulatory audits and improve services to be compliant
• Present change requests before the advisory and governance board to provide business justification and seek approval for all changes

Confidential, Charlotte, NC

Technology Lead / Database Analyst

Responsibilities:

• Interact and liaise with customers, Business teams and provide technology solutions meeting their requirements
• Manage project risks through comprehensive assessment, planning and mitigation
• Participate in review sessions with offshore team to provide inputs and feedback from clients and doing analysis and high level design
• Coordinate and manage SDLC phases including requirements gathering, design, development, unit testing, system integration(SIT) and user acceptance testing (UAT) for business applications
• Establish and manage client relationship through issue resolution, status updates and deliver high customer satisfaction
• Present change requests before the advisory and governance board to provide business justification and seek approval for all changes
• Lead deployment of applications/infrastructure and post production support activities
• Lead the team for integration/system/performance testing to ensure defect free programs / modules
• Designed and implemented the migration of existing Oracle DB (RDBMS) based application to CQL (NoSQL) - Cassandra DB based application
• Generate periodic and adhoc SQL reports for business and management review and audit tracking
• Primary BAU point of contact and database SME for the entire suite of application.
• Creation and management of activities in the Go Live plan.
• Collaboration with business, technical teams and external vendors for application enhancements, maintenance along with upgrades and addition of new features to existing system.
• Automate transaction logging data extraction and transfer via NDM to data warehousing team, using UNIX shell scripts and scheduling the same through Autosys.
• Coordination with other support teams for setup of automated log and MQ queue monitors, management, OS/Server based resource monitoring.
• Was pivotal in identifying the gaps in the monitoring of the servers (space, CPU utilization, any other glitches) and onboarding them to Introscope and Site Scope monitors for better troubleshooting.
• Work on design, script creation and implementation of both Oracle (Meta data) and Cassandra (Logging data) for all projects.

Confidential

Technology Analyst

Responsibilities:

• Production Support for applications related to commercial banking hosted as part of the MaxTrad application (Payments, Information Reporting, Notification, Support, Admin, Reports).
• Creation and management of activities in the Go Live plan.
• Coordinating releases for application enhancements, maintenance and vendor software upgrades.
• Conduct Root cause analysis and impact analysis of logged issues, prioritize and ensuring the provision of production support as per the committed SLAs.
• Worked directly with business and customer facing helpdesk to provide resolutions to various issues.
• Business Requirements gathering and henceforth preparation of High and Low level design documents.
• Development of reports for the Information Reporting module of MaxTrad Suite of application, using Actuate Enterprise Reports.
• Coordination with line of business, technical teams and external vendors for application enhancements, maintenance along with upgrades and addition of new features to existing system.
• Automated batch scheduling jobs using UNIX shell scripts and scheduling the same through Autosys.
• Coordination with others teams for setup of automated log and MQ queue monitors.
• Identified environmental contentions and work with appropriate teams to address those issues in a timely manner.
• Coding, bug fixes, unit testing and integration testing for multiple modules in the application.
• Peer Code review for the rest of the team, helping them resolving Code and Environment related issues.
• Document SOPs (standard operating procedures) and resolutions for the commonly reported problems and their solutions
• Knowledge Management anchor in the team to create a centralize repository of technology, domain and processes artifacts.
• Handling incident, problem and request for change (RFC) tickets using Maximo.

Confidential

Software Engineer

Responsibilities:

• Production Support for Java/J2EE web application modules within the Retail banking portfolio.
• Incident management, change control/request for change (RFC), root cause analysis (RCA) using Peregrine.
• Automation of batch jobs using UNIX shell scripting and scheduling them through Autosys.
• Requirement analysis for small enhancements and end-to-end design for them.
• Coding, Bug fixes, unit testing and integration testing for multiple modules in the application.
• Partner with various infrastructure, development, and application teams to ensure environment availability, stability, and functional readiness.
• Documented all the frequently reported incidents as a handbook for easy handling of the incidents
• Creation of System Appreciation documentation for the application.
• Handling incident, problem and request for change (RFC) tickets using Maximo.