Subhash Reddy Email & Phone Number

Charlotte, Nc, Us

Currently working in Environment Management team supporting Credit Studio & Sparck systems within Enterprise Credit Risk division. Sparck is Quartz based platform for integrated trading, position, pricing and risk systems. This includes Sandra, which is a NoSQL, oriented-object database that stores and replicates data to different geographical locations for consistency, redundancy, and speed. Credit Studio is the Sybase legacy system for calculating Peak Exposures for Credit Risk purposes, and Expected Exposures for use in Basel RWA calculations. Sparck/CS operate as a hybrid of the two systems to process daily Internal Models Method (IMM) batch. IMM calculates capital reserve requirements for the bank based on forward-looking simulations of the market, under both normal and stressed conditions, for exams conducted periodically by the financial regulators. Involved in performing Autosys, Code, GUI and Shell deployments in UAT environments from Red Hat Ansible Tower. HPDMA is used for all Sybase DB deployments & Toad Data Point for verifying SQL queries. CA Workload Automation iXp tool is extensively used for monitoring Autosys jobs and Super Putty tool for connecting to UNIX servers for checking logs & running shell scripts. MapR Dashboard is used for monitoring Disk Space, Nodes in Clusters & checking Volumes. Interact with Development teams, QA teams, Release Management Teams and End Users during the process of Credit Studio and Sparck batch runs. Involved in utilizing many Quartz Desktop tools, QzDev for writing Python scripts, Bob Monitor for starting the python scripts, DB Browser tool to navigate the directories and objects stored in Sandra, QzRelease2 for pushing the changes from Dev to QA and UAT lanes.

Responsible for development, maintenance, testing and deployment of Traffic Violations Bureau application (TVB) for Metropolitan Government of Nashville and Davidson County using SAP PowerBuilder 12.6 and Oracle 12c RAC. TVB has all the details of citations, collections, defendants and payment receipts. Used Toad for Oracle for creating PL/SQL statements, packages, procedures and triggers. Atlassian JIRA Project Management Software 6.3 is used for planning, tracking and releasing multiple TVB items to UAT and Production. Also, involved in creating SQL queries using SAP Crystal Reports 2013.

Zurich, Ch

• Involved in development, maintenance, testing and deployment of Global Price Testing application (GPT) using Sybase PowerBuilder 12, Sybase ASE 15.7 and Red Hat Enterprise Linux, RHEL 6.4. GPT is used by product controllers for price testing and validation.• Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones for GPT were completed on time, on budget and with the desired results.• Used PBSCC Proxy for version control and DBeaver Enterprise Manager 3.6 & Squirrel v 3.7 for creating stored procedures, functions, triggers and SQL queries.• Implemented a robust framework for Checks & Controls Validation Engine having a single wrapper used in Integrity & Tolerance check validations. Installed modular and reusable rule driven cross regional enrichments and calculations (with traceable exceptions where needful) with transparent logging to help fasten defect analysis. • Created new screens for Checks & Controls such as Threshold Limits, Batch Job Status and Exception reports for all 3 regions, Asia Pacific, Europe and North America. Used Sybase PowerDesigner 16 in creating physical data models for databases.• Provided documents in detail for KPMG Audit team members. Proficient in managing Service Now for Change / Incident / Problem / Release Management tickets for all the change requests.• Responsible in monitoring all the Control-M batch schedules in GPT, checking the upstream and downstream feed files in Linux, and maintaining shell scripts in Linux. Also provided L3 support for all production issues.

New York, Ny, Us

• Involved in analysis, design, development and testing of Data Utility tool within the Standard and Poor’s Rating Services division using PowerBuilder 12.5 and Oracle 11g. The Data Utility is included in Corporate Repository (CORE) application which is the primary storehouse of Standard & Poor's Ratings and Ratings-related data. CORE contains information on Ratings at the Organization, Debt Type, Issue, Program, and Municipal Parity Level. Through DU tool, End Users and Data Managers can perform Single and Bulk Uploads of various screens, such as Rating Type, Regulatory Indicator, Analyst Roles & Names and Rating Reason Types. Responsible for the release of deployments in phases, attending daily Scrum meetings & coordinating with offshore development teams as well as QA testing teams for the QC defects entered in HP ALM 11.5.

Memphis, Tennessee, Us

• Responsible for supporting OEI (Order Entry and Invoicing) and MRS (Material Receiving System) applications using C++, Oracle 11g and PowerBuilder 12.5. Involved in converting C++ programs into PowerBuilder, resolving production support tickets and also improving the performance of SQL queries. Microsoft Visual Studio TFS is used for version control & involved in writing many SQL queries, functions and stored procedures in Toad for Oracle PL/SQL. Also responsible for monitoring daily/weekly/monthly batch jobs running on Microsoft SQL Server 2008 R2 by coordinating with WebMethods and SAP groups.

New Brunswick, Nj, Us

