Colin Alexander Email & Phone Number

Tallahassee, Fl, Us

Mclean, Va, Us

• Assisted the management of developing and coordinating warehouse deployments, ensuring timely & accurate execution.• Conduct detailed data mapping, architecture, SQL warehousing, and developed conceptual data models for organization.• Performed cleaning and validation standards and guidelines to custom SQL queries requested by stakeholders and team. • Designed and executed test cases for UAT, validating data accuracy and user interface alignment for business processes.• Led over 10 data analysis projects using Agile and SCRUM methodology, improving business decision-making by 20%. • Develop and migrate datasets into PowerBI to utilize text tables, visualizations, DAX/aggregations, and level of detail. • Lead requirement sessions with stakeholders to gather insight & translate business needs into actionable product features.• Created Jira dashboards for real-time tracking of team progress and improving transparency across internal stakeholders.• Develop user stories, acceptance criteria, and process flows for communication between business and technology teams.• Facilitate data mapping and identify gaps to support the legacy suite modernization for the Servicing line of business.• Managed, coordinated, and designed Freddie Mac internal websites for team organization to gather documents and files.• Conduct detailed data mapping, architecture, SQL warehousing, and developed conceptual data models for company. • Assisting in the management of developing and coordinating DDL deployments, ensuring timely and accurate execution. • Develop and migrate code into PowerBI to utilize text tables, chart visualizations, DAX/aggregations, and level of detail. • Utilize ServiceNow, Eclipse, and ER/Studio to create data models and provide SQL reports and queries for data analyst.

Cordova, Tennessee, Us

• Managed 300,000+ products and analyzed sales in 150 locations between the US and Canada for planning and budgeting.• Worked closely with the Director of Global Sourcing to develop market strategies and support the product development.• Cultivated relationships with 200+ vendors and several key business partners to expand product lines across the country.• Prepared pricing, delivery, and usage reports in Tableau for stakeholders, resulting in a 25% increase in decision making.• Generated weekly status reports of pending and approved updates to managers at our corporate headquarters and retail.• Design, develop, & maintain ETL processes to extract, transform, and load data from multiple sources into a warehouse.• Specialized in data validation techniques to maintain data quality and reliability by referencing aggregations and language.• Exhibited advanced Excel skills by showcasing expertise with VBA Macros, IF Statements, VLookUp, Pivot Tables, etc. • Managed data migration projects, achieving 98% smooth and efficient transfer of large datasets with minimal downtime.• Participated in the development and enforcement of data validation rules which reduced data discrepancies by 35%.

Charlotte, Nc, Us

• Demonstrated robust analytical skills by discovering security flaw that allowed a client to receive $150M without approval.• Assisted in the creation and implementation of Excel VBA’s and Macros automation processes to free 20+ hours/week.• Created interactive visualizations in Tableau while improving data accuracy by reducing data processing speeds by 20%.• Analyzed UAT results, data discrepancies, data validation, and complex SQL querying to resolve issues for production.• Maintained data mapping documents in SharePoint to define data transformation, data cleansing, and mapping specifics.• Demonstrated robust analytical skills by discovering security flaw that allowed a client to receive $150M without approval.• Utilized SQL Server for efficient data warehousing, optimizing storage & querying which enhanced data retrieval by 30%.• Ranked in top 10% of employees by understanding time-management, adapting to new situations, and attention to detail. • Identified gaps in data management adherences and assisted developing plans that reduced loan processing gaps by 25%.• Forecasted trends & connected data in order to contribute to design, modeling creation and implementation of strategy.

Charlotte, Nc, Us

• Ranked in top 10% of employees by understanding time-management, adapting to new situations, and attention to detail. • Performed detailed EV, data migration and financial analysis to prepare budget baseline, scheduling, and cost operations. • Knowledge of SharePoint, statistics, analyzing data sets, running/creating queries, presenting findings, and data models.Analyzes data using statistical tools, methods, and techniques; and interprets results to identify significant differences in data. Prepared comprehensive technical reports to interpret data, identify alternatives, and justify recommendations.

Us

