Business Systems Analyst

• Assisting the Navy Personnel Research, Studies and Technology NPRST in the Production Management Office Business Process Re-engineering Effort. Provide program support to Navy Client in the existing Navy Enlisted Supply Chain NESC process.
• Support an assessment of existing NESC process as well as the related Tools to understand business rules, assumptions, and existing methodologies.
• Support assessment of the business information needs and develop Functional Requirements to meet the changing business needs.
• Collaborate with a cross section of Navy stakeholders to understand user requirements for flexibility and ability to adapt tool configuration locally as changes in priority or business need dictate.
• Analyze and update the Business Process Reengineering BPR and Functional Requirements Document FRD covering the NESC Street-to-Fleet process.
• Apply standards and templates in accordance with DOD, Navy and specific client direction.
• Participate in discussions with Navy stakeholders and defined the scope and objectives, determining, business rules, developing, and documenting user functional and cross-functional requirements.
• Analyze business and user needs, document requirements, and revise existing system logic difficulties, as necessary.
• Identifies, communicates, and coordinates with all affected stakeholders for various projects.
• Conducts and/or participates in the analysis of business processes and functional requirements and in the preparation of appropriate documentation to communicate and validate the information.
• Conducts stake holder analysis and information gathering techniques resulting in customized solutions.

Confidential

SQL Server Database Administrator / Developer

• Managed the SQL Database Administration, business analytics and reporting to meet corporate objectives.
• Supported the oversight of all individual Microsoft SQL Server instances locally at the corporate office and retail locations.
• Managed the database security by maintaining the policies and procedures ensuring the integrity of all databases and executed structure queries from different databases.
• Developed and designed database strategies, system monitoring and improving database performance and capacity issues.
• Provided performance tuning, query optimization, by utilizing Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Responsible for the configurations, administration, monitoring and maintenance of all databases in the organization.
• Responsible for providing operational and development database services, including tracking and resolving database related incidents and requests, responding to database related alerts and escalations.
• Responsible for troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, data connectivity issues, security issues etc.
• Created, monitored and maintained the backups, restores, recovery models, database shrink operations, and troubleshooting SSIS packages, T-SQL Code and design strategies stored procedures, functions, tables, views, triggers, indexes, and constraints .
• Experienced with creating in-house adhoc reports using SSRS per requirements to include the full life cycle for developing and enhancing of new project requests to meet the business needs.
• Gathered project requirements from internal customers to develop, design, build, test and deploy SSRS Reports.
• Produced documentation manuals with written documents, and created other documentation for all process and procedures, as required and requested.
• Created and modified new subscriptions for users on the SQL Server Reporting Services
• Added new SSRS reports on the SQL Mail server by setting up SQL permissions for the users.
• Provided on call support 24x7 for SQL databases, space on servers and break fix jobs.

ACCOMPLISHMENTS: I created a SSRS report to accommodate a backup-reporting project that would enable us to look at the status of all the backups of any SQL server in the company in a single report. I had to create a multi-server query SSRS backup report by using the Central Management Server CMS . First, by establishing the CMS environment and registering all the SQL server instances. Then I generated two reports into one - a parent report and a sub-report to accomplish this task

Sr. Business Systems Analyst / JAVA Developer / Configuration Manager

• Was responsible for supporting a new Navy Future Pay and Personnel System NFPPS . Assisting the Bureau of Naval Personnel BUPERS Business Transformation Office BBTO , which was established to conduct policy research and analysis of all Navy artifacts associated with current personnel and pay systems using data maintained in various systems.
• Developed, documented, executed and implemented configuration management and change control program for the development team, Business Analyst BA teams and quality assurance QA team.
• Established and maintained consistency of a Navy's product's performance, functional and physical attributes and artifacts with its requirements, design and operational information throughout its lifecycle.
• Coordinated with internal and external end users to understand user requirements, analyzed user business problems and business needs
• Responsible for backup, monitoring and troubleshooting data sources to accommodate new data fields, data types and values.
• Assisted in the developing, loading data, processing data, artifact images and testing of a custom Functional Metadata Repository.
• Performed tests on Java code to ensure it can be delivered and run in a production environment.
• Reviewed new Java code, and migrated with Eclipse Java development tools JDT to ensure that correct versions of the source code base has been compiled correctly.
• Provided system support of all branches of the Directorate in reporting and analysis of Functional Metadata.
• Assisted Data Team Leads with compliance of all required government reporting deliverables and due dates
• Established and maintain policy for storage and version control of produced artifacts and documentation ensuring positive control of artifacts for all departments work processes.
• Experienced in developing and implementing a comprehensive Configuration Management solution programs, processes and managed data sources for artifact images.
• Utilized Serena Dimensions CM as our CM tool and operated as our data repository for signed Configuration Item CI documents and Quality Assurance QA approved business process artifacts storing them as electronic files.
• Involved in preparing, making presentations that include our findings and recommendations.
• Ensured that proper Configuration Management practices are followed and government interests are protected.
• Involved in the complete lifecycle of the data flow from diagnosing and managing the correction of data issues, Data Migration, QA and CM.
• Participated in updating FRD's
• Developed reports for Navy and DoD leadership to track overall progress of the Production Management Office's PMO initiative by analyzing and interpreting data and assisting in the developing of presentations, i.e., charts, graphs, etc. utilizing Crystal Reports to produce reporting deliverables.

ACCOMPLISHMENTS: I have assisted in the development and testing of a Java based custom Functional Metadata Repository ETL tool running on a MS SQL Server instance and MS Access database. This tool allows access for retrieval and reporting of data collected in the data warehouse. This gives the user the ability to load new data to perform ad hoc queries and to provide a powerful analytical and reporting data store to assess the business. I also trained users on the utility and assisted in the documentation of the process and procedures using standards and templates in accordance with DOD, Navy. I also involved in the Department of Defense Architecture Framework DoDAF The Enterprise Information Management EIM Drumbeat meetings with the Business Enterprise Architecture BEA office to establish the life cycle methods to scope projects, to collaborate across functional lines with business processes, business systems planners, business operating divisions, Data Analyst and DoD customers.

Confidential

Sr. Database Administrator / Business Systems Analyst / Deployment Manager