SUMMARY:

• Senior Business and Data Analyst and possesses 10+years of experience in Financial Services and Retail Services Domain having served diverse clients including - Confidential covering with fair understanding of Confidential.
• Project Management expertise (over FOUR years) in managing enhancement projects with large teams at client site in onsite/offshore model.
• Successfully managed client expectations and executed projects worth $500K towards system implementation/enhancements.
• Competent in developing the Rough Order of Magnitude (ROM) estimate.
• Extensive experience (over FOUR years) in Business Intelligence.
• Extensive experience in reporting tools like Tableau 9.x/8.x/7.x of Desktop, Server and Public, Business Objects 4.0 and Microstrategy.
• Extensive experience in Salesforce for data analysis, Data mapping and user stories creation.
• Worked on critical engagements, managed and built relationships with clients and multi vendors, displaying sound collaboration, interaction, negotiation and communication.
• Led matrix team comprising Jr. BAs, developers and testers on engagements ranging from data analysis, system development to enhancement.
• Performed functionality decomposition for one of the critical applications in area of wealth management with one of the biggest Investment firms in USA
• Experienced in various SDLC phases with proficiency in methodologies like Waterfall, RUP and Agile.
• Proficient in analyzing business (‘AS-IS’ and ‘TO-BE’) opportunities using GAP Analysis, Risk/Impact Assessment, Process / Project Feasibility Study to achieve end state requirements and drafting Concept/Business Case / Process Documentation.
• Experienced in conducting Requirement sessions, interviews, JAD, project meetings, document reviews and business walkthroughs.
• Extensive experience in creating technical documentation specifications like Information Mapping, Use Cases, BRDm FRD, Vision and Scope Document (VSD), UI/Screen Prototypes, Standard Operating Procedures (SOP), Process Flows, User Manuals, RTM, Test Plans, Test Scripts, UAT, Product Release Notes and Project Milestone Tracker.
• Extensive experience in Data Warehouse along with the analysis of ODC and DataMart components.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Handled Tableau admin activities like Installations, Configurations, creating user, user groups, granting access and managing extracts.
• Experience on Teradata scripts like BTEQ, MLOAD, and FASTLOAD.
• Data mapping using SQL across databases (Oracle and Teradata) and running ad-hoc queries.
• Extensive experience in defect tracking through HPQC.
• Proficient in MS Office (Word, Excel and MS-Power point) and MS Access.
• Extensive experience in mainframes support and development.
• Experience in implementation of Risk Management Information System(RMIS) with Risk connect and Learning Management System(LMS)
• Dealt with Derivatives, Equities, Mutual Funds and Fixed Income asset classes with Reference data sources like Bloomberg, Eagle Pace, DST HiNet, Golden Source etc.
• Worked with Treasury, IRA, Capital Market, Corporate Action, ALM, bank secrecy act, Anti-Money Laundering departments
• Excellent knowledge in AML/KYC & Trade Surveillance and good understanding of related topics
• Successfully managed team delivery in Onsite-Offshore models with focus on managing project, resources, risk and vendors with Client Stakeholders and Project Delivery Managers managing project budget, costing, SOW and PO for software contracts and resources furnished in onsite/offshore.
• Extensive practical knowledge of Agile/Scrum principles in addition to CMMI and IEEE software standards.

TECHNICAL SKILLS:

BA Tools: Rational Req Pro, BluePrints, MS Office, MS Access

SDLC Methodologies: RUP, Agile, Scrum, Waterfall.

Testing Tools: HP Application Lifecycle Management (ALM)

OLTP: CICS

Tools: Rexx, Eazytrieve, File Aid

BI Tools: Microstrategy, Tableau Desktop & Server 7, 8 & 9 versions, Business Objects

Business Modeling Tools: MS Visio, Rational Rose, Business Modeler, BluePrints, MHUB

Defect Management Tool: HP Quality Center

Languages: COBOL, JCL, C

Database: VSAM, Oracle, Teradata, Salesforce, MySQL,Toad

Reporting Tools: Cognos, Crystal reports, Business objects

Other: AUTO CAD, Changeman, CA7-Scheduler, Xpeditor, TWS, Endeavour

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Lead Data Management Analyst/Business Analyst

• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets
• Work with business partners to gather and understand functional requirements, develop complex queries and provide reports.
• Provide thought leadership and participate with projects that involve any of the upstream or downstream data flows and processes.
• Ensure controls are in place over applications to ensure the data integrity by performing data integrity gap analysis.
• Construct the business definitions and business rules to the associated business terms.
• Interact with business on a regular basis to contruct business certified definitions for the business terms.
• Analyze and create the business rules in order be compatible with the business model.
• Work on data remediation in order to remediate the data with issues.
• Perform data quality checks on the data against the data quality measures like uniquenes, validity, completeness.
• Coordinated with the Business Users and SMEs get KYC requirements and then analyzed and documented system requirements and procedural changes along with compilation and distribution of supporting documentation to facilitate the KYC process.
• Involved in the full SDLC life cycle of KYC Module starting from going through the specifications and documentation, Testing, Deployment, UAT and Production release.
• Raise the defects on ALM and ensure the defects are fixed on time
• Validate the data profiles on MHUB and generate customized reports on MHUB.
• Prepare to-be process flows and design artifacts using process/solution/product knowledge.
• Preparation of mapping artifacts to contribute towards ETL development.
• Involve in regular status meeting to provide development updates to project teams.
• Perform comparitive analysis of multiple products, frameworks and technologies.
• As part of the Agile environment, responsible for segregating the requirements into various sprints.
• Translating the requirements into user stories and prioritizing the same as per the business needs.
• Conducted JAD sessions to have the walkthrough of the requirements and solution the requirements with the ETL team.
• Keeping track of the user stories and delivering the same to business.
• Developed process flows and activity diagrams for the data flow from the legacy sytem to the target.
• Developed mapping artifacts for the ETL team to refer to.
• Written pseudo code for the transformation logics to be utilized by the ETL team.
• Played a key role in the scrum meetings.
• Understanding of SAS code to translate the same to mapping artifacts to be used by the ETL team.
• Review test plans/cases,conduct root cause analysis and take corrective steps.
• Conducted JAD sessions for requirements gathering and solutioning the requirements with the technical teams.
• Performed data profiling to check data quality measures in terms of accuracy and data reliability.
• Provide inputs and make sure the DataMart is desirable for BI Tools to report.
• Generating the tableau reports for the bank.
• Generated graphical reports through tableau to check the performance of the campaigns and offers.
• Developed highly Visualization dashboards.
• Performed data analysis for the ETL team by executing SQL queries..
• Created data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Integrated Cognos with Cognos BI and performed BI Reporting
• Utilized Informatica for Extraction, Transformation and Loading; Cognos for report generation of the data to be analyzed from the data warehouse and data marts
• Accessing and interpreting data using UNIX scripts.

Environment: Toad, SQL,SAS, Rational ReqPro, HP Quality Center, Informatica, Tableau, UNIX .

Confidential

Lead Business Analyst/ Tableau Analyst

Responsibilities:

• Own and deliver end to end project functionality from feasibility analysis stage to production support.
• Created documentations for Project initiation, BRD/FRD, Use Cases, Release Management logs and Scrum Planning,
• Assisted PM in Project planning, RAID logs management and in defining Agile work scope of the Program into Strategic Initiatives, Programs, Epics, Features and Stories/Task.
• Developed and estimated the ROM to present to the stakeholders.
• Created business and technical roadmaps for Data mart, implementation designs, identification of tables for Data Sourcing, and serving as bridge between business and IT team (Data Modelers, ETL and QA).
• Performed data Integrity analysis using MS Access.
• Performed data mapping, logical data modelling in Salesforce, created class diagrams and ER diagrams and used SQL queries to filter data
• Translated the requirements to user stories for various sprints on Salesforce and assigned story points based on priority.
• Implemented dynamic Tableau visualisations with the help of Tableau KPI's.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Mapped Data Lineage for various source systems, right from data origination to results area.
• Worked with Internal modelling team for data analysis and profiling.
• Worked with Data governance and quality.
• Worked on mapping and validating new field requirements.
• Actively participated in gathering requirements from various markets, SMEs, Risk Analysts via JAD/JAR sessions.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Designed and developed Use Cases, Activity Diagrams.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Gathered data from the legacy system (Salesforce) to the present updated system using data warehouse tools such as Informatica.
• Acknowledgement and tracking of the user stories.
• Interacted with various SME's to understand the scope of central build and have created business requirements, system requirements and design documents for major retailing markets of Confidential .
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Responsible for loading, testing, and maintaining courses/content and learning tracks in LMS
• Working on LMS Sum Total implementation and integration with SAP using WebMethods.
• Worked on data modelling and produced data mapping and data definition documentation
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system.
• Use Tableau desktop to create dashboards that provide concise and actionable insights to client.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps,etc., to assist business users in solving complex problems.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Migrating reports from Qlikview BI to Cognos BI
• Trained the customers with regard to the reports developed and the Tableau reporting tool.
• Conducted JAD sessions to resolve critical issues
• Prepared the UAT test plan for the stakeholders as per the requirements.
• Coordinate with various BUs and various stakeholders globally to accelerate the UAT testing and responsible for receiving the UAT sign off.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Participated in Affiliate Review Processes.

Environment: Oracle, RALLY, MS-Visio, Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio, Informatica, Oracle, Tableau Server, Agile, Salesforce, Quality Center, Tableau 9.2

Confidential

Senior BI Developer/Data Analyst

Responsibilities:

• Worked with Product Owners to set release plans and prioritize scope in the initial discussion sessions
• Elicit business objectives and requirements, and communicate/document them in a clear, concise way.
• Lead systems design approach and collaborate with technical teams to recommend solutions; ensuring all interfaces are identified and understood with respect to documented business processes and system workflows.
• Developed a Learning Management System (LMS) for Staff, Customer and Partner training
• Follow FSDM delivery methodology for documentation, provide estimate analysis, establish milestones and manage scope
• Execution of the BTEQ, MLOAD and FLOAD scripts through JCL’s to ensure data availability in Teradata.
• Performing the data analysis in the database to design the dimensions and measures in Tableau.
• Developed various dashboards in Tableau as per the customer needs.
• Trained the end users on Tableau and creating PowerPoint presentations with regard to the developed reports and educational presentations on Tableau.
• Conduct quality assessments of coursework received from vendors through Articulate Quizmaker, Quick Assessment in Sum Total implementation

Environment: Tools: Visio, SharePoint; Tableau Dev Environment - DB2, JCL.

Confidential

Senior Developer/Data Analyst

Responsibilities:

• Read the rules and analyze to create template for analysis of 4000+ business entities
• Coordinate with various BUs and various stakeholders globally for additional documents pertaining to in corporation, activities, purpose, trading products list, investor list and constitutional references for shell, standalone and subsidiary entities to extract records of investors, products and positions
• Validate data against business entities and updated management with deliverables post analysis of BU’s located globally.
• Worked on various modules like KYC Module, Recertification Module, User Module and Reporting Module of the application
• Worked closely with Compliance to identify medium and high-risk customers and evaluated client AML/KYC risk, including conducting independent research, verifying appropriate risk profile, and making independent risk assessment recommendations.
• Extensive usage of MS access for data integrity analysis and mutual funds market research
• Validate records and transactions from legacy database (DB2) on business entity setup services offered by Confidential .
• Conducted JAD sessions for project feasibility and business requirements
• Document Use Cases (UC), System Specifications, Navigation flows and co-ordinate with UX team for UI design.
• Developed various dashboards in Tableau by creating Filters, quick filters, table calculations, calculated measures and parameters.
• Developed bar charts with trend lines and forecasting.
• Publishing the reports and dashboards on Tableau server .
• Validating the tableau reports against the database.
• Maintainence of user profiles and access profiles in the Tableau server for the services provided to the customers.
• Coordinated with various BUs and stakeholders for system requirements, product integration documentation, testing and implementation of the systems.
• Created shipment and order reports using Cognos Report Studio
• Validate metrics and evaluate release candidates based on Testing and Development release cycles.
• Analyzed, researched and recommended well articulated feasible solutions for implementing new designs and suggested underlying dependencies to mitigate risk.
• Extensive usage of HPQC for the acknowledgement of tickets and defect tracking.

Environment: Tableau 8.0, DB2, JCL, MS-EXCEL, MS-POWERPOINT, SharePoint, MS Visio, HPQC

Confidential

BA QA

Responsibilities:

• Trust and Securities Servicing (TSS) IT, identifies needs and requirements of business groups to manage streaming operations across trust and securities landscape of Deutsche Bank ensuring management of processes/applications for business continuity.
• Lead the Software Testing Team (8 members) to execute unit and SIT and documented errors/bugs in IBM Synergy
• Responsible for test delivery including work allocation, resource management, test release management and status reports to senior management using ‘PM Smart’, a CMMI compliant proprietary tool.

Environment: IBM Synergy

Confidential

Business Systems Analyst

Responsibilities:

• Conducted user interviews and requirements gathering sessions
• Documented and published BRD, FRD, Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Interacted with Product Owners for requirement gathering interviews, defining user stories, sprint planning, backlog grooming, delivery management and conducting sprint retrospective for future sprints.
• Conducted Product Backlog Grooming sessions to improve the requirements, user stories and to finalize the functionalities that need to be delivered in each sprint
• Involved in budget management and ROI analysis.
• Worked with Business users to come up with Reporting Requirements. Reports were developed in Cognos
• Worked on the databases to understand the source & target systems, volume of data, staging areas, transfer methods, reports and listed all of them in a spread sheet as part of conversion activities.
• Executing the BTEQ and MLOAD scripts to ensure the appropriate data loading.
• Preparation of test scripts and test plan for UAT.
• Testing the developed reports in Microstrategy and presenting the same to end clients.
• Mentored the en users on Microstrategy.

Environment: Teradata, SQL, Rational Req Pro, HP Quality Center, Microstrategy,JCL.

Confidential

Sr. Developer

Responsibilities:

• Lead the infrastructure batch support team of 6 and train the new joinees so that they can be part of future upgrade project.
• Involved in analysis of versions and coding the environmental components such as JCL’s, Sort Cards and Ezytrieves etc from the infrastructure point of view.
• Prepared the entire CMS Batch flow taking care of the GOLD 2.0 functionalities & aligning it with OHC 2.0 functionalities.
• Involved in the batch support during all the phases of testing (SIT & UAT) which includes issue resolution as well.

Environment: COBOL, JCL, CA-7