PROFESSIONAL SUMMARY:

• 8 years of experience in IT Project Management handing project planning, resource allocation, project governance, risk management and stakeholder communication.
• Around 12 years of IT experience as a Business System Analyst in SDLC: analysis, design, development, deployment, testing, and implementation of projectsforvarious businessand finance organizations.
• Worked on different SDLC Methodologies including Waterfall, Agile, RUP, Scrumand IDEF.
• Good knowledge about Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to Tableau server and Tableau Online.
• Good expertise in for managing the project from inception to closure creating Project Plans, Project Matrix, Resource Sheets, RACI documents, Communication Plans, Training Plans, etc.
• Strong working experience in planning and carrying out of Teradata system upgrade initiatives, Data Warehousing, MPP(Multi parallel processing) and Large - Scale Database Management.
• Good knowledge and understanding of data modeling, data integration, data quality, and data cleansing concepts.
• Hands on experience using Teradata utilities (SQL, BTEQ, FastLoad, MultiLoad,FastExport, etc.)
• Expertise in preparing Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and Manual testing using Rational Test Manager.
• 5+ years of diversified experience Quality Assurance Testing working in all phases of testing life cycle.
• Excellent skills in Business Analysis, Data Analysis, GAP Analysis, Financial Data Analysis, Risk Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Expertise in Manual Testing and Automated Testing for Web and Client/Server applications on UNIX and Windows Platforms.
• Proficient in using UML for BusinessProcess Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them usingMS Visio.
• Good working knowledge of Service Oriented Architecture (SOA) standards-based design approach.
• Good expertise in creating Test Cases on the basis of product features, client requirements and technical documents. Developed, executed and maintained Test Scripts. Reviewed and documented system Test Plans.
• Ability to understand and interpret Entity Relationship Diagrams and document them.
• Proficiency with Rational Enterprise Suite (Requisite Pro, Rational Rose, Clear Case, Clear Quest) in support of the RUP methodology.
• Experience in Financial Industry with exposure to Automated Financial Systems, SWIFT messaging, FX Rates, Risk Analytics, STP Processing, Retail Banking, Treasury Management and Investment Banking
• Understanding of different Money Market Investment Tools including Treasury Bills, Bonds, Notes, CDs, and Commercial Papers.
• Good knowledge of Cash Management and Treasury Management services (Account Reconcilement Services, Positive Pay, ACH, Lockbox, Sweep Accounts, etc.) and tools (Fiserv, CheckFree, Fidelity Systems, etc)
• Understanding of Financial Statements, Options, Fixed Income Securities, Equities, Futures, Cash Flows, Financing Structures, Stock Valuation, Bond Pricing, and Hedge Funds, Derivatives.
• Experience in developing business and functional Requirements, including requirements traceability, categorization, and prioritization.
• Successfully worked on iterative offshore/onshore IT Business Development model.
• Proactive approach to streamline different IT efforts and also worked to set up core IT processes.
• Able to effectively converse, relate and liaise with multifunctional teams, including business owner, stake holders, mangers, architects, developers and testers at all levels.
• Good Interpersonal skills in listening, mentoring, coaching, negotiation, mediation, influencing, and conflict resolution.
• Strong communication, written and presentation skills.

TECHNICAL SKILLS:

Project Management Tools: MS Project, JIRA, Confluence, IceScrum, Replicon, Clarizen

Rational Tools: Rational-Rose, Requisite-Pro, Clear Case, Clear-Quest and Test-Manager.

DataModeling Tools: MS Visio, MS Word, MS Project, MS Excel, Enterprise Architect.

Databases: Oracle (8/9i and 10g), MS Access, MS SQL Server, Teradata, Netezza, Amazon Web Services (AWS), Redshift, Mongo, NoSQL

Business Intelligence: Tableau, Cognos, Business Objects, Microsoft RS, Adhoc Reports and Crystal Reports.

ETL Tools: Data-Stage, Informatica.

