SUMMARY:

• Senior Systems Analyst with over 18 years in the software industry analyzing design, development and implementation of innovative business process and system solutions using different Software Development Life Cycle (SDLC) methodologies.
• Demonstrated ability to develop customized applications in a project - oriented environment with aggressive deadlines, working as a team leader.
• Expertise in developing and implementing test plan and test cases.
• Seeking a challenging position using strong analytical and problem-solving skills to facilitate healthy communication between the client and IT department.

TECHNICAL SKILLS:

Languages: C#, VB, VB.Net, ASP.Net, MS Office VBA, JavaScript, VBScript, HTML, SQL, Transact-SQL, PERL, AngularJS

MS Windows, MS Office Add: Ins, WinForms, WebForms, WebAPI, Web services, WCF, REST, Visual Studio .NET, MS Access, MS Excel, MS Word, MS Power Point, MS Visio, MS SQL Server including SSIS, SSRS, SSAS, Sybase, Crystal Reports, IBM Cognos (BI, Reporting, Administration), IBM Lotus Notes, TFS, PVCS, Visual Source Safe, ALM, Autosys, ODBC, IIS, WebEx;

Object: Oriented Analysis & Design (OOAD), Waterfall, Spiral and Agile Approaches, Prototyping Approach, Integrated Software Development.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Senior Specialist, System Development

Responsibilities:

• Enhanced existing applications by changing front-end and code behind according to industry’s best practices and recommendations, standardized look-and-feel across custom built applications using different Software Development Life Cycles (SDLC) methodologies best suited to each project: Waterfall, Spiral, and Agile.
• Tuned underlined SQL Server components, including creation of proper keys and indexes, re-worked stored procedures, created views, created and tuned Data Transformation Packages -DTS- using SSIS, etc.
• Played key role in converting applications to support IE11 and Office 2013.
• Served as project manager, lead developer and/or team member on dozens of application development projects. Led the research, design, development, documentation, testing and rollout of enterprise applications. Coordinated and led knowledge transfer for overseas testers (using life and recorded WebEx sessions).
• Initiated Test Driven Development (TDD) concepts, defined overall testing strategy, created test plans and executed number of test cases using HP ALM. Decreased application release defect rating (from 0.75% to 0.2%)
• Developed and standardized departmental procedures and policies on defining Business Requirements Documents (BRD). Reviewed and integrated Systems Requirements Specification or Document sections (SRS or SRD) based on BRD, using custom made automated Excel templates. Used for training new team members saving time and revenue.
• Initiated Language Specifics and Coding Standards for team use including sections: C#.NET in Code Behind, JavaScript in Client Side Scripting, MS SQL Database design, Web Forms Look-and-Feel, Cognos Models and Reports and Software Documentation delivering reliable software with reduced time in future enhancements and/or maintenance.
• Led offshore team in upgrading Cognos v8 to Cognos v10 including redesigning models and reports to improve performance and maintenance (reports runtime reduced up to 30%).
• Oversaw offshore developers, performed code review and provided development support of Transaction Information Ticket Allocation system (TITAN) written in C# with advanced use of Ajax and MS SQL database with advance use of SSIS, SSRS and SSAS to perform daily and on-demand data load/extract ensuring integrity of the code and meeting application requirements.
• Developed departmental Business Continuation (BC) plans, policies and procedures. Performed Production and BC server configuration.
• Automated previously manually operated Excel Title Tracking spreadsheet using VBA macros to streamline data comparison, entry and updates enriched with dynamic quantitative/qualitative statistics, color coded error-checking and inclusion of data protection. Automation saved hours (5 hours down to minutes) in monthly processing.

Specialist, System Development

Confidential

Responsibilities:

• Played different roles during years from team developer to project lead.
• Primary responsibilities include gathering requirements, design and development of server code, web forms, client side scripting, database design and report creation of many (over 15) financial related applications written in C#.NET, JavaScript, Ajax, JSON, VBA, SQL Server 2000/2008 (with intermediate use of SSIS) and Cognos Reports using object oriented programming (OOP) concepts.
• In addition served as primary coordinator for vendor financial product Confidential - the first software system dedicated to secondary loan trading.
• LoanTrak supports multiple traders, portfolios, locations and currencies.
• LoanTrak provides a global view of the business for senior management and market-specific functionality for traders, salespeople and closers. LoanTrak used for both Private and Public business lines in PCG.
• Developed, tested and scheduled nearly 100 of inbound and outbound data feeds including data processing using SSIS, SSRS, SSAS tools, archived source files, and data uploads. Implemented advanced control system with automatic e-mail notification of data accuracy and process completion.
• Automatically delivered reports for domestic and international based groups for weekly, monthly and quarterly financial and future strategy planning meetings.
• Scheduled, coordinated and maintained production releases between internal and external groups to ensure users get all updates timely and painless. Overall release process time reduced by 25%.
• Built hundreds of custom queries and reports to retrieve data for analysis and making business decision.
• Provided full technical support through the lifetime of the product. Coordinated and performed retirement of the application and data migration to newly purchased software.

Developer, Reporting Team Lead

Confidential

Responsibilities:

• Developed Consolidated Asset Management Private Placement SystemWeb based application written using ASP, HTML, DHTML, JavaScript, AJAX, Web Services, and MS SQL Server. Confidential is populated with data from several sources, including PAM & PeopleSoft.
• Additionally designed, developed and tested new financial system Confidential using VisualStudio 2003 (VB.NET, VBScripts, JavaScripts, WebServers), MS SQL 2000.
• Confidential is an application supporting commercial mortgage origination and asset management.
• It is used by PMCC origination and servicing staff in over 15 domestic Confidential offices to manage our commercial lending efforts.
• Major application functions include transaction entry, reporting and document management which support lending activities .
• Achieved an OWL Awarded (Team award for Confidential Application)
• Implemented unique document management system using MS Word and MS Excel SDK - satellite of Confidential, which allowed creation of very personalized letters to customers on fly (not using pre-typed template) with an ability to insert data directly from database including but not limited to customer names, company names, addresses, and financial information. Data was available on side bar and inserted in document using XML tags - drag-and-drop technique. This system was extremely helpful in reducing misspells and errors caused by human factor as well as reducing overall time for document preparation.
• Lead offshore development team to convert and consolidate over 300 reports built using different reporting systems (Crystal Reports, Active Reports, Cognos Impromptu 6) into one reporting repository.
• Installed and configured SQL, Cognos BI and IIS servers on production, QA, UA, BC and development environments to ensure system match and secure data with proper access for business users.
• Played main role in troubleshooting and technical customer support in Newark office while development headquarter was moved to Dallas - helped both business and IT team save time and money on support and maintenance cost.

System Developer

Confidential

Responsibilities:

• Performed architectural design, data modeling and implementation of VB 4.0/5.0/6.0 forms, modules, classes, IN-PROCESS and OUT-OF-PROCESS OLE Servers based on the 3-tier COM/DCOM architecture and ADO/RDO/DAO data access, Sybase System-11.5 and MS SQL Server 6.5/7.0 tables, indexes, conversion scripts, stored procedures, views, rules, cursors, temporary tables, triggers, and dynamic SQL statements and cursors, MS ACCESS 2000 databases, forms, classes, modules, macros and queries, MS Excel Workbooks and VBA code modules, and Crystal Reports 5.0/6.0/7.0 reports for the TEAMS (Trade Entry and Asset Management System) at Investments division of the financial company Confidential .
• System is being used to track processing of Asset-backed securities (ABS) like equities, private and commercial mortgages, from the initial contact with a potential borrower to the final loan disposition.
• Achieved Best Application Award (team award).
• Developed over 75 SQL Conversion Scripts for integration with the PAM (Princeton Financials Accounting System)
• Designed and implemented Report Module (over 100 built-in and standalone reports) using Crystal Reports 8.0.
• Performed debugging, fine-tuning and trouble-shooting of Sybase and SQL Server stored procedures and triggers to achieve best application performance and enforce data integrity.

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Provided object-oriented design, programming and implementation support of the unique tracking system for moving companies, written in VB4/VB5 and MS Access.
• System provided full cycle of cargo flow including short and long term storage service, trucks time tracking service.
• Stored client’s contacts and interactive reminders to the scheduled events.