SUMMARY:

• Confidential expertises providing data/system support for Business Enterprise Architecture, including Data warehouse, financial system, operations, and intelligence.
• Confidential has extensive experience gathering, analyzing, defining business scope, and documenting business and functional requirements.
• Confidential provides data analysis, profiling, cleansing of systems/databases across enterprise.
• Confidential performs data analysis and reporting utilizing SQL, Excel, Access, Oracle, Hyperion, Crystal Report, and Cognos Portal.

TECHNICAL SKILLS:

Operating Systems/ERP: Confidential Netezza datawarehouse Software v6.0, Confidential Initiate Application 9.7, Oracle Hyperion Interactive Reporting Studio, OutlookSoft reporting, Data Warehouse Reporting of MicroStrategy and Business Object, PeopleSoft (GL, A/R, A/P modules)

Relational Databases: Oracle SQL Plus, PL/SQL, Access.

Tools: /Other: Troux Architecture, Business Object Crystal Report, TOAD, XQuery

MicroSoft Office: Excel, Access, Visio, Word, Power Point.

PROFESSIONAL EXPERIENCE:

Confidential

Data Management Team Analyst

Responsibilities:

• Support data quality and data management activities related to the loading, extracting and presenting of data from multiple data sources.
• Transform and analyze data from data sources to ensure the interoperability of the data with the existing data warehouse.
• Identify and investigate data quality/integrity problems, determine the impact of solutions to problems, support the production of regular and ad - hoc reports, develop/monitor automated loading scripts, and provide service support for these processes.
• Collaborates with IT Development applying logic rules and data schema from new releases to support existing data exports.
• Acts as a liaison with business clients to facilitate the implementation of new and improved business process requirements critical to data interoperability needs.
• Develops business specifications and data specifications, maintains data dictionaries and detail requirements.

Confidential

Senior Database Analyst/Reports Developer

Responsibilities:

• Responsible for the full life cycle of very large databases and/or data warehouses including requirements analysis, design, architecture, development and deployment of database applications, new features, and correction of defects.
• Responsible for ongoing data loading and reconciliation, customer support, technical troubleshooting and maintenance of developed databases.
• Designs, develops and maintains a multitude of relational database reports. Performs quality assurance role. Prepares appropriate design and deployment artifacts per the standard development methodology. Leads and mentors others in the creation and use of standards for very large database development.

Confidential

Senior Application Architect Consultant

Responsibilities:

• Analyzing requirements, implementing Confidential Initiate Application, and supporting overall integration and testing.
• Propose and implement configuration/tuning to improve performance and reliability of the system.
• Participate in the full software life cycle to include analysis, design, deployment, and operational support.
• Develop and maintain Initiate Database and ETL process, diagnose data anomaly.
• Support Initiate 9.7.0 deliverables for development, testing and production.
• Support operation of the Initiate environments during the ongoing development life cycle,
• Maintain the Initiate environments to coincide with development and maintenance releases.

Confidential

Data Management Team Analyst

Responsibilities:

• Support data quality and data management activities related to the loading, extracting and presenting of data from multiple data sources.
• Transform and analyze data from data sources to ensure the interoperability of the data with the existing data warehouse.
• Identify and investigate data quality/integrity problems, determine the impact of solutions to problems, support the production of regular and ad-hoc reports, develop/monitor automated loading scripts, and provide service support for these processes.
• Collaborates with IT Development applying logic rules and data schema from new releases to support existing data exports.
• Acts as a liaison with business clients to facilitate the implementation of new and improved business process requirements critical to data interoperability needs.
• Develops business specifications and data specifications, maintains data dictionaries and detail requirements.

Confidential

Data DW Analyst

Responsibilities:

• Analyze and document data mapping, modeling and business rules in Source Operation data bases, data warehouse staging & target data bases, and repository data bases in Confidential Integrated Decisions Support Data Warehouse Architecture.
• Analyze and document candidate data sources for future data sources to be migrated into ICE Decisions Support Data Warehouse Architecture.
• Extract and profile complex data to generate Hyperion Interactive Reporting Studio reports on performance dashboard and matrix.
• Analyze current and future ETL process flows.
• Monitor, identify, troubleshoot, and make suggestion to DHS to resolve operation risks and issues.

Confidential

Senior Business Analyst/Data Architect

Responsibilities:

• Analyze as-is data architecture systems and support to-be logistics life cycle logistics data warehouse and Business Intelligence for Marine Corps.
• Maintain and develop Confidential Total Lifecycle Management Data warehouse or data mart.
• Perform process/system/database analysis through USMC TLCM Enterprise Architecture.
• Perform data profiling, cleansing, and governance on major data flows.
• Interview business stakeholders to collect business rules, and draft business requirements.
• Confer with business partners, technical partners, and other stakeholders to draft function requirements, technical design specification, and UAT documents.
• Draft Use Case, Data flow, Swimlane diagrams.
• Recommend and design Marine Corps-Wide process and data management improvements intended to accelerate the USMC’s “time to value” for the improved TLCM.

Confidential

Senior Transportation Financial Data Analysis Support

Responsibilities:

• Provided weekly Budget Execution Report for Logistics Distribution by monitoring the Transportation Working Capital Fund (TWCF) billing and dispute process.
• Developed and maintained MC Logistics financial and billing database.
• Performed transportation financial data reconciliations, tracking and cleansing.
• Performed other transportation financial data analysis duties as assigned.
• Responsible for responding to queries from field activities and other DoD, OSD, Joint Staff, Federal/external agencies and commercial parties.

Confidential

Sr. Financial System Analyst

Responsibilities:

• Worked with Outlook Soft Team to implement OutlookSoft Financial planning and reporting architecture from underlying Oracle Financial Hyperion.
• Migrated, reconciled and consolidated historical data to OutlookSoft.
• Served as OutlookSoft Sherpa Admin and Hyperion SME and maintained both systems.
• Created 2008 financial plan and forecast.
• Created new reporting packages and procedures for month-end closing.
• Provided Outlook Soft training for financial team.

Confidential

Sr. Financial Analyst

Responsibilities:

• Served as Confidential liaison to project managers and discussed project phasing status and head count hours for monthly reporting to I/ Confidential Finance management.
• Assisted with generating monthly financial review of the project status.
• Reported via different financial tools including OutlookSoft and Hyperion.
• Acted on behalf of financial controller in approving IT employee workstation, software updates and purchases.

Confidential

Sr. Business Analyst

Responsibilities:

• Used SQL to consolidate, analyze Test Run and Production Run from different data sources.
• Analyzed Confidential Restatement’s monthly implementation for Amortization Tool and Database Management.
• Analyzed financial and business impact of business requirements driven testing plans.
• Coordinated with project management, IT, and operations to address issues arisen from monthly implementation releases and ad-hoc problems.
• Drafted all detailed releases’ documentation for auditing.
• Reconciled and explained variances between production run databases against G/L product accounts.

Confidential

Sr. Operations System Analyst

Responsibilities:

• Used TQSQL and Access queries to collect, report and analyze trouble-shooting and network outage for Confidential National Networks.
• Drafted Ad-hoc reports via different applications and databases.
• Drafted requirements for Business Object Data Warehouse of network ticketing system.
• Facilitated project management for EBTS cell sites renaming project.
• Analyzed network alarms for iDen system.
• Conducted weekly network performance evaluation for Confidential sponsored Nascar races.

Confidential

Senior Business (Systems) Analyst

Responsibilities:

• Gathered detailed requirements from end-users, wrote requirements, worked with project management team and engineering on new releases keeping track of project progress to ensure timely delivery.
• Performed Extensive data analysis with SQL Plus and Pl/Sql in Oracle DB and MicroStrategy.
• Prepared development process meeting reports to review business logic to help in coding.
• Worked with billing department to schedule end-user tests of new billing system functions, coordinated data migration and integration testing.
• Made sure tests were completed on time.
• Collected, analyzed, cleaned, and reported data from on-line transactions, credit card transactions, enterprise DB, billing DB, production fulfillment procedures, and customer service Oracle DB to reflect correct customer impact and revenue for monthly closing.
• Addressed reporting variances from plan/forecast with upper management.
• Served as primary contact for Engineering, Operations, and QA for tech issue tracking and resolution for enterprise DB schema and migrate credit card information in data mart.
• Participated in the design, setup, process, and auditing of the Partners Collection Project.

Confidential

Sr. Business Analyst

Responsibilities:

• Prepared month-end closing, financial reports and schedules (SG&A, Revenue/Billing).
• Supported the implementation of Confidential & Confidential (Travel & Entertainment) Tracking Tool for General Business Group through life cycle.
• Interviewed customer service and sales department management for project assessment and scope analysis, gathered end-user requirements, and prepared and revised business requirements.
• Worked with tech support team and data management team for functional requirement and budget planning.
• Worked with development team for code-review to apply correct business rules and travel policies.
• Performed co-ordination of project milestone management to ensure timely phase releases.
• Retrieved Oracle DB for testing data sets and prepared Phases of UAT plans.
• Performed UAT and addressed issues for corrections and improvements (including testing live data reconciliation against PeopleSoft A/P module).
• Coordinated system swap and new tool kick-off.
• Drafted end-user manual and maintained project implementation documents.
• Performed on-going maintenance releases due to business rule updates and data cleansing recorded in project documents.
• Supervised 2 financial analysts.