Testing Tools: Win-Runner, Load-Runner, Quality Center, Test Director, Quick Test Professional (QTP)

Operating Systems: UNIX, Solaris, Linux, Windows NT/2000/XP.

Other Tools: SnagIT, TIM/ TAM (Tivoli Identity Manager/ Tivoli Access Manager), Novell, Serengeti Tracker, Ariba Buyer, SAP Accounts Payable, TOAD, Adobe Campaign, Unica Interact, Java, J2EE

PROFESSIONAL EXPERIENCE:

Confidential, Arlington Heights, IL

Technology Project Manager/ Product Specialist/ Scrum Master

Responsibilities:

• Extensively used Clarity for creating project plans and drive, optimize and manage all plans while presenting alternate scenarios to continuously reduce overall critical path.
• Responsible for facilitating status reviews with all stakeholders updating project status and clarifying roles and responsibilities developing accurate, detailed consolidated reports to continuously manage expectations.
• Development of complex project budgets, manage resource plan to budget and reports planned vs. actual budget variances.
• Responsible for managing large complex high risk/high visibility projects for cross-functional global projects for multi-national companies.
• Use Project Management KPIs to track all portfolio and organization's strategy and ROI goals.
• Engagement Level Status Reporting including Clients VPs, Sr. VPs, CTO, CEO
• Support Product Owners in suggesting scrum tools and techniques that deliver expedited value
• Managing Project Managers, IT consultants, and implementation teams for successful completion of software development and mobile projects.
• Co-ordinate and manage work with multiple teams (10+) that are located in globally.
• Responsible for managing large sets of data and perform reporting using Cognos and Tableau
• Responsible for reviewing ETL code, creating Implementation Plans and supporting implementation activities.
• Responsible for working with Solution Architects, DBA’s and SQL Developers to provide Architectural Insight.
• Facilitated all scrum ceremonies - daily stand-up, sprint planning, sprint review, and retrospectives
• Worked with the team to ensure that all scrum artifacts (top priority backlog log items, sprint backlog, and burndown charts) were up-to-date. Extensively used JIRA.
• Assisted with refinement/grooming coordination and techniques for estimating/sizing
• Removed impediments to ensure that the team could continue to work towards completing sprint goals
• Prevented team distractions in order to keep the sprint focus on completing the features in the sprint
• Coached and Trained team on various agile frameworks (Scrum, XP, Kanban, Lean)
• Acted as the mediator between the development and leadership teams.
• Facilitated and coordinated and the Scrum of Scrums.
• Responsible for providing support for Product Owners, Development Team, and Organization as part of Sprint implementation.

Environment: Adobe Campaign, Teradata (12.X, 13.X, 14.X), IBM DataStage,Teradata SQL Assistant, Tableau, Control-M, GitHub Version Control, Visio, Micro Strategy 9.x, Scrum, HUB, MS Project, JIRA, Confluence, Mainframe, HADOOP, Date Governance and Data Lineage

Confidential, Dallas, TX

Senior Project Manager/ Implementation Consultant

Responsibilities:

• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Preformed end-end project planning, change management, risk management and implementation planning.
• Responsible for the complete AS-IS analysis of the NALP’sdepartments including domain knowledge, procedures, reports, third parties and data structures to derive the requirements.
• Responsible for documenting the process flows using MS Visio 2010 with UML specification.
• Responsible for performing GAP analysis on the existing process and suggest improvements as needed. departments' activities were transformed to ODOO ‘s ERP system and routine reporting activities were automated.
• Developed reports using ODOO’s reporting app as per the business needs.
• Developed the Business Requirements, Front-end mockups, Mapping document and File Specifications
• Responsible for base lining existing business processes and identifying key areas for improvement/ enhancement and driving a broader awareness of those areas.
• Responsible for performing data analysis and creating data structures using SQL.

Environment: OdooOpen Source ERP Platform (BPM, ERP, Reporting), .net, PHP, Java Script, MS Project, HADOOP, Python, PL/ SQL, NoSQL database.

