Feb 2021 – Jun 2022 · 1 yr 4 mos · Southfield, Michigan, United States

• Involved in gathering business requirements from the end users and management
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
• Used Rational Requisite Pro for Managing and Configuring the Requirement Analysis effort.
• Experienced in gathering/analyzing the business/user requirements, designing ODS tables in consultation with the Data Architect, analyzing the source/target dependencies & Production Troubleshooting.
• Used Informatica reusability at various levels of development.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle 9.2. Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF.
• Extracted the business requirements from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Prioritized requirements to be developed according to Agile methodology.
• Performed extensive requirement analysis and gap analysis.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.

Apr 2019 – Feb 2021 · 1 yr 10 mos · Wixom, MI

• Prioritized requirements to be developed according to Agile methodology.
• Performed extensive requirement analysis and gap analysis.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents

Feb 2017 – Apr 2019 · 2 yrs 2 mos · Cookeville, TN

• Development and support of the key data integration and migration initiative for the conversion, integration and migration of data from different legacy systems to the central database system, from where it will be consumed for further business decisions.
• Interact with legacy business users to understand business process flow, business logics and to assess major data objects, data volume and level of effort required for data conversion and migration.
• Work with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements.
• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in Definition Stage.
• Implemented the data governance standards, policies, and procedures for the control, protection, consistency and delivery of corporate data and information assets.

Jun 2016 – Jan 2017 · 7 mos · Bangalore, India

• Gathered data requirements around new data sources and new uses for existing data sources
• Participated on cross-functional project teams to identify critical requirements from a reporting perspective
• Acquired data from multiple sources and prepared data for further analysis
• Worked on customer data related issues and worked on project resolution in collaboration with development teams
• Involved in discussions with business partners to identify questions for data analysis and experiments
• Met with SME to gather information, designed/created process maps; process flows, swim lanes using Visio
• Responsible for managing the process, technology changes and implementing agile methodology
• Used Excel Sheets, flat files to generate tableau ad-hoc reports

Nov 2013 – Mar 2016 · 2 yrs 4 mos · Hyderabad, Telangana, India

• Researched, analyzed, gathered data defined and developed requirement specifications for Mortgage Product, Compliance and Regulation Projects and performed testing.
• Involved in Management consulting, intra-day reporting, architecture, business analysis and application development for real-time EOD reporting for hedge funds and prime brokers.
• Identified and documented improving areas to meet capital requirement regulations.
• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).