SUMMARY:

• Data Consultant with 15+ years of information technology experiences with Federal and DOD clients.
• Areas of knowledge include Oracle, SQL, Sybase, UNIX (Sun Solaris), Windows etc.
• An information Technology professional with experience in Data Management and Data Quality projects for government and non - government organizations.
• Pro-active, Innovative and result oriented IT professional.
• Equally performs both as a team player and independently.
• Effectively contributed in work situations requiring an ability to work on multiple, concurrent projects and responsibilities.
• Always perform with exceptional communication, interpersonal, technical, analytical, strategic planning, troubleshooting, problems solving and leadership skills.

TECHNICAL SKILLS:

Databases: Oracle/SQL, Sybase, DB2

Software, Tools, Languages: SAP/EBS, Alteryx, VistA CPRS, MUMPS, KIDS, FileMan query, HL7, Smart on FHIR, cTakes, NLP, eXo, VA Pulse, VA VDL, VEMS, VIP/VCMS, FPDS, SAM, GMS, Market Research, MaxPrac, RMS, Microsoft Visual Studio 2015, Visio, SharePoint, VRM/CRM, IBM Rational Tools (RRC, RTM, RQM), Rally, VistA, Remedy, Enterprise Wizard System, Siebel, Track-IT, AWRDS, TOAD, SQL, PVCS, MS Excel, MS Access, FrontPage, CWA, PowerTrak, TOPS, DPS, MIP, JXplorer, Aqua Data Studio (Management Database), IBM Tivoli, Business Process Choreographer Explorer, Cropper, WinSCP3, AIX, Jump Server, Management Server, LDAP, Citrix, MSC, Clear Quest, ROID Tool, ASP, .net, Java Script, HTML, etc.

Operating Systems: Windows, UNIX (Sun Solaris), Linux

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Data Consultant

• Had the ability to be collaborative, creative, detail-oriented, a good communicator/listener, organized, an ‘outside the box’ thinker, proactive, self-motivated, and team player.
• Conducted analysis on several pieces of associated and disassociated information and draw conclusion.
• Supported client in a fast-paced, dynamic environment.
• Multi-tasked and worked independently.
• Provided timely and concise communication of status, risk, and challenges to project manager/leadership on all assigned projects.
• Highly skilled in Microsoft Office Programs (Excel, Word, PowerPoint, Visio & MS Project).
• Experienced with the lifecycle of data from data warehouse/storage, data extraction, data blending, data analytics and reporting/visualizations.
• Experienced working with large data sets in a variety of tools to include (but not limited to) Excel and Access.
• Experienced with one or more syntax/languages to include (but not limited to) SQL
• Experienced with reporting and visualization tools to include SAP/EBS and Alteryx.
• Experienced working with financial data to solve gaps in an organization’s business intelligence.
• Being member of the DMO (Data Management Organization) team, I was involved in monthly data extraction from SAP/EBS (Enterprise Business Systems) priority 1, 2 and 3 tables (FMUSFGA-BKPF, FI-BSEG, EKKO, EKPO, KBLK, KBLP, VBAK, VBAP, MARA, BSAS, ZSVT H, ZSVT I, OIJ, etc.), which is an EDW (Enterprise Data Warehouse) of DLA (Defense Logistics Agency) audit readiness of the financial transactions (i.e., DLA Aviation, DLA Energy, Oil, Food Supply, Soldier support, Warship, etc.) of Sales Order and Purchase Orders, AP (Accounts Payable), AR (Accounts Receivable), WCF (Working Capital Fund), GF (General Fund), TF (Transaction Fund)/reconciliation.
• According to clients adhoc PBC request, perform data extraction of Sales Order and Purchase Order tables of SAP and run these data through the three workflows of Alteryx.
• Performed data cleansing using Alteryx and produced correct output according to the clients sample and send it to the data team manager for QA. After identifying any issues with the data, respective correction was performed and the final output was sent to the DLA by KPMG team lead for disaggregation and sent to client.
• Ran Alteryx workflow for UCO (Unfilled Customer Order) and UDO (Undelivered Customer Order) and upload to Sharedrive dashboard reports for DLA clients.

Confidential

Data Analyst

• This contract is to support the VA’s Office of Knowledge Based System in developing standards-based Clinical Decision Support (CDS) that enhances the ability of the VA and clinical staff to collect clinical data effectively at the point of care and able to use and re-use the data for improved care to the Veterans.
• Develop and execute a strategy for acquiring the necessary resources to conduct a professional internal environmental scan to develop and document (using MS Office) a deep understanding of VA CDS sharing and migration potential from technical, organizational and clinical perspectives.
• Review CDS sharing from the perspective of VHA and VISNs through surveys and interviews with VISN CHIs, Facility CHIs, and CACs. One goal is to understand VE Strategic Planning - CDS Sharing, Planning and Analysis VistA CDS tools, and configuration methodologies and resulting data.
• Use of Fileman queries or Fileman Query Language (FMQL) to extract CDS artifact definitions from VistA implementations approaches to scale up and automate or semi-automate the use of existing VistA CDS artifact export routines
• Methods to encourage VA staff to voluntarily share CDS artifacts from their local VistA implementations
• Methods to “reverse engineer” VistA CDS artifacts from stored data
• Supporting an Analysis of Alternatives
• Developing and providing a pilot demonstration of each recommended approach on test data sets
• Support the development of a migration approach for new CDS artifacts for national deployment.

Environment: VistA CPRS, MUMPS, KIDS, FileMan query, HL7, Smart on FHIR, cTakes, NLP, eXo, VA Pulse, VA VDL, VA Citrix Remote Access, SharePoint, Visio, MS Office, etc.

Confidential

Functional Analyst

• Developed trusted relationships with clients and managing their expectations
• Acted as liaison between business stakeholders, such as management, customers or end users, and the development or technical teams
• Consulted with management and users to determine business requirements and needs of the system
• Created business cases, process flow diagrams, conceptual models, and software specifications
• Gathered data from government executives and staff into structured formats and documents
• Analyzed and communicated any stakeholder needs by translating business requirements into system design/development specifications
• Assisted in implementation, coordination of tests and observation of the system to validate performance
• Created presentation and presented to groups of customers and peers
• Reviewed, analyzed and provided input on the requirement documents for VEMS (Veterans Enterprise Management Systems), Goal Management Systems, MaxPrac, Market Research and Risk Management Systems.
• Modified Visio diagram of the process models of the above applications.
• Analyzed and validated business rules and made necessary changes to those.
• Attended 3 to 4 meetings each day of the week with SMEs, Vendors (Microsoft, Sales Force, Service Now, MITRE, Valador, etc.) and Veterans Affairs SBA (Small Business Administration) team to collect valuable information on many applications.
• Attended weekly meeting with the IT Director, Deputy Director, Team Lead and internal VA team to discuss weekly progress, roadblocks and future task on VA SBA Procurement goals.
• Created meeting minutes from the weekly ITSI meeting and provided a copy to the VA upper management and internal team members.
• Uploaded copy of the meeting minutes to SharePoint calendar and VA network drive.
• Created matrix from 22 internal reports used by VA.
• Used Microsoft Power BI to track VA’s Small Business Vendors, Contractors from Geo-spatial maps.
• Worked on the Pilot program of VEMS with the many IT Companies.
• Downloaded procurement fund management data from SAM, FPDS, D&B and verified against Goal Management Systems.
• Closely worked with SharePoint developer to create software solutions for VA’s internal customers.
• Created Dashboards for Onboarding/Off boarding, Office Supplies, Time and Attendance and on-going Seminars.
• Created User Stories and Acceptance criteria using Microsoft Visual Studio 2015.
• Performed UAT and provided feedback to the Vendors and VA upper management on Goal Management Systems, MaxPrac and Market Research.
• Used many IT applications like VEMS, VIP/VCMS, FPDS, SAM, D&B, Goal Management System, Market Research, MaxPrac, Risk Management System, Microsoft Visual Studio 2015, SharePoint 2010, Visio 2010, etc.
• Learned and applied new technical subjects through self-directed learning and training classes

Environment: Windows, Microsoft Office, Microsoft Power BI, Microsoft Visual Studio, Visio, VEMS, VIP/VCMS, FPDS, SAM, D&B, Goal Management, MaxPrac, Predictive Analytics, Market Research, SharePoint, etc.

Confidential

Functional Analyst

• Provided systems engineering, technical management and technical advisory support directly to the Government Project Managers and Program Manager.
• Analyzed technical assessments of non-functional requirements in the areas of new IT initiatives and Non-functional Requirements related to operational requirements, such as performance, capacity, and availability.
• Conducted in-depth interviews of subject matter experts to obtain information needed to support system change request recommendations.
• Provided systems engineering or technical advisory support to VA project stakeholders Develop and revise system requirements, traceability matrices and/or architecture artifacts Review and support updates to vendor design, development, testing and technical documentation.
• Conducted research on various aspects of existing or proposed projects, and perform analysis of alternatives.
• Experienced working with customers, users and project leads in analyzing, designing, implementing and supporting a wide variety of IT business systems covering many diverse applications such as healthcare and financial systems.
• In-depth understanding of functional analysis processes and procedures at the enterprise level.
• Understood of technical assessments of non-functional requirements in the areas of new IT initiatives and Non-functional Requirements related to operational requirements, such as performance, capacity, and availability.
• Ability to conduct in-depth interviews of subject matter experts to obtain information need to support recommendations.
• Participated in project and portfolio reviews to maintain the project’s alignment with the business case.
• Provided independent, objective reviews of vendor design, development, testing and technical documentation.
• Provided triage and support services for the HPS (Health Product Support) in the areas of applications support, training, and issue resolution.
• Worked with the National Service Desk and Project Staff (infrastructure, database, and development personnel) to troubleshoot issues.
• Completed multiple simultaneous projects in a timely manner.
• Supported for Clinical Information Support System (CISS), Bed Management System (BMS), and Occupational Health Record-Keeping System.
• Used Remedy System to track and document applications issues.

Environment: IBM Rational Jazz (RTM, RQM, RRC), Windows, Microsoft Office, LTS, DevCloud (Java/JDK, Mavin, Oracle, Microsoft SQL Server, etc.)

VetsAmerica Business Consulting, Inc., (VA/VBMS), Arlington, VA

Data Modeler

• Strong Reading, Writing, and Client skills (able to communicate, identify, and extract Conceptual Data entities during SME sessions)
• Conducted user interviews and perform detailed data analysis to identify appropriate data sources, key facts, and dimensions that support the business requirements.
• Reviewed business and technical/application requirements; interpreting and developing them into Conceptual and logical data models design using dimensional modeling leading practices.
• Working knowledge of Physical Data Models.
• Developed source to target data mappings; documenting business and transformation requirements; performing source system data profiling; documenting findings.
• Experience in enterprise data modeling tools and data profiling.
• Experience in relational and dimensional data modeling, enterprise data management methodologies, and possess the ability to analyze large volumes of data for business rules definition and validation.
• In the capabilities to support the definition and analysis of data requirements for the supporting business processes and corresponding information systems.

Environment: Windows, Mercury Test Director 8.0, Test Complete, Oracle, Microsoft Visual Studio Team System 2010

Confidential

Tier 2 Production Support Specialist

• Worked with Business, Development, Quality Assurance, DBA and other support teams to resolve production issues.
• Supported application releases, infrastructure changes, data base modifications, data corrections and other ad-hoc production change requests.
• According to user’s requests Transferred, Claimed, Unclaimed cases in MIP Workbench and making sure the databases are in sync (MNGMT or Aqua Data and BPEAdmin or Business Process Choreographer Explorer).
• Terminated, Deleted, Restarted tasks as user’s request for Amendment, Revision and Study cases according to the Workflow diagram. Used XMB to manage content, i.e. delete link of CM content.
• Verified whether user exists in JXplorer. If user does not exist, then create user in LDAP (Lightweight Directory Access Protocol) and modify information in JXplorer.
• Created and updated users of MIP with Role, Tasks, Groups and Subscriptions, using Tivoli Directory Server Web Administration Tool. Performed folder administration (Copy, delete, move etc.) using Citrix.
• Verified cases for Review DFIRM DB QA Submission in MIP and try to validate the submission. If the case stuck in upload or in progress, then clear requestids and transfer the case back to the user to run and pass the validation.
• Performed 508 testing for the MIP release 4.2 on Amendment Project, Revision Project and Study Project workflow.
• Reset user MIP account using JXplorer. Updated SOP with the new process.

Environment: Windows, Unix (Sun Solaris), Citrix, SQL Server 2008, AIX, Jump Server, Management Server, LDAP, DB2, JXplorer, IBM Tivoli, MIP, WebSphere, Rational Clear Quest, ROID Tool, Enterprise Wizard Systems, Excel

Confidential

TOPS Functional Analyst

• Researched, resolved and updated functional and technical issues with TOPS (Transportation Operation Personal Property System) and CWA (Central Web Application) shipments going to 112 sites worldwide for DOD service members. Supported SDDC’s Family First program.
• Conducted additional research for logistic related data issues/ problems, such as inbound, outbound, NTS, OTO and DPM shipments. Worked with TOPS Helpdesk Team to resolve production issues of DOD member’s shipment.
• Conducted follow-up on previously opened service requests and contact user to provide update on the issues resolved. Produced and develop various ad-hoc and canned reports as required using SQL.
• Worked as a SDDC/SRC staff (TOPS Technical/Functional) and take TOPS helpdesk calls, which come from Inbound, Outbound PPSO (Personal Property Shipping Office), TSP (Transportation Service Provider) and DOD service members.

Environment: Windows, TOPS, CWA, Seibel, ORACLE SQL, Adobe Acrobat, Excel, UNIX (Sun Solaris), TOAD

US Patent & Trademark Office, (DOC), Alexandria, VA

Patent Examiner (GS 9, Step 11)

• Performed examining work on multiple systems and sub-systems with various components.
• Administered, supervised, or performed professional, scientific, technological, and legal work involved in the examination and disposition of applications for patents, exclusive of design patents, to determine the grant or denial of patents based on such applications and in the adjudication of petitions and appeals from decisions on such applications. Reviewed and analyze relational database related applications.
• Utilization of the basic and advanced concepts of the natural sciences, the techniques of all branches of engineering and of the industrial arts, and the application of those aspects of procedural and substantive law generally, and of the statutory and case law applied to patents specifically, which are applicable to the patent examining process.

Communicated findings of the research to the practitioners/inventors.

Environment: MPEP, East, West, IEEE, ACM, Google patent

Confidential

IV&V Technical Tester

• Regression testing of TOPS (Transportation Operational Personal Property Systems) and CWA (Central Web Application). Performed duties of a System Administrator.
• Technical testing of new release of CWA 4.0 EDI (Electronic Data Interchange) re-engineering process.
• Analyzed CWA 4.0 EDI documents to fix various testing errors.
• Changed backup tapes in eight test servers and ran commands to check, if they are running properly.
• Used UNIX commands to Add, modify and delete users from the test boxes.
• Installed and trouble-shoot Sun Solaris 8 Version 2.02 and TOPS 9.6.1 in the test server.
• Installed and trouble-shoot TOPS Survival Kit in the IV&V test servers.
• Installed and configured TOAD (Oracle), CWA, Sun Solaris (Unix), Silk Meter, Windows XP, Microsoft Office, etc.
• Worked as a backup to the helpdesk to take calls from 160 TOPS sites worldwide to support installation of the Survival Kit.

Environment: Windows, CWA, Seibel, TOPS, ORACLE SQL, Adobe Acrobat, Excel, UNIX, TOAD, Silk Meter Suite

Confidential

CWA Analyst

• Researched, resolved and updated functional and technical issues with TOPS (Transportation Operation Personal Property System) and CWA (Central Web Application) shipments going to 112 sites worldwide for DOD service members. Supported SDDC’s Family First program.
• Conducted additional research for logistic related data issues/ problems, such as inbound, outbound, NTS, OTO and DPM shipments. Worked with TOPS Helpdesk Team to resolve production issues of DOD member’s shipment.
• Conducted follow-up on previously opened service requests and contact user to provide update on the issues resolved. Produced and develop various ad-hoc and canned reports as required using SQL.
• Worked as a SDDC/SRC staff (TOPS Technical/Functional) and take TOPS helpdesk calls, which come from Inbound, Outbound PPSO (Personal Property Shipping Office), TSP (Transportation Service Provider) and DOD service members.

Environment: Windows, TOPS, CWA, Seibel, ORACLE SQL, Adobe Acrobat, Excel, UNIX (Sun Solaris), TOAD

Confidential

Database Consultant

• Performed queries using Oracle/SQL to find information from different database tables of TEAM.
• Ran scripts to find the solution for the user's TEAM database related errors.
• Used Java Script, ASP, and VB Script for web development.

Confidential

AWRDS Analyst II

• Worked very closely with DOD customers to meet data quality goals, Adhoc reporting needs, data completeness in mission critical environment. Trained client and end users on AWRDS application.
• Set data standards (profile, analyze, match format etc.) to avoid reporting anomalies.
• Ran the day-to-day operations of the AWRDS database based on Army regulations.
• Analyzed and stratified materials for the Army pre-positioned units, using PL/SQL.
• Coordinated and implemented database and software upgrades for the Army installation.
• Wrote SQL queries for army personnel dealing with Army readiness.
• Used automated tools to generate TCMDs (Transport Control Movement Document) and export electronically to Military Transportation Movement Control (MTMC) before equipment movement.

Environment: Windows, UNIX, Oracle, Sybase, SQL, AWRDS, FedLog

SunTrust Bank, Arlington, VA

Business Analyst

• Analyzed and modeled the domain of business and created workflows and technical requirements.
• Defined and documented customer business functions and processes.
• Defined the problem of the business and identified/validated business requirements.
• Analyzed the feasibility of, and develops requirements for, new systems and enhancements to existing systems.
• Ensured the system design fits the needs of the users.
• Created functional requirements in use cases.
• Co-ordinated requirements walk-through, verified with user representative/stakeholders that use cases and process models accurately portray specific business needs.
• Participated in user acceptance testing and testing of new system functionality.
• Provided technical assistance in training, mentoring, and coaching professional and technical staff.
• Contributed to project plans.

Confidential

NOC Analyst

• Answered helpdesk calls for FAA network solution center.
• Documented calls in the helpdesk application.
• Assigned network team members to resolve customer issues.
• Closed helpdesk tickets, after issues had been successfully resolved.
• Cleared printer queues for customers print jobs in Novell network.
• Ran helpdesk reports for morning meetings and presented to management team and client.