Summary

Highly motivated Professional and Leader with a strong financial management and analysis background. MBA with 20 years of IT experience. Committed to adding value and exceeding expectations by creating and implementing methods to improve processes and increase profits. Keen understanding of business priorities, genuine team player committed to managing operations and projects flawlessly while contributing to cost saving activities. Organized and detail-oriented brings versatile operations oriented skills to strengthen all company initiatives. Out-of-the-box thinker with excellent analytical, and technical skills. Recognized for an ability to effectively gather, correlate, and explain data necessary for determining business decisions.

Areas of Strength

Professional Experience

Confidential

Project Manager/PPM Tool Developer

• Plan, execute, and finalize projects within triple constraints of delivering on time, within budget and scope objectives, includes acquiring resources and coordinating efforts of team members in order to deliver projects according to plan. Identify, effectively communicate, and resolve project issues and risks.
• Coordinate effort, participation and accountability within the Shared Services teams highlighting integration dependencies. Present to team leaders/senior management the project's status and deal with issues regarding project completion or budgetary overspend.
• Translate business needs into technical terms, prepare detailed work breakdown structures WBS and instill time management practices for achieving project milestones.
• Resolve numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.
• Administer the organization's PPM tool through weekly data loads and developing reports utilizing Cognos Report Studio 10.2 analyze the reporting needs of the PMO enterprise and build the enterprise reporting architecture
• Develop, test and deploy the solution create different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Act as the primary business liaison for user questions, concerns, dashboard and new reporting requests.

Confidential

Senior Data Analyst

• Responsible for executing the complete systems development lifecycle on a variety of client projects using traditional techniques such as business process mapping, business and functional requirement gathering, development definition, application design, data analysis, software testing, and deployment.
• Collaborated with multiple teams, reviewing business and technical documentation, conducting data analysis, and developing related data mapping and design documentations.
• Developed systems architecture diagrams both physical and logical modeling utilizing Erwin created new database schemas.
• Created complex SQL queries/extracts and manipulate data through Teradata SQL assistant scripts.
• Engaged in work efforts at all scales ranging from minor defect fixes and enhancements to development of new applications.
• Worked closely with partners to identify new processes and process improvements.

Confidential

Senior Business Systems Analyst

• Designed, developed, enhanced and supported database applications used for data warehouse / business intelligence solutions translated business requirements and conceptual designs into functional and technical documents for use in the development process created project charter and request for work documents.
• Documented business processes using formal methods and tools, analyzed existing data structures and data relationships created physical and logical data models/entity relationship diagrams.
• Performed risk and cost/benefit analyses in order to determine the most accurate solution method
• Acted as the interface between the users and the different teams involved with application development to enhance understanding of the business and IT process throughout the software development life cycle SDLC

• Created complex SQL queries/extracts and manipulate data through Oracle SQL Developer scripts and Online Analytical Processing Essbase tools to drive reporting and validating data providing insights to the business responsible for creating cubes, load and calc scripts utilizing Essbase EAS/EIS
• Provided testing support, including phase-specific test planning and end-to-end project test strategy development created and executed unit test plans through HP Quality Center based on application upgrades. Test scripts included running and validating production Informatica mappings to insure they ran successfully within the new software upgrade infrastructure.
• Created basic Informatica mappings, collected, organized and generated new documentation for Informatica ETL projects including technical specifications, ETL test scripts, change control, implementation checklists, data flow diagrams utilized Informatica to analyze workflow processes and recommended solutions to modify them for new business uses.

Confidential

Senior Business Analyst

• Identified, assessed, and documented business requirements, recommending business priorities, and advising business on options, risks, and costs.
• Conducted research to determine if solutions to business requirements currently exist within or outside of data warehouse architecture, and if not, whether new solutions were feasible. Analyzed impact of proposed solution across the business, developed use cases to explain/demonstrate business requirements/specifications to IT teams, and contributed a business or process perspective during design reviews.
• Assisted Quality Management team to ensure that requirements documentation could be easily translated into test plans, and ensured that the proper testing plans had been completed.
• Facilitated implementation of new functionality through training sessions, demos, and the development of appropriate documentation. Provided relevant test scenarios for the testing team.
• Worked with test team to develop system integration test scripts and ensured the testing results corresponded to expected outcome.

Confidential

Financial Systems Manager

• Responsible for the design, implementation, and operations of a financial accounting system and online scheduling software tool acting as the project leader in defining the scope and tasks required to manage these systems.
• Determined source data transformation needs based on requirements, assisted in the design and development of the mappings and maintained ongoing operational procedures
• Managed all financial and accounting support operations including: invoicing, billing, and collecting outstanding receivables performing weekly payroll operations reconciling chart of accounts and bank deposits and setting pricing points
• Maintained and updated scheduling software to maximize truck routes, and minimize traveling expenses to ensure the most cost effective routes were used, tracked unfinished work, and expedited important work orders
• Assessed and determined end-user reporting needs and led monthly status meetings with upper management to highlight problem areas on financial statements, debt collection reports and profit reporting.

Confidential

Information Architecture Manager

• Oversaw and managed the company initiative to develop, implement, and maintain PeopleSoft's Enterprise Performance Management EPM data warehouse including: performing data analysis and enterprise architecture modeling formulating metadata and business definitions guiding the extraction, transformation, and data loading process assisting in the front-end reporting tool selection along with defining user level security rules and constructing user acceptance testing and the creation of a computer-based training program
• Determined source data transformation needs based on requirements, assisted in the design and development of the mappings in the ETL tool Informatica and SQL queries, and maintained ongoing operational procedures
• Managed the data architecture, models, and physical implementations consistent with new development enhancements or requests such that standards were utilized
• Documented business processes using formal methods and tools, assisted in the compilation of technical and functional requirements, and analyzed existing data structure and data relationships
• Developed, maintained, and managed processes and procedures to ensure data warehouse data was understood and had shared meaning across the enterprise
• Created and implemented the enterprise security policy, coordinated and performed system and end-user testing, and created and implemented business processes for data verification/reconciliation
• Assessed and determined the end-user reporting needs and provided recommendations on potential reporting tools, assisted in the implementation of tool sets Cognos , and created and delivered canned
• reporting requirements including a dashboard environment and web portal.
• Assisted in the ongoing creation of technology planning for the data warehouse and related components to include hardware, application software, and technology process improvements

Confidential

Decision Support Manager

• Responsible for the development, implementation, and operational support function for several OLAP/ROLAP tools used within the Business and Market Planning BMP organization including Hyperion Essbase, Hyperion Wired Web interactive edition , and MicroStrategy DSS
• Provided database management including: manipulating source data writing load rules and calculation scripts verifying data results to ledgers and invoices and creating standard reporting templates from these decision support applications
• Developed and implemented a graphical web reporting interface that involved: determining web and client configurations as well as software licensing requirements assigning user-level security maintaining and updating the reporting views based on user's reporting requirements and coordinating user training and user documentation along with client installations

Data Warehouse Project Manager

• Responsible for the overall leading, planning, and implementation of a corporate driven initiative to create a data warehouse for MCI WorldCom
• Managed and directed project plans created system requirements identified source interface systems designed and developed logical data models developed reporting modules and tested modules and assisted in test planning and implementation created reporting repository/metadata utilizing Business Objects
• Led weekly team status meetings to ensure clear communication about projects, that problems were identified and resolved, and all team members were completing work as needed
• Served a dual role in supporting the DW users as the project's business analyst and as the liaison between the technical developers and end user to ensure needs were met by the delivered system

Confidential

Project Manager/Business Systems Analyst

• Responsible for the overall leading, planning, and implementation of a general ledger system for AT T's international business
• Led all phases of development including: directing project plans managing performance objectives within scheduled time frames providing status reports expediting critical resolutions and monitoring the deployment process
• Gathered and documented system requirements, conducted system reviews, and ensured that requirements met corporate accounting policies and specific users' needs
• Reviewed and provided input to test conditions and provided training documentation to users acted as a liaison between system developers and business unit customers

Business Systems Developer/Financial Resource Analyst

• Responsible for the design, implementation, and operations of a R D project accounting system acted as the project leader in defining the scope and tasks required to manage this financial system
• Conducted monthly book closing routines, prepared intercompany transactions, reconciled and analyzed general ledger accounts, and reported financial statements
• Managed and reviewed system processing to ensure reporting integrity of all expenses
• Interfaced with AT T business unit customers and end users while acting as the R D liaison for the Bell Labs technical community
• Designed specifications, system testing, and financial training for a budgeting module that interfaced with the project accounting system