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 e-commerce 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 DB tools. Expertise in the creation of complex reports
• . Proficient with Data modeling using UML
• Expert in writing web services REST or SOAP interfaces to pass data between applications
• 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, User Guides, Interface agreements, GUI designs documents
• Updated requirements in Confidential Rational tools such as ReqPro, PRISM, ClearQuest, iRISE
• Experience in supporting and resolving ST, UAT, ORT, and production 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

TECHNICAL SKILLS:

Platforms: MS Windows, MS PowerPoint, MS Excel, MS Visual Studio, SQL, PRISM, reqPRO, Confidential Rational ClearQuest, iRise, Agile, Rally, Clarity, JIRA, Sharepoint, Camunda, Confidential Cognos, Informatica, JAVA, C++, GUI, HTML, CSS, Java Script, VB, VB Script, ASP, JSP, JDBC, XML, UNIX, Webservices, JSON, REST, SOAP, CICS, JCL, COBOL, JCL, ORACLE, DB2, Confidential Mainframe, MS SQL, MySQL, MS Office Suit

PROFESSIONAL EXPERIENCE:

Confidential - Middletown, NJ

Business Analyst/Data Analyst

Responsibilities:

• Responsible for system requirements for CANOPI 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 using Cognos. Supported Mobility rapid development SDLC
• Participated in extensive CAMUNDA
• Designed No Touch Auto disconnect process workflow. For work orders with type “Disconnect” CANOPI automated the process with VFO system using disconnect notification Request to VFO which will replace the existing AUTO or Manual ASR issuance. Using REST web services API to communicate between CANOPI and VFO.
• 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 - data integration 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 from different sources using ETL tool - INFORMAICA, and load to Hadoop to perform analysis and prediction
• 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 s and the push capability of their application.

Confidential - Middletown, NJ

Business Analyst

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 AT&T. 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 writing user stories for agile project. Wrote about 120 user stories different complexity using JIRA tool
• Expert in defining TR3 requirements for ordering in USRP and interfacing applications, expert in negotiation and designing web services REST or SOAP 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 AT&T 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 “PNT Migration base solution”. With the introduction of this project, it will be possible to rehome MLPPP, or MARO circuits with PL access.
• Rehome of MLPPP group (up to 8 circuits) will be done simultaneously, using common for the group Wan Link IP Address, or Virtual Port Assignment ID. Connection of the MARO, nested MARO will be displayed in separate “USRP Rehome-IP Service” screen, and will be sent to INSTAR in the same order. INSTAR will process one group (leg) per transaction.
• Successfully completed project “BVOIP CNR Modify Capability”. Two interfaces were modified for this project: IPGW-EFMS, and IPGW-CADM. Depending on new CNR indicator received from EFMS, USRP will identify “Customer is Not Ready” orders, and will pass it to CADM, so that customer will be billed for the time when Confidential provided the capability for test and turn up, but customer was not ready to T&T. By completing this project I have helped to generate revenue to AT&T.

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.

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
• Expert in writing XML, or web services interfaces to pass data between applications
• Developed reports, charts and graphs to analyze critical data using Cognos tool
• 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 accounting billing system - complex application on Oracle database
• Responsible for General Ledger project: consolidate data from separate ledgers, maintain separate ledgers at department level, monthly consolidated and departmentalized financial statements, monthly reconciliation statements

Environment: Java, JSP, HTML, CSS, Java Script, Oracle, MS Windows, MS PowerPoint, MS Excel, MS Visual Studio, SQL, PRISM

Confidential - Indianapolis, IN

Programmer Analyst

Responsibilities:

• Developed “Web-$9.99 Club” project to accept additional CNE enrollments from the new web site using object-oriented methodology to access DB2 tables
• 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 CICS 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. Extensively used SQL.
• 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 New Member Enrollment System

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

Confidential - Indianapolis, IN

Programmer Analyst

Responsibilities:

• Designed CICS 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
• 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, CICS, and batch applications including Commercial Declarations for Y2K

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