• Developing workflows in Alteryx using aggregations, formulas, database connections, and iterative macros.• Querying data in Oracle SQL Developer.• Collaborating with data visualization teams and delivering Tableau data sources using Alteryx.

• Migrating large data sets, data mapping between SQL environments and applications (Loan origination systems). • Conducting data analysis and proposing SQL transformation for development team. • Meeting with team daily to discuss objectives. • Conducting QA on newly implemented releases.• Creating SQL logic with joins, aggregate functions and case statements in SQL Server, Postgres and Snowflake environments.• Conducting analysis in multiple AWS platforms including Amazon Cloud Watch, Athena, S3 and Dynamo DB. • Interfacing with clients and collecting requirements. • Tracking workflow, creating user stories and defects in JIRA. • Partaking in Agile ceremonies (Sprint planning, sprint review, sprint demos, refinements and retrospectives). • Retrieving and mapping data from APIs in Postman • Using tools such as Zoom, Google Suite, Smartsheet and Slack.

Bank of America's Mortgage Data Technology• Conducting data analysis and systems analysis and creating business requirement documents (BRD) and business change documents (BCD).• Coordinating with Agile team by attending and participating in Daily Stand-Up meetings.• Handling different Agile roles to ensure work completion.• Implementing SDLC using Agile (SAFe).• Contributing to enhancement and development by providing work on time and announcing roadblocks to team during periodic team meetings.• Created complex SQL queries with joins, common table expressions, aggregate functions, case statements, etc.• Pulling data from different tables for Ad-hoc reports.• Conducting quality assurance (QA) tests on data for validity.• Creating and executing Test Plans and creating User Acceptance Testing (UAT) Reports.• Using MS Excel formulas to create SQL statements quickly.• Researching and analyzing data to resolve irregular issues where table fields are sourced incorrectly in the data warehouse. • Consistently updating analysis documentation with new findings.• Using various tools & software systems such as Jira, Rally, WebEx, SharePoint, TFS, and Visual Studio.• Regularly using MS applications (Excel, Word, PowerPoint, and Outlook).• Attending calls, or in person meetings with managers for progressive knowledge transfer.• Scheduling meetings with team members and managers for process improvement.• Accepting additional workload when appropriate.

• Creating Reports with data queried using SQL.• Creating Pivot Tables in Excel• Supporting technical issues in within the company.• Updating and enhancing company web sites by modifying HTML and Angular code.• Using Mantis bug tracking software.• Writing update statements to update user-end data.• Creating specification documents to keep track of the changes.• Creating process documents for business process flow.• Creating user handbooks and guides for smooth navigation through company platforms.• Migrating data from Excel and CSV files to SQL databases using SSMS tasks.• Coordinating with off-shore team to pass on functional requirements.• Optimizing and enhancing existing Standard Operating Procedures (SOPs) for better business results.• Analyzing areas that need to be improved in company websites.• Optimizing existing documents with Enhanced written English structure and formatting.• Attending meetings with managers to establish work order.

• Conducting functional QA testing on client websites.• Documenting QA test cases.• Using Mantis Bug Tracking software to report errors in websites.• Engaging and meeting with clients for website requirements.• Using MS Excel to document and organize client interactions.• Updating client information in company online CRM software.• Engaging in daily meetings with managers to enhance business workflow.• Scheduling meetings and creating support tickets for clients.• Regularly using MS applications such as Excel, Word PowerPoint and Outlook.• Managing client’s Yelp business page by responding to customer concerns and updating business information.