SUMMARY

• Dynamic, result oriented technical Certified Scrum Master®, Product Owner® & Lean Six Sigma Green belt with 12 years of software experience in Business Analysis, Data Warehousing, Business Intelligence and Project Management in Investment banking, Trading, Treasury services, Wealth management and Risk management.
• Acquainted with processes related to Requirement elicitation, Business & system analysis, Application Documentation & development and Software project planning, execution & monitoring.
• Extensive experience in developing Business Requirement Documents (BRD), FRD), Software Requirements Specification (SRS), Requirements Traceability Matrix (RTM).
• Proficient in developing Business Process Flows, graphical depictions of Use Cases including Use Case diagrams, Activity diagrams, Sequence diagrams, Class diagrams and Collaboration diagrams.
• Strong communication skills in engaging Project Sponsors, Business stakeholders, subject matter experts and Business Users in gathering the intricate workings of business processes.
• Performing extensive analysis on all the LOBs reporting applications to design a tool that supports all of them
• Involved in development, testing, and supporting of business intelligence, analysis and reporting solutions
• Collaborating with the visual graphics team to design site maps, process flow diagrams, wireframes, prototypes
• Working closely with the project sponsors, business users and acted as a liaison between the business user groups and the functional, Technical, QA and Support teams
• Assisting the development team in understanding the functional and technical requirements and do the development as per the requirements
• Working with the QA team to help them understand all the requirements and assisting them in developing QA test cases
• Providing periodic status reports to the stake holders, updating them with the current status of the project and highlight any issues or risks
• Performing BA functional testing after the development to make sure the functionalities were developed as required and data consistency and accuracy are maintained
• Working with project team members, clients and vendors to coordinate activities, provisioning, environment setup, installation, and integration testing
• Coordinating development and testing activities while making sure the deliverables confirm to requirements
• Allocating resources to various departments and managers as per their needs and requirements

TECHNICAL SKILLS

Programming Languages: C, SQL, T - SQL, PL/SQL, Shell Scripting

ETL Tools: INFORMATICA 9.1/8.6/7.x/6.x, DTS (Data Transformation Services)

Databases: Oracle 11g/10g/9i/8i, DB2, MS Access, SQL Server 2000/2005/2008 , Teradata V2R4/R3

Data Modeling: ERWIN 4.0/3.5, Oracle Designer, MS VISIO

Operating Systems: Microsoft Windows 95/98/00/NT/XP/Vista/7/8, UNIX, MS-DOS

Database Tools: Oracle Data Integrator 10g(Formerly known as Sunopsis), SQL Developer, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential

Scrum Master

Responsibilities:

• As an Scrum Master, performed the day to day activities in delivering the Project.
• Requirement analysis, design and Development of ETL mappings and Processes on Informatica Power Center and Unix.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Performing gap analysis between the current state and future for the business processes, data warehouse and Business Intelligence/Reporting environment.
• Documenting the requirements in Business Requirement Document (BRD) and converted them to Functional and Software Requirement Documents (FRD) and Software Requirement Document (SRS) to user stories for the understanding of the development team.
• Assisted the Product Owner in compiling and prioritizing the Product Backlog on JIRA using prioritization technique MOSCOW.
• Facilitated all the Sprint Ceremonies: Backlog Refinement, Sprint Planning, Daily SCRUM, and Sprint Review.
• Time boxed Daily SCRUM meetings and resolved all impediments faced by development team.
• Mentored and helped the team grow into a self-managing entity. Encouraged collaboration between the SCRUM team and product owner.
• Maintained and monitored SCRUM Artifacts-Sprint Backlog, Sprint Tasks, and Sprint Burndown Charts using JIRA.
• Analyzed and understood the business users' requirements for information and communicated them to the rest of the data warehouse team. Assisted Data Warehouse Data Analyst in analyzing existing reports.
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process. Acted as consultant to the ETL and front-end programmers.
• Created Data Models, Data Flow Diagrams and ER diagrams using ERWIN to depict the Source-to-Target Mapping.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using RDMS Microsoft SQL server queries for documenting and retrieving data from database.
• The project involved developing mappings for moving data from heterogeneous sources to Staging Area (STG) and then to Data Warehouse (DWH)
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Creating the deployment documents and migrating the code to the production environment.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support
• Generating the Reports and Dash Boards using Tableau for the Business Users and Senior Management.

