RAM PRASANNA

Email: actg7g@r.postjobfree.com *** Iris Ave, Apt 125

Phone: 201-***-**** Sunnyvale, CA-94086

Career

IT Professional Experienced in Managing and Leading Support for Critical Production Applications in Wealth Management, Equity, Utility and Mortgage Domains. Proven ability to effectively plan, execute and adapt to rapidly shifting priorities and deadlines. Interested in working for a firm to manage and lead critical production support.

Education:

Master of Science in Computer Science, New Jersey Inst. Of Tech, NJ

Master of Computer Applications, UP Technical University, India

Bachelor of Science (Hons.) Mathematics, Delhi University, India

Diploma in National Institute of Information Technology, Delhi, India

Profile Summary:

Experienced in building and managing Global Production Support teams from scratch

Experienced in Contract Negotiations and setting up Service Level Standards with vendors

In hand experience in handling Critical Financial Data for Wealth Management, Equity and Mortgage clients and delivering them on real time targets

Actively involved in managing/ optimizing support’s financial budget and hiring staff

Skilled to setup and maintain production standards and implement quality-controls

Experienced functioning as a liaison between technical teams and business clients

Involved in active troubleshooting and enhancing Distributed/ Mainframe Batches

Strong Transact SQL and Database Query Tuning skills

Worked in all phases of software development lifecycle

Years of experience in using Sybase, Perl and Unix Shell scripting

Exposed to Object Oriented application development

Exposed to Infrastructure Migrations and setting up Server Grids

Experienced in setup and handling Windows server, VMware and Load Balancers

Trained and skilled to deliver presentations to large audience

Excellent communication and documentation skills

Technical Exposure:

Languages: TSQL, KSH, Perl, TCL, XML, PL/SQL, Html, JavaScript, C, C++, Java

Operating Systems: HP UNIX, Linux, Sun Solaris 2.x, MAC OSX, Windows NT/2003

Databases: Sybase 11.x, 12.x, Oracle10g, SQL Server, DB2, MS Access 2000

Technology & Tools: DBArtisan, Toad, Clear Quest, Clear Case, OOP, VB, DBI/DBD,

CronTab, Citrix, Autosys, Remedy/Picasso, Falcon, Microsoft Reporting Services, Oracle Warehouse Builder, Visio, Visual Source Safe, Aquadata, CTT, CFF, Rapid SQL, Web Workspace, Hummingbird Exceed, Exceed on Demand, FTP, Data Synapse, Ganglia, DataStage, Hyper-V, VMware, Scenario tester, Win Merge, Real VNC, MS Project, Visual Source Safe, VCS, Putty, Sockeye, Netcool, Sitescope, Splunk, Optier, ExtraHop

Web Servers: IIS, Apache Web Server

Protocols: TCP/IP, FIX, SWIFT

Professional Experience:

Vice President, Morgan Stanley, NYC (Jan’2013 - Current)

Field and Management Technology, Research and 3D Resources Space

Applications in FMT Space are designed to help Financial Advisors and Business Managers with business intelligence and decision support capabilities at every level to evaluate their business performance, monitor progress, view compensation, track revenue, recognize best efforts and readily identify areas that need attention. Applications in Research and 3D Resources space are more content related which provides improved access to existing research and strategy content, provide exclusive perspectives from industry experts and allow Financial Advisors to collaborate and share insights based on their areas of focus.

Systems have SQL Server and DB2 as databases and the applications have .Net and Java based interfaces.

Role - Global Support Manager for Field & Mgt Technology, Research and 3DResources space

Responsible for setting up the entire Support Team Onsite NY and Offshore from scratch

Active engagement in Contract Negotiations and Service Level calibrations with vendors

On-boarded and trained single handedly the support team of 20+ people across regions

Responsible for overseeing the Production Processes and drawing up production schedules

Maintained/ measured SLA/KPI’s every month and ensured efficiencies are met/ exceeded

Worked with Sr. Directors to implement the company's policies and goals for the space

Acted as a Point of Escalation for every Outage/ Major issue in the space

Responsible for Planning, Coordination and Control of every Change deployed in the space

Responsible for Setup and Maintenance of Production standards and implementation of quality-controls through efficient Problem Management

Led multiple teams for setting up Application/ Infrastructure monitors

Manage and Track batch jobs executions and failures and taking remedial actions as needed

Responsible for association of end to end ticket routing from user to Level 2/3 support teams

Host/ Chair Support Global Team meetings and actively involved in horizontal (infrastructure/ application) event meetings

Responsible for every employee's performance review and identifying their training needs

Environment

SQL Server, DB2, .Net, Java, KSH, Linux, Alfresco

