PROFESSIONAL OBJECTIVE

• Highly motivated, results - driven, IT Professional with seasoned industry experience.
• With a proven track record, possess an excellent mix of business and technical skills.
• I aspire to work for a stable company, with a dynamic and stimulating environment, in a challenging and rewarding position.
• That will enable me to utilize my vast array of data science skills creating business and competitive intelligence strategies, in order for the company to achieve and surpass its strategic objectives.

TECHNICAL SKILLS

Microsoft Operating Systems: XP, Windows 2000, Vista, Windows 7

Office Suite: Excel, Word, PowerPoint, Outlook, PowerPivot

Business: SharePoint, Visio, Project, SpiceWorks, Pivotal Tracker, Jira

Analysis: MiniTab, SPSS, QI Macros, BRIO, Cognos, Crystal Report, SRS, SSRS, QI Macros

RDBMS: Oracle SQL Developer 2.0~3.x, MS Access, TOAD Data Point 3.2, SQL Server Management Studio, Power Pivot, Power View, Power Query, Power Map, Teradata V.13, V.14

Web Analytics: Visual Science, Watchfire, Coremetrics, Google Analytics, Omniture, eSignal, ESign, Acuity, Workstation Pro, Visual Site Prof v 3.2, Visual Workstation, MetaTrader

WORK EXPERIENCE

Sr. Business Analyst / Data Analyst

Confidential, Miami, Florida

Responsibilities:

• Collaborated with department managers in the Bank Services division to implement projects/programs that helped meet financial revenue, operating efficiency, strategic goals and regulatory requirements. Worked with various business units to analyze and define user requirements in order to develop the service/product that met the strategic needs of the Business Unit
• Performed business needs analysis, gathered and documented requirements in the data specific areas. Acted as a liaison between IT and the business on assigned projects and worked closely with the project manager to keep stakeholders informed of progress. Provided both strategic and detailed support to the Project Manager on significant projects and initiatives. Identified and properly assigned $11,000,000,000 in unassigned or erroneously place assets to fulfill the LCR (Liquid Coverage Ratio) Project.
• Reverse engineered and data mapped reports and dashboards to help drive a project designed to speak to a confidetial supporting the CRE (Commercial Real Estate) division.
• Coordinated test plans to meet project requirements and helped drive user acceptance testing to produce quality deliverables. Acted as a conduit between the business and technical teams to ensure requirements are understood. Analyzed data to validate business domains and requirements.
• Acted in an advisory capacity in data model reviews, architecture approach, and solution design to ensure high-quality deliverables.
• Translated business needs into design documents and specifications; documented current state and future state process workflows.
• Defined and documented the test plan and coordinated user acceptance testing to help ensure delivery of a quality solution.
• Proactively collaborated with the business to identify potential process improvements and enhancements that increased efficiencies and decrease costs. Gathered an understanding of the source systems and its data models to identify gaps in TCE (Total Credit Exposure) calculations as well as derived formulas and source to target mapping to ingest the proper information into the solution.

Sr. Internal Business Intelligence Auditor

Confidential

Responsibilities:

• Conducted verbal and written communications with stakeholders regarding IT audit status, findings, and other relevant issues.
• Inspected accounting systems to determine their efficiency and protective value. Delivered recommendations that provided management with insight into best practices and opportunities for increased efficiencies. Leveraged audit expertise to coach and develop staff auditors and facilitate cross-functional knowledge sharing throughout the Internal Audit department.
• Analyzed data obtained for evidence of deficiencies in controls, duplication of effort, extravagance, fraud, or lack of compliance with laws, government regulations, and management policies or procedures. Analyzed and architected business process workflow activities for the customer in either horizontal or vertical business applications. Ensured integrity and accuracy of data entered into IT systems, identified inaccuracies in practice performance and assisted in problem resolution along with delivery of audit findings for specified departments and lines of business.

Project Manager - Business Intelligence/Data Analyst

Confidential, Boca Raton, Florida

Responsibilities:

• Developed and reviewed project scopes, analyzed resources, and technological constraints with consideration to business impacts and identified risks.
• Created and executed project work plans and revised as appropriate to meet the changing needs and requirements.
• Developed project standards and improved existing processes when applicable.
• Developed and manage portfolio roadmap and integrated project charter & plans across initiatives and work streams and deliver the following: Transparent reporting of project status,timelines,milestones, dependencies, issues/risks, resource allocation, budget, root cause analysis, and executive interventions required.
• Provided consistent, clear, and timely communication of initiative goals, tasks and progress/status to project teams, sponsor, and executives
• Responsible for the planning, development, implementation and support of financial tools / applications related to the Operations Accounting group functions. Acted as the subject matter expert with respect to applications requiring robust VBA Macros and Access Database development and customization. Created, developed, analyzed and maintained new and / or existing systems, applications, and processes to identify integrity issues and process improvements.
• Elicited and documented business requirements using interviews, workshops, and/or existing systems documentation or procedures via Data Flow Diagrams.
• Acted as the liaison / lead between Operations Accounting, Financial Applications and IT to identify support issues and develop and deploy resolutions for systems / applications requiring the support or involvement of these groups.
• Developed “to be” and “as is”documentation and conducted / directed system testing and training programs based on user requirements / needs.
• Designed, developed, and implemented robust applications with Excel and/or databases (e.g. Access) front ends requiring extensive macro, VBA and / or SQL development / customization. Performed frequent updates, maintenance, modifications, and enhancements of databases to support business requirements.
• Developed and executed resolutions for identified issues related to system integrity / processes by analyzing existing databases / macros / applications to ensure compliance with the organization’s controls. Worked directly with management, financial teams, Financial Applications, IT, and internal / external auditors in the development, implementation, and support of financial applications / systems as required.
• Applied the elements of the project management discipline at a level of rigor appropriate to the project while managing the life cycle of projects proactively identifying and managing project risks. Provided hands-on stewardship of multiple projects to meet technological and business requirements on time and within budget. Provided and maintained accurate and timely project information in all project plans, communications, status reporting. Communicated complex and / or detailed information to multiple individuals / audiences with differing knowledge levels, presented both in writing and verbally.

Business Analyst / Business Intelligence/Data Analyst

Confidential, Boca Raton, Florida

Responsibilities:

• Architected solutions with optimal processing and storage technologies to support specific business use cases and leveraged high volume transaction data in a cost-effective manner to provide actionable business insights and developed data marts for ad-hoc reporting. Used industry standard analysis techniques to document business requirements such as data flow modeling, use case analysis, workflow analysis, functional decomposition analysis, and object modeling.
• Performed Cost Benefit Analysis to evaluate various technology and data project initiatives such as the automation of MIS reports, vendor selection, and resourcing strategy.
• Computed unit costs, checking and clearing data for costs associated with company labor, materials, products, inventory, and services. Compiled large amounts of complex data, conducting exploratory analysis, and analyzing results to provide actionable recommendations for Supply Chain ad hoc requests.
• Worked with the Logistics Analyst and wider teams to develop, refine and manage a dashboard of structured reports and reporting services for a range of stakeholders.
• Analyzed reporting data requests and confirmed requirements with stakeholders. Initiated and executed analysis, data mining and reporting that drove business improvement. Data Extraction: Using SQL, Excel, generated understanding of the company’s internal databases and data architecture allowing for data extraction and manipulation for a wide range of business problems. Used data extracted to conduct detailed business analysis to support the growth in the company. Garnered understanding of business challenges, worked to define and layout the goals of the analysis or the hypothesis. Inferred from incomplete data and use reasonable judgment to draw logical conclusions thus affording expedient decision making.
• Profiled data; determine trends, patterns, inconsistencies; draw accurate conclusions utilizing the latest data visualization tools. Produced ad-hoc reporting and complete special analytical projects that were used as input into system and process enhancements and changes. Provided data reporting, analysis, and support for operations and support teams. Aggressively identified potential data quality issues; pinpointed trouble spots in data and processes; assessed impact on customer needs and retention and made recommendations for improvement. Performed research and root cause analysis of individual data issues. Ensured high quality standards for data integrity and accuracy, analysis and reporting. Used and designed forecast reporting and analysis tools for all phases of the forecast process. Diagnosed problems in the forecast by assessing the impact of variances of forecasted items and made appropriate forecast adjustments. Interfaced with Information Systems to ensure the continuous development and enhancement of the forecast process, designed new reporting requirements and troubleshot existing reports.
• Facilitated and lead daily project meetings with work stream leads and weekly or bi-weekly steering committee meetings with executive sponsor(s). Acted as subject matter expert across multiple data implementations. Worked closely with cross-functional development teams to help establish and enforce data use standards and documentation of current state vs future state standards for existing and new systems and processes. Developed and maintain the monthly KPI’s for tracking and communicating change requests to stakeholders in retail, direct(e-commerce),contract, B2B and target coupon initiatives. Worked on a consultative basis for new project and enhancement initiatives to help ensure consistent application of data business rules and implementation of best practices. Prepared and analyzed data presentations for both internal and external publication.

Business Analyst / Business Intelligence / Data Analyst

Confidential West Palm Beach, Florida

Responsibilities:

• Participated in various phases of the software development lifecycle (SDLC) including requirements analysis, specification generation, database/ datawarehouse design and implementation, software development and unit/integration testing. Managed requirements and functional design through entire lifecycle - tracked and fully documents changes for functional and business specifications; wrote detailed universally understood procedures for permanent records and for use in training.
• Served in a technology leadership position devised effective ideas that delivered benefit to the customer, developed, and demonstrated these concepts independently.
• The group had extensive interaction with internal and external parties both to ensure effective oversight for existing business but also to shape and implement solutions for new products, strategies and systems. Trained the team in dealing and trading services of the Trading Desk, execution client currency transactions and FX spot trades.
• Ensured the team was able to furnish client access to up to date market and pricing information.
• Monitored FX positions and managed FX exposure as directed by the Chief Dealer.
• Maintained an excellent level of communication and collaboration. Analyzed historical data and market intelligence in order to develop and improve the forecast.
• Maintained a solid understanding of all data and its relationship to the forecast.
• Maintained the platform knowledge up to date with market information and monitored trends in currency pairings.
• Monitored trades to ensure compliance with internal anti-money laundering policies and procedures. Assisted Chief Dealer with establishing desk positions.
• Performed reporting and analysis tasks. Developed code for data provisioning, ETL processes . Supervised and guided BA/ QC and other junior developers.
• Applications created using technologies such as Microsoft SQL Server databases, stored procedures, SSRS reports. Analytics & Reporting team within the Foreign Exchange Capital Markets Operational Division maintained existing reporting, built new and improved reporting, including comprehensive dashboard reporting, and documented all automated reporting and analytical processes. Trained the team on how to publish weekly FX market updates. Utilizing SSAS and SSRS to produce dynamic ad hoc reports.
• Researched and documented findings on emerging technologies. Advised management and clients on proper use and integration of new technologies, including performance and financial considerations.

Business Intelligence

Confidential Atlanta, Georgia

Responsibilities:

• Used advanced statistical techniques to interpret and identify correlations using univariate and multivariate analysis to develop new approaches to financial market trading.
• Recommended process improvements based on industry best practices. Collected and cleansed data used in the modeling analysis.
• Coordinated with other departments to improve existing data capture and began the capture of new data elements required for modeling.
• Utilized specific business / system expertise and competence gained by active engagement in understanding client’s business environment to a) determine or analyze needs for client solutions; b) simplify or eliminate low value-added work processes; and c) recommend creative and innovative solutions.
• Provided advice to data and database personnel regarding application/business intelligence design specifications.
• Provided assistance and conducted complicated walk-throughs of technical and operational features, functions, and attributes of new or existing data/KPIs.
• Extracted, classified, and analyzed data stored in multiple systems for use in the decision-making process pertaining to one or more areas of interest to the customer. Developed and optimized complex data and reporting solutions using T-SQL, SSRS, and SSAS.
• Responsible for working with extremely large data sources from multiple platforms.
• Developed, managed, manipulated and analyzed various reports, dashboards and decision support tools and provide high-level analysis to leadership.
• Identified repeatable analysis processes where needed. Provided advice and input to senior management regarding project-related decisions.
• Participated in the project proposal process relative to solution design and project estimation.

Business Intelligence

Confidential,New York, New York

Responsibilities:

• Coordinated and produced standard national, local office, key client, competitor financial and other reports to assist Confidential Management with business development strategies.
• Developed, lead and delivered programs and initiatives related to business analysis, development, metrics, reporting, and associated areas.
• Worked with Confidential Management partners to identify new business opportunities with prospective and current clients by researching and analyzing business trends, demographics, and other indicators.
• Lead research and analysis on companies facing circumstances indicating potential transformation and compiled monthly comprehensive reports and executive summaries.
• Maintained and delivered comprehensive client and industry news.
• Applied expertise in data analytics and enterprise search, deliver BI & CI using data from the financial and other related software environments.
• Collaborated and worked closely with the RIS team on complex research projects.
• Responsible for keeping abreast of advances in technology and communication to senior management how these advances will affect/improve Confidential Management technical strategy. Developed new and standard reports utilizing data warehouse information with SSAS & SSRS; which maintained strong knowledge of data warehouse architecture, data definitions, system capabilities, related programming languages and statistical programs, and data integrity issues.

Business Analyst

Confidential, Atlanta, Georgia

Responsibilities:

• Provided business insight and actionable intelligence to drive strategic business recommendations and initiatives.
• Provided analytic support by dissecting large data sets and structuring a wide range of complex business problems, extracted and analyzed data from a variety of sources, utilized facts/data to derive a conclusion, and constructed presentations that distilled complex analytical findings into communications informed and influenced executive level audiences.
• Utilized astute business acumen to understand our customers’ business objectives and seek data driven solutions that address ongoing customer needs.
• Served as *voice of the customer- to provide pertinent supporting evidence and suggestions for an enhanced user experience.
• Proposed creative solutions to proactively address customers’ business problems with analytical services. Continuously monitored customer usage to identify revenue and decay trends that drive effective customer growth and retention strategies. Lead the company's efforts to design and implement A/B and multivariate testing, creating testing roadmaps.
• Worked independently to develop critical business partnerships to drive cross-functional business engagement, analysis and collaborative issue resolution recommendations.
• Developed Executive Level presentations Present complex and customized analytic findings
• Extracted data from multiple sources, manipulated data/data validation, conducted root cause analysis, developed solutions/recommendations and presented to Sr. Leadership
• Queried data from relational databases (Teradata, MS SQL server) performed data validation, analysis and modeling (root cause analysis, behavioral analysis)
• Lead continuous improvement initiatives for the Call Center (Direct to Customer) Organization. Created and distributed high level business performance reporting.
• Architected cross functional relationships to drive strategic discussions and continuous improvement
• Provided new strategy recommendations based on actual KPI data, including staff and outbound campaign scheduling and key metrics such as RPC % and “best-time-to-call” methodology. All metrics associated with daily operations. Including, but not limited to daily, weekly and monthly MIS reporting, call forecasting and call center scheduling, IVR data and trend analysis.
• Performed ad hoc statistical, data mining, and machine learning analysis on complex business problems related to Billing call volumes, customer experience and call deflection. Created innovative algorithms behind a variety of services ranging from Call prediction and Segmentations. Collaborated and worked closely with various Businesses, IT and Marketing teams
• Recommended improvements in call flow, worked with collection teams to develop dialing strategies, worked with customer care teams to improve inbound call routing, resolved problems and managed efficiency improvements. Monitored performance of phone and dialer systems to ensure department objectives are met and to maximize productivity through call handling efficiencies, system uptime, staffing levels, reporting and analysis.

Consultant

Confidential, Atlanta, Georgia

Responsibilities:

• Acted as troubleshooter, process improvement and business initiative specialist analyzing and determining operational and business issues when launching new products.
• Exhibited ability to take action in solving problems while exhibiting judgment and realistic understanding of issues.
• Responsible for quantitative, analytical and business processes. Coordinated ad-hoc problem solving and identification and tracking troubleshooting process.
• Excellent written and oral presentation skills.
• Participated in the monthly closing process, Consolidated country submissions, Performed standard journal entries, Analyzed and resolved variances.
• Prepared reports for senior management. Assisted in the preparation of various analytical reports for senior management and assisted in the preparation of monthly business updates.
• Assisted in the preparation of annual US GAAP and IFRS Audited Financial Statements.
• Performed Financial modeling through the analysis and melding of internally developed data as well as outside research.
• Produced period reports for senior management. Ad-hoc reports & analysis. Developed metrics and tools for tracking product and service performance.