Environment: Informatica Power Center 9.1/8.6, UNIX, Oracle 11g, SQL, PL/SQL, SQL Developer, Metadata Manager, Oracle Designer, MS VISIO, JIRA, ERWIN, IBM Mainframe, Toad.

Confidential

Scrum Master

Responsibilities:

• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Interacting with the business representatives to understand the requirements and determine the best approach for timely delivery of information.
• Ensuring timely deliveries of work items to the Client.
• Involved in Implementing ETL standards and Best practices.
• Review of Data Model and validating its feasibility to physical implementation.
• Assisted the Product Owner in compiling and prioritizing the Product Backlog on JIRA using prioritization technique MOSCOW.
• Facilitated all the Sprint Ceremonies: Backlog Refinement, Sprint Planning, Daily SCRUM, and Sprint Review.
• Time boxed Daily SCRUM meetings and resolved all impediments faced by development team.
• Mentored and helped the team grow into a self-managing entity. Encouraged collaboration between the SCRUM team and product owner.
• Maintained and monitored SCRUM Artifacts-Sprint Backlog, Sprint Tasks, and Sprint Burndown Charts using JIRA.
• Analyzed and understood the business users' requirements for information and communicated them to the rest of the data warehouse team. Assisted Data Warehouse Data analyst in analyzing existing reports.
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process. Acted as consultant to the ETL and front-end programmers
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Creating the deployment documents and migrating the code to the production environment.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support
• Generating the Reports and Dash Boards using Tableau for the Business Users and Senior Management.

Environment: Informatica Power Center 9.1/8.6, UNIX, Oracle 11g, SQL, PL/SQL, SQL Developer, Metadata Manager, Oracle Designer, MS VISIO, JIRA, ERWIN, IBM Mainframe, Toad.

Confidential

Subject Matter Expert

Responsibilities:

• Managing daily production data warehouse administration, troubleshoot and resolve highly complex application and data load production problems, managing user access to the Teradata database and Business Objects account and universe, 24x7 on-call rotation, project implementation and planning. Delivered exceptional 24x7 on-call rotation; supporting applications, extracts, control-M data batch load to various activities owned by the Data Warehouse production environment
• Analyzed and troubleshoot application and batch issues using UNIX, Teradata SQL Assistant, Teradata Administrator and resolve highly complex issues that do not have standard documented solutions
• Managed off-shore/on-shore model multicultural team environments, providing support / guidance to the development teams during the analysis, design, development, and testing processes and deployment of project
• Subject Matter Expert(SME) on Control-M scheduling, capabilities, application features and UAT Coordinator

Environment: Informatics Power Center 7.1.4, Teradata, PL/SQL, Oracle 9i, SQL Server, TOAD, MS-Access, ERWIN, Windows XP/2000.

Confidential

Senior Production Support Analyst

Responsibilities:

• Support mission critical production application responsible for enterprise wide pricing of products
• Managed DSPM Ticket Queue, Support Mailbox, Hotline Calls and follow Sun model for Handovers to Global Support Team
• Provided application support for all production issues in the MDS (Market Data Service) environment from initial client contact through to resolution
• Developing in depth knowledge of the Market Data and business processes to support all facets of the production environment
• Monitor and manage user/group permissions, Quarterly Permission Audit, API’s, Control-M batch processes, In-House build software, application processes, servers and databases
• Planning, coordination and execution of production deployments, system upgrades and emergency bug fixes
• Reduced client disruptions through prioritization of production impacting issues and by providing root cause analysis to identify and prevent similar issues in the future
• Build and maintain relationships with clients to become their first point of contact when they are in need of assistance
• Use SQL to extract and modify data as well as create/update new tables, views and indexes in order to optimize performance
• Ensured optimal server performance by identifying and analyzing trends and processes in Linux and UNIX environments
• Performed On-Call rotation including weekend support for releases, upgrades, Disaster Recovery (DR), Quarterly Maintenance Windows (QMW) tests and related activities.
• Document and improve new and existing processes and procedures for global team in order to comply with internal and external regulations.