SUMMARY:

• Senior Database Developer is a result oriented and solutions focused data business analyst with strong combination of technical and management talents backed by a proven ability of data analysis and strong technical skills and experience, well organized and analytical problem solver with strong interpersonal and negotiation skills; adept at overseeing multiple tasks, resources, and cross - functional team efforts while interfacing effectively with team members and senior management.
• Highlights of expertise include:
• 12+ years in Information Technology with Expertise in Data Analysis and Data Warehousing and Web based applications.
• Data Analysis Mortgage Quality Assurance
• BPMN Notation Financial Reporting Process Development/Improvement
• Business Process Analysis Scrum, Agile, Waterfall & SDLC Testing
• BI Reporting OLAP Data Governance

TECHNICAL SKILLS:

Content Management: SharePoint, RATIONAL ClearCase, ClearQuest

Programming: SQL, PL/SQL, VBA Macro Writing, ASP.NET, Java script. HTML, JK Developer.

Databases: Oracle Developer, TOAD, Teradata, SQL Server, DB2, UDB

Application Suites: MS Project, MS Office, MS Access, MS Excel, MS Visio, XML, Erwin

Operating Systems: Windows 7, XP, Windows 9x/2000/NT, UNIX (Admin)

BI Reporting: MicroStrategy, Tableau, Business Objects, BOXI, Crystal Reports, SSRS Reporting Services, Tableau, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C

Sr. Database Developer

Responsibilities:

• Works with the data migration project of legacy systems from ADABAS and COBOL to Oracle and web development projects.
• Reviews and analyzed report data for migrations and upgrades of the system and Web development, performs Re-engineering tasks to re-created the reports in new Oracle database.
• Develops complex PL/SQL queries in JK developer to create online reports.
• Develop data models using in Oracle database Modeler according of reporting requirements and maintains the metadata dictionaries as needed.
• Implements of solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication.
• Designs and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume.
• Software life-cycle support to include migration of all custom application changes through four different instances to production.

Environment: Oracle SQL Developer, SVN, Legacy Systems, JK Developer, WebLogic, APEX

Confidential, Reston VA

Sr. Data Analyst

Responsibilities:

• Coordinated with stakeholders and SMEs various mid and high complex project deliverables in Agile environment, that included data and business requirements and solutions gathering for project estimation for software engineering and database development for Info Sec teams that included SOX Compliance and Technology Engineering Services.
• Translated business requirements into BRDs functional specifications for technical teams following SDLC and Agile project cycles Freddiemac standards, managed projects in a Share Point environment.
• Provided liaison between business units and technology services for new projects and ongoing updates and final QC and testing completion and application integration.
• Also supported the data and reporting generation, analysis and large sets of data extractions from various database sources to audit and provided privileged user and OSSA activity reports on production UNIX, MSSQL, DB2 UDB, SYBASE and ORACLE Distributed Databases under the scope of Sarbanes-Oxley (SOX

Environment: Oracle, MS Access, MS Excel VB Macros, DB2, UDB, SYBASE, SharePoint

Confidential

Sr. Business/Data Analyst

Responsibilities:

• Conducted meeting and JAD interviews with SME’s concerning the process and data concerning affordable housing programs provided by D.C government.
• Coordinated meetings with D.C. Agencies(including DHS) internal and external stakeholders to capture the As-Is business processes concerning programs for affordable housing that included property data and programs for low income resident of D.C. residents. Provided recommendations and solutions for the To-Be processes supporting the centralize data warehouse implementation of affordable housing for the District of Columbia, residents.
• Conducted Re-engineering analysis and gathered requirements data, verify requirements and create business requirement specifications (BRS). Created process flow diagrams BMPN swim lines using Visio. Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Worked with internal architects in the development of current and target state data architectures
• Worked with project team representatives to create business glossaries metadata dictionaries and data models were developed in line with D.C government standards and guidelines.

Environment: Quick view, Oracle, SQL Server, BPMN, MS Access, MS Excel, SharePoint .

Confidential

Data Analyst

Responsibilities:

• Provided technical and analytical support to the QC activities related to the mortgage home loans, bankruptcies and foreclosures control functions
• Gathered requirements to create test cases and procedures, executes complex SQL test cases and validates data and transmission logs in a Share Point server environment
• Gathered and organized the data and procedures in order to increase the effectiveness of key controls and tracking and report of any risks and related issues as needed
• Investigated data attributes within various servicing and loss mitigation databases. Created logic’s to automated data extraction and validations QC testing that included OLAP cubes and Six Sigma Calculations
• Worked within the policies and standards regarding sampling methodologies. Thoroughly documented the operating procedures for testing sampling execution

Environment: Teradata, AS400, Oracle, Sig Sigma, SQL Server, MS Access, MS Excel formulas, pivot tables, macros, SharePoint

Confidential, Somerset, NJ

Business Analyst

Responsibilities:

• Lead the process and technology teams focused on code tables data warehouse Implementation projects to design, develop, and deploy standardized code tables to LOB partners which meet the defined goals and objectives of the engagement
• Performed a leadership role in designing the distribution layer that will supply updates in the code tables data warehouse, developed the business processes, systems requirements and project plans to integrate the new insurance ISO that included ICD-9 and IDC-10 standards and updates that include the updates of the codes
• Created BRDs technical specifications to integrated need data into the Data warehouse as needed.
• Created and updated the project plans and project status reports using flow charts and diagrams, coordinated weekly meetings with the PMO team members to inform the milestones deliverable s of the project, and addressed any issues as needed that included risk management reports.

Environment: Concord, ISO, Oracle, SQL Server, BPMN, MS Access, MS Excel, SharePoint

Confidential, McLean, VA

Sr. Systems Analyst

Responsibilities:

• Provided technical support to the ETL and data Compliance teams by and translating business requirements into technical data specifications requirements for new and updates in the reporting concerning developments and updates in risk and compliance of Loan Modification Programs.
• Developed the technical requirements (BRSs) functional requirements for data models and data marts.
• Translated business data models into physical model used Erwin and Visio Studio. Created and maintained the metadata dictionaries.
• Developed data models using Erwin based on requirements analysis
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Participated in the implementation an automation that included MS Access Applications and MS Excel Spreadsheets dashboards with advance pivot tables and macros to automate and improve the manual reporting processes for the Loan Modification Fraud Investigations for the Call Center departments concerning MHAC compliance programs.

Environment: s: DOORS, SQL Server, MS Access, MS Excel VBA, ASP.NET, TOAD.

Confidential, Reston, VA

Business Analyst

Responsibilities:

• Supported the accounting and billing Teams by creating the business requirements to upgrade the billing system into web based platform, coordinated requirement gathering with stakeholders and managers. Recommended process improvement strategy.
• Researched and validated the billing data before production in SQL server environment, reported results from the monthly billing and wholesale invoices for senior management. Documented specifications and user requirements. Prepared and submitted invoices according of the SLA agreements
• Researched and investigate the root causes if were any unusual movements in the wholesale invoices that included transactional data in an Oracle environment created and updated PL/ SQL procedures as needed.
• Supported the accounting team by reviewing the accuracy of the reports pulled from the monthly invoices.
• Researched data and assisted the accounting team to provide innovative solutions to increase the revenue and margin from 32 Mil to 41 Mil a month, by matching components and standardize products.

Environment: s: Oracle PL/SQL, SQL Server, UNIX, MS Excel VBA, ASP.NET, TOAD.

Confidential, CA

Data Analyst

Responsibilities:

• Worked for the Billing and Revenue Assurance reporting departments to assist in the data migrations to centralize the revenue reporting data. Analysed multiple source system to identify the data for migration
• Interacted with the business users and SMEs supporting teams across US to understand both data and reporting requirements
• Assisted in design & development of reconciliation report for tracking the data during conversions
• Developed source to target mapping documents for multiple subject area
• Worked closely with the ETL team to coordinate data mapping during code development by creating BRDs, data specifications and metadata dictionaries as needed.
• Responsible for coordinating with team member to perform testing Developed data validation plan to assist business readiness and legal compliance team for signoff
• Responsible for providing sensitive data to the business readiness team, to support data migration from legacy to target systems.
• Also automated data migrations from MS Access to SQL using VBA macros for the Reporting Departments. Participated in the development and testing of the ASP.NET website reporting application.

Environment: s: Oracle, UNIX, SQL Server, MS Access, MS Excel VBA, ASP.NET, TOAD.