SUMMARY:

• 7+ years of professional IT experience in Financial/ banking and Government contracting.
• Experience in the Analysis, Design, Development, Testing and Implementation of business application
• Proficient in data research and analysis, contract compliance and Working knowledge of network, system, programming, database and application - level security
• Knowledge of business intelligence, dashboard and/or visualization tools (Tableau, PowerPivot, Business Objects and SAP)
• Tableau report and dashboard design/visualization, creation, and optimization to support IT / Business/ BI operations
• Perform logical and physical data models and database design, Gather business requirements and translate them into reporting needs including documenting using current Client templates
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Excellent in Advance Excel, VBA, spreadsheet modeling, pivot tables, Lookups, Data Modelling, ETL and manipulating large Data sets
• Hands-on SQL experience

TECHNICAL SKILLS:

• Programming Languages: Oracle PL/SQL, SQL, Python, NZPLSQL,R
• Database: Oracle 11g, IBM Netezza Database Tools: Oracle SQL Developer,
• Data Modeling Tools: ERWin, Microsoft Visio
• Lending & Underwriting Guidelines, Credit & Income Analysis
• Loan Review and Due Diligence Underwriting, Loan Document Analysis
• Compliance and Legal Documents Review
• Cash-Flow Analysis | Risk Assessment | Loan-to-Value Ratios | Debt-to-Income Ratios
• Confidential & Government Mortgages, Conforming & Nonconforming Confidential | ARMs
• Knowledge of Informatica, PeopleSoft Financials, Cognos Planning, WP 2, SAS, SPSS, DB2, ODS, PE,ACER, MIDAS, Report Works, Blitz Doc, SAP,DOORS Clear Quest, Sales Force, Jira and Share Point.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

CEO and Founder/Data Analytics Manager

• Working with business unit leaders to understand business needs, data requirements and translate them into analytics, database design useable to specific units
• Document and describe logical data models, semantic data models and physical data models.
• Design logical database models using normalization/ standardization techniques
• Mapping operational data to the data model and Preparing Data Dictionary.
• Extract, Transform and Load (ETL) data using PL/SQL/MySQL
• Collaborating with IT teams to determine if solutions currently exist or whether new solutions are feasible to meet business requirements.
• Identifying business and functional requirements by working with application end-users.
• Developing business cases use cases, test plans/strategies and operational procedures.
• Crafting business cases to evaluate the feasibility of technology initiatives.
• Developing business data processes, scenarios, workflows, information flows and wireframes /designs of the proposed solutions for the data analytics team.
• Maintaining Business Intelligence reports and Dashboards using Google analytics and Tableau that enables fact-based decision making, analysis, and insight generation
• Maintaining comprehensive trail of requirements using Jira, Confluence

Confidential, Washington, DC

Senior Business Data Analyst

• Collecting requirements, analyzing, designing and deploying Enterprise Data system to be used for analytics tasks in Agile lifecycle.
• Support the federal work stream lead(s) as a subject matter expert in data management, providing strategic guidance and deliverables on data cleansing, governance and provide briefing leadership on data management concepts, opportunities for innovation, risks and tools.
• Act as the Data Architect/Data Steward responsible for the creation, support and maintenance of data repositories used as sources for group data-driven initiatives.
• Consult with the client to identify client business problems, clarify analytic objectives, establish analytics priorities, create practical analytic roadmaps, identify data needs and formulate data solutions, drive and execute analysis, package and present insights to stake holders.
• Designing and executing test cases to be used for applications development and implementation of projects.
• Create database physical and logical design, create data modeling, create/modify database structures/object definition re recommending design and structural modifications and enhancements
• Analyze, design, develop, code test and maintain Business Intelligence reports and Dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE), Google analytics and Tableau that enables fact-based decision making, analysis, and insight generation.
• Extract, Transform and Load (ETL) data using PL/SQL, Excel and R programming from multiple internal and external sources.
• Perform automated text/data classification and categorization (Taxonomy) as well as entity recognition, resolution and extraction.
• Work with Market Data Operations (MDO) and Data Architecture and Standards to contact data submitters to resolve identified issues and define validation logic to prevent similar problems in future data submissions.
• Actively monitor data quality on a specific data stream, profiling and analyzing the data to identify Data Quality issues on target datasets.
• Prepare artifacts documenting the issue so issue owner has information necessary to solve issue.
• Work closely with the customer to determine the scope of data stream to be actively monitored - may be limited to certain fields, or certain submitters, etc.
• Define and execute processes to monitor data governance policies and procedures to ensure data integrity and privacy, establish consistent data definitions, and monitor overall data quality
• Adopt latest Agile methodologies such as sprints,epics,users stories, acceptance criteria in project life cycle