Confidential, Chicago, IL

Technical Project Manager/ Tableau Developer/ Scrum Master

Responsibilities:

• Responsible for leading/ working on multiple initiatives for Targeted Interactions (TI) including nSegment (Member Segmentation), Campaign Mart, TI Mart, etc. following TI’s Scrum methodology.
• Involved in all he stages of scrum - sprint planning, daily stand ups, sprint review and sprint retrospective.
• Responsible for supervision of the nSegment project including - creating new nSegment(s) using SQL, driving new functionalities, reporting, business interactions/ project reporting and error reporting, etc.
• Extensively used Tableau 9.0 to develop, publish, re-design and maintain reports for multiple projects for TI.
• Developing dashboards as a part of the Self Service Offer Delivery project to replace manual creation of reports, which minimized their work from 8 hours to on-demand for various teams inside the organization.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Created interactive scheduled and live dashboardsin Tableau using Tableau Desktop pulling the data from Teradata, MySQL, MS Excel. Data blending and cross joins between databases, scheduling extract refresh and publishing to server.
• Extensively used SQL to Interpret data, analyze results using statistical techniques and providing KPIs to product managers and business analysts to improve the workflow. Analyzing the health data and deriving meaningful reports using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Facilitate stand-up meetings, JAD sessions, weekly status meetings, etc. as a part of multiple projects.
• Facilitate scrum meetings such as - grooming, sprint planning, retrospectives, daily stand-ups, etc.
• Protect team from over-commitment, manage backlog, and prioritize resolution of defects/bugs as evidenced by the on-time delivery.
• Manage the lifecycle of code development, from ideation to sprints to deployment.
• Communicate with other management, engineers, product managers and support specialists on product issues.
• Facilitate meetings to development of strategic plans for projects of high business complexity.
• Work closely with the Product Owner to maintain the Product Backlog and release plan for multiple TI projects
• Responsible for getting creating, modifications and approvals for project delivery artifacts (such as Project Scope document, Delivery plan, Implementation Plan, Change Request, CCMDB, etc.) for numerous tier projects within TI.
• Responsible for end-end project planning and monitoring (scope, design, development, delivery and technical approaches, risks, assumptions, staffing and scheduling, etc.)for various tier projects within TI.
• Monitors and report key project metrics for significant deviations in quality, cost, or schedule and identify areas of improvement.
• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Responsible for resource planning and allocation on the project (including getting approvals on resources, etc.)
• Responsible for overall success of the project including handling change management, stakeholder communication and project risk management.
• Responsible for managing the project from inception to closure creating Project Plans, Project Matrix, Resource Sheets, RACI documents, Communication Plans, Training Plans, etc.
• Responsible for maintaining the customer segmentation log for Sears’ N-segment functionality.
• Facilitated data requirements sessions for data migration efforts and assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica.
• Responsible for creating architecture diagrams, data flow diagrams co-ordinating with the Teradata DBA’s.
• Responsible for base lining existing business processes and identifying key areas for process improvement/ enhancement and driving a broader awareness of those areas.
• Developed the Business Requirements, Functional Requirements, Technical Design Specifications, Use Case Document, UML diagrams, Traceability Matrix, Minor Design Document (MDD) and Business decks presentations.
• Responsible for creating Datawarehousing artifacts such as - Reporting Dashboard mockups, Mapping document, File Specifications, Source to Target Documents, etc.
• Successfully completed a POC with HADOOP architecture for nSegment project.
• Responsible for gathering requirements for MicroStrategy Reporting platform which includes Canned Reports, Self-Service dashboards and Score Cards.
• Responsible for suggesting architecture best practices, providing deployment support, production support as a part of the project.
• Responsible for providing frequent status reports to the higher management regarding tasks, risks, pending decisions, impediments and release progress.
• Responsible for mentoring business analysts, other teams and mentoring (onshore and offshore).
• Responsible for project management activities such as business communication, status meetings, conflict resolution, task allocationprioritization and mentoring.
• Responsible for monitoring testing activities such as developing test scope, test plan & strategy, test cases and involved in multiple stages testing.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Working on Query designer to build the reports in the Web intelligence.
• Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.
• Created Multiple Universes in Designer in secure connection as well shared connection.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Created Technical and Design Documents, Test Consideration Documents, Run documents for new Reports and Universes.
• Responsible for creating, reviewing and implementing nSegments using SQL based on the business requirements.
• Responsible for reviewing the nSegment engine code (SQL/ Unix) for implementation of the system enhancements.
• Created multiple system requirements documents as a part of N-Segment functionality improvement.
• Responsible for maintaining the product backlog for log for Sears’ N-segment functionality and implementing as per agreed upon terms.
• Extensive worked on Self Service Audience Engine - creating wireframes, system requirements, test documents and user acceptance testing.
• Facilitated data requirements sessions for data migration efforts and assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica.
• Responsible for creating architecture diagrams, data flow diagrams co-ordinating with the Teradata DBA’s.
• Created and modifiedTeradata BTEQ scripts to load data from different databases to Target database to support MSTR/Tableau Reports.
• Responsible for supporting multiple applications and monitoring/ production support jobs in Control-M application scheduler.
• Worked with Micro Strategy for creating Liquidity and IncrementalityScorecards, Dashboards and Extensive reports

