Senior Technical Analyst Resume
Summary
Over 15 years of experience in Software and Database design and development. Over 5 years of Financial industry experience in Data Analysis, Production Support, Software Development and Technical Analysis. Experience in taking lead responsibilities and mentoring. Experience in Object Oriented Programming, database design, table normalization, SQL query tuning and optimizations.
Technical Skills
Languages
Java, Java Socket Programming, EJB, C/C++, SQL, Unix Korn Shell (sed, awk, grep), Tcl.
Web Technologies
J2EE, Java, JSP, JavaScripts, JavaBeans, Java Servlets, JDBC, XML, Web Services(SOAP), EJB 2.0(Entity & Session Beans), JNDI, J2EE Design Patterns, MVC, JAXP, SAXP, BEA Weblogic 9, Jakarta Struts, Apache Tomcat WebServer 4.x, HTML, XML
IDE and Other Tools
Eclipse, JBuilder, Dreamweaver, Oracle TOAD, ANT, Microsoft Visual Studio.
Database and related software
Oracle 10G/8i/9i, SQL*Plus, PL/SQL, Pro*C, JDBC. Database design, table normalization, SQL query tuning and optimization. Sybase, SQL Server, Microsoft SSIS packages.
Network and Client/Server Programming
TCP/IP, Unix Network programming, IDL, Visibroker CORBA.
System Environment
SunOS 5.4, Solaris 2.3, HP-UX, AIX, Unix System V, Windows NT, NCR, Linux RedHat.
Education
M.B.A. in Finance (in progress)
M.S. in Computer Science
B.E. in Electronics and Communication Engineering
Experience
Confidential, Cranford NJ 06/2005 – 12/2010
Assistant Vice President, Senior Technical Analyst
Senior Analyst for Portfolio and Fee Billing platforms at the Global Wealth and Investment Management (GWIM) Division.
Key Responsibilities
- Developer for applications to enable enrollment of Accounts under Managed Fee based products, using Java, J2EE, Struts and Web Services, with Oracle 10G as back-end database and WebLogic9 as the application server.
- Lead developer for applications to Calculate and Allocate Fees to the Clients, Financial Advisors and Account Managers, using Java, J2EE, EJBs, WebLogic9 and Oracle 10G.
- Leading a team of developers on Technical Analysis, Application Development, Strategy and Systems Delivery across various Lines of Business.
- Developer for migration of Fee Based Managed and Advised Accounts from BofA platforms to Merrill Lynch, using ETL tools such as Microsoft SSIS packages connecting to Oracle, SQL Server and Sybase databases.
- Responsible for verification Data Validity and Integrity for Managed Accounts, using SQL and PL/SQL stored procedures.
- Responsible for meeting Service Level Agreements with the Business Partners by ensuring the smooth processing of jobs under GWIM platforms.
- Management of Disaster Recovery Exercise to ensure smooth transition from Production to Contingency environment, in the event of a disaster.
- Involved in providing Production Support by running Batch Jobs for CFAS and Mutual Fund Research applications; the jobs run either manually or scheduled using Cron, AutoSys and iXp.
- Involved in ensuring Data Integrity and verifying Business Logic for Operations and End Users, by running SQL queries and Stored Procedures on Oracle10G, SQL Server and Sybase databases.
- Involved in maintaining Java Web Application with enhancements and modifications to existing web modules and batch jobs.
- Provide estimates for design and development of applications.
Software used:
Java, J2EE, Servlets, JSP, JDBC, EJB, Oracle10G, Jakarta Struts, WebLogic9, SSIS Packages, Sybase, SQL Server, Web Services (SOAP Architecture), Eclipse, Visual SourceSafe, Subversion.
Confidential,Lawrenceville, NJ 10/2004 – 05/2005
Software Consultant
Lead Developer for Web based Financial Applications to provide consolidated Enterprise Investment Account data, and Portfolio Accounting and Performance Reporting solution to Fortune 500 Financial Institutions and help them in their critical applications such as Business Planning, Product Development, Analytical and CRM applications
Key Responsibilities
- Development of Fee Billing application to enable Financial Advisors and Institutions to bill their clients for managing their portfolios.
- Development and testing of Fee Billing applications in J2EE environment, to provide consolidated financial data (reports) to Financial Advisors, Investors and Brokers.
Software used:
Java, J2EE, Servlets, JSP, JDBC, EJB, JNDI, Oracle9i (SQL), Dreamweaver, JBuilder, TOAD,
Jakarta Struts, WebLogic8.1.
Confidential,Trenton NJ 03/2004 – 09/2004
Software Consultant
Developer for web based Applications to provide Business and Marketing solutions for Pharmaceutical and Financial companies.
Key Responsibilities
- Development of Web based Survey Applications to enable clients to fill-in survey questions for services provided by Pharmaceutical companies.
- Provide estimates for design and development of applications in J2EE environment.
Software used:
Java, J2EE, Servlets, JSP, JSP Custom Tags, JDBC, EJB, JNDI, Oracle8i (SQL), Dreamweaver,
Eclipse, TOAD, Jakarta Struts, WebLogic 6.1/8.1.
Confidential,Morristown NJ 05/2002 - 01/2004
Sr. Software Developer.
Senior Developer for a web based Integrated Project Management Tool, to manage End-to-End Business Initiatives, Financial and Budget allocation for AT&T. The project was to oversee Budget, Cost, Revenue, Operational Expenses, Capital Gains and Investment process of the company.
Key Responsibilities
- Analysis of Data Model and Table Structures created in Oracle 9i.
- Development and Testing of the application.
- Used ExtenXLS software to generate Excel Spreadsheets from Java and HTML.
Software used:
Java, JavaBeans, J2EE, Servlets, JSP, JSP Custom Tags, JDBC, EJB, JNDI, Oracle 9i (PL/SQL
Stored Procedures and Packages), Dreamweaver, NetBeans, TOAD with Apache Tomcat as the
Web server, on Windows NT.
Lead Developer of FlowMon DataFlow VoIP interface between AT&T Content Server and Genesys Customer Premise equipment. The Project was to analyze, monitor and track the VoIP data packets over the network. It provides the web based user with the statistical information of the network and also lets the user to make changes to the network configuration on the web.
Key Responsibilities
- Design of the Configuration entities.
- Development and Testing of the application.
- Used Forte for building server application.
- Used ANT build tool to automate the build process.
Software used:
J2EE, Java, JSP, JavaBeans, JavaScripts, EJB, C++, UNIX Named Pipes, XML, Oracle9i (PL/SQL Stored Procedures and Packages) and BEA WebLogic Application Server, Forte, ANT, Dreamweaver on SunOS 5.6 and RedHat Linux.
Lead developer of a fully automated Web based Network Elements Inventory Management system, a tool to track and monitor the movements of Network elements such as ATM and Frame Relay Switches(CISCO and Lucent), for AT&T. Worked through the entire life-cycle of the project.
Key Responsibilities
- Worked through the entire life-cycle of the project(design development and deployment)
- Took lead responsibilities in Collection of Requirements, interaction with the users to understand the business flow, Hardware environment and Software Configuration.
- Design and development of the User Interface using JSP, HTML, CSS, JavaScript using Dreamweaver.
- Design, development, testing and deployment of server application.
- Used J2EE Design patterns to conform to MVC(Model-View-Controller) architecture
- Writing Design Document.
Software used:
Java, Servlets, JDBC, SQL, Oracle8i (PL/SQL Stored Procedures and Packages), SQL*Loader, JSP, JavaScripts, HTML, Dreamweaver, Jbuilder, Apache Tomcat, Oracle 8i on SunOS 5.6.
Confidential,Piscataway NJ. 02/2000 – 03/2002
Software Consultant
Developer for Maintenance and Operations Console (MOC) Server, a Web based tool to monitor the network activities such as Alarms, Status and Security of the Network.
Key Responsibilities
- Development of Security Server, a sub-process that enables the user to do administrative work such as User, Password and Network Administration on the network site it is monitoring.
- Development of a process to enable the user to open a Telnet session to the site to correct any problem that is displayed on the MOC Server’s Java Swing based GUI.
- Development of the Java Signed Applets to enable the MOC process write to the user’s local desktop as well as performing the cut & paste mechanism from the Java Applet.
- Creation of test cases for Unit, Multi-Unit and Integration testing.
- Writing Design Document.
Software used
C++, Java, Oracle8i (PL/SQL Stored Procedures and Packages), JDBC, Java Applets, Java Signed Applets, Java Sockets, Java Swing, RMI, IDL and Visibroker CORBA on AIX platform.
Developer for Telcordia Inventory Manager (TIM), a system that efficiently manages Network Inventory such as Switches, Plugs, Gears and other network hardware.
Key Responsibilities
- Working with the Requirements and Design team to finalize the application.
- Development and Testing of the application
Software used
C++, Oracle 8i (PL/SQL Stored Procedures, Packages and Triggers), Pro*C on HP-UX system.
Confidential,Piscataway NJ. 11/1996 – 11/1999
Lead Developer for Data Scrub, a Data Integrity application to ensure the integrity of the customer billing, name and address data.
Key Responsibilities
- Lead position in collection of requirements, design and development.
- Mentored developers from mainframe and DB2 background to make them conversant in UNIX and Oracle platforms.
- Design and Development of the application.
- Testing and Production Support
- Performing SQL query optimizations and tuning for performance enhancement.
- Developed scripts in Unix Korn Shell for string, text and pattern matching and filtering of duplicate and irrelevant data from ASCII text files, using sed, awk and grep.
Software used
Pro*C, Oracle 8.1.2(PL/SQL, Stored Procedures, Packages and Triggers), SQL*Plus, SQL*Loader, SQL Report Writer, Unix Korn Shell, sed, awk, grep, on HP-UX and AIX.
Developer for Billing Name and Address, a datawarehousing project for AT&T.
Key Responsibilities
- Involved in the entire life cycle of design and development of the project
- Mentored developers from mainframe and DB2 background to make them conversant in UNIX and Oracle platforms.
- Overall design of the project, including collection of data, requirements, design of the Database and normalization of Oracle tables.
Software used
Pro*C, Oracle 8.x (PL/SQL Stored procedures, Packages and Trigger), Tuxedo and Unix Korn
Shell scripts on HP-UX platform.
Confidential,Piscataway NJ. 08/1995 – 10/1996
Software Engineer
Developer for MYNAH, a Business Flow Test case Automation Testing Tool.
Key Responsibilities
- Design and implementation of Test Case Message Generation process, using Oracle Trigger process to transfer messages from the database to front end GUI developed in Motif X-Windows, developed on SunOS 5.4 platform to support automated executions of tests and manage test activities.
- Developed Test Status Report generation processes to indicate the execution flow of the Test cases, their dependencies etc.
Software used
Pro*C, C++, PL/SQL, Unix Korn Shell and Tcl scripts.