• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees). • Interact with business users to identify dashboard strategies, wire frames and analysis presentations.• Delivered multiple dashboards Mitigate Risk, Track Critical Dates, Portfolio Summary, Optimize Cost, Browse Properties, Manage Transactions and C &W performance summary.• Delivered multiple reports; Critical Dates, Target market Rent vs Offers, Lease Holdovers, Transaction Schedules, Mark to market variance, Upcoming expansions/Area, Portfolio ownership overview, largest site cost summary, Upcoming expirations/Area, Building cost/Area, Regional cost Summary, options lease, opportunity lease and lease scoring summary.• Continuously analyze existing KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps.• Delivered UAT test cases; validated the quality and integrity of the data included in the Reporting Packages and Dashboards.• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.• Involved in the competitive market analysis research for the Production team to provide insight into enhancements using Power BI.• Deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source.• Creating custom complex data analytics in Microsoft Power BI to identify trends within quality data and find new sources of revenue within customer data.• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder.

• Worked on Data Management and Business Solutions team, worked on Data Analysis, Requirement gathering, GAP analysis, Data Mapping and Testing of ETL and BI Reporting requirements.• Created source to Target data mapping document for reconciliation between different data systems.• Report Development using AXIOM Controller View creation of Data Sources, Data Models, Shorthand, Portfolios, Aggregations, Free Form and Tabular Report and workflows using AXIOM Controller View tool.• Used Agile/Scrum method for gathering requirements, documenting user stories to discuss project specifications.• Worked on business requirements from CIB and IHC Financial Reporting, Management Reporting, and Regulatory Reporting work streams to improve the process and quality of Board reports, management reports, financial statements, and regulatory reports (i.e. FRY-9C, FRY-9LP, FRY-12, FRY-15, and FRY-11).• Create Pricing Report along with creating Pivot Table for review and compare against.• Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.• Worked with users and IT to confirm manual data input templates which could be configured by AXIOM, plan Feed and Line Automation, and create Functional Requirements Document (FRD).• Worked on Exporting large data sets to excel relational worksheets, pivot tables, create massive formulas and VLOOKUPs to compare data and perform searches.• Handled several projects for the HR and Finance areas as well as Revenue Accounting.• Deploying a tool that analyzed absolute products leading to productivity savings developed a model to forecast demand for different Exchanges.• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.• Analyzed business requirements and employed Unified Modeling Language (UML) to develop high-level and low-level Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data-flow Diagrams, Business Workflow Diagrams, Swim Lane Diagrams, using Rational Rose.• Gathered requirements to customize ATG provided solutions, services, and ongoing guidance to power a more relevant and personal e-commerce.• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.• Partially involved in creating and maintaining data dictionaries for naming various objects in the finance domain.• Using Shared Containers and creating reusable components for local and shared use in the ETL process.• Worked on creating and maintaining sales reporting using MS Excel queries, SQL in Teradata, and MS Access, produce performance reports and implement changes for improved reporting.• Working with region and country AML Compliance leads to support start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases training, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.

• Gathered requirements from Business Owners, stakeholders, Data Governance Team, and the subject matter.• Experts through meetings to understand needs of the system.• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.• Involved in SDLC including requirements gathering, designing, developing, testing, and release to the Production environment.• Used Data Warehouse Architecture and Design - Star or Snowflake Schema, FACT and Dimensional Tables.• Physical/Logical Data Modeling and data flow diagrams.• Involved in developing and maintaining the Requirement Traceability Matrix (RTM).• Analysis of the Enterprise Data Warehouse in Teradata to create accurate fact and dimension tables so that it can be queried by OBIEE.• Participated with the team in building the Data Quality projects/solutions using Trillium Software System for customers.• Involved in Creating impactful dashboard in excel for data reporting by using Get pivot and VLOOKUP, helped in transforming raw data into meaningful, actionable information.• Moderate Linux Red hat, UNIX Commands awareness, Application Automated Performance Monitor and Resource Analysis, Oracle DB tools, troubleshooting and system application log reviews to maximize speed and accuracy.• Coordinate with Account Managers to discuss and approve Informatica Workflow requirements and logic Troubleshoot design options for new Informatica Workflow.• Analyzed SQL performance using Teradata viewpoint.• Extensively done ETL process and extracted the data from different source systems like Teradata, Sales force, MS SQL Server, Flat files, XML.• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata.• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.• Transformations of requirements into data structures, which can be used to efficiently store, manipulate, and retrieve information.• Worked with different business users to develop Vision Document and Business Requirement Specifications by gathering Business and Functional Requirements. Experience supporting the full Software Development Life Cycle SDLC in Agile Scrum methodology.• Documented the AS-IS Business Workflow adhering to UML standards. Comprehensively performed requirement gathering for enterprise reporting system-using Requisite Pro.• Collaborate with data modelers and ETL developers in creating the Data Functional Design documents.• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata Performed data integrity and balance sheet verification procedures, as well as contributing to process improvements in the product control function.• Maintained a Traceability Matrix to ensure that all Functional Requirements are addressed at the Use Case Level as well as the Test Case Level.• Performed Functional and GUI Testing to ensure that the user acceptance criteria are met. Created User training materials. Co-coordinated with the SME'S to make sure that all the Business Requirements are addressed in the application.• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day.• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Bank data warehouse EDW.