Environment: Adobe Campaign, Unica Interact, Teradata (12.X, 13.X, 14.X), IBM DataStage,Teradata SQL Assistant, Tableau, Control-M, GitHub Version Control, Visio, Micro Strategy 9.x, Scrum, IceScrum. HADOOP, MS Project, JIRA, Confluence, Amazon Web Services (AWS), Redshift, Java (Spring, SpringBoot).

Confidential, Charlotte, NC

Project Manager / Sr. Business Systems Analyst

Responsibilities:

• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Responsible for the complete AS-IS analysis of the Confidential ’s media sales business including domain knowledge, procedures, reports, third parties and data structuresto derive the requirements.
• Responsible for documenting the process flows using MS Visio 2010 with UML specification.
• Responsible for performing GAP analysis on the existing process and suggest improvements as needed.
• Responsible for preparing business decks for project scope verification and facilitating hands-on meeting with higher management to lock-in the scope of the project.
• Developed reports using Tableauand MicroStrategy for Operative Online and XGP.
• Responsible for leading the project through matrixed teams to ensure proper delivery of the project.
• Developed the Business Requirements, Reporting Dashboard mockups, Mapping document, File Specifications, Source to Target Documents, etc.
• Responsible for base lining existing business processes and identifying key areas for improvement/ enhancement and driving a broader awareness of those areas.
• Responsible for performing data analysis and creating data structures using SQL.

Environment: TOAD, SQL, Agile, Netezza, Informatica, MS Visio 2010, MicroStrategy, MS Project 2010, MS Excel 2010, MS Word 2010, Tableau, Micro Strategy

Confidential, San Rafael, CA

Project Manager/ Sr. Business Analyst

Responsibilities:

• Responsible for the complete AS-IS analysis of the Confidential ’s Legal department including policies, procedures, forms, cross dependencies and reports to derive the requirements.
• Responsible for documenting the process flows using MS Visio 2010 with UML specification.
• Developed the Business Requirements, Functional Requirements, Use Case Document, Traceability Matrix and Business deckspresentations.
• Responsible for performing GAP analysis on the existing process and suggest improvements as needed.
• Responsible for base lining existing business processes and identifying key areas for improvement/ enhancement and driving a broader awareness of those areas.
• Facilitated JAD sessions, requirement gathering workshops with the stakeholders as needed.
• Responsible for managing the project from inception to closure creating Project Plans, Project Matrix, RACI documents, Communication Plans, Training Plans, Resource Sheets, etc.
• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Provide appropriate and timely written and oral communications with allproject team members, department managers, and ITmanagement throughout the life of the project.
• Responsible for overall success of the project including handling change management, stakeholder communication and project risk management.
• Responsible for preparing the RFP document and negotiating the contract with the vendor Serengeti Law.
• Responsible for providing vision (including technical and business vision) and insight of the project with higher management, department heads, stakeholders through monthly meetings, business presentations and process flows to both technical and non-technical parties.
• Responsible for providing direction to the project by conducting project team meetings to gather project statusand guidance to the project team members information, track and prioritize tasks, etc.
• Participated in the user stories and sprint planning sessions hosted by security teams.
• Responsible for tracking, resolution and escalation of impediments during sprint planning.
• Responsible for providing frequent status reports to the higher management regarding tasks, risks, pending decisions, impediments and release progress.
• Facilitated agile development scrum stand-up meetings with the security and infrastructure teams.
• Ensure the project health/status metrics and performance indicators are accurate and communicated effectively to the higher management.
• Performed the role of being the primary customer contact between the project team, business partners, stakeholders and higher management. Mediates and resolves project team conflicts.
• Responsible for developing test scope, test plan & strategy, test cases and involved in multiple stages testing.
• Involved in various different testing roll outs such as Regression, Rolling Regression, UAT (User Acceptance Testing), etc.
• Extensively used SAP Business ObjectsWebi (Web Intelligence) to perform analysis on existing reports, functional dependencies with SAP Accounts Payable, SAP General Ledger (G/L).
• Responsible for creating custom BO universes as a part of the project and performing adhoc queries for reporting purposes.

Environment: Agile, Scrum, MS Visio 2003, SAP Business Objects, Serengeti Tracker, Ariba Buyer, SDLC, SaaS,Cloud Computing,MS Project 2010, MS Excel 2010, MS Word 2010.

Confidential, Charlotte, NC

Sr. Business Analyst&Test Analyst/ Jr. Project Manager

Responsibilities:

• Understanding of the current Consultant Views and RPPM systems based on the BLC platform supporting products such as IRA’s, SEP IRA’s, Keoghs, 401k, 403b, etc.
• Responsible for communicating with the various teams such as AIS Consultants, Trust Consultants, Technology teams, Stakeholders and Product Owners on a daily basis.
• Responsible for managing project from start to finish and ensure project meets overall defined scope.
• Facilitating review sessions and JAD sessions with the business to substantiate and finalize the BRD.
• Substantiating the Functional Requirements, Business Requirements document Use Case Document, Traceability Matrix and Business deckspresentations.
• Extensively used Caliber RM requirement management tool for requirements management.
• Facilitating the sessions with the business to resolve the open issues items (known as parking lot items).
• Responsible for transferring the functional requirements from Caliber RM to HP Quality Center.
• Responsible for creating test cases and performing manual testing.
• Performed manual testing using the test cases for positive and negative testing.
• Responsible for performing QA reviews for test cases and automated test scripts.
• Worked closely with developers for Defect tracking and reporting.
• Responsible for understanding / substantiating data requirements for data migration efforts.
• Assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica
• Executed queries in SQL as a part of research activities.
• Responsible for determining risk and issues in the requirements and develop mitigation strategies through meetings
• Responsible for creating initial set of mock up screens, UI design and validating with the appropriate folks.
• Responsible for managing the overall scope of the project.
• Performed project management activities such as developing project plans, RACI matrix, mentoring, resource allocation, etc.
• Prepared business presentations for providing, scope, vision and insight of the project across project team members, department heads and stakeholders during the initial phase of the project.
• Responsible for writing the test cases for interfacing systems such as Siebel Call Center CRM, PEGA PRPC, Fund Allocator, etc.

Environment: Agile, Oracle SQL Developer, SQL, Oracle Analytics, Caliber RM, MS Word, Excel, PowerPoint, Oracle, Clarity, XML Spy, Siebel CRM, HP Quality Center, PEGA, Java Spring.

