Applications Consultant Resume
Chicago, IL
SUMMARY
- 5+ years of Project Management and Technical Lead experience with proven track record in leading and delivering software solutions of varying scale and scope.
- Experience leading/delivering enterprise software solution projects.
- Highly effective in global and cross - functional environments, offering a unique combination of strategic problem solving, creativity, and analytical skill with the ability to create cost-effective solutions for internal and external clients.
- Adept at overseeing all facets of project lifecycle, including initiation and planning; change, risk, and issue management; and guiding development and QA teams.
- Proven leader effective in managing technicalteams (onsite and offshore).
- Strong understanding of Agile software development, SDLC, and business analysis practices.
- Solid project planning, scoping, scheduling, and budgeting skills.
- Strong documentation and reporting skills.
- Excellent interpersonal, collaboration, problem solving and conflict resolution/management skills.
PROFESSIONAL EXPERIENCE
Applications Consultant
Confidential, Chicago, IL
Environment: MS Project, PowerBuilder 9.0, Oracle 11g (Exadata), Sybase 12.x, C++, JDK 1.5, Business Objects XI, Oracle SQL Developer, PVCS, MS Office, ITSM Remedy 7.0, UNIX & Windows XP
Responsibilities:
- Delivering applications that meet user expectations relative to performance, scalability, fault tolerance, usability, and data integrity.
- Achieve individual and team objectives by delivering work products within time, budget and risk parameters even in the face of obstacles.
- Manage and Implement multiple enhancement projects successfully for various applications using traditional Waterfall SDLC Methodology and Agile Scrum Methodology.
- Manage and coordinate activities of onshore/offshore consultants for the execution and successful implementation of several new project initiatives and production support issues.
- Diligently monitor actual hours and cost being booked for that project on all the timekeeping tools.
- Provide timely status reporting based on the needs of the business partners, sponsors or technology partners.
- Establish the timelines and create the project plan for various project initiatives.
- Work with product partners and external clients from across the globe to define the requirements.
- Develop prototype/Proof of Concept. Translate user requirements into prototypes that illustrate the final result, thereby ensuring understanding of the deliverable.
- Identify and reduce risks. Document points of risk identified through analysis of application process and data flow. Propose risk mitigation measures.
- Respond quickly to production issues. Assume ownership and take responsibility to ensure the issue is resolved. Ensure systems run accurately on holidays.
- Timely and clear escalation to management of the issue, actions being taken, target resolution time and all business/IT impacts.
- Participate in design and coding walkthroughs for projects.
- Act as a liaison to the other systems areas, provide technical guidance and can lead project development effort as needed.
- Ensure all project documentation is properly completed and stored in a centralized location.
- Develop cost/benefit analyses and determine recommended solutions in conjunction with senior management.
- Architect technical solutions and act as Technical Lead for various project initiatives.
- Develop technical/detailed design documents.
- Hands on design and development for project initiatives with highest standards using PowerBuilder, Oracle PL/SQL, and C #.NET when required.
- Implement processes to efficiently manage the release of code.
Sr. Programmer Analyst
Confidential, San Francisco, CA
Environment: PowerBuilder 8.0, DB2, CICS, COBOL, Oracle 9i, Sybase SQL Adaptive Server, MS Visual Studio 2003, C#, MS Visual C++ 5.0/6.0, UNIX & Windows XP
Responsibilities:
- Oversaw the conversion of GUS system from PowerBuilder 8.0 to MS .NET environment.
- Provided technical guidance and lead project development effort as needed to junior resources.
- Involved in development, unit testing and deployment of GUS.
- Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation for creating objects, writing scripts and functions.
- Responsible for creating and modifying Windows, Window functions, User Objects, UO functions, User Events and DataWindow.
- Responsible for modification and enhancement of C++ codes
- Part of production support team.
Confidential, San Francisco, CA
Environment: Java - JDK 1.4, JBuilder 9.0, JDBC, PowerBuilder 9.0/8.0, Oracle 9i, PL/SQL, SQL Navigator, TOAD, MQ Series, StarTeam, UNIX & Windows NT
Responsibilities:
- Involved in Design, Development, Unit Testing and Deployment of Mercury Phase III Part 2 and 3.
- Responsible for developing Proof of Concept to call Java methods from PowerBuilder 9.0 and implementing PB to Java connectivity.
- Developed PowerBuilder code and proxy objects that call Java methods, which validates data and returns it back to PowerBuilder GUI.
- Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation for creating PB objects, writing PB scripts and functions.
- Responsible new Windows, window functions, User Objects, UO functions, User Events and new DW.
- Responsible for migrating application from PB 8.0 to PB 9.0.
- Wrote complex SQL queries and Oracle stored procedures.
- Performed the role of new version release manager.
Confidential, Bridgewater, NJ
Environment: PowerBuilder 6.5, Oracle 8.x, PL/SQL, JSP, JavaScript, JDBC, HTML & Windows NT 4.0
Responsibilities:
- Interviewing the end users to gather requirements and prepare functional and design specifications documents.
- Used OOPs concepts e.g. Inheritance, Polymorphism and Encapsulation for creating objects, writing scripts and functions.
- Coding stored procedures and complex SQL scripts which are used as data source by the PowerBuilder report objects or to build data into the tables.
- Responsible for rewriting/enhancing existing PowerBuilder reports.
- Coded Visual/Non-Visual user objects, UO functions, Window functions and User events.
- Responsible for creating Java Server Pages Web Reports for the Samples Report application using JSP, JavaScript and HTML.
Confidential, Parsippany, NJ
Environment: MS SQL Server 2000, DB2, MS Visual Basic 6.0, Active X, ASP 3.0, MS Visual Interdev, Site Server, PowerBuilder 8.0/7.0, PFC, Visio, & MS Windows 2000.
Responsibilities:
- Responsible for data analysis and writing MS SQL Server T-SQL stored procedures, triggers and SQL scripts in the data mart integration project.
- Involved in the support and maintenance of Sales Force Automation application developed using PowerBuilder 8.0/7.0, PFC and MS SQL Server 2000.
- Involved in the migration and maintenance of the application from PowerBuilder version 7.0 to 8.0.
- Developed COM Objects using VB 6.0 for the Kraft Enterprise Portal keeping in view the type of transaction (Required or supported).
Confidential, Atlanta, GA
Environment: PowerBuilder 7.0, PFC, Sybase 12 Direct Connect, Sybase T-SQL, Oracle 8i/Gateway, PL/SQL, DB2, PVCS, Windows API, UNIX & Windows NT/95
Responsibilities:
- Writing functional specifications and user requirements document.
- Was involved in the evaluation for PowerBuilder version 8.0 extensively.
- Coded complex PowerBuilder screens.
- Responsible for writing DB stored procedures, functions and SQL scripts
- Used a variety of PFC Services e.g. application, data window, non-visual objects and windows.
- Used Windows API calls through non-visual user objects to enable deployment of new code and objects between two major application releases.
- Provided user training
Confidential, Atlanta, GA
Environment: PowerBuilder 6.5/PFC, Oracle 7.3/8i, PL/SQL, MS SQL Server 6.5, T-SQL, SQL Navigator 3.0, AS/400, ERWin 3.0, MS Excel, Visio, UNIX & Windows 95/NT
Responsibilities:
- Designed the PPV application to automate the processes involved in generating invoices for various vendors.
- Used a variety of PFC Services e.g. application, data window, non-visual objects and windows.
- Developed all the screens, data windows, user objects, functions and reports.
- Wrote DB stored procedures and SQL scripts (team of 2).
- Used ERWin 3.0 for database engineering and data modeling.
- Provided user training.
Confidential, Pittsburgh, PA
Environment: PowerBuilder 6.5, C++, Oracle 7.3, Sybase 11, Sybase T-SQL, DB2, ERWin 3.0 & Windows NT
Responsibilities:
- Created various user objects for the upload module of the data from Sybase or Oracle databases to the mainframe system and vice versa.
- Wrote SQL scripts for RICS database schema and used ERWin 3.0 for data modeling.
- Performed unit testing and created system documents for the application.
Confidential, Santa Monica, CA
Environment: PowerBuilder 5.0/6.0, Sybase 11, Sybase T-SQL, Rapid SQL, 6.0, MS Excel, UNIX & Windows NT 4.0
Responsibilities:
- Created PowerBuilder reports for four rating types and ad hoc reports.
- Primarily used Infomaker 6.0 to generate reports.
- Responsible for testing FRED to ensure it delivered the correct output, which was reflected in the reports. Tested all the report modules rigorously.
Sr. Programmer
Confidential
Environment: PowerBuilder 5.0, PFC, Oracle 7.x, Sybase SQL Anywhere & Windows 95
Responsibilities:
- Designed, developed, tested and implemented Custom and Central Exercise, FOREX and Payroll system applications.
- Coded and tested the various complex screens of the front end application in PowerBuilder.
- Created and coded various PowerBuilder reports.
- Wrote DB stored procedures and SQL scripts.
Programmer
Confidential
Environment: PowerBuilder 4.0, Watcom SQL Server & Windows 3.1
Responsibilities:
- Coded the various complex screens of the front-end application in PowerBuilder.
- Created and coded various PowerBuilder reports.
- Involved in unit testing of the applications