• Collaborated with cross functional teams to deliver products on time, resulting in 25% increase in successful delivery rate.• Created product roadmap, prioritizing features based on customer feedback, business objectives, and technical feasibility.• Monitored competitor activities and market dynamics to provide competitive intelligence and maintain industry outlook.• Managed 140 affiliate stores to make product suggestions, create marketing strategies, and provide data SWAT analysis. • Utilized Jira to manage product backlog, track progress, ensure goals are met, and workflows align with company objectives.• Drive innovation by identifying opportunities to leverage data to improve business process and drive strategic initiatives.• Managed 140 affiliate stores to make product suggestions, create marketing strategies, and provide data SWAT analysis. • Collaborated with cross-functional teams to gather requirements and deliver tailored analytical solutions for challenges. • Implemented MicroStrategy dashboards and reports for multinational chains, resulting in 20% sales and revenue growth.• Deployed SQL, Tableau, and Excel applications daily basis to exhibit performance, improving market insights by 30%.• Apply sophisticated statistical techniques to extract insights from large datasets and tackle complex business problems.

Dallas, Tx, Us

• Finished in the top 10% of best sellers from the “February Class" with a top sale of $32,000.• Awarded “Top Sales Performer” for the month of February after exceeding quota by 550%.• Nominated team captain for Class 181 and assists team in exceeding quotas and revenues.Engaged with customers in the sales process from small business owners to multinational organizations and introduced them into IoT products that were being offered by AT&T. Consistently generated new leads and builds relationships with clientele to drive profit margins.

St. Louis, Mo, Us

• Won “Marketing Project Competition” by creating innovative solutions to fix customer service.• Earned number #1 ranking in car sale rental protection for the month of August in group 293.• Assisted branch manager with accounting/accounts receivable work and writing off bad debt.• Increased Lockport’s branch customer satisfactory rating by 10% throughout the internship.

Rochester, Ny, Us

• Demonstrated robust communication skills by responding to customer questions and needs. • Performance level of “Items Per Minute” was 13% greater than the average employee. • Assisted in modifications to the business model and new shirt designs for associates. • Received 100+ daily payments by cash, check, credit cards, or automatic debits.

Cupertino, California, Us

• Received a 97% positive customer service rating by building relationships/trust with customers.• Sold $100,000+ worth of Apple products by leveraging trustworthy and consistent knowledge.• Delivered excellent customer service skills to guests with a high degree of professionalism. • Ranked #2 in encouraging 100+ customers to sign up for “Today at Apple” class sessions.

Chicago, Illinois, Us

• Participated in knowledgeable conversations with portfolio managers about upcoming events.• Applied analytical skills to examining the stock market and bond market on a daily basis.• Forecasted stocks, bonds, and futures daily as well as analyzed the Wall Street Journal.

Chevy Chase, Md, Us

• Only intern to garner 100% approval ratings from top level management for data research work.• Hosted professional meetings with management to discuss current funding and business issues.• Fixed systematic issues by conducting analysis on 200+ associates and clientele of GEICO.• Applied analytical skills to data-based feedback to improve overall satisfaction ratings.

Cincinnati, Oh, Us

• Worked overtime to ensure player needs were fully completed and prepared for the next day. • Toiled in the equipment department to install, repair, and haul in new equipment for players.• Implemented expedite thinking and reaction skills according to coaches and players needs.• Assisted the Cincinnati Bengals on a daily basis in order to keep the organization running.

New York, Ny, Us

• Utilized Power BI, Bloomberg, Morningstar, Excel and PowerPoint to show visualization of outcomes in the market.• Analyzed and connected data in order to contribute to design, modelling creation, and implementation of strategy.Assisted Financial Control department in budgeting, auditing, security analysis (short and long term), and portfolio management. Worked alongside management team to monitor a pooled collection of over $200,000,000 in client allocations. Responsible for inspecting, cleaning, modelling and transforming information to support business decisions.

Master'S Degree, Business Administration

Bachelor Of Arts (B.A.), Business Administration (Financial Analysis)

Boot Camp, Data Analytics

Google Data Analytics Certification, Data Analytics