Confidential, Charlotte, NC

Sr. Business Systems Analyst/ Test Analyst/ Jr. Project Manager

Responsibilities:

• Responsible for analyzing the existing Brokerage site and the vendor tool One StopTM.
• Responsible for requirements elicitation, verification and substantiation of Requirements document from the Project Definition Document.
• Responsible for performing GAP Analysis and Impact Analysis on the existing brokerage site.
• Responsible for overall project coordination including project planning, establishing cross dependencies, providing strategic direction, SLA Agreements, Document/ Deliverable sign-offs, scheduling status meetings, etc.
• Responsible for facilitation of JAD sessions for stakeholders, technology team, managers.
• Responsible for validating the test case scenarios for the project.
• Interacted with various teams on a day-day basis such as core development team, SAML team business team, production delivery team as a part of the project.
• Responsible for providing Subject Matter Expertise (SME) for the current brokerage system to the end users and business team.
• Responsible for analysis of existing applications to provide input for the application decommissioning.
• Responsible for managing riskthroughout project.
• Analyzed user requirements and developed test plans, test cases, test scripts to test the Usability and Functionality scenarios.
• Provided adequate supporting information for bottleneck analysis.
• Created online training demos using Oracle UPK toolset.

Environment: ISG RUP, MS Visio 2007, CMMI Level 3, Agile, MS Project 2007, MS Office 2007, MS Visio 2007,MS Outlook 2007, MS SharePoint 2007, Yodlee, DOORS, XML, HP Quality Center.

Confidential, Jersey City, NJ

Sr. Business Analyst/ Test Analyst

Responsibilities:

• Responsible for leading the efforts or Business Analysis, Quality Assurance with the on shore/ off-shore teams, business teams based in UK and Ireland.
• Responsible for working on parallel projects including a migration project and customer enhancement project.
• Performed the existing analysis of the TreasuryVision portal (from both the business and technical side) to determine the Gaps clients from both a business and technical perspective.
• Responsible for determining the requirements for the migration of the existing portal into the industry leading portal called “NextGen”.
• Worked on various financial products including Fixed Income Bonds, Equities, Money Markets, Loans, etc.
• Responsible writing use case document and test cases for the project.
• Performed verification, validation and System Tests.

Environment: Agile,HP Quality Center, MS Visio 2007, Java, MS Project 2003, MS Office 2003, MS Visio 2003 MS Outlook 2007, MS SharePoint 2007, Panorama, Exidio, .net, DOORS, XML, XSD, WebSphere MQ series 5.3

Confidential, Lowell, MA

Sr. Business Systems Analyst/ Test Analyst

Responsibilities:

• Responsible for leading the efforts or Business Analysis, Quality Assurance with the on shore/ off-shore teams, business teams based in UK and Ireland.
• Substantiated the Business Requirement document, Functional Requirements documents, Use case document and the Minor Design Document (MDD) to enhance the existing functionality of the system.
• Worked on various financial products including Fixed Income Bonds, Equities, Money Markets, Loans, etc.
• Facilitating the CE (Customer Experience)/ UC (Use Case) review meeting with the core business team, Web development team, Designing team and the Testing team to present the use case and assist design and development.
• Involved in various different testing roll outs such as Regression, Rolling Regression,UAT (User Acceptance Testing), etc.
• Extensively usedPEGA PRPC5.3 BPM tools and worked closely with team that developed a Work Management Solution.
• Responsible for creating process flows and uploading in PEGA PRPC.
• Responsible for working with the developer to establish business rules, workflows and clarification on requirements in PEGA PRPC.

Environment: Agile,HP Quality Center, MS Visio 2007, Java, TOAD, FTP,MS Project 2003, MS Excel 2003, MS Word 2003, MS SQL Server/ Oracle, MS Outlook 2007, MS SharePoint 2007, PEGA PRPC, Rational Requisite Pro, Novell.