Consultant/ Associate Morgan Stanley, NYC (Sep’2010 – Dec 31’2012)

Center of Investment Excellence, Research and Strategy Insights, External Insights, Disclosures

These applications are used by Financial Advisors to have improved access to existing research and strategy content, provide exclusive perspectives from industry experts and allow Financial Advisors to collaborate and share insights based on their areas of focus. It is a place to find the tools, resources and solutions residing at Morgan Stanley Smith Barney to help address client’s needs, grow practice and drive investment excellence.

Systems have Sybase as database and the applications have Java, Alfresco and HTML based interfaces.

Role - Operational Manager for MSSB Research Applications

Responsible for on-boarding all MSSB Research applications to PWM Support Team

Acted as a single point of contact for any Level 2 support related issues for Research

Acted as a Triage point for all Research Applications

Performed Disaster Recovery Procedures and coordinated RFB checks

Supported application runs, addressing problems identified by users and troubleshooting issues in production

Responsible for setting up both Application and Infrastructure Monitors for research applications as per Support Standards

Track batch jobs and taking remedial actions when they fail

Executing Turnovers for both Research and existing PWM Team

Responsible for documenting fix logs and creating twiki for all support related issues for Research

Created Incident queue structure, added applications to Incident Portal interface for Research

Conduct team meetings for status updates and application handover for Research applications

Responsible for Infrastructure Inventory Capture for Research

Environment

Sybase, Informatica, KSH, UNIX, Java, Alfresco

Production Support Associate, Credit Suisse, NYC (April’2010 – Sep’2010)

Gobus, GCE, End of Day Application

The applications are created to support the Trading Floor at Credit Suisse. The team is a part of Client connectivity Equity 1st and 2nd level support. Till now my major involvement has been with the End of day reports and Gobus application. After every day Close of Business, our EOD application generates client OMAN specific reports and consolidated reports depending on the client’s need. In the Gobus application, the FIX Gateway takes order information from the fix engine and via a message switch it routes orders to different Agoras via Agora Gateways. GCE interacts with the Agora Gateway and we have a SMD database and Gobus configuration database to interact with the Fix gateway.

Systems have Oracle and Sybase as databases and the applications have KSH, PERL and Java based interfaces.

Role - Team Lead for Client Connectivity Production Support Team

Acted as a liaison between the technical team and business clients

Supported application runs, addressed problems identified by users and troubleshooting issues in production

Monitored batch jobs and took remedial actions when they fail

Wrote and edited numerous scripts as hot fixes and enhancements

Performed System Ready for Business Checkout Procedures

Improved and fixed existing KORN Shell Scripts in production

Set up Fix Gateways and Agora Gateways in production

Scheduled numerous jobs in production on daily basis

Installed and set up application interfaces from scratch

Wrote and Optimized several SQL scripts as a part of production troubleshooting

A key resource in Server migration for production applications

Worked with off-shore team in India, Singapore and London

Worked in testing and created and updated support documents and run books

Environment

Oracle, KSH, PERL, UNIX, Windows XP Professional

Sr. Control Analyst, Duke Energy, Cincinnati, OH: (Dec’2007- March’2010)

Trouble Call Outage Management System, Crew Callout, Gas Callout, Major Account Outage, Outage Maps, External Web Pages, Common OMS, Midwest Daily Staffing, Storm Management pages, Web Workspace Application

SPL Outage Management System is used to handle critical Power Outage information in Midwest Area (OH-KY, IN). As calls come in from customers reporting outages and other problems, they can be ingested into or entered directly within SPL OMS. This system analyzes the calls and applies a set of analysis rules. It then groups the calls based upon those rules and presents the information to call center in terms of trouble events. Crew Callout is used to manage, dispatch and reorder crews on field duty. Major Account Outage and Outage Maps are external applications used for reporting and to generate statistical information for the business. Web Workspace is a web version of the OMS application.

Systems have SQL Server, Oracle, KSH in the backend and TCL, Java, Html based interfaces.

Role - Sr. Analyst to lead a Production Support Team

Work in INC Remedy, Change Management, SQL Server, Oracle Warehouse Builder, KShell, Perl, UNIX, Windows Server

Interact with business users and understand their needs.

Converting business requirements to technical book of work.

Lead resource for numerous Deployments and Releases.

Worked as a BI resource for the Common OMS project to tune logic flows

Rewrote and Implemented Disaster Recovery failover and failback plans.

A resource for On Call schedules and Storm Duty support shifts.

Did various Stress/ Load and volume testing for applications.

Supported multiple Live Outage Applications in Window Server and Unix Environment.

Used Remedy, IMDB, SR and Change Management for fixes, deployments and releases.

Wrote Packages and several Stored Procedures on SQL Server Database.