Confidential, Alexandria, VA

Senior Data Analyst

• Analyze IT portfolio investments for alignment to VA Vision, architecture, strategy and associated risks.
• Lead the implementation of enterprise data governance strategies and solutions as part of a dynamic enterprise data governance team.
• Designing, modeling (Logical and Physical) and maintaining the models for different subject areas based on claims, provider, eligibility and other related data.
• Analyze differences between old and new system change requirements, create logical and physical database design based on required changes, create/update technical design documents
• Mapping operational data to the data model and Preparing Data Dictionary for various data sources/datasets.
• Ensuring CMS standards are implemented in the data model and database.
• Working with database developer and DBA to implement the physical schema in a Redshift database and load data into the database
• Support development of CPIC Guidance, SOPs, Resource Allocation Plan (RAP) and OMB 300 Business Case
• Provided support to Business and Data Analyst(s) in gathering and/or clarifying data and reporting requirements from business owners.
• Perform database analysis and SQL queries, extract files from database and import them into standard desktop software packages
• Prepare annual budget reviews, quarterly briefings using Dashboards
• Make effective use of NGA provided computational methods, tools, and data sets. Work as a part of an integrated investment analysis team to include direct interfacing with program offices and senior NGA leadership.
• Maintain program budget and spend plan according to financial best practices
• Maintain program Lifecycle Cost Estimate (LCCE) and perform SQL queries on PMAS and e-CPIC Databases
• Manage multiple contract tracking worksheets and reports generation through Excel and Tableau
• Review budget plans for all activities, tracking obligated, committed, and expensed amounts against the plan, investigate variances, identify shortfalls and propose reallocation of funds when necessary
• Data/Requirements analysis and documentation, performing data analysis as it pertains to issues and gaps
• Conduct budget and expense forecasts through creation of Dashboards.
• Respond to financial data calls and develop financial reports

Confidential, Washington DC

Consultant (Business Data Architect/Analyst)

• Worked with central CMS data architect to ensure CMS standards were implemented in the data models and databases in line with Data Governance framework.
• Worked with Local DBA for implementing the physical schema in a DB2 database.
• Worked with developers for loading data, using operation data system and creating reports
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Ensure proper data capture for performing compliance audit/review of existing mortgage Confidential that are managed by originating and/or servicing institutions.
• Analyzing the entire loan documentation file including initial loan application, modification and/or workout documents, payment & credit history, required closing documents (HMDA,RESPA, GFE, TIL, HUD-1, Title Policy, etc.) and borrower and institution correspondence.
• Responsible for complete review and evaluation of client financial institution mortgage Confidential to ensure they are compliant with all state and federal HMDA lending regulations
• Performed data profiling in the source systems that are required for Salesforce and Unifi System
• Develop and prepare SDLC documentation and process flows
• Handle requirement definition and analysis
• Interpret and deliver business intelligence and effective system solutions
• Performing data analysis / accessing data from multiple sources providing summaries of data trends
• Preforming web analytics, data extraction, data analysis using Python, SQL and Tableau software for visualization
• Creating business role spreadsheets / mapping documents
• Creating and maintaining data artifacts, data dictionaries, and models
• Working with the users to do the User Acceptance Testing (UAT).
• Queried the databases, wrote test validation scripts and performed the System testing using SQL
• Review loan level system data, as well as file documentation, to ensure compliance with governmental and investor guidelines.
• Compile data for each loan reviewed and corrective action needed based on criteria established by clients, government programs and/or management
• Ensure proper data capture/export for reporting and tracking purposes and identify anomalies and trends
• Testing of new system releases/system enhancements to ensure data validity

