We provide IT Staff Augmentation Services!

Project Manager/scrum Master Resume

NyC

SUMMARY:

  • Business/Systems data Analyst, with Around 10 years of extensive experience in all phases of Software Development Life Cycle: Gathering Requirements, Analysis, Implementation and Testing of projects. A smart working, motivated, sincere, committed, quick learner, detail - oriented team player with excellent communication, analytical, leadership, interpersonal and problem-solving skills. Extensive experience in project handling and management in various environments, all experience is in Data warehousing projects which includes Reporting, ETL & Business Analysis. Key strengths are strong technical knowledge and strong communication skills. Good problem solver and a good liaison officer. Expert level interactions with business and vendors in a very productive way.Highly adaptive in various situations mold as a good team-player as well as individual contributor.Having good international exposure. A team-player and able to work well individually and team, enjoying travelling, love to mingling with new people.
  • Expert level knowledge of RDBS and SQL relationships, Excel 2010 and 2013 especially Pivot tables (Power pivot, Power query and closely work with Dashboard reports).
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
  • Dealing with complaints, coordinate with offshore team and cover the duty when necessary.
  • Experienced in design and development of reporting applications and dashboards for supporting the business analysis and corporate wide reporting.
  • Experience in Maintenance of projects in MS Project Server especially in SharePoint activities like create, close, publish, and modify settings.
  • Facilitate Rally Scrum of Kunban and JIRA with other Scrum Masters and Leadership. Maintain teams' performance and velocity metrics.
  • Expert in behavioral, structural and architectural modeling by using UML, like Use Case/User stories, Activity, Structure and Sequence diagrams.
  • Highly proficient in operating MS SQL Server 2012/2008 R 2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS. Experience in Windows Performance for monitoring and tuning SQL Server performance.
  • To perform as a liaison among business stakeholders to understand business problems and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
  • Experience in Joint Application Development (JAD) sessions as facilitator with end-users, Subject Matter Experts, Development and QA teams.
  • Managing Ad-hoc reports, Parameterized, Custom Reporting using SSRS for daily reports.
  • To deliver Business Process Model, Business Requirements Documents, Business Requirements List and Business Use Cases. Work with project manager to deliver project charter. Plan and develop feasibility study, requirements and risk analysis.
  • Administered all Agile/Scrum process and assisted others staff on same. Coordinated with onshore-offshore team
  • Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process (RUP), Agile and Waterfall Method.
  • Skilled in creating Wireframes/Screen Mock-Up's based on requirements captured by meeting with End Users/Customer/SME's.
  • Using project management tools like MS-Project for status reporting and planning
  • Used agile methodology for SDLC and utilize scrum meetings for creative and productive work(Jira and Rally technology)
  • Expertise in creating BRD, FRD,SDS,SRS, Requirement traceability Matrix (RTM) documents while using various requirement gathering techniques like brainstorming, conducting interviews, workshops, Rapid Application Development (RAD), Joint Application Development (JAD) sessions with stakeholders, business users, and development team
  • Extensive experience in gathering Business/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams using Microsoft Visio and Rational Rose, and in addition to creating Business Requirements Document (BRD).
  • Broad knowledge of Test plans, Test cases and test scripts review from the Requirements Document,well versed in User Acceptance Testing, Smoke Testing, Regression Testing, Performance Testing and Functional Testing.

TECHNICAL SKILLS:

  • MS SQL 2014
  • 2012
  • 2008R2/2005
  • Rally()
  • JIRA
  • SharePoint
  • MS SQL Server Integration Service (SSIS)
  • MS SQL Reporting Services (SSRS)
  • Business Intelligence Development Studio (BIDS)
  • SQL Profiler
  • Enterprise manager
  • Management studio
  • Microsoft Access 2000
  • ERWIN 4.2/7.2
  • MS SQL Server Analysis Services
  • Microsoft Visio 2010 & 2013
  • Snaglet
  • StarUML
  • Lucidchart
  • Gliffy
  • Cocoo
  • MS office 2007/2010
  • Windows 2000/2003
  • SQL Developer
  • Microstrategy
  • Tableau
  • SAP SD-CRM
  • Windows Project Management/Microsoft Project
  • Arisbpm
  • RSA Archer(case management) and SPSS.

