Technical Systems Analyst Resume
San Francisco, CA
SUMMARY
- Over 8+ years of professional experience in IT Industry involving in various phases of Software development including system analysis, design, development, testing, implementation and production support of web based applications using Java/J2EE architecture. Effective team player with excellent problem solving abilities, a willing and quick learner with strong technical and communication skills.
- Proficient in core Java Enterprise technologies such as EJB, Spring, Java Servlet, JSP, JSF, Struts, Custom Tag Library, JDBC, Hibernate, JMS, JTA
- Excellent knowledge of Web Services, WSDL, SOAP, JUnit, XML, XSL
- Strong ability to co - ordinate with external and internal clients as well as analyze existing system models and business requirements
- Professional experience in the Financial, Retail, Manufacturing, Telecom and E-Commerce sectors
- Perform data analysis, testing, debugging and problem resolution
- Research and evaluate technology solutions and present recommendations for improved system operations
- Create data verification methods and comply with standard system procedures
- Excellent knowledge of UML, Rational Rose and Object Oriented methodologies RUP.
- Excellent knowledge of J2EE and Enterprise Applications Design under J2EE framework.
- Extensive hands on experience in various database systems such as Oracle (10g/11g), DB2, Vertica, Hadoop (Datalake, Hive, BeesWax, HUE) etc
- Proficient in SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers and Hibernate HQL Queries
- Experience in building UI screens using JSF
- Professional experience with Tibco BW 5.7
- Experience in web-based GUI development using HTML including HTML4 and CSS.
- Working experience in Apache Tomcat and IBM Web Sphere
- Good understanding in UNIX, Perl & shell scripts
- Thorough understanding of J2EE modules and Design Patterns
- Strong analytical skills
- Ability to consistently meet deadlines
TECHNICAL SKILLS
Languages: Java 1.3/1.4/5.0, J2SE 5.0, PL/SQL, UNIX Shell Script, C, C++, Perl
Operating Systems: Windows NT/95/2000/XP, DOS and UNIX Solaris
Databases: Oracle, MS-Access
Java Skills: J2EE: EJB, JSP/Servlet, JSF, JPA, JDBC, RMI, Java Beans, JMS, Java Design patterns, AJAX, Web services( SOAP, WSDL), SOA, Agile J2SE: Swing, I/O, Multi-threading, Applet
TIBCO Skills: Tibco BW 5.7, Administrator
XML: Xpath, XSL, XSLT, FO, DOM, SAX
Web: HTML, DHTML, CSS, JavaScript
O-R mapping: Hibernate
Tools: /Utilities: TOAD 7.6, SQL Loader, Ant, CVS, Microsoft Access, Hudson/Jenkins, Blade Logic, Net Beans 5.5, Eclipse 3.6/3.7, IBM RAD, AutoSys, MS SSIS Package Utilities
ETL: IBM DataStage and QualityStage
Configuration Management: Maven, Maven 2, Ant
Application Servers: Tomcat, Websphere 4.1/5.x/6.0, JBoss
Frameworks: JSF, MVC Struts 1.1, J2EE Design Patterns
Version Control: Serena Version Manager, Subversion, Harvest
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
Technical Systems Analyst
Responsibilities:
- Co-ordinated with developers, testers and end users to ensure technical compatibility and adherence to business requirements.
- Created design documents for existing system architecture as well as new system designs
- Created Source-to-Target Mapping (STM) documents to map source and target databases
- Conducted thorough requirements analysis
- Analyzed ETL processes built using IBM DataStage to pinpoint possible trouble points and bottlenecks
- Wrote complex SQL in order to create/design ETL solutions to cater to our users’ needs
- Worked with Lean Lab teams on various time-critical initiatives that were deployed on the Macy’s website during peak holiday sales season which resulted in increased sales
Confidential, Menomonee Falls, WI
Applications Engineer / Developer
Responsibilities:
- Analyze legacy applications for deprecated and / or obsolete code for the purpose of cleaning up bloated legacy applications and bringing them up to current day coding standards
- Re-engineer legacy applications to move away from an EJB based design to a Spring data based design
- Replace the iBATIS persistence framework with Hibernate for all legacy back end applications
- Convert native SQL queries to HQL queries
- Create JPA Entity classes to map database tables to POJOs
- Rewrite old methods to use built-in methods provided by JPA to perform CRUD operations on underlying database tables
- Replace a domain object based approach for accessing data with a model (Spring MVC) approach
- Upgrade old Java code base (1.4 and 1.5) to the latest version (1.6 and 1.7)
- Write exhaustive JUnit test cases to ensure proper working of re-engineered applications and also compare new test results with legacy test cases
- Create and / or make changes to configuration files such as pom.xml to compile and deploy applications
- Analyze Sybase database tables, SQL queries and Stored Procedures
- Use Maven to build and deploy applications
- Agile Scrum was the development methodology in use
Environment: Java/J2EE, JDBC, Sybase, Linux, Maven, Eclipse, JAXB, JPA, iBATIS, JUnits, Struts, Hibernate, SQuirreL, RazorSQL
Confidential, Reston VA
Software Developer / Analyst
Responsibilities:
- Understand business processes of Fixed Income Securities.
- Responsible for all phases of the application development life cycle, including analysis, design, programming, testing, implementation and maintenance.
- Translate business requirements into workable software solutions
- Support OF and FHL Bank users by addressing problems and priority needs relating to applications support in a timely and cordial manner
- Develop and maintain accurate and up-to-date user and technical documentation. Technical documentation includes, but is not limited to, diagrams such as UML, Data Flow Diagrams, and Entity Relation Diagrams as well as supporting documentation
- Developed new SOAP based web service in Java using JAXB
- Wrote new stored procedures and modified existing stored procedures to ensure proper implementation of business requirements
- Interacted with business users to analyze requirements and discuss feasible solutions and approaches
Environment: Sybase, Linux, Maven, Eclipse, Hyperion-SQR, Business Objects, ColdFusion, PowerBuilder, SoapUI
Confidential
Responsibilities:
- Re-wrote Java code to implement a database table based approach to replace an in-line code based approach to compute the status of report submissions from banks
- Analyzed the application to determine unused/deprecated code for removal and/or upgrading to make the application leaner and faster
- Implemented HQL queries and used JPA built-in methods to get, update, insert or delete underlying database tables with specific codes representing the real-time status of reports submitted by banks
- Used Java multi-threading to process multiple user requests simultaneously
- Modified JSF pages and underlying backing and servicing beans to get the proper status codes from the database and translate them into appropriate color codes for display on the front end.
- This approach has significantly reduced running times of the application
Environment: Java/J2EE, JDBC, Sybase, Linux, Maven, Eclipse, JAXB, Struts, Hibernate, JSF/RICHFACES, SOAP, WSDL
Confidential, Charlotte NC
Data Analyst / Developer
Responsibilities:
- Build Trade level Start of Day and Real time Cash Projection reports for various depositories like BONY, DTC EuroClear (GLOSS)
- Reconcile the Trade level Cash Projections against various depositories
- Analyze trading activity on a variety of products such as Bonds, MBS, REPO, Treasuries etc to accurately project Start of Day and Real Time cash metrics
- Provide time critical support to Traders in resolving the Cash discrepancies occurred in real time trading.
- Analyzed the Clearance and Settlement life cycle of a Confidential trade in Bony and DTC depositories
- Proactively interact with Traders to understand the Confidential Trading practices in order to provide efficient technological solutions
- Automate the process of generating Cash Projection reports and circulate to the users in real time throughout the trading hours
- Implement the Cash Projection reports scripts using PERL scripting and Java Code
- Perform extensive analysis on the trade data provided by the BroadRidge Systems’ Impact Fixed Income trade processing system
Environment: Java/J2EE, JDBC, Perl, MS Access, MS SQL Server, Sybase, AutoSys, Linux, MS SSIS Package utilities, AntHill
Confidential, NY
Java Developer
Responsibilities:
- Involved in the SDLC process such as user requirements gathering, Documentation, Development and testing.
- Configured and deployed applications on IBM WebSphere.
- Created new functionalities and POC’s in product using Java, J2EE and various other technologies.
- Developed Persistence service layer by using Hibernate to populate and fetch data from DB.
- Expose services via SOAP and Restful Web Services.
- Wrote Maven, Ant and Shell scripts for the new or modified component.
- Designed and implemented the user interface using JSP, Servlets, JavaScript, HTML, CSS andAJAX.
- System designer using a JBOSS Application Server to design and develop backbone J2EE architecture for the implementation of the modernized system.
- Generated transaction and end user reports using Servlets and JSP
- Used Java Messaging Service (JMS) for reliable and asynchronous communication.
- Used Java multi-threading on the server side implementation to handle multiple user access to the system
- Used Apache's Jakarta STRUTS 2 as MVC framework for designing of the complete Web tier.
- Core Java Enterprise technologies such as Spring, Swing, JDBC, Hibernate, JMS, and JTA
- Used JavaScript, j-Query, XSL, CSS, XHTML, and HTML for developing User Interface.
- Implemented the application architecture, using the J2EE standards, Spring 3.0(Business Logic), JSF (Controllers) & JSP.
- Built the bulk of the initial JSF structures to allow for development-administration of the system
- Developed the application using Spring Web MVC framework.
- Used jQuery, Ajax and plain JavaScript to perform client side validation and other functionality.
- Developed user stories.
- Wrote JBOSS, Springs Components for Scheduling and Transforming Objects.
- Developed GUI using JSP, Struts frame work.
- Implemented Struts Bean Tags, Logical Tags and Display Tags in JSPs.
- The technical environment included Java, JDK1.5, JSP, JSTL, spring, Eclipse3.2, Struts 2, JavaScript, Struts Validation frame work, Tomcat, UML, ORACLE 9i/10g, Clear Case and Clear Quest.
Environment: Java, J2EE, JSF, spring, Hibernate, JAXB, Rest Web Services, Oracle 11g.
Confidential, Malvern, PA
Java/TIBCO Developer
Responsibilities:
- Develop new functionality in Trade Flow which is a third party vendor software from Confidential
- Develop new functionality in TIBCO using TIBCO Designer 5.6
- Support for Performance Test
- Production Support
- Create Change records and support elevation and post elevation
- Unit testing of developed business integration processes, preparation and execution of UTR plans.
- Successfully implemented a trade filtering process using TIBCO Designer to filter out Currency and Forward trades.
- Successfully implemented a Manual Batch Load (MBL) process to manually process trades and supply the trades to the automated system.
- Successfully implemented the Continuously Linked Settlement (CLS) functionality. CLS is an industry standard settlement system which is used to settle Foreign Exchange (FX) trades. Wrote code in TradeFlow as well as implemented some enhancements in existing trade capture process within TIBCO to support CLS.
- Gained thorough understanding of various Fixed Income Securities like Bonds, Mortgage Backed Securities, Agencies, Treasuries, REPO and FX
- Also supported the VIA - Australia Integration process. Currently TradeFlow system consumes all Black Rock System (BRS - Fixed Income Trades) trades which are executed in US. We are leveraging the existing TIBCO Functionality to send the Trades executed in Australia to a different system.
Environment: TIBCO BW 5.7, TradeFlow, SWIFT Messaging (MT540 series, MT300, MT301, MT304), Volante, Oracle 11G, UNIX Solaris, RAD 6.0, WAS 6.0, Serena Version Manager, Subversion, ANT
Confidential, Lake Mary, FL
Java/J2EE Developer
Responsibilities:
- Involved in analysis, design and development of the system components.
- Developed the bank process using various BPEL activities invoking web services and also EJB components using Java Bridge component.
- Wired business process components to various services and BPEL sub services using Service Component Architecture.
- Created business data objects using Service Data Objects.
- Created various human task activities for the bank business process.
- Developed 2 web services using WSDL and SOAP.
- Developed a long running business process and some micro flow business processes.
- Used JSF Framework for the development of the web application components.
- Used BFM (Business Flow Management) API for invoking the BPEL Processes.
- Designed and developed entity beans for representing data model.
- Developed Enterprise Java Beans (EJB)/Web Services for various business transactions
- Used log4j framework for logging errors.
- Involved in database Design Creation of Tables, Stored procedures to access using the Callable Statement. JDBC Connection Pooling for achieving back-end connection.
- Used Websphere Integration Developer as IDE for development and Websphere Process Server as Runtime for the development of BPEL.
- EJBs and Web services were developed on WAS 5.1.
- Involved in testing of the business processes.
Environment: Java 5 (JDK 1.5), BPEL, SCA, SDO, SOA, SOAP, ANT, ESB, WSDL, Unix, XML, EJB 3.0, JPA, EJBQL, JSP, JSF, Adobe Flex, Oracle, Websphere Integration Developer 5.1 and Websphere Process Server 5.1, WAS, RAD 5.1 and Log4j 1.2.
Confidential
Java Developer
Responsibilities:
- Understanding the business requirements and Implemented the MVC architecture.
- Web components developed using JSP, Servlets, and JDBC.
- Developed Stateless Session EJBs to accommodate the business logic as per the business requirement.
- Applied J2EE design patterns like Business Delegate, Service Locator, Value Objects, DAO, Singleton etc
- Deployed and tested the application using WebSphere Application Server.
- Writing SQL queries to fetch the business data using Oracle as database.
- Log4j used for logging the application log of the running system to trace the errors and certain automated routine functions.
- VSS was used as configuration management tool.
Environment: Java 1.4, JSP 1.2, Servlets 2.3, EJB 2.0, JDBC, IBM WebSphere Application Server 6.1, VSS, Toad, Oracle 9i.