SUMMARY

• Proactive, self - directed, result oriented Senior Business Analyst/ Data Analyst with over 6 years of experience in business requirements gathering and analysis, object-oriented design, data modeling, systems development, implementation & administration.
• Comprehensive domain knowledge of Know Your Client (KYC), On-Boarding Process, Anti-Money Laundry (AML), Credit Products, Fixed Income, Securities, Bonds, Derivatives, Credit Risk Management - Risk Exposure Evaluation through VaR, Market Data, Client panning.
• Extensive knowledge and experienced in different software development life cycle methodologies like Waterfall, Rational Unified Process (RUP) and Agile (Scrum).
• Strong knowledge of requirement Elicitation Techniques like Interviewing, Questionnaires, Brainstorming, and Surveys for enhancing features of the Application.
• Experienced in conducting Joint Requirement Planning (JRP) and Joint Application Development (JAD) sessions for requirements gathering and translating to Business Requirements Document (BRD), Functional Specification Document (FSD), System Requirements Document (SRD) and other High Level artifact/Low Level artifacts.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalizationand De normalization Concepts.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD).
• Proficient in analyzing and creating Use Case Scenarios, Use case Diagrams, Activity Diagrams, Sequence Diagrams and Business Flow Diagrams using MSVisio andSAP Power Designer.
• Experienced in conducting Gap Analysis,Impact analysis, ROI analysis, SWOT analysisand Cost benefit analysisand eliciting high-level business requirements.
• Conducted requirement gathering and analysis to develop data warehousing projects using Ab initio and Informatica. Followed through with testing and maintenance.
• Extensive experience with Data Analysis on Data warehouse system for various reporting systems within an organization.
• Possess very good Understanding on Data Warehouse, Client-Server, and Object-Oriented design experience with Data Analysis, Business intelligence (BI).
• Extensive knowledge in ETL process, Data Mapping, Data Modeling, Star/Snowflake Schemas, OLTP/OLAP, designing E - R Models and reference data management.
• Assisted UI design throughout development using tools like JUSTINMIND and kept in touch with the client and updated them about the UI design.
• Proficient in conducting different types of testing including User Acceptance Testing (UAT), Black Box testing, Load Testing and Performance Testing and writing Test Cases, Test Plans and developing RTM (Requirements Traceability Matrix).
• Directed teams and participated in Data Visualization, Business Intelligence, Business Analytics, Statistical Analysis and Data Mining. Also worked on extracting data through writing SQL queries.
• Excellent Problem Solving skills, Critical Thinking skills and comfortable in working with onshore/offshore model.

TECHNICAL SKILLS

Modeling Tools: JUSTIN MIND, UML, MS Visio, SMART DRAW.

SDLC Methodologies: Agile Scrum, Waterfall, RUP (RATIONAL UNIFIED PROCESS)

Database: MS SQL Server 2012/2008/2005, MS Access.

BI Reporting Tools: SAP NETWEAVER 7.3ETL Tools: AB INTIO, INFORMATICA, XCEPTOR

QA Testing Tools: HP Quality Center, JIRA, Load Runner, Mercury QC.

Documentation Tools: MS Office Suite, SharePoint 2010/2013.

Data Warehousing: Data Marts, OLTP, OLAP, Query/Reporting,Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up

Project Management Tools: MS Project professional, MS Project Server.

Agile Management Tools: Agile JIRA, Rally, HP Agile Manager.

Web Technologies: HTML, SOAP, XML, and WSDL

Working Tools: Oracle SQL Developer, PUTTY, WIN SCP, Power Designer 16.5, GitHub, SERVICE NOW

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Worked with SME’s and VP’s from various LOB’s such as Confidential ( Confidential ), Confidential ( Confidential ) and Corporate Controllers to ascertain their business process and gather the various documents used in their process through interviews, feasibility assessments & reviews.
• Worked on multiple internal projects from various LOBS’ across different locations such as LATAM, EMEA and ASIA to provide Cost and Time Beneficial process improvements.
• Worked with Front End Process Owners to create SOP (Standard Operating Procedure) documents for their process to be used by Tech team & Business Users, using MS Word and MS Visio.
• Identified ‘AS-IS’ process and ‘TO-BE’ process as parts of Gap Analysis for implementing diverse process improvements using automated bots and macros.
• Instrumental in creating bots which can create standardized reports in PDF, PowerPoint, and other reporting mediums from multiple sources such as SAP, FDW, Capital Desktop, Athena by manipulating Excel to create charts, pivots & tables.
• Coordinated Tech discussions, did routine follow-up meetings with the tech team, Business process owners and SME’s to clarify any doubts or questions they might have.
• Extensively worked with the Robotics Centre Of Excellence (COE) to generate new process improvement ideas through Brainstorming sessions, questionnaires etc.
• Coordinated Daily stand up meetings, Sprint planning sessions, did user story planning and estimation using JIRA.
• Worked on XCEPTOR tool to get hands on understanding on how to manage disparate structured and unstructured data sources with extensive BPM and reconciliations functionality, accessing data in any format and any channel and then enriching and standardizing it with full data lineage.
• Kept track of all internal projects by creating a Blitz tracker on SharePoint, thus giving the team an estimate on productivity being achieved every month.
• Wrote extensive Test Case documents for UAT testing to be performed by the VP’s or SME’s, thus maintaining high productivity at all ends.

Environment: Scrum (agile), MS-Visio, MS Word, MS PowerPoint, SharePoint, Excel, Excel (Macros), VB Script, Agile, JIRA, XCEPTOR

Confidential, TAMPA, FL.

RESPONSIBILITIES:

• Performed requirement gathering and knowledge extraction about the Investment banking through interviews, audio/video conferencing and JAD sessions.
• Translated the gathered requirements into user stories by detailing in the functional and non-functional requirements based on interactions with the Product Managers and SME’s who gave the customer’s real-time feedback about the Fixed Income products (Bonds, Municipals, Treasury) and Credit products (Credit Default Swaps, Total Return Swaps )to evaluate risk exposure.
• Worked with Front Office/ Middle Office to understand KYC & AML compliance and build workflows for business process modeling using Power Designer.
• Identified ‘AS-IS’process and ‘TO-BE’process as parts of Gap Analysis for implementing VaRcomponent.
• Wrote extensive queries using the SQL/Oracle Server to perform data analysis, data validation, data governance, data mining, and data cleansing.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Performed data profiling in the source systems to avoid data anomalies and ensure data quality.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 9.5.
• Coordinated Phased Data Migration process to handle large and complex volumes of data and address dashboard reporting capabilities.
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer
• Supervised and worked closely with data coordinators, and other team members to provide technical support and end user training on the developed applications.
• Created & published functional requirements, Screen prototypes on portal for access by all project participants.
• Produced Requirements Traceability Matrices to support the application development that included Business Requirements, Actor Survey, Use Case Survey, Supplementary Specification Survey, Analysis Model, and Design Test Case Survey.
• Assisted project manager and product owner to track and improve efficiency and Team Velocity using Sprint Burn-Down Chart and Product Burn-Down Chart, Work Breakdown Structure andMilestones List.
• Assisted QA department to write and execute Test plans and Test Cases; and workedonUAT.

Environment: Scrum (agile), MS-Visio, MY SQL, MS Word, MS PowerPoint, SharePoint, Excel, JAD, HP ALM,, My SQL, Informatica 9.5, Agile, JIRA

Confidential

Responsibilities:

• Involved in Business Process Management, Documentation, External and Internal Communications, Governance Processes, Program Issues and Risk, Risk Mitigation, Audit and Change Requests.
• Reviewed and analyzed Business Requirement Document (BRD/HLD), Functional Requirement Document (FRD/LLD) and helped transforming them into a complete System Requirement Specification (SRS) as to enable all the stakeholders’to accurately understand requirements.
• Created project progress documentation for high level requirements gathering, tracking and validation.
• Experienced with working on Data warehouses using Type I and Type II SCD (Slowly Changing Dimensions) schema to store current and old Credit records of customers.
• Co-ordinated with several SME’s and Project Managers to get the right approved data source for each of the projects. Conducted thorough Data analysis and Gap analysis to verify the data sources.
• Elicited requirements by conducting JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Developed conceptual and logical ER diagrams for the database and created Data Dictionary for the data models.
• Handling sensitive data and good hands on experience in customer data and generating BI reports.
• Collected and Incorporated user feedback to create and modify AbIntio graphs to address business requirements.
• Professional in creating Source to Target Mapping Document using MS EXCEL by taking input from SSA document and feed Ab Initio Developers.
• Used MS Visio for mapping business process to ensure optimized processes.
• Used UNIX to connect to various ETL and Database servers and to enable AUTOSYS job scheduling and Jill scripting.
• Expertise in handling sensitive customer data and provide use full information by using BI tools.
• Experienced in creating SSA mapping Document using MS EXCEL by collecting information from Functional Analyst and feed Data Modeler according to his requirements.
• Had keen contact with end-user how the intent system behave by keeping in mindBDD(Behavior Driven development) .
• Worked with developers in validating data using SQL and UNIX Shell Scripting in PUTTY.
• Assisted creation of Test Cases, Test Plans, Test Scenarios and created forward and backward Traceability Matrices. Conducted User Acceptance Training (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Black Box Testing and Regression Testing.

Environment: MY SQL, MS Excel, MS SharePoint, MS Word, Note Plus, AUTOSYS, PUTTY, Power Designer, UNIX, AB INITIO, Service Now .T

Confidential

Responsibilities:

• Managed various sales and purchase accounts under divisions such as FICO (Financial accounting and controlling) using reports created with the help of SAP NetWeaver 7.3.
• Created UML Diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using MS Visio,thus defining the Business Process Model and Data Process Model.
• Performed data analysis on various financial reports that were generated in excels spreadsheets and was managed by MS Access database.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest
• Effectively worked in the FTS (Follow The Sun) Model to provide 24x7 support all year around in different GC’s with Change Control and messaging functions.
• Worked with Data Store objects such as Infocubes, Infosets and infopackages in the SAP Netweaver 7.3 platform.
• Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.
• Handled issue resolution and issue management on tools like Service Now.

Environment: WATERFALL Methodology, MY SQL, MS Excel, MS SharePoint, MS Word, Note Plus, MS Visio , Rational Clear Quest, Power Designer, UNIX, SAP Netweaver 7.3, Service Now .

Confidential

Responsibilities:

• Creation of Test Cases and use case scenarios from the SRS and validating the same from BA.
• Assisted Developer in Unit Testing on the development environment.
• Experience in Manual & Automated Testing for Software Quality Assurance (SQA)
• Execution of Test Cases using Manual Testing concepts.
• Bug Reporting and following the defect life cycle.
• Testing Business Scenarios and the change requests and respective impact on the functionality.
• Product Testing on Laptop for client demo and Certification for Release.
• Co-ordination with the respective PM, TL and Developers, Test Planning, SRS Understandings, Demos.
• Implemented automated testing tools spawning more diligent levels of regression testing, negative testing, error/bug retests and usability.
• Mentoring of new team members.

Environment: MY SQL, MS Excel, MS SharePoint, MS Word, Note Plus, Load Runner, HP Quality Center, HP QTP .