SUMMARY:

• 10 + years of Technology, Analytics, Business Intelligence and Enterprise Data Warehousing.
• Highly dedicated professional with strong technical and business background.
• Resourceful problem - solver, skilled in identifying and troubleshooting complex issues.
• Skilled at coordinating projects and prioritizing work, and thriving in a fast-paced, changing environment.
• Effective leader that motivates others in order to maintain a productive environment.
• Excellent interpersonal communication and presentation skills with strong ability to foster relationships.
• Working experience and knowledge of Agile and Waterfall project life cycle development.

TECHNICAL SKILLS:

MicroStrategy 9.X (BI), Dundas (BI), Tableau(BI), Data Modeling, Informatica Power Center 9.X (ETL), SQL Server Integration Services (SSIS - ETL), MS SQL Server, Business Intelligence Development Studio, Visual Studios, Dot Net Frame Work, Source Safe, PL/SQL, Direct Connect 4.X (NDM), Proficient in use of Excel, Access, PowerPoint, Word, SharePoint, Visio, DB2, Netezza, Oracle, Toad, Aginity

Languages: SQL, T-SQL, Oracle-SQL, VBA, VB.NET, Java

PROFESSIONAL EXPERIENCE:

Confidential

Senior Engineer Lead Developer

• Investigate new data source to assist business with finding better data source to perform new analytics.
• Develop complex one off dashboard and reports for business users various BI tools for Business presentation.
• Researches appropriateness and availability of data resources required for each project.
• Build reports and dashboard to provide insight into data housed in the data warehouse and data analysis.
• Data profiling before project initiation.
• Perform trending analysis on Account Receivable and Membership Rewards.
• Developed the process within BIDW for providing auditor evidence to complete various audits.
• Creating and managing regulator controls processes for SOX and SOC2 compliance (PRSA).
• Direct audit assignments to Production Support and other areas
• Develop a working relationship with external and internal auditors and application vendors.
• Developing new audit control policies for BIDW to mitigate future audit risks.
• Review and enhance BIDW audit process to meet changes in audit and regulatory requirements.
• Managing onshore and offshore resources during large project development in both Agile and Waterfall methodology.
• Design new solution using existing tool set to meet Business and Technology goals.
• Solve technical problems to assist blocked projects.
• Conducting interviews with business SMEs to build new report and understand business processes.
• Translate business needs into technical designs.
• Partnering with Business SMEs to develop requirements for new projects.
• Liaison between BIDW and Business Partners (across the globe) at all levels.
• Communicating complex ideas to Business to help decision making tasks.
• Working with Database Admins and Data Modeling teams to complete solutions.
• Data modeling for business intelligence platforms.
• Review/Approve project architectural designs.
• Performing quality control reviews of the SQL code in MicroStrategy.
• Strong understanding of the Membership Reward program and Account Receivable process within Confidential .
• Leading Scrum teams during project initiation.
• Develop new process for BIDW to provide consistencies in day to day job functions.
• Review/Approve project architectural designs post analyze.
• Manage new functionality and find changes in the system to better assist our business partners.

Confidential

Business Intelligence Adoption Lead

• Development complex one off dashboard for business users in MicroStrategy.
• Development complex to simple reports in MicroStrategy for business users.
• Assist in the development of a MicroStrategy self-serve model within the business.
• Provide development consulting on MicroStrategy projects to developers.
• Provide technical assistance and consulting on ETL, data modeling, security model, data warehousing requirement.
• Consult business groups on MicroStrategy development in their self-serve project.
• Mockup MicroStrategy dashboards for visualization for business groups and MicroStrategy developers.
• Participate in Agile sprints, teams, and store boarding section.
• Provide guidance to less experience staff.
• Develop training and reference material for business users.
• Provide business users with training on MicroStrategy.

Confidential

Analytics Consultant/ Business Systems Consultant

• Uses highly technical skills and knowledge to provide leadership on project/programs.
• Performs improved visual representation of data to allow clearer communication, viewer engagement and faster/better decision-making.
• Develop and maintain MicroStrategy Documents, Dashboards, PDF reports and Grid reports for combined Wells Fargo and Wachovia Operational areas.
• Perform query optimization within MicroStrategy to increase report performance.
• Perform administrative tasks related to MicroStrategy including project setup, schema management and user maintenance.
• MicroStrategy Desktop software install on user PCs for all of Operations.
• Development and roll out of MicroStrategy Transaction Services to all Operational areas for data keying.
• Developed and maintain complete suite of MicroStrategy reports for Finance reporting.
• Trained users to use MicroStrategy Visual Insight.
• Develop new SSIS packages using BIDS and MS SQL 2005 to complete ETLs with Operational Areas.
• Provided technical assistance to Operations groups with SQL coding to facilitate new data feeds to backend Oracle databases for key volume indicator and productivity reporting.
• Automation of month end data loads from various systems for reporting to Finance and Operation groups.
• Internal consultant for technology and business groups for system changes and testing.
• Liaison between client area and technical organization by planning, conducting and directing the analysis of highly complex business problems to be solved with automated systems.
• Assist with user groups to provide training, resolve questions, assess user needs, and recommendations for report and data development.
• Manage complex to simple ETL projects.
• Manage server build, testing, install and cutover to production servers for MicroStrategy and Lumen applications.
• Assist MAB Group in complying with Software Development Lifecycle methodology (SDLC).
• Assist in the development and coaching of MAB Group Team Members.
• Developed and maintain Image Exchange Access database using T-SQL and Visual Basic.
• Develop and maintain Finance Graphing Report using Visual Basic (Essbase).
• Participate in audit reporting of various Operational areas.
• Establish policy and procedures for ETL feeds to Lumen application.
• Established On Call procedures and policies for MAB Group.
• Trained and wrote procedures for MAB Group members to use PAC2000 Change Request and Problems Ticket Tool.

Confidentia`

Project Manager3/Business Systems Consultant

• Assisted in developing and design of a new Operations Development Group.
• Maintain and employ the Operations Program Office Change Control Database
• Develop and maintain all Operations Change Control reports that are provided to internal/external partners and Management.
• Implement Change Control and Project Expense Reporting process for Operations Project Managers.
• Perform trending and analysis of Change Controls to find best practices and efficiency that can be utilized in existing and future projects.
• Assist Upper Management with decision making regarding Change Control and new processes.
• Monitor Change Controls initiated within Operations funded projects.
• Develop Testing Expense Recovery process for Operations funded projects to assist Project Managers.
• Utilize SharePoint to develop Operations Program Office and Executive Representative SharePoint sites for information and report delivery.
• Assisted in structuring of a new Operations Development Group and new policies for project reporting.
• Develop and implement the Operations Program Office Change Control Database using Microsoft Access and Visual Basic.
• Developed the SharePoint site for streamline report delivery to peers and Upper Management.

Confidential (Customer, Sales, Service and Operations)

Business Systems Consultant ( )

• Assisting Delegates and line of business (LOB) with opening initiative in RoadMap for project initiation prior to opening projects in CREST.
• Liaison between Operations groups and Technology teams.
• Forecasting Project Management hours for expected projects.
• Monitor CREST project under review by Operations and its partners to assure Service Level Agreements (SLA) are met.
• Maintaining reports on all current/completed projects from Operations and Operation’s partners.
• Employ Crystal Reporting tool to assist management with project budget forecasting.
• Maintaining SLA reports for Operations.
• Assisting Developers with the development of online reports within RoadMap for Operations Executive Representative Team.
• Testing new functionality within RoadMap.
• Developed new project tracking report for increase efficiency.
• Developed “One Touch” report for Operations Management.

Confidential

Operations Analyst

• Testing Image software to meet the U.S. Federal Check 21 Act.
• Installing and maintaining Microsoft SQL server to build Items Exception Report and MSOR Report.
• Performing Image Inspector product testing for improving image quality.
• Increasing efficiency of reporting process by utilizing Visual Basic.NET.
• Performing Image Quality Inspection.
• Assisting capture sites in decreasing the amount of suspects.
• Monitoring of CSMF - DCIMS and CIMS image databases.
• Mentoring co-workers in the use of Microsoft SQL and Visual Basic.NET.
• Developed report cards for capture sites based on the Item Exceptions Report.
• Developed EIB report to be used to reverse incorrectly flagged suspect items.
• Developed procedures for Image Inspector training.
• Developed the exceptions delimited file to assist in development of other process and automaton of reports sent to the capture sites.
• Developing Item Exceptions Report to track and assist in cleaning up suspect items.

Confidential

Business Operations Analyst

• Analyzed and develop reports for the MPF, AFS and FDR collection units regarding volume, financial impact, and business strategies.
• Manage and Forecast a $100 million and growing Restructured Portfolio (High Risk Accounts).
• Create queries in both Microsoft Transact SQL and Access to find discrepancies and current reports and develop new reports.
• Special projects including research and analysis dealing with new products and existing accounts.
• Make recommendations to Collections and Risk Management on high risk accounts.
• Build queues and setup rules in You Owe Me (YOM).
• Manage Risk Management Projects from beginning to end.
• YOM and BTL liaison for Business Direct Loss Control Unit.
• Presented analysis of AFS and FDR accounts via PowerPoint to upper management every monthly.
• Developed new standards for the Collections unit and evaluate performance and metrics.
• Developing Collections Letters to be sent to delinquent accounts for Risk Management Projects.
• Developed and automated the AFS Forecasting Report
• Developed conversion GUI interface (combination of Excel, Access) for FDR account conversion to AFS accounts.