SUMMARY:

• Twenty(20) years of experience in the Data Processing field. Object Oriented Experience includes using IBM MVS MAINFRAME & UNIX as well as PC based software products; designing and documenting programs using TABLEAU,ACTUATE, BUSINESS OBJECTS, HYPERION BRIO,C Language, ORACLE, JSP Pages, TSO CLISTs, COBOL, CICS, ACCESS, Visual Basic and SAS user language. Extensive knowledge in accessing Sybase, Oracle and SAS databases using SQL query language.

TECHNICAL SKILLS:

• TABLEAU
• THOGHTSPOT
• HYPERION BRIO
• ACTUATE
• INFORMATICA ETL tools
• BUSINESS OBJECTS
• ERWIN
• JCL snf COBOL
• PL/SQL for ORACLE
• JAVA
• Transact SQL for SYBASE
• ORACLE
• DB2
• UNIX
• ACCESS
• SQL Server
• ACCESS VBA
• VISUAL BASIC
• SAS
• SAS/AF
• SAS/SCL
• SAS/SQL
• TSO TSO/ISPF
• CLISTs
• TRUE DBGrid
• EASYTRIEVE
• MICROSOFT OFFICE products
• MICROSOFT PROJECT
• VISIO
• HTML
• XML
• WEB OBJECTS FRAMEWORK
• RATIONAL CLEARCASE
• CLEARQUEST
• CRYSTAL REPORTS

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst/Developer III

• Developed SQL based applications and TABLEAU,THOUGHTSPOT Dashboards utilized by business units such as Acquisitions and Contracts Ops. Lead technical role in developing automated applications in accordance with unit and business Processes. Participated in all of the steps in the software development life cycle to create and modify the software.
• Followed the Agility process for development of software needed by the business units.
• Lended technical expertise and provide assistance in extracting data from specific software applications, in supporting interface processes, and in analyzing the impact of system upgrades on management reports.
• Designs databases and create structured query statements to provide management reporting not available through the warehouse. Assists in the implementation and administration of a Change Control Management procedure to insure the security and integrity of databases.
• Participates in the implementation of future upgrades; analyze what impact upgrades may have on reporting databases and the scheduled reports. Prepare and manage scheduled daily, month - end and quarter-end reports in a backup capacity. Train staff on the use of the company’s databases, including entering, extracting or exporting data. Developed procedures, forms, exhibits and database documentation.

Confidential, Greenbelt, MD

Sr. Business/Data Analyst

• Analyzes systems to Develop Access Databases that store all information needed by Confidential Brokers, Managers, Salespersons and Administrative staff. Utilizes SQL, Visual Basic and JAVA to develop Monthly and daily reports needed.
• Performs Data Extraction and Analysis through SQL to automate the population of Excel spreadsheets and Access databases to identify marketing trends and opportunities for improvement. 
• Analyzes models to determine benchmarks and provide feedback on next steps in order to gain the largest profits for Faifax Realty.
• Strengths include Strong attention to detail, time management, troubleshooting, analytical, verbal and written communication.
• Streamlined multiple business processes to create consolidated systems to create corporate wide efficiency.

Confidential, McClean,VA

Sr. Business/Data Analyst/Developer

• Worked under pressure to meet proposed deadlines.
• Analyze data requirements and test plans.
• Test data conversions, troubleshoots and recognizes system problems.
• Utilize Strong data research skills including controls assessments.
• Posessess Strong attention to detail, time management, troubleshooting, analytical, verbal and written communication skills..
• Data development involves multiple components: Credit Management, Single Family Profitability, and Financial Reporting.
• The Financial Reporting work involves consolidating financial data into the Single Family Credit Data Mart (SFCDM) such that a common source for management and external reporting is created.  
• Certain financial data today is maintained in an EUC (End User Computing) application.  
• The project is focused on establishing a consistent usage and meaning of data within the data mart, ensuring that the appropriate data controls are in place, migrating historical data from the EUC and other sources to the data mart, facilitating reporting from the data mart, and ultimately, retiring the EUC.
• Assists in developing the data conversion strategy and approach.
• Researches data sources and documents critical data elements, data lineage, and controls as needed.
• Contributes to the reporting requirements  as needed. Analyzes the CDWP environment and understands the CDWP data architecture(i.e. base tables, collection tables, views, dimensional tables, sourcing tables vs servicing tables, monthly snapshots, historical vs current data, etc).
• Ability to understand and analyze business rules and footnotes in BRS.
• Ability to perform data lineage analysis and ability to write SQL utilizing SAS,DB2 and Oracle databases.

Confidential, Herndon,VA

Business Analyst & Quality assurance analyst

• Monitored spreadsheets daily to coordinate successful sql execution.
• These jobs had to be monitored constantly and outputs delivered on a timely basis.
• These transactions were critical to General Ledger generation.
• Utilized Oracle SQL,Access SQL and Data Staging tools to retrieve data for Business Objects,Hyperion/Brio and SAS reports to support quarterly General Ledger bookings.
• As Data Warehouse tester, Utilized defect tracking tools to determine defects and suggest ways to resolve. Ensured software enhancements confirmed to required specifications.
• Responsible for generating test plans, test scenarios and test data in accordance with the design documentation.
• Generated various testing scenarios based on application processes. Applied suggestions for improvements to the current AUT, test methodologies and processes.
• Applied a thorough understanding of the SDLC process to various stages of the Testing lifecycle and made adjustments where required.
• Suggested modifications to queries and reports based on results of test run.
• Multitasked work assignments to provide necessary level of accuracy and proficiency in meeting deliverables.
• Analyzed areas where automation can facilitate manual process/generation and requisite queries and establish parameters for data summary & review, management sign-off and timing of disclosure updates.
• Created USE Cases and Conducted final review sessions with Director & VP for sign off on processes and Facilitated knowledge transfer training sessions to update employees of enhancements.

Confidential, Bethesda,MD

Sr. Business Analyst Manager/Developer

• Supervised employee Responsibilities for analysis, maintenance and support for data warehouse needs within the Portfolio Risk Management unit.
• Developed IT Project documentation in accordance with CMS Investment lifecycle.
• Converted existing IBM Mainframe SAS and COBOL batch programs into data warehouse architecture. Code, scripts and stored procedures. Reviewed monthly for source system changes and modified programs as needed.
• Coded bqy files in Hyperion and ORACLE SQL to meet the needs of the Credit Analysis department of Confidential
• Utilized Informatica ETL Application to transform data to be loaded into database.
• Created JOOLE (OLE Automation Controller within JavaScript) modules to automatically link and download data to Excel files on a monthly bases. Utilized Hyperion Intelligence Clients to control external ActiveX applications that uses OLE Automation servers.
• Converted existing SAS batch programs into data warehouse architecture. Coded scripts and stored procedures. Reviewed monthly source system changes and modified programs as needed.
• Met regularly with Analysts and Management to determine their needs and translated requirements to work specifications to structure data extracts and reports from the data warehouse.
• Prepared data extracts and file merges from data warehouse on a monthly production and AD Hoc basis. Structured and maintained data downloads for analysts as specified.
• Intermediated between credit policy and technical personnel in business lines to ensure data programs met requirements.

Confidential, Washington, D.C.

Sr. Business Analyst/Developer/DBA

• Wrote SQL and stored procedures for Business Objects reports utilized by Confidential ’s internal and external users.
• Developed technical design specifications and test scripts for each report.
• Maintained and Updated Business Objects Universe which ran off of an ORACLE backend by adding variables, objects and classes as needed by Business Users
• ETL Experience using Abintio
• Customized Actuate and Crystal Reports controls by overriding methods using Visual Basic.
• Executed SQL to extract data from ORACLE environment.
• Oversaw daily UNIX production environment/process. Implemented changes to C code, Java, and Sybase stored procedures as needed.
• Creates Visual Basic modules in Access pertaining to all procedures as needed.
• Created Bypass Edit database to track MBS and Cash edits that are bypassed in order to determine if they were bypassed correctly.
• Assisted business users with writing requests and developing Business Objects, Access, Actuate and Crystal Reports.
• CORE Project -conducted Data Analysis of all CORE related legacy reports. This included decoding legacy programs written in EXCEL, COBOL, SAS, ACCESS, SYBASE, SQL and JAVA.
• Developed both logical and physical designs based on sub-stream applications. Worked with Business Analysts to gain a solid understanding of the business flows and corresponding data flows.
• Developing data for Corporate warehouse.
• Writing Actuate and Business Objects reports for Confidential ’s internal and external users.
• Developed technical design specifications and test scripts for each report.
• Worked closely with the Data Architecture team to ensure atomic level data and aggregated data was properly defined and available within the ORACLE Operational Reporting Database(ORDB).
• Created and Deployed/ Published reports on the WEB from Specifications utilizing Business Objects and Actuate eReport Server.
• Customized Actuate Reports and controls by overriding methods using Visual Basic. and Updated Business Objects Universe by adding variables, objects and classes as needed by Business Users.
• APE(Automated Pricing Environment)
• Designed and developed screens and programs for the APE99 enhancements. Code was written in Visual Basic, utilizing True DBGrid, SQL and Crystal Reports .
• As a Developer on the APE system, I designed and wrote Visual Basic code to enhance the system for APE99. I was responsible for screens, modules and classes. The screens developed utilized True DBGrids and Crystal Reports.
• Dealfactory
• Supervised. Developed and implemented new enhancements and modifications for the Deal Factory of Confidential .
• The Deal Factory processes seasoned loans to check the mark to market ability, geo/goal score as well as the credit score of each loan submitted for purchase to Confidential .
• The system utilizes SAS, COBOL, CICS, UNIX, SYBASE, ACCESS and the IBM Mainframe.
• Programs are written utilizing Unix shells rips, SYBASE, SQL, ACCESS and SAS.

Confidential, Baltimore, MD

Task Leader/Senior Programmer Analyst

• Supervises 15 employees,. designs, develops and implements all new enhancements and modifications to the Decision Support Access Facility(DSAF) which is included in the Health Care Information System(HCIS) for the Health Care Financing Administration(HCFA).
• This system allows the user to retrieve Medicare and Medicaid claims data based on specific data field values, percentages, and a locator (finder) file in order to perform health care analysis, clinical, and epidemiological research.
• These systems require extensive knowledge of COBOL, CLIST, SAS and SYNCSORT languages as well as TSO/ISPF, JCL processing.
• Designsed, coded and tested GUI systems written in SAS/AF, which utilizes SCL and SQL