PROFESSIONAL EXPERIENCE:

Confidential -NYC

Project Manager/Scrum Master

Responsibilities:

  • Manage Splunk training engagements from initiation through deployment. Provide project planning, risk planning, action/issue tracking, and overall project communication. Contribute to best practices, new process creation, and identification of business improvements.
  • Identify and analyze risks within projects; strategize, facilitate, and lead the risk managementmethodology;
  • Develop comprehensive data taxonomy for information security and risk management policies within Amex environment. Work closely with compliance, operational and Credit risks(RIM)
  • Define tasks within the project plan related to risk; facilitate the development of action plans to mitigate or eliminate risks;
  • Design solutions for remediating any deficiencies and Perform Change Management Control
  • Coordinate with IT Application owners, developers including project deliverable roll-outs in offshore teams.
  • Manage risk throughout all phases of the project; support all teams within the project; document business strategies for risk management; analyze impact of identified risk;
  • Conducting GAP analysis, KPI’s, SWOT analysis, Cost Benefit analysis and ROI Analysis in all phases of the Software Development Life Cycle (SDLC)
  • Lead business requirements gathering, analysis, and transition of business needs into a software production environment
  • Administer all Agile/Scrum process and assisted others staff on same. Part of Agile charter development and Project planning
  • Created Use Case, Test cases, UAT, SIT documentation and Agile project Charterfor project development.
  • Assisted business partners to identify and clarify their goals and IT requirements
  • Manage development team and Conduct JAD sessions to gather business requirements project plan and project setup documentation
  • Coordinate several high visibility projects including an Credit Risk Application tools project to consolidate all key risk indicators into a single source for use across various business units and lines of business
  • Host recurring working group sessions accounting for over 100 hours of feedback and discussion with key SME stakeholders responsible for contributing updates on company policies, control standards and risk statements.
  • Primary lead for a ‘Big Data’ POC using Splunk and Archer, Tableau, Jaspersoft and Rally training and documentation.
  • As a Product Owner, develop Big Data Platform (BDP) capabilities to improve the customer experience, drive growth, and reduce losses. This will be achieved by creating next generation capabilities on the Big Data Platform (BDP), supporting the following credit & risk products: 1. Credit Eligibility 2. Line / Limit Management 3. Exposure/Capacity Management 4. Customer Experiences
  • Worked as a Product Owner to develop Big Data Platform (BDP) capabilities to support fundamental transformation of our offer generation, presentment, and acquisition/fulfillment processes, related to: 1. Global New Accounts (GNA) modernization (workflow management, rules engine, etc.) 2. Dynamic Customer Experience (DXP) applications (online applications) 3. Orchestration and case management 4. Global Risk Fulfillment (GRF)
  • Work closely both with the business partners and the technology teams very closely on a daily basis to assist in defining the capability and being involved throughout the build process
  • Strong ability to think strategically to enable fundamental transformation - experience in demonstrating think through strategies / options and understand and articulate back the pros and cons to enabled in effective decision making of the project
  • Deep and broad expertise experience in systems and capability development, including data flows and database design - strong understanding of data variables and its usage within the Credit Risk framework
  • Having ability to work independently, Lead multiple initiatives especially leading 3-4 use cases at any given point in time
  • Good presentation and articulation skills,counducted several presentation to senior leadership, managed effective communication between business partners and technology teams

Environment: Clarity, MS Project, Load Runner, Agile Methodology (JIRA/Rally-), SharePoint, Contact Center, MS Office Suite, Powerpoint 2013,Excel 2013, Rational Requisite Pro, UML, Microsoft Visio, SQL/PLSQL, SQL Server 2012,Splunk,SAS,Hadoop,Cornorstone,RSA Archer, Tableau admin and Jaspersoft admin .

