Divy Agrawal Email & Phone Number

Sterling, VA, US

Reston, VA

• Worked on One Cohort database for SAT, PSAT and AP data where I was responsible for doing the UAT on newly created tables and views as per requirements.
• Wrote various Data Quality queries to make sure all the de-normalized tables were created as expected.
• Worked with Research, College Assessment, and various other teams to gather the business rules and requirements and pass it on to the Database developers.
• Created various Admin Views for SAT, PSAT, and AP which would extract data from various tables in a more user-friendly format for the business users.
• Worked closely with the Data Architects, Developers, and Data Modelers to understand the flow of data from one system to another and the corresponding business and transformation rules for some tables and attributes.
• Did Gap analysis between the tables that research team had and what they need from the new One Cohort database and suggested changes and updates to the One Cohort development team.

Mclean, VA

• Managed an MS Access SOX Database where I am responsible for making any updates and corrections.
• Automated the process of preparing the files we receive from various workstreams and importing it to the production MS Access database utilizing (Visual Basic) VB modules.
• Created a front-end UI for users to run the queries, create reports by utilizing Forms, filters, tables.
• Wrote VBA scripts in MS Excel to automate the report generation process.
• Wrote SQL queries to analyze the data for number and type of Issues and Key Controls across different months.
• Performed Data Quality checks on the files we receive from various teams to check for Completeness, Accuracy, Consistency, and Integrity.

Washington D.C. Metro Area

• Created a Loan Management MS Access Database to manage loan corrections sent to Fannie Mae by different Lenders.
• Automated the process of receiving multiple files from lenders and running Data Quality checks and sending it to the production system to process the corrections utilizing (Visual Basic) VB modules.
• Created Weekly and Monthly Reports for Management from the database to track the workflow.
• Worked with multiple teams to gather requirements for the database development.
• Created a front-end UI for users to run the queries, create reports by utilizing Forms, filters, tables.
• Wrote VBA scripts in MS Excel as well to automate the report generation.

Washington D.C. Metro Area

• Built profiles in Informatica IDQ Analyst tool for the Loan Level Disclosures file to help the business quickly identify data anomalies, and hidden relationships among data. The profile, also assist with finding the.
• Created user-defined Data Quality rules and used prebuilt industry-specific rules to analyze and validate data issues across multiple Data Quality Dimensions.
• Customized drill-down functions that help the business fully assess the root cause of the data issues.
• Created scorecards in the Informatica IDQ Analyst tool to report on metrics and historical trending of data and rules.
• Assisted the disclosure team to generate reports based on the scorecards for Compliance, Audit, and Monitoring of data.
• Created Mapping Specifications in the tool for Cross Table Analysis.

Mclean, VA

Automated Data Quality and Reconciliation Reports for the EPMO Reporting Group.Created a CR and Variance Tracking Tool in MS Access database using Forms for the EPMO Reporting and EPMO Governance team.Created a resource reporting tool in MS Access using Forms and Reports for the Project Management group for managers to automatically retrieve their.

Washington D.C. Metro Area

• Worked on Ad-Hoc requests from the internal customers.
• Optimized already existing SQL scripts in Oracle using the Optimizer Hints like parallel, with, and ordered clause.
• Automated the reports in Unix where the scripts will run on a particular day of the month or week automatically and email the report directly to the customers.
• Worked on Data Compare project where we checked the loan attributes coming from Servicers with the ones Fannie Mae has.
• Technical hands-on expertise using OLAP tool Business Objects XIR2(Reports, Designer, Web Intelligence, Info view).
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values.

• Performed analysis and reporting for the Fraud Operations team.
• Coordinated with cross-functional teams in different locations for quality data and analysis.
• Created and automated scripts in Teradata that runs on a daily, weekly, or monthly basis.
• Developed numerous sql and shell scripts to get the data from the flat files in different formats and load it in teradata tables.
• Created ETL scripts to transfer the data from Oracle to Teradata.
• Created crystal reports to be used by the business team for their analysis.

• Analyzed Test Bed Data and Business Requirements to get a better understanding of the system from both technical and business perspectives.
• Loaded data from heterogeneous sources like flat files, MS Excel, and csv format using SQL Loader and similar utilities into the database.
• Created Perl scripts to validate the fixed width files, delimited files and other file validation tests.
• Analyzed, designed, and implemented moderately complex computer-based systems for statistical analysis and data management.
• Created scripts in Perl and Korn shell to automate loading/validation processes.
• Used Oracle SQL Developer to access the databases and write all the data checks.

• Prepared Test Plan Approach document. Updating to the requirements based on the enhancements.
• Used the XML scripts to the XML Injectors, which connect through the TCP/IP connection to the iLink Gateway which would send the orders to the Fix Gateway and hence to the Trading Engine.
• Wrote shell scripts to gather the required information from the log files in UNIX and analyzed them.
• Generated various Financial Reports, Financial Data mart, Data Structures for higher management with regard to databases, Account Level performance, and financial needs.
• Worked on the FIX protocol 4.2, NSC and TIBCO messaging system.
• Performed manual testing of different types of orders like Stop Limit, Limit, Market Limit to verify their functionality.

Ann Arbor, Michigan

• Implemented a disk scheduler using multi thread programming in C/C++.
• Implemented a POSIX thread library in Linux Environment.
• Designed a 2-way superscalar 5-stage pipelined processor in Verilog. Made data and instruction cache module, multiplier module and predicted branch not taken.
• Designed a search engine in C++ to perform web searches on ASCII files.
• Used combination of Hash tables and BST to improve performance and speed.

Bachelor Of Science

B.S.

High School