SUMMARY:

• Competent, highly motivated IT Professional with 20+ hands - on experience in all aspects of Software Development Life Cycle (SDLC)
• 15+ years of experience as a Business Analyst/Project Manager working in the Software Development Industry, specializing in requirement management, documentation and project coordination. 5+ years of experience as a Programmer Analyst
• Experience in Waterfall and Agile Software Development Methodology
• Participated in multi-tiered architecture JAD requirements review sessions. Worked extensively on Business Requirements elicitation, Business Process Modeling, Risk analysis, Data Analysis, Statistical Analysis, Big Data Analysis and development of e-commerce functional requirements specifications
• Extensive experience in SQL queries for data analysis, design and reporting, querying database, or using tools such as Database Workbench, Cognos. Expertise in the creation of complex reports.
• Proficient with Data modeling using UML
• Expert in writing Business Requirements Document (BRD), Systems Requirement Document (SRD), Functional Requirements Document (FRD), non-functional requirements (NFR), High Level Design (HLD), Application Interface Design (AID), logical data modeling (LDM), Release Notes, Interface agreements, GUI designs documents
• Updated requirements in Confidential Rational tools such as ReqPro, PRISM, ClearQuest, iRISE
• Experience in supporting and resolving production, ORT, ST, UAT, PDU, controlled introduction and general availability issues during SDLC. Support Test Cases review, DEMO for stakeholders
• Providing data expertise to customers, responding to ad hoc requests, including analysis of data in source systems using SQL queries, data warehouse and assessment of information
• Experience in project management. Recognized as decision-maker and team player with excellent work ethic and ability to communicate technical information to non-technical personnel
• Demonstrated outstanding problem identification, and resolution skills
• Proven ability to work effectively under pressure within tight deadline constraints. Constantly learns new skills and accepts challenges, ability to work effectively in cross-functional and geographically diverse teams
• Excellent presentation, written and verbal communication skills, outstanding organizational and time management skills

TECHNICAL SKILLS:

MS Windows, MS PowerPoint, MS Excel, MS Visual Studio, SQL, PRISM, reqPRO, Confidential Rational ClearQuest, iRise, Agile, Rally, Clarity, JIRA, Confidential, Accounting (Balance sheet, Netting, Reconciliation), Confidential Cognos, JAVA, C++, GUI, HTML, CSS, Java Script, VB, VB Script, ASP, JSP, JDBC, XML, UNIX, Stored Procedures, Webservices, MS Access, Confidential, JCL, COBOL, JCL, ORACLE, DB2, Confidential Mainframe, MS SQL, MySQL, WebSphere

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, NJ

Business Analyst/Systems Engineer

Responsibilities:

• Responsible for system requirements for Confidential Mobility RDs (rapid development). Created about 30 user stories different complexity, quick implementation of which allowed business to accomplish their immediate needs. Running SQL queries for data analysis and design in the production environment, Expertise in the creation of complex reports Supported Mobility rapid development SDLC using Agile methodology.
• Participated in designing No Touch Auto disconnect process workflow using Confidential modeler. For work orders with type “Disconnect” Confidential automated the process with VFO system using disconnect notification Request to VFO which will replace the existing AUTO or Manual ASR issuance.
• Participated in ECOMP (Enhanced Control, Orchestration, Management and Policy) project.

Confidential, Warren, NJ

Project Manager/Business Analyst

Responsibilities:

• Datameter on iPhone, iPad, Android project. Data Meter Widget displays data usage and allowance information directly on the widget face with data usage updates in real-time or near real-time. Customers could also view shared data usage as well as line level usage
• Data Meter Dashboard project. Data Meter Dashboard is centralized application which supports monitoring, statistics, reporting, alerting functionality for DataMeter
• Participated in Big Data analytics project. Designed data modules that convert underlying raw data to more readily usable formats for reporting, statistical analysis, and customer actions prediction. Extract data using SQL tools from different sources and load to Hadoop to perform analysis
• Self Service Action project. The Self Service Action in a Web Portal that allows users to send Push Notifications to Confidential Customers, to send real time transactions on demand using open API. These push notifications will provide Confidential customers with useful information about their account, promotions, and account maintenance information regarding their Confidential Service. Portal users will also be able to manage their applications certificates and the push capability of their application.

Confidential, Middletown, NJ

Business Analyst/Systems Engineer

Responsibilities:

• Collaborated with business and IT partners to facilitate and manage the end-to-end development of technical requirements for complex initiatives impacting multiple business areas, functions and system platforms at Confidential . Coordinated changes and updates to end-to-end technical requirements, business rules and use cases at each re-iteration of design. Served as a mentor and as an example to other technical analysts with providing best practice around requirement management and process
• Participated in design of 134 projects different complexity. Have lead 40 projects.
• Expert in defining TR3 requirements for ordering in Confidential and interfacing applications, expert in negotiation and designing interfaces with upstream and downstream systems.
• Created system documents including HLD, AID, Release Notes, Interface agreements, logical data base designs, GUI design, client/server design, defect sheets, process items. Updated requirements in Confidential tools such as ReqPro, PRISM, ClearQuest, iRISE
• Successfully resolved production, ORT, ST, UAT, PDU, regression testing, controlled introduction and general availability of software issues during SDLC. Have written and verbal appreciation from ORT and production support managers.
• Successfully completed project “ Confidential Migration base solution”. With the introduction of this project, it will be possible to rehome MLPPP, or MARO circuits with PL access.