Confidential - Charlotte, NC

Scrum Master/Technical Project Manager

Responsibilities:

  • Gather detailed Business and technical requirements, including mapping to the source and applicable data marts/extracts. And also documented business requirements from Trading Partners, user groups and vendors via interviews, surveys, and workshops.
  • Lead business requirements gathering, analysis, and transition of business needs into a software production environment
  • To deliver Business Process Model, Business Requirements Documents, Business Requirements List and Business Use Cases. Work with project manager to deliver project charter. Plan and develop feasibility study, requirements and risk analysis.
  • Communicate technical solutions across departments to both technical and non-technical staff
  • Work as the liaison between business units and internal partners/external vendors by providing accurate and timely updates to all stakeholders and taking a proactive role in solution definition
  • Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process (RUP), Agile and Waterfall Method.
  • Coordinate and execute user acceptance testing (UAT) with internal Business partners and external partners
  • Design and maintain the integrity of database structures which involves providing consistent, standardized, integrated, auditable, traceable, and quality data.
  • Perform Process Modelling whenever applicable for both Database Management and File Management processes
  • Owned Business Analysis and Project Management of the Daily, Weekly and Monthly Report projects.
  • Responsible for scheduling the subscription reports with the subscription report wizard in SSRS 2012.
  • Provide deep diving data analysis using SQL queries data dumps into MS Excel of findings to other Analyst and Managers to help team understand exceptions root cause in product setup in source systems
  • Conducted JAD sessions, workflow diagrams, UML diagrams, process models, activity diagrams, use cases, for incorporating design changes in the order creation/ management system.
  • Creating Power Pivot, Power query, DAX formula, Analysis, View in Excel 2013. Responsible for SharePoint and Dashboard reports and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Maintaining Transactions daily and build SSIS frame work which maintain the metadata and can handle the transaction data.
  • Performed logical and physical modelling, developed and maintained ER diagrams and data dictionary to show the relationship between business components to map data with various fields and others business components with the given data requirements.
  • Expertise in Data analysis, Data modeling for transactional as well as Data Warehousing ( Dimension Modeling), ETL Mapping Document and BI reporting.
  • Accountable for developing reporting, and reporting strategies for both internal and external client needs using various technologies, like SSRS, SharePoint, Excel, PowerPivot, Power View
  • Develop a repeatable and high quality release management process for reporting
  • Experienced in document sharing applications including MS SharePoint and documenting user stories using Rally.

Environment: JIRA, Version1,Clarity,Power BI (Power Pivot, Query and view), Visio 2010 & 2013,Excel 2013, SharePoint, Visual Studio 2012, Microsoft SQL Server 2008 R2,2012&2014,JIRA,Rally(CA Technology), HP Quality Center, SSIS 2012, SSRS 2012, SSAS 2012, Microstrategy and Tableau.

Confidential - Marengo, IL

Project Manager

