Senior Systems Analyst Resume Profile
Newark, DE
Specialization
ASA 7 with replication
Other:
|
Profile Summary
Hands-on senior software professional having excellent leadership communication skills. 12 years of experience working in industries like finance, insurance pharmaceuticals involving large geographically distributed teams. Also possess sufficient experience in project planning, execution, monitoring client reporting.
Professional Experience and Accomplishments
Confidential
Senior Systems Analyst
Brief Description: Confidential has a state-of-the-art real time mortgage originations system. It allowed PHH mortgage consultants to gather all customer information over the phone or thru the web, in real time and provide a mortgage quotation from internal as well as external agencies such as FNMAE, FREDDIEMAC, Merrill Lynch, and Charles Schwab etc. This system had the ability to interact with other systems across platforms using PowerBuilder with built-in java class calls. It was one of the most complex and vital system for PHH mortgage and requires support 24/7.
Technical Environment: PowerBuilder 11.x/12.x, Informatica 9.x, Sybase ASE 12.x, Oracle 12.x, Star Team 2.0, Rapid SQL 7.x,, Borland Caliber RM, MS Visio. MS Project, HP-QC 11.x, Oracle 8.x/9i, SQL Server 2005, Toad, T-SQL/PL-SQL
Confidential
Role: Conducting discovery meetings with Subject Matter Experts SME to gain a broad understanding of legacy applications. Performing detailed analysis of each application and preparing a high-level migration timeline. For each legacy application, identified a summary of business context and migration risks. Proposed the best assessed Migration Strategy for each application involved. Revised and discussed strategies for high volume Sybase database objects such as stored Procedures triggers. Deliberated viable migration strategy to maintain compatibility between Sybase proposed PowerBuilder upgrade
Technical Environment: PowerBuilder 12.x/11.x/9.x, Oracle 9.x, PB Analyzer 4.9, MS Office 2007, MS Visual SourceSafe, Sybase ASE 12.5, IBM Rational Application Development Eclipse , , T-SQL/PL-SQL
Confidential
Role: Involved from early stages including requirement gathering and functional design, of major enhancement initiative of proprietary Contract Management Application for one of the largest pharmaceutical companies and Double Diamond Accenture customer, in US. These enhancements allowed client to expand its capabilities associated with Sales Based Contracts SBC , Usage Based Contracts UBC and Government contracts. It made feasible for users to not only create but also maintain in the image repository a copy of the customized or third-party contracts It cohesively interacted with existing external contract template development tool and generated MIS reports by sharing data with other contract management utilities across the company . Intrinsically involved in design/development phases of Software Development Life Cycle. Responsible for enhancing existing application code and modifyng objects to ensure all functional and technical requirements are met optimally. In addition, as a senior member of the project responsible for gaining a general understanding of all external interacting systems. Reached out and worked with other team members to help them accurately understand business and functional requirements in context with the enhancements being targeted for the project. Helped in providing an insight on best policies for project at hand and proposed ideas that can provide best value to the customer.Job profile included modifying fine tuning Sybase database objects such as stored procedures, functions, triggers, indices to improve and enhance functionality.
Technical Environment: PowerBuilder 11.x, MS Visio. MS Project, Windows XP, Oracle 9i, Toad 7.5, Sybase ASE 12.5, Oracle 10.x, DB Artisan, Crystal Reports 9.x, , T-SQL/PL-SQL
Confidential
Role: As the lead and prime database personnel, provided for implicit integrity routines coding of all database object functions to interact with Java classes. Extensively involved in regular client co-ordination to enhance state of the art rule based engine self-appraising life insurance quotation system.
Result: Successful implementation of NBP-II acted as a working prototype for future risk assessment solution sought by John Hancock Financial Services. It helped propel further new project concepts that made John Hancock consolidate its lead in life insurance market.
Technical Environment: Oracle 8i dB/ 8.0, Client, NAS 4.x, Java Beans 4.x and Business Object 4.x , T-SQL