| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SUMMARY:Excellent professional communication skills through clearly written, concise and comprehensive documentation; strong technical writing skills and ability to develop and/or present training to operations trainers and/or business users.Experienced in Data mining of disparate Data sources and with NPR Report Writing and Crystal Reports.Prepare reports and coordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.Experience with multiple Customer Assignment System proprietary systems and with SQL Database and knowledge of different ETL tools (PL/SQL, SSIS, T-SQL, Data Migrator.Experience with SSRS Report Builder, TeraData SQL Reporting, Toad Data Point and worked with ALM or Quality Centre for defect tracking and testing.Used advanced Tableau features including calculated fields, parameters, table calculations, joins, Data blending, and dashboard actions.Responsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS Excel and used complex computer programs to mine Data sources and look for trends.Support Data manipulation and developed performance metrics with BI reporting tools MicroStrategy, Tableau, Power BI, Qlik and Cognos.regulatory requirements and Data model governance10 years experience in Data management10 years experience in Data governance10 years experience in Data analysisStrong experience defining and documenting process flows and design in both verbals to transfer into system requirements and specificationsTECHNICAL SKILLS:Proficient in numerous MS Office Applications, PowerPointExperienced working with CognosExperienced working with QlikExperienced working with Power BI ReportingAdvanced MS ExcelExperience with all phases of Software Development Life Cycle, Agile/Scrum methodologiesExperience with Visual Basic, VB Script or similar language (PowerShell, JavaScript, Auto Hotkey, Autofit)Advanced knowledge in Visio Studio, SharePointAbility to build or create Tableau DashboardsActive DirectoryDemonstrated ability to be work under pressure and to meet tight deadlines with proactive, decisiveness and flexibilityEXPERIENCE:Wells Fargo - Lead Data Management Analyst Dallas, Texas 09/2022 to PresentPerform initial analysis of Application Data to determine potential owners of Application Groups. Work with both business and technology partners identified as potential owners to obtain ownership agreement.Work with IT development team to get ownership of Application Group(s) properly assigned to the owner.Maintain detailed tracking logs that identify the status of each Application Group. Provide visual diagrams such as bar charts based off of the Data in the tracking logs. Analyzing business requirements with complex logics.Identify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailableDeveloped perp Flow Diagrams for Tableau dashboard.Develop Power BI reports and Dashboard for internal team needsPartner with other team members as well as cross-functional partners to support business processes, system solutions and strategic projectsChallenge conventional thought, offer unique perspectives and conceive innovative solutionsWrite & execute Test Plans and Test Scripts (both Functional and Data Integrity)Identify opportunities to streamline or improve processes through operational or technical solutionsWrite and execute basic SQL queries (knowledge of Database structure necessary)Perform Excel VLOOKUPs, various count formulas and build out charts based on those formulasProvide technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines.Establish and formalize relationships in and between departments where business critical dependencies have been identified.Provide input during development and implementation phases, including formulation and definition of systems scope, objectives, and necessary system enhancements.Northern Trust - Business/Data Analyst Remote 09/2021 to 09/2022Perform initial analysis of Active Directory Group Data to determine potential owners of Active Directory Group(s).Work with both business and technology partners identified as potential owners to obtain ownership agreement.Linked Tableau server to publish dashboard to a central location for portal integration.Work with IT development team to get ownership of Active Directory Group(s) properly assigned to the owner.Utilize all Tableau tools including Tableau Desktop, Tableau Public/Online/Server, and Tableau Reader.Maintain detailed tracking logs that identify the status of each Active Directory Group. Provide visual diagrams such as bar charts based off of the Data in the tracking logs. Analyzing business requirements with complex logicsDesign, configure, and document Tableau Data Source and Extract.Identify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailableWrite & execute Test Plans and Test Scripts (both Functional and Data Integrity)Identify opportunities to streamline or improve processes through operational or technical solutionsWrite and execute basic SQL queries (knowledge of Database structure necessary)Perform Excel VLOOKUPs, various count formulas and build out charts based on those formulasAmerican Eagle - Data Analyst Remote 03/2021 to 09/2021Work daily with Oracle Financial as part of Implementation TeamServe as direct consultant for Finance & Accounting team, assisting with Oracle integration and Data validationAnalyzing business requirements with complex logicsManage the domestic and international supply chain Data stream identifying exceptions and resolving discrepanciesIdentify Data gaps and research missing transmissions by using reporting and partner systems; Create Data where transmissions are unavailableCreate and utilize reporting to analyze trends and ensure compliance from our Data trading partnersExperience in configuration and administration of Tableau Server in a multi-server and multi-tier environment.Implement supply chain-related integrations (flat files, EDI transactions, XML) with Trading PartnersActively manage and contribute to Data compliance programs and scorecardsPartner with other team members as well as cross-functional partners to support business processes, system solutions and strategic projectsChallenge conventional thought, offer unique perspectives and conceive innovative solutionsWrite & execute Test Plans and Test Scripts (both Functional and Data Integrity)Identify opportunities to streamline or improve processes through operational or technical solutionsWrite and execute basic SQL queries (knowledge of Database structure necessary)Utilize business intelligence reports/dashboards using QlikView, Tableau or CognosParticipate in appropriate training and development activitiesBank of America - Data Analyst/Database Tester Dallas, Texas 06/2020 to 11/2020Analyzing business requirements with complex logics, translation of business logic into test cases/scriptsCreated report schedules on Tableau server. Created drill down and drill up in worksheets in tableau.Responsible for SQL Database testing using SQL server or Oracle.Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.Deploy QA builds, applying OTSs & running batch processes on QA environments.Troubleshoot issues occurred during the testing.Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.Perform modification of the code/SPs in test and creation of the test DataFunctional Testing and Data Integration Testing & executing Automated Test ScriptsTest Management tools like HP-ALM QC, JIRAWells Fargo - Data Analyst Dallas, Texas 07/2019 to 04/2020Makes recommendations based on Data analysis that may have performance and financial impacts to the companyResponsible for SQL Database design, architecture, administration, and report customization.Prepare reports on excel and coordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.Prepare Dashboards using calculations, parameters in Tableau.Develop performance metrics and develop Database QA tools and KPI metrics.Conduct and contribute to project meetings and responsible Database and reporting functionalityDesign interactive dashboards in Tableau Desktop and published them to Tableau Server.Design and maintain Data Dictionary for Technical and Business stakeholdersDesign and maintain MetaData templates for Technical and Business stakeholdersProvide Data analysis to support business requirements definition and interact with both the business and technical partners.Collecting, organizing, and analyzing Data from various resources and prepare complex Data reports on excel.Experience in retrieving Data with TeraData, Oracle, and SQLCreated own customized visualizations in tableau.Managing the activities required to maintain a Data & process governance structureDemonstrated experience in one or more of the following disciplines: Data QualityManage the daily, weekly, and monthly reports on excel and contribute to continuous improvement projects and Data maintenance projects.Steward Health Care System - Supply Chain Data Analyst II Richardson, Texas 08/2018 to 07/2019Makes recommendations based on Data analysis that may have performance and financial impacts to the companyResponsible for SQL Database design, architecture, administration, and report customization.Responsible for Database and reporting functionalityUtilize MS Excel and interpret Data, extract trends, and identify insightsCoordinate on various system process improvement initiatives and exciting ad hoc analytic projects as assigned by the Director, Process & System Performance.Develop performance metrics with BI reporting tools MicroStrategy, Tableau, Power BI, Qlik and Cognos.Develop Database QA tools and KPI metrics and utilize excel and interpret Data.Assist supply chain team with DBA support when needed.Present reporting to supply chain team members and hospital users as required on excelCollecting, organizing, and analyzing Data from various resources and generate reports on excel.Experience in retrieving Data with TeraData and SQLContribute to continuous improvement projects and Data maintenance projects in the Supply Chain Department.Responsible for a range of activities including statistical analysis, designing, and deploying dashboards, identifying key trends based on Data, and forecasting or predicting business outcomes.Design and maintain Data Dictionary for Technical and Business stakeholdersAssist with the ETL and Data modelling using AlteryxAssist with building and maintenance of Data warehouseBank of America - Business Intelligence Consultant Richardson, Texas 08/2017 to 03/2018Makes recommendations based on Data analysis that may have performance and financial impacts to the companyUse complex computer programs to mine Data sources and look for trends.Effectively works with cross-functional teams and establishes strong relationships with key members of the Compliance Operations teamCreated own customized visualizations in tableau.Manually combine Data elements to create compliance to track performanceGenerate Performance Reports daily, weekly, and monthly and promptly distribute to all business owners and the executive management team in a timely manner.Interpret Data, extract trends, and identify insightsProactively provide timely feedback to the management team whenever key metrics and measurements exceed the acceptable parameters.Used advanced Tableau features including calculated fields, parameters, table calculations, joins, Data blending, and dashboard actions.Designing and plan BI solutionsDesign interactive dashboards in Tableau Desktop and published them to Tableau Server.Writing relational and multidimensional Database queriesConfiguring, deploying, and maintaining Database serversExperience with Data Extraction, Transformation and Loading (ETL) with Microsoft SQL Server SSIS from different Data sources like DB2, Oracle, MS SQL Server etc.Experienced with different Relational Databases like TeraData, Oracle, and SQL Server.Experienced working on large volume of Data using TeraData SQLResponsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS ExcelWrote several TeraData SQL Queries using TeraData SQL Assistant for Ad Hoc Data Pull request and used Joins like Inner Joins, Outer joins while creating tables from multiple tables.Utilized ODBC for connectivity to TeraData via MS Excel to retrieve automatically from TeraData Database.Designed & developed various Ad hoc reports for different teams in Business (TeraData and Oracle SQL, MS ACCESS, MS EXCEL)Created pivot tables in Excel by getting Data from Toad, TeraData, and Oracle.Design, configure, and document Tableau Data Source and ExtractExperienced structured Databases, information architecture, metaData management, and documentationExperienced Visual Studio, Team Foundation Server, Agile, SharePoint, and Microsoft teams.Develops, implements, and maintains policies and procedures regarding regulatory requirements and Data model governanceDesign and maintain Data asset-related artifactsDevelop and deliver presentations, summarizing key business needs and articulating model options to facilitate model optimization decisions and to drive decision-making with key stakeholdersDesign and maintain Data Dictionary for Technical and Business stakeholdersSupport Data manipulationWriting reports/reporting services using SSRSSupported Compliance reports with Microsoft SQL Server SSRSBank Of America - Business Intelligence Developer Dallas, Texas 08/2016 to 07/2017Effectively works with cross-functional teams and establishes strong relationships with key members of the Compliance Operations teamMakes recommendations based on Data analysis that may have performance and financial impacts to the companyUse complex computer programs to mine Data sources and look for trends.Manually combine Data elements to create compliance to track performanceGenerate Performance Reports daily, weekly, and monthly and promptly distribute to all business owners and the executive management team in a timely manner.Interpret Data, extract trends, and identify insightsExtensive experience in working with Tableau Desktop, Tableau Server, Tableau Online in various versions of TableauCreate user support documents for Tableau use to be shared on SharePointWriting relational and multidimensional Database queriesConfiguring, deploying, and maintaining Database serversExperience with Data Extraction, Transformation and Loading (ETL) from different Data sources like Toad, DB2, Oracle, MS SQL Server etc.Provide ongoing support and user training for Tableau useExperienced with different Relational Databases like TeraData, Oracle, and SQL Server.Experienced working on large volume of Data using TeraData SQLResponsible for Analyzing report requirements and developing the reports by writing TeraData SQL Queries and using MS ExcelWrote several TeraData SQL Queries using TeraData SQL Assistant for Ad Hoc Data Pull request.Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.Utilized ODBC for connectivity to TeraData via MS Excel to retrieve automatically from TeraData Database.End to end experience in designing and deploying Data visualizations using Tableau.Designed & developed various Ad hoc reports for different teams in Business (TeraData and Oracle SQL, MS ACCESS, MS EXCEL)Created pivot tables in Excel by getting Data from TeraData and Oracle.AT&T - Business/Data Analyst Plano, Texas 02/2016 to 08/2016City Of Arlington - Data Inventory Analyst Arlington, Texas 11/2015 to 02/2016Ernst & Young - Data Research Analyst Dallas, Texas 03/2014 to 11/2015Dr. Pepper - Data Research Analyst Plano, Texas 11/2013 to 03/2014Interface People - Data Support Specialist Lewisville, Texas 06/2011 to 10/2013Education:Tarrant County CollegeAssociate Degree in CommunicationCola berry School of Data AnalyticsDeveloping BI/EDW Applications with MS SQL ServerBusiness Intelligence applications with Microsoft SQL Server 2016 using SSIS, SSRS and SSAS services.70-467 Designing Business Intelligence Solutions with Microsoft SQL Server Certification |