Responsibilities:

  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Lead business requirements gathering, analysis, and transition of business needs into a software production environment including facilitating production support and troubleshooting of deployment and release issues • Manage an enterprise-wide effort of identifying the Key Performance Indicators (KPIs) across all the domains of the organization • Establish and maintain engagements with the business partners regarding onboarding of the data ensuring the integrity of the data resulting in about 75% improvement in SLA for launch and dashboard refreshes
  • Liaise between business units and internal partners/external vendors by providing accurate and timely updates to all stakeholders and taking a proactive role in solution definition
  • By using Microsoft Excel/Access advanced techniques for data analytical tasks such as data cleansing, data validation, data modelling, automation of extraction using MS Query, ODBC links to source data or Bex Query for SAP BW extracts, transformation of data by applying similar rules to ETL Processes, data preparation for loading 3rd party databases, visualization/dashboard reports (Xcelsius), pivot table reports
  • In-depth knowledge of Integrated Reporting Information System (IRIS)
  • Manage and maintain the integrity of database structures which involves providing consistent, standardized, integrated, auditable, traceable, and quality data.
  • Worked on various Datawarehouse initiatives by providing needed information from either DW or offline data stores
  • Responsible for estimations of the new requirements or enhancements in existing projects.
  • Responsible for requirement gathering and creating requirement and technical document.
  • Coordinated UAT with the stakeholders for Pilot and Go Live implementations.
  • Implement a Kanban framework to enhance efficiency and productivity of the company.
  • Manage Microsoft Project and provided updates velocity and burn down metrics.
  • Supported management in product development, branding and oversight of the organization's Communications, Investor Relations and sourcing deal leads through investment and international donor organizations.
  • Supported the team in creating financial models, analyzing historical and projected financial statements, conducting industry and market research, reviewing portfolio company information and preparing internal memos for senior management review. Conducting research on business services sub-industries for investment suitability
  • Exposed to operational side of a private equity fund management company and also get a good grasp of the life cycle of a deal (sourcing, due diligence, structuring, capital deployment, value creation and post-investment monitoring.
  • Performed data entry into audit forms, scans and emails information to providers/auditors

Environment: Visual: Studio 2012, Microsoft SQL Server 2008/2012, SSIS 2012, SSRS 2012, SSAS 2012, JIRA, Agile, SQL Developer, MS SQL Profiler, SQL Server Database Engine Tuning Wizard, Windows Server 2008R2, MS Office 2010, MS Access, MS Visio,Aris bpm.

Confidential

Technical Project Manager//Business Analyst

Responsibilities:

  • Communicated project plans, weekly deliverables to project teams and tracked the status of deliverables with Product Owners.
  • Lead daily Scrum meeting and Communicated, negotiated, and managed the scope of the assigned project to ensure that expectations are set concerning the project deliverables, timeline and costs.
  • Tracked Project timelines using Jira and designed mockups with balsamiq.
  • Uploaded project related documentation to common repository and provides Project coordination and support to the IT PMO team all the while managing budgets and vendor relations.
  • Reviewed and processed Vendor invoices, ensures back-up documentation is complete and accurate.
  • Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and parameterized reports using SSRS.

Environment: MS SQL Server 2012,2008 R2, T-SQL, SSIS 2008, SSRS 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v7.1, Windows XP, MS Office 2010, MS Access, IBM Rational Clear Quest.

Confidential

Data Analyst/SIS/SSRS Developer (MSBI Developer)

Responsibilities:

  • Responsible for migrating data from staging area to enterprise-wide data warehouse to store reliable data for decision support systems using Data Stage.
  • Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
  • SSIS Package Deployment to Production Server as well as Job Scheduling for Package In Daily bases.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
  • Documented the project work in Interface and for all process

Environment: Microsoft SQL Server 2008, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, Business Objects, VB .Net, Windows Server, MS Visio,DB2, MS Excel, Microsoft TFS.

Confidential

Jr. Database (SQL) Developer

Responsibilities:

  • Worked with non-technical colleagues and provide them SQL 2005 queries and store procedures to make their task easy and less time consuming.
  • Facilitated Joint Application Development (JAD) sessions with the Management, Mainframe users and HIPAA team to make sure everyone are in sync with the business requirement processes.
  • Developed mapping specifications for EDI transaction sets supporting EDI Health Care Claim Status inquiry/response i.e. 276 and 277
  • Reviewed defects, logged in HP Quality Center and maintained an issue log to keep track of the bugs and follow-up to resolve them.
  • Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance. Worked on data cleansing techniques using look-ups, conditional split, and fuzzy lookup.Provided efficient error handling to SSIS packages.
  • Prepared the reports using SSRS 2005 from scratch, created parameterized, drill down reports and Changed old reports as per requirements using SSRS 2005.
  • Create report model to give flexibility to users to create their own reports in SSRS.

Hire Now