Wrote and Enhanced Korn Shell, Perl and TCL scripts.

Optimized and wrote several queries and scripts for greater efficiencies during storms.

Used DataStage, DTS and Crontab for job runs and packets in the application.

Designed and developed reports using MS Reporting Services and HTML.

Tested/ Implemented Service Packs and Bundle Releases.

Documented Service Level Agreements and Support/ Release documents.

Environment

SQL Server 2005, Oracle 10g, HP UNIX, TCL, KSH, Perl, Html, ASP, Solaris 2.x, Windows Server 2003, TOAD, Exceed

Production Support Analyst, Freddie Mac, VA (Sep’2006 - Dec’2007)

Key Issues, Debt Funding, Risk Metric Validation, Mortgage Price, Error Tracking, Euro Dollar Pricing

These Financial applications were used by the Trading Floor to do Online Trade in the Mortgage Market. Every day the Close of Business data goes to a prime repository called the IPMS from where different set of reports and data are generated for different teams and stored in the Database. Key Issues and Debt funding are reporting applications that does a lot of trade calculations based on the market Debt analysis and previous day market close. RMV and Mortgage Price are used to calculate the Risk and TBA prices according to the market scenario and current day trading activities.

Systems have Sybase, KSH and Perl in the backend and PERL, C and Java based interfaces.

Role – Liaison between Mortgage Clients and the Technical Team

Work in Autosys, CTT, Clear Quest, Clear Case, INC Remedy, Sybase, Perl, KShell, UNIX

Worked as a technical resource who interacts with the business clients

Led a technical team and handle all critical Production Support issues

Supported many production Financial Applications using Autosys and Data Synapse

Used Clear Quest for hotline fixes, defects and emergency and regular deployments

Wrote Stored Procedures and Triggers on Sybase Database

Developed many TSQL queries for ad-hoc reports

Stored Procedures with DBI/DBD connection to Sybase

Optimized existing Stored Procedures for faster and efficient flow of the data.

Worked in TSQL batches for data handling in the backend

Enhanced and edited Perl scripts for applications modules

Designed and developed many PERL scripts for server side data processing.

Improved and fixed existing Korn Shell Scripts.

Created many PERL programs with BCP for the data upload and download.

Designed and developed reports using Perl and HTML

Worked in testing and documenting Service Level Agreements and ITSR

Environment

Sybase, PERL, Sun Solaris 2.x, DBI/DBD, Sybase 11.9.2, Windows XP Professional

Other Major Projects handled

Prime Brokerage Trade Processing and Transaction & Liquidity Reporting

This system acts as a central processing unit of trade information.

System has Sybase, Perl and Unix Shell scripts in the backend and PERL/CGI and Java based interfaces.

Role – Sr. Team Member

Created many Tables, Stored Procedures and Triggers on Sybase Database. Designed and developed reports using PERL, Stored Procedures with DBI/DBD connection to Sybase. Created many reports using Html. Developed many TSQL queries for ad-hoc reports. Worked in TSQL batches for data handling in the backend. Created many TSQL/PERL scripts for data archiving and movement. Created/Modified numerous web pages using HTML with JavaScript validations. Enhanced and fixed existing Korn Shell Scripts.

Workforce Management

Application was developed to cater the managers for the production plant.

System has PERL, KSH, Sybase 11.x, DBI/DBD, ISQL, BCP, Solaris 2.x, Windows 2000

Role – Team Member

Created many PERL scripts for data format/validation checking. Worked in PERL data loading modules in Research server. Worked with QA team for testing and test data and script preparation in PERL. Participated in Sybase performance tuning. Created Unix Shell Scripts for sequential execution of PERL scripts including data extraction, loading and Sybase Stored Procedure execution. Created Sybase Tables, Stored Procedures and Triggers. Worked in creating test scripts in PERL. Took part in User, QA meetings. Created technical documentation user manual

Order processing

The system manages all the purchases of the firm.

System has Perl, Sybase 11.x, TSQL, CGI, HTML, JavaScript, DBI/DBD, Apache, Solaris 2.x

Role – Team Member

Developed part of the middle tier application using Perl. Designed and developed many Perl programs. Developed programs for accessing the database using DBI/DBD. Wrote many queries and Stored procedures, Triggers on Sybase database. Wrote Perl programs with queries for data retrieval, manipulation and update on underlying Sybase tables. Tuning Sybase queries and Stored Procedures. Participated in requirement analysis and documentation during various module designs. Analysis, modification and coding of various Stored Procedures, packages etc. for application enhancement. Testing, documentation and end-user training. Created front-end search and lookup screens using PERL/CGI &Html. Participated in documentation and testing.

References: Available on Request

Contact this candidate