• Involved in the development & maintenance of Executive Compensation Management (ECM) & ECM Reports applications using PowerBuilder 10 & Oracle 10g/11g. ECM is a series of programs designed to enable J&J to attract, attain and motivate the high caliber of executives required for the success of the business. The main ECM application contains the ability to maintain Grantee Demographics, Compensation Plans, Stock Compensation, Options Compensation, CEC / AAR Compensation and reference tables.• Responsible for adding new LTI vehicle, Performance Share Units (PSU) in ECM and also creating new reports for PSU in ECM Reports using Sybase PowerBuilder 10. • Used SQL Navigator 6.6 for creating/modifying various functions, packages, stored procedures and triggers in Oracle 10g/11g development database.• Involved in creating user requirement specification documents using standard templates by discussing with business users and also involved in other phases of SDLC by testing ECM and ECM Reports and implementing the initial user requirements. HP Quality Center is used for defects and responsible for tracking issues and resolving them during UAT phase.

Zurich, Ch

• Involved in development, maintenance, UAT testing and deploying Global Price Testing application using Sybase PowerBuilder 11.5/12 and Sybase ASE 12.5/15. • Responsible for monitoring all the Control-M batch schedules in GPT, checking the upstream/downstream feed files in UNIX, checking the Perl scripts data from MDS servers and maintaining Shell scripts in UNIX. • Coordinated with offshore teams in India and Singapore and responsible for migrating the GPT application from PB 7 to PB 11.5 and creating MSI packages using Windows Installer XML 3.5 (WIX). Used Tortoise SVN for version control and DBArtisan 8.5 for writing SQL queries, creating/modifying stored procedures and triggers in Sybase ASE 15.• Responsible for developing, maintaining and resolving production support tickets in SPARTA application using Oracle 10g and .Net Framework 4. • Experience using Informatica PowerCenter 8.6 Repository Manager, Designer, Workflow Manager & Workflow Monitor while monitoring the support tickets from upstream feeds.• Involved in creating and debugging stored procedures, functions, materialized views and triggers using Oracle PL/SQL in SPARTA application.• Used BMC Remedy Change Management for monitoring all the change requests. • Liaise among stakeholders in order to elicit, analyze, document, communicate and validate business needs and requirements for changes to business processes, policies, and information systems within the Product Control division.

New York, New York, Us

• Experienced in modifying & testing the reports to meet business requirements in Project Tracking System (PTS) and Time Reporting System (TRS) using PowerBuilder 10.5 and Sybase ASE 12.5• Maintained, tested and supported Public Finance Department (PFD) application using PowerBuilder 10.5 and Sybase ASE 12.5. PFD system has different modules (Deal Tracking, Short Term, Table Administration, Travel & Expenses, Request for Proposal, Employee & Syndicate Maintenance). • Responsible in deploying all the modules to the users by interacting with different teams within CITI such as Change Control, Global Database Management, Global Deployment, Wintel Wrapping and System Administrators. Deal Tracking module has the details of all the Issuers, Offering & Series along with G-37 Compliance report, Revenue & Forward Calendar reports. • Involved in all stages of the project lifecycle to date from the business case development through to post implementation and support. • Responsible for monitoring the entire daily AutoSys UNIX job processes & helped other team members in migrating revenue reports into Business Objects.

New York, Ny, Us

• Responsible for developing, testing and supporting Compliance Monitoring System (CMS) using PowerBuilder 10.2 and Sybase ASE 12.5. • Generated monthly reports for CMS users such as Compliance Review, Low Priced Equity Commissions, Firm wide Listed (NYSE) stock record positions and positions for NASDAQ, OTC BB and Pink sheets. • Ran queries for generating quick reports based on the requirements from Compliance & Internal Audit Departments and also responsible for preparing Integration Test Plan for functional team as well as for development team. • Liaised between both business and IT functional areas across Oppenheimer's Legal and Compliance Department.• Responsible for the successful migration of CMS to run in Fahnestock's data warehouse technology environment. • Modified CMS and compiled using PowerBuilder 8.0.3. The back-end schema, batch creation and report stored procedures are modified using Sybase ASE 12.5 to reflect Fahnestock’s data feed. • Identified all of the change components affecting the front-end and back-end. This includes getting definitive answers regarding schema changes, data conversion and data mapping documents. In the development phase, began fast track conversion of the batch and report procedures, reporting and application tables, PowerBuilder report objects, data windows and windows. In the testing phase, involved in testing of the data feeds, batch and report procedures, front-end view generator, security manager and reports. Also involved in documenting the complete business process by identifying the requirements and finding the system requirements.

Telsource• Responsible for the development and maintenance of 3 tier order entry applicationPowerBuilder 8, Sybase EAServer 3.6 / Jaguar CTS 3.6.• Created reports using Crystal Reports 8.5 and used OLE in PowerBuilder for displaying these reports. Louis Dreyfus• Actively involved in the process of migrating contract data from Grain Commodity Trading System database (Oracle 7.3) to Ceres database (Oracle 8i) at Louis Dreyfus Corporation using PowerBuilder 8.0. • Used dynamic SQL, cursors and stored procedures within PowerBuilder to access multiple physical databases and versions. Several reports are generated for Commodities, Customers, Exchanges, Futures, Locations and Shipping Certificates in the new migration application using PowerBuilder 8.0 and Crystal Reports 8.0. Utilized PL/SQL 8 in creating functions, stored procedures, triggers and packages in TOAD 7. • Responsible for the web application of the domestic and export contracts that uses BEA WebLogic server and Forte for Java. Pfizer• Participated in the conversion of COMCAL application at Pfizer from DB2 to Oracle 8.0 using PowerBuilder 7.03. COMCAL • Used TOAD v 6.4 from Quest Software to build, execute, tune queries and also to edit, debug PL/SQL 8 and profile stored procedures including functions, packages and triggers. • Tested the system through Citrix Web Client - Active X Control. CIBC Oppenheimer• Responsible for the release of new version of CMS Compliance Management System at CIBC Oppenheimer using PowerBuilder 7.03 PFC and Sybase Sql Server 11.5. • Used DBArtisan 4.0 and Embarcadero Rapid SQL for stored procedures and Visual Source Safe 5 for version control. • Created Jaguar Components in PowerBuilder and also involved in the prototype phase for selecting web reporting tools such as Actuate, Brio, Cognos, and Seagate Crystal Reports 7.0.

New York, Ny, Us

• Responsible for the complete maintenance and some new development of the billing systems in Financial Operations, Advisory Services Group. • Migrated all the billing applications from PowerBuilder 4.0 to 5.0 and Sybase system 4 to Sybase system 11. • Created crontabs and wrote shell scripts in UNIX for the daily processes such as getting in new clients, terminations, and groups in the billing system. The weekly billing is done for the journal entries and production credits. • Used SQL Advantage in Sybase Central for creating & debugging the stored procedures. • Attended seminar in Building Web applications using PowerJ & Sybase EAServer 3.6.• Involved in the prototype phase for selecting web development tool and used Jbuilder 3 for applet user interface using JFC/Swing and Servlets were used for server side programming & connectivity made through JDBC. All the reports are generated using Seagate Crystal Reports.

Bristol Myers Squibb• Employed as a Sr. Consultant for Bristol Myers Squibb in teaching PowerBuilder for Interim Employees and created a sample application. • At Interim Technology, learned JAVA 2 platform / HTML programming and built simple user interfaces for applets. • Utilized advanced features in JAVA such as designing a User Interface with AWT & Swing and also handled user events with Swing. • Used PowerBuilder with Sybase EAServer 3.5 to build web based applications.Merrill Lynch• Responsible for the maintenance of Capital Management Group (CMG) application using PowerBuilder 6.5 PFC and Oracle 7.3.• Involved in complete maintenance of the screens using PowerBuilder PFC and also responsible for creating & modifying the stored procedures & functions using PL/SQL 2.3. Used non-visual user objects and utilized the PowerBuilder features, Inheritance, Encapsulation and Function Overloading. • Tested the whole application for Y2K compliance using different dates. Ambac Financial Group• Responsible for developing, testing and implementing a Secondary Market Trading System ( SMTS ) application on Windows NT 4.0 using PowerBuilder 6 and Oracle 7.3.• Completely responsible in the development of SMTS application, both on the server side and on the client side.• Responsible for the development of Encore application using PFC.

Amherst, New York, Us

• Involved in the development of One Vision Level 3 / 4 Business Control systems for Order Management, Production Management and Shipping & Logistics subsystems using PowerBuilder v 5.0 and Oracle v 7.3 on Windows 95. • Responsible for creating and debugging stored procedures & functions using PL / SQL v 2.3 running on HP UNIX 9000. ORACLE Procedure Builder 1.5 is used for debugging PL / SQL code. • Used INTERSOLV PVCS Version Manager for Software configuration management and Version control. Also involved in developing the windows & data windows, and creating functions & user objects using PowerBuilder v 5.0. • Designed, developed, tested and implemented engineering and business applications for steel companies using PowerBuilder 5.0, Sybase system 10 and Oracle 7.2. • Utilized Inheritance and MDI client windows & System Architect is used for the database design. • Developed and implemented an EAF application in Level 2 using PowerBuilder 4.0 and Sybase v 4. • Developed windows in LMF and Caster applications in Level 2 & created executable files. Used hypertext links and graphical links to navigate from one window to other windows.

Michael Baker• Designed, developed and tested a Resume Tracking application system at Michael Baker Corporation that keeps track of all the applicant’s resumes using PowerBuilder 4 and Oracle 7.• Designed the prototypes for all the windows & implemented using PowerBuilder 4.0. • Used RoboHelp for creating the help files. Thrift Drug• Involved in converting business applications such as Gross Profit Analysis and Buyer/Budget Performance from Pilot Software to PowerBuilder 3.0a. • Extensively used Data Windows, Structures & User Objects in both the applications. • Responsible for creating the help files using Doc 2 Help. Black & Decker• Worked on the development of an Order Processing System at Black & Decker that handles 30,000 orders per day. • Creating of windows, data windows, menus & writing powerscripts to access the data using PowerBuilder 3.0a and Sybase v 4.• Responsible for creating the reports using SQR.

Ms, Civil Engineering

Bs, Civil Engineering