Business Analyst Resume McLean, VA - Hire IT People

SUMMARY

Familiar with Agile/Scrum methodology and testing—all phases.
Familiar with Erwin Data Modeling Tool and conversant with others.
Extensive knowledge of building ORDMS/RDMS tables and creating/managing constraints.
Experience in writing SQL scripts to generate reports from manipulated data.
Database experience utilizing platforms such as Oracle, MySQL, SQL Server, Teradata, DB2, and MS Access.
Experience in using database tools such as Oracle Toad, SQL Plus, SQL Developer, SQL Loader, and APEX.
Experience with PL/SQL stored functions/procedures, packages/cursors and triggers.
Experience in Data Profiling, Database SQL Tuning, and Data Quality/Master Data Management.
Informatica PowerCenter 9.6.1 transformations utilizing PowerCenter components: DesignerWorkflow Manager, Workflow Monitor, and Repository Manager.
Informatica Data Quality Components: Informatica Data Explorer, Informatica Analyst, Metadata
Manager, Business Glossary, Informatica Developer.
Experience in testing BI Reports including MicroStrategy, OBIEE, and others.
Experience in developing Excel VBA/Microsoft Access custom applications.
Knowledge of Python, UNIX, Java, VBA, JavaScript, VBScript, XML, and JSON.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Business Analyst

Responsibilities:

Summary: Developed Excel VBA application to extract business metadata from 2900 data warehouse (BRS) business rule binary (.xls) workbooks capturing table names, columns, composite primary keys, code table elements, their allowed values, derivation logic for upload to Informatica Metadata Mgr.
Gathered/analyzed complex requirements, translated requirements into VBA programming specifications utilizing both RAD/Agile Methodologies or prototyping/iterations of Extreme Programming respectively.
Created looping structures, complex If statements, concatenation tables, lookup tables, Boolean logic, text functions, variable driven auto - filtering, deduping, dynamic ranges, utilizing powerful components of Excel Object Model to build application to meet complex programming requirements following Agile methodology.
Performed ‘heavy lifting’ programmatically for Data Governance Group implementation of Metadata Manager significantly reducing project costs, while delivering a high degree of data quality for the metadata.
Assisted with compilation of business glossary metadata, data quality rules, data lineage, data mappings/work flows, metrics, thresholds, and verification in DOORS and Informatica Metadata Manager.
Utilized Informatica Analyst/Data Explorer to profile CDW data, validate correctness of mappings in CDW.
Completed QC of metadata information extracted programmatically/manually resulting in high data quality.

Confidential, Rockville, MD

Systems Analyst

Responsibilities:

Summary: Facilitated Marketing, Information, and Analytics Group of global company for OBIEE Migration.
Reviewed, gathered, analyzed complex business requirements including functional, technical requirements, process flows of MIA data consistent with future state of logical/physical OBIEE corporate-wide data model. Assisted in mapping business requirements into information/data requirements/SQL capturing components from Oracle, Oracle EBS, MS Access.
Defined/documented source to target data mappings for legacy MS Access databases, Oracle BI Publisher reports, and MIA data warehouse tables to Oracle staging repository including specific schema, table, field names, and data types for migrated OBIEE BI Dashboard reports utilizing Erwin Modeler.
Troubleshooted complex SQL, PL/SQL scripts utilized for both data analysis and ETL composed in SQL*Plus, TOAD, and MS Access SQL to be congruent with changing requirements, changing data attributes, and advance of calendar/fiscal years.
Verified Informatica PowerCenter mappings, transformations, and, workflows for MIA data contribution to production environment.
Reconciled Managed Accounts-MS Access database comprising sixty million in revenue having difference of $200k versus Oracle data warehouse SQL script sales reports identifying 647 reconciling differences.
Completed MS Access reporting/rebuild through MIA migration to OBIEE reporting system in six months saving significantly in project costs.