Confidential, Jersey City, NJ

Programmer Analyst

Responsibilities:

• Involved in design, development, testing, and implementation of the application.
• Run SQL queries in DB using TOAD to extract and analyze data attributes
• Converted HTML pages to JSP pages. Used session implicit object to handle user sessions.
• Developed JDAO - java database access object, which provides connection to the Oracle database, executes appropriate query, formats result list as an Array List, sends it back to the calling module, closes the connection
• Recorded any users actions (accept or reject of terms and conditions) in Oracle database Audit table using SQL
• Used JavaScript for Client side validations, to pass hidden parameters to the Controller, to close window if user rejects Terms and Conditions, to invalidate session on exit, to enable back button, to disable right click, etc.
• Converted Word documents to secure PDF files to display in separate window when user clicks on Package Insert link. Displayed URL dynamically using Oracle database location field.
• Composed test cases, completed unit testing, provided QA test support for CTR.

Environment: Java, JSP, J2EE, Servlets, EJB, JDBC, HTML, WebSphere, CSS, Java Script, Oracle, Windows

Confidential, Middletown, NJ

Business Analyst/Project Manager

Responsibilities:

• Managed/defined/designed/wrote detail requirements, translated business requirements into systems solutions and engineered systems requirements.
• Elicited requirements using techniques including process descriptions/flows, use cases, scenarios, business analysis, task and workflow analysis. Coordinated changes and updates to end-to-end technical requirements, business rules and use cases at each re-iteration of design. Serves as the conduit between the partners and the software development team Determined impact to existing systems from the given business requirements Collaborated with various stakeholders and drove technical planning, design and architectural decisions, impact analysis, validation and business approvals
• Designed web based “IPC Manager Worklist”. IPC Managers using this work-list are able to update primary IPC for the selected Country, reassign the order to selected IPC, view selected order detail screen.
• Participated in design of GAIM (Global Access Invoice Management) financial system

Confidential, Indianapolis, IN

Programmer Analyst

Responsibilities:

• Served as member of Customer Relations Online System Support Team
• Responsible for Confidential online programs of Confidential, supported regular enrollments from 27 agencies as well as web site enrollments
• Confidential has been bringing people and music together for over 50 years. The company is the largest direct-to-customer distributor of music in the world and has millions of members across its various genre-based music clubs.
• Developing/modifying online system to allow more options to automatically send appropriate correspondence to customers.
• Redesigned online application SVMU (Sales Vehicle Maintenance Utility) allowing additional sources on multiple screens instead of one screen.
• Redesigned complex application: “Fraud table maintenance” from CSP to Confidential adding new features and multiple functionalities, allowing add, change, delete, and browse DB2 fraud table/improving efficiency by reducing number of DB2 cursors from 80 to 2.
• Designed Opt In/Out Project developing online and batch processing to keep web site and mainframe data in sync on DB2 tables.
• Identified and resolved productions problems modifying SVMU applications to block invalid source plan combinations and to update DB2 files accurately. Analyzed existing production data using SQL queries.
• Provided vendor support allowing 13 agencies to be enrolled through batch enrollment processing.
• Successfully provided production support of Confidential

Environment: Confidential Mainframe, COBOL2, DB2, SQL, Confidential, SPUFI, MVS OS/390, MVS/JCL, VSAM, TSO/ISPF, FILEAID, EXPEDITOR

Confidential, Indianapolis, IN

Programmer Analyst

Responsibilities:

• Designed Confidential application, which allows update association status field on VSAM master file.
• Redesigned Homeowners and Personal Auto Profile Reports adding “Payroll Deduct” as an option under Billing Method.
• Developed reports, charts and graphs to analyze critical data using SQL
• Participated in General Ledger project: consolidate data from separate ledgers, maintain separate ledgers at department level, monthly consolidated and departmentalized financial statements, monthly reconciliation statements
• State expansion project to include Virginia and Maryland
• Completed rate change modifications to Homeowner VIP Program
• Redesigned Data Warehouse Claim Counts Program and DLM Series Program making corrections and producing same totals of claim counts. Analyzed existing production data using SQL queries
• Completed 1099 Freedom ASCII-download project producing download files to satisfy 1099 form for Internal Revenue Services reporting.
• Successfully completed MCCI Refund Project allowing premium refunds to Michigan policyholders after state rules changed.
• Successfully provided production support.
• Res for converting COBOL and ASSEMBLER, Confidential, and batch applications including Commercial Declarations for Y2K

Environment: Confidential Mainframe, Assembler, COBOL2, DB2, SQL, Confidential, SPUFI, MVS OS/390, MVS/JCL, VSAM, TSO/ISPF, FILEAID, EXPEDITOR, Easytrieve, Syncsort, Stored Procedures