OBJECTIVE:

I am seeking a Senior Data Analyst position or a system analyst position requiring analytical skills in an information systems environment.

SUMMARY:

Worked with information systems for over twenty six years in several positions requiring advanced skills in the areas of business requirements, data analysis, system requirements, system analysis, design, testing, production support, project management, and client training in health care, telecommunications, web - based service providers, mortgage related financial services industries. Experience in working in data warehouses, web-based client servers, and mainframe platforms. Extensive experience in the areas of accounting and auditing. Holding active Top Secret clearance and working on a project at the Confidential .

SKILLS:

Oracle, Sybase, Toad, SQL, BusinessObjects, Doors, SharePoint, Erwin, Embarcadaro, Embarcadaro Studio, HTML, XML, TCL, C++, Unix, MS Access, Excel, Visio, Tableau, TestDirector, IMS, TSO, JCL, DB2, File-Aid, Cobol, and Fortran.

EXPERIENCE:

Senior Analyst

Confidential

Responsibilities:

• Currently, I work in the SAOC and I am the team lead responsible for conducting, directing, overseeing data analysis at Confidential and SAOC. Performance of my duties requires the application of technical knowledge to extract the required data, via SQL queries, from the SEVIS database and analyze it and present my report and findings to meet the investigatory and data needs of SAOC, other Units in Confidential, supporting criminal investigations, US Congress, White House, Media - both print and television, Department of State, ICE, Freedom Of Information Act (FOIA) requests, and various departments within the Confidential . I am knowledgeable of the laws and regulations that govern Confidential .
• I have demonstrated knowledge of the processes involved in certifying academic institutions and I generate several reports that initiate and track this certification processes. I also monitor, very closely, the enrollment of international students and exchange visitors at schools and programs in the US.
• Not only do I analyze data from SEVIS, but data from ENFORCE, ADIS, and CLAIMS is also reviewed and analyzed on a daily basis, in conjunction with SEVIS data, to complete our tasking and analysis.
• Data analysis in the SAOC is high pressure work demanding a very high degree of accuracy in completing complex and technical analysis. The timelines are short. The deadlines are hard. And the flow of incoming work does not abate. I have worked within SAOC since its inception and I have fully met the data needs of the SAOC and all its affiliated constituents even during the times when I was the only data analyst in SAOC.
• I accommodated substantial increase in our workload caused by changes in our responsibilities with the creation of SAOC in 2011. This required changes in priorities to meet the changing program objectives with the existing resources and maintaining the existing high quality and quantity of work. The role of my team changed very significantly with the creation of SAOC and we have adapted admirably. We took on a fourfold increase in workload and are meeting customer expectations while maintaining the same headcount as before.
• Developed new reports to analyze the monthly performance of the Confidential Response Center (SRC) and calculated whether the established metrics for customer service were met. Made significant improvements over the existing SRC reports and set up a reporting database to make report generation efficient. I served as an expert analyst in evaluating the effectiveness of the SRC in monthly reports and advised the Branch on ways to improve their productivity and efficiency.
• Designed and developed a back-end process to receive I-515 data from the daily Enforce interface and scrub this data to correct it for some of its glaring inaccuracies. Used the scrubbed data from the Enforce feed to extract data from SEVIS and load it into tables.
• I generated reports indicating the severity of the data mismatches between Enforce and SEVIS. This process also made data from Enforce and SEVIS available for further I-515 processing.
• I am responsible for conducting in-depth data analysis and program wide evaluations of the effectiveness and efficiency of all the major operations throughout Confidential .
• This evaluation involved the operations of Tri-Valley University, which was the focus of a major ICE investigation.

Senior Business Analyst

Confidential

Responsibilities:

• Responsible for a critical component of a very big and high intensity development project, which required quick on the job learning and delivery of accurate results in extremely tight deadlines.
• This Investor Reporting project was critically important to Confidential and sought to replace an aging legacy system.
• Responsible for assembling the logic to board Confidential loan acquisitions into the new system.
• This logic was in pseudo-code format and documented in hundreds of complex rules.
• These rules were referred to as requirements but were in fact design mappings as they provided detailed instruction on what to code in Ab Iinitio and PL/SQL based ETL processes.
• Also wrote SQL queries to perform data analysis to explain and resolve disclosure and outbound interface data discrepancies that arose during parallel testing.
• The new Investor Reporting system serviced all loans owned and guaranteed by Confidential .

Senior Systems Analyst

Confidential

Responsibilities:

• Designed and supported multiple web-based applications to register new Confidential members in US and in Europe. Interacted with the business team to flesh out the project requirements and developed the technical requirements document.
• Completed detail design with the assistance of the developer.
• Managed projects by providing firm resource estimates and ensuring the project adhered to scheduled dates.
• Responded to design issues raised by the QA group and assisted the developer to research bug fixes.
• Performed post install verification and production support.
• The applications developed were in TCL and C based on Confidential ’s proprietary messaging infrastructure connecting multiple servers.
• Also worked on OnRamp, a project to consolidate all member related data in one data warehouse to make access to member related data easy and efficient.
• Member data related to demographics, customer contacts, trouble tickets, and usage was consolidated into a data warehouse from external and internal data repositories.
• Prepared concept papers, requirements, design documents, production support documents, and test plans for various projects.
• Developed and maintained data models in Erwin.
• Defined usage-reporting requirements for various products and services at Confidential .
• Business Objects is the primary reporting tool for the data warehouse.
• Extract, Transfer, and Load (ETL) using AbInitio is the primary method of moving data between the various data repositories and the Red Brick data warehouse.
• The OnRamp project was a joint effort between Confidential and the Confidential.

Business Analyst

Confidential

Responsibilities:

• Supported the information technology group with the development of Confidential, a data warehouse to consolidate into a single platform the reporting capabilities of all legacy systems within Confidential and Confidential for order tracking and reporting.
• Responsible for preparing the analysis and design documents which explained how the functionality of the order entry and reporting systems to be assimilated would be implemented in Confidential .
• Upon assimilation into Confidential, the legacy systems were decommissioned.
• Responsible for defining the data elements in the host system data feeds which would allow the implementation of functional parity in Confidential .
• Also worked on projects to enhance the functionality of Confidential .
• Participated in conference calls with user groups and then interacted with the development teams to determine a plan of action.
• Investigated data discrepancies between the host system and Confidential by importing data extracts from both systems into MS Access and preparing comprehensive reports for giving management assurances about the data integrity issues.
• Confidential is a web-based system using Oracle and the Actuate reporting tool.

Business Analyst

Confidential

Responsibilities:

• Responsible for identifying and establishing the corporate processes required to successfully market new e-commerce products.
• The processes defined the roles and responsibilities of the various departments within Cable & Wireless for the new products from order entry to order completion and billing.
• Arranged and conducted meetings involving decision makers responsible for moving the orders to completion.
• Identified process shortcomings preventing streamlined order processing and causing orders to fall outside the allowable intervals.
• Tracked and ensured the speedy resolution of outstanding issues. Prepared process tables assigning departmental responsibility for each process step.

Business Analyst

Confidential

Responsibilities:

• Participated in a corporation wide effort to replace the existing fragmented legacy systems with an integrated web-based system.
• This effort required a rethinking of how the business operations were supported by the information technology infrastructure in an effort to streamline such support.
• Wrote the business requirements for the Corporate Finance’s pooling system for grouping the available mortgages for the purpose of creating securities.
• These requirements were for business operations in the middle between the front end purchase of mortgages and the backend operations related to Federal Reserve regulations for securities, accounting, and tax. Developing the business requirements involved extensive discussions between the users, the front end, and back end teams.
• Participated in system design meetings with developers.
• Also developed the logical data requirements to support the new system.
• Participated in testing systems which displayed the daily price for different types of mortgages, verified the data on purchased mortgages, and settled the purchases.
• Also, tested systems for cooperative buying of mortgages between Freddie Mac and its business partners.

Business Analyst

Confidential

Responsibilities:

• Worked as a business analyst with the Confidential software development group.
• Confidential is an integrated software package sold to health maintenance organizations to run their managed health care business by enrolling and billing members, pricing and paying claims for medical services, capitation, pre-certification and interfacing the financial information to financial systems.
• Provided direction to develop the Confidential system.
• Interacted with the user community to ascertain the requirements and communicated these requirements to the development team. Participated actively in the design of system enhancements and ensuring the quality of the product delivered to customer.
• Managed projects, participated in sales effort, and made presentations to prospective customers. Conducted classes to train the new users in the system functionality.
• Implemented the system at customer sites both in the US and abroad.
• Configured the system to meet customers’ needs and provided production support.
• Worked as a consultant at Confidential for three years.
• Worked on several projects, including providing assurance to a department that its requirements were adequately documented and included in the design of a large corporation-wide project.
• Investigated and made suggestions for achieving cost-savings in an acquired telecommunications company by identifying areas of overlapping and duplicate costs.
• Performed integrated testing on the EVS product for the Business Markets.
• Participated in designing and testing the Personal Thanks system for Consumer Market.