| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name , M.B.A.Business AnalystPHONE NUMBER AVAILABLE Glastonbury, CT EMAIL AVAILABLE LINKEDIN LINK AVAILABLE PROFESSIONAL SUMMARY Over 6 years of professional IT experience in technical and business analysis. My expertise lies in data management and analysis, showcasing proficiency in Excel, including macros and pivot tables. Successfully led the accounting and billing processes for a $2 million federal and state grant program. Exceptional team skills demonstrated through coaching students, collaborating with end users and vendors, and effectively working with cross-functional teams to implement successful database design projects. AREAS OF EXPERTISE CompensationAnalysis Data Management Documentation Bookkeeping Payroll Problem Solving RelationshipBuilding ProjectManagement Federal Grants Analytical Skills Communication Skills Business Acumen Teamwork Collaboration Annual Audit Confidentiality Flexibility Excel Proficiency,including Macros andPivot Tables QuickbooksPROFESSIONAL EXPERIENCE Efficiency for All, Windsor, CT Program/Data Specialist DECEMBER 2022 - MAY 2024Community organization that offers training in building science and energy efficiency to students in diversity, equity and inclusion (D.E.I.) and Environmental Justice Communities. Led accounting and billing processes for a $2 million federal and state grant program funded by the Inflation Reduction Act by maintaining Quickbooks and supporting documents with Excel Delivered supplemental income to the program of $50,000 by writing an additional grant Coached students in accessing support services, including helping with financial planning and resumes. Collect weekly timesheets and prepare weekly payroll for both regular employees and students doing On-the-Job Training Manage student stipends and additional benefits allocated to them through the program Nationwide, Columbus, OH Sr. Analyst, Data Designer NOVEMBER 2017 - MAY 2021Recruited to fill the role of Data Analyst for the Data Management Division. Moved across the country and learned a massive amount about databases. Instruct the coders how to ingest data from overnight data source by creating 53 source-to-target mappings. Collaborate with end users and vendors to identify requirements for an Oracle Database replacement on AWS. Create tables within an MS SQL Server by designing 19 Data Definition Language Scripts (DDLs) Ensure data cohesion by conducting interviews with subject matter experts (SMEs) Ensure adherence to best practices for Software Development Life Cycle (SDLC), DevOps, and DataOps. Understand the organization's data to skillfully carry out the company's database design projects by designing and using physical and logical data models, data lineages, and data dictionaries. Follow proper workflow and Agile methodologies by utilizing RTC and Jira. Jade Marketing Group, LLC, West Hartford, CT Jr. Business Analyst FEBRUARY 2014 - MAY 2017Blue jeans company focused on optimizing the supply chain between China and the United States. Company designed various jeans and denim apparel. Initially recruited for data entry and quickly promoted to IT. Sped up weekly reporting process from 4 hours to 5 minutes by automating process with macros in Excel Created sales reporting process for major customers by scraping data from retailers and organizing into coordinated dashboards for departmental users, optimizing statistical efficiency and data quality. Conducted analysis to identify best-selling jeans and created a display for the sales team to know what products to push.EDUCATION Master in Business Administration, University of Kentucky, Lexington, KY Certificate in Editing, New York University, New York, NY Bachelor of Arts, English, University of Connecticut, Storrs, CT TECHNICAL SKILLS Jira MS Office Suite Data Analysis HTML CSS SQL Data Governance Data Lineage Data Modeling Business Analysis Financial Management, including Bookkeeping Excel: VBA/Macros and Pivot Tables Documentation: Source to Target Mapping Agile Methodology Grant Writing Payroll Projects M=Power Efficiency f0r All, Windsor, CTProvided direct support and training for students to become Building Scientists. Supported six weeks of intensive classroom training to earn OSHA and Building Performance Institute (BPI) certificates to work in energy efficiency careers. I was responsible for payroll for the following six weeks of On the Job Training. Actuarial Modernization Project Nationwide, Columbus, OH Project combined financial databases. Completed Source to Target Mappings (STMs), Data Definition Language Scripts (DDLs), Data Lineages, Logical and Physical Data Models (LDMs and PDMs) using IBM Infosphere Data Architect. Work was managed through RTC and Jira using Agile methodology. University of Kentucky Project Connect Valvoline, Lexington, KY Identified opportunities for process improvements at a Marketing Warehouse on the outskirts of Lexington. Mapped out the entire supply chain and found areas where communication could be improved. Developed standard operating procedures to correct.Linked In Profile: https://LINKEDIN LINK AVAILABLE |