Confidential, Fairfax, VA

Business Data Analyst

• Responsible for processing document that details the steps for preparing and maintaining Master Change Request (CR) Template and Artifacts that support the creation of the MYP Artifact for Budget Monitoring.
• Responsible for maintaining the Master Data and automating data collection to support the use of authoritative data sources and the reuse of data collection for 350+ projects. Update the CR Form (multi-year templates) to ensure that the multi-year budget formulation documents are maintained.
• Responsible for maintaining Financial Tracker and templates/artifacts for the collection of financial information for the purposes of multi-year budget programming and planning (MYPG).
• Prepared Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
• Assisted in collecting and submitting information to be used by the Programming and Long Term Investment Board to prioritize IT requests in order to prepare annual IT Budget request.
• Conducted reviews to show historical information, current trends and forecasting based on the information submitted by project or program managers
• Consolidated Change Requests to Master Repository, conducted analysis to ensure consistency, reasonableness and prepared various artifacts for the annual submission of IT financial requirements
• Compiles and help with presentation materials for the Non-VA Care operation budget.
• Receives and Interprets Calls for Budget, prepares annual budget formulation documents in final form and ensures that all reconciliations are made as to workload data, accuracy, distribution of programs.
• Responsible for mapping and migrating all current data Budget Submission to intranet SharePoint online sites and maintaining a consolidated inventory of data to be used for future analysis.
• Reviews historical financial operating data and trends to prepare and/or validate estimates and post on SharePoint to enable team access and collaboration.
• Provided support to Business and Data Analyst(s) in gathering and/or clarifying data and reporting requirements from business owners
• Developed dashboards/reports in accordance with client requirements
• Identified and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems
• Used Microsoft Office Tools particularly Excel (Graphs, Pivot Tables, functions, formulas) to test, log and resolve data accuracy and completeness issues.
• Developed work breakdown structures, prepared charts, tables, graphs and diagrams to assist in analyzing problems.
• Prepared Reports Forecasting Financial Trends by Investments and Projects and IT Programming Categories. Created and/or enhanced report objects, metrics, filters, and prompts as needed.

Confidential, Washington, DC

Business Analyst/ Consultant

• Provided architecture team, with logical data modeling, physical database design, enterprise data definition, data load, stored procedures, triggers and a complex bi-directional replication schema based on specified requirements
• Participate in data modeling and database design
• Migrating Oracle data mart onto Netezza along with the enhancement of the Corporate Treasury Data Mart (CTDM) loan data with improved Current Appraisal Values and Current Loan-to-Value ratios.
• Provide Oracle and Netezza database related technical insight on project for migrating code and data
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Managed database change control and impact assessment on database changes.
• Led Information architecture team on daily basis and assigned development tasks to database and SQL developers.
• Worked with systems engineering, project manager, application development team leaders, and application developers to implement database design.
• Plan and document all Confidential related project artifacts that were to be migrated Monitored and participated in development integration testing in accordance with information architecture practices.
• Responsible for assessing, documenting, monitoring and reporting on compliance client portfolio monitoring activities, ongoing testing and related controls
• Evaluate Netezza features to leverage existing functionality and test application performance Ensured any and all post-closing loan conditions are met and documented accordingly and third party service providers complied with reviews on document submission.
• Prepare and distribute weekly and monthly summary highlights to report results and corrective actions
• Used multiple systems, platforms, applications, and data repositories in various data environment to access and perform compliance audit
• Responsible for auditing closed loan files, analyzing and reporting on significant loan quality trends and initiating necessary action to improve efficiency, document accuracy and compliance as it relates to Office of Currency Controller’s guidelines on audited banks
• Audited pending foreclosure and closed loan files, analyze and report significant loan quality trends and initiate necessary action to improve efficiency, document accuracy and compliance.
• Analyzed defaulted loan servicing policies and processes to improve internal testing, isolate root cause, and suggest viable solutions to mitigate issues.
• Assisted in the development of business cases and management presentations to represent operational impact to the organization.
• Reviewed and decipher civil code as it relates to state specific Residential Lending practices.
• Provide a detailed forensic analysis of Confidential, VA and Confidential to ensure findings are compliant with OCC practices.
• Assisted in writing test plans and managed system testing efforts for both System Integration Testing and User Acceptance Testing.
• Worked with subject matter experts and technologists throughout the project lifecycle to produce relevant artifacts (process flow charts, user requirements, user guides, release notes)
• Created database queries (SQL, Excel formulas, Excel Macros) to extract data for analysis, trending and testing from databases

Confidential, McLean, VA

Default Fulfillment Analyst

• Provide supports to more than 2300 large and small full-service regional mortgage lenders on portfolio of Confidential in default, imminent default Confidential with a focus on loan modifications, document validation, Net Present Value model running, completing second mortgage modifications, executing short sale/ DIL or answering technical foreclosure questions.
• Created Repository and User groups, and Performed basic analysis and daily reporting functions to support the processing of Confidential under Making Home Affordable(MHA) program
• Used Rational DOORS for Requirements gathering and Business Analysis and analyzed the functional specs provided by the data architect and created technical specs documents for all the data mappings.
• Managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources submitted by Servicers.
• Extensively used TOAD for generating SQL, PL/SQL stored procedures, Packages, Triggers, Clusters, Synonyms, Indexes, Views, Materialized Views
• Used Toad for Unit testing before transferring data from OLTP to data warehouse, data is transformed at the staging area.
• Created database queries (SQL, Excel formulas) to extract data for analysis, trending and testing from databases
• Ensured loan submittals met internal and external eligibility requirements. Gained extensive experience in underwriting Confidential, VA and Confidential
• Maintains data-specific artifacts, including but not limited to the data-specific requirements template and the various models to manage data visualization and dashboards.
• Reviewed, validated, and developed financial cash flow for non-performing Confidential
• Actively participate in identifying processes to be refined through analysis and the application of technologies.
• Perform financial risk management advisory and audit relating to settled foreclosures, modifications, retention and REO.
• Manage mortgage file set up, data validation, batch folder creation and upload of submitted servicer’s loan
• Review and Manage all emails incoming from shared team mailbox, acting on emails as appropriate
• Adjust system records to reflect results of changes made to accounts at loan level
• Assist special Teams on compliance testing related to new technology, software and back test servicers platforms to confirm with Confidential
• Origination of daily work reports and creation of Transmittal folders

Confidential, Fairfax, VA

Business Analyst

• Collecting, recording and analyzing disaster registration information from individuals, families, and businesses affected by Declared Hurricane Disaster zones overseeing implementation of area projects/program to ensure funds objectives benefit affected victims through liaison with support services of field officers
• Assisting in the validation of initial grants application, audit files and disbursement amounts
• Issues additional funds disaster victims in compliance with Government Contract specification
• Coordinating and implementing the review of grant applications with assigned Teams as SME (Subject Matter Expert) on Insurance issues
• Coordinating post review activities including the preparation of review summaries
• Ensure that all underwriting and pre-closing documents meet policy requirements specifically to benefit disaster victims
• Review and approval of Grant Appeals applications
• Writing proposal, analyzing program data, and prepares program status reports for review and current status on specific programs connect and pull data from all sources in a dynamic and flexible way to report on them with real time refresh capability
• Create/maintain excel pivot table reports, charts, graphs, dashboards, scorecards of settlement analysis to maximize the Fund’s recovery.
• Creating, reviewing and reconciliations of individual client’s application and Funds disbursement
• Monitor and review the progress of program implementation to assure that responsibilities are carried out according to established policies and procedures. Assists in the analysis of the efficiency and effectiveness of program delivery methods and implements quality control procedures.
• Carrying out additional responsibilities and projects as assigned

Confidential, Binghamton, NY

QC Inspector

• Responsible for inspection of semiconductor products, laminate chip carriers, panels and assemblies.
• Perform visual and mechanical inspection of supplier parts to QIP. Work with other departments to ensure quality of manufactured products.
• Troubleshooting and problem unlayering to the component level using data supplied by the tester in addition to bench test equipment.
• Enter observed data and run reports by use of SAP software