Senior Business Systems Analyst Resume Profile
NY
OBJECTIVE
T obtain a Sr. Business Systems Analyst or related position where I can draw upon my 19 years of professional experience t build innovative, user-friendly software solutions for process management, performance optimization and continue t develop my technical knowledge and skills in a fast-paced, collegial, and highly interactive working environment.
TECHNICAL EXPERTISE
Twenty years experience in data management with emphasis on software development and ensuring data quality across all phases of the Software Development Life Cycle i.e., requirement gathering, analysis, design, development, testing, and implementation .
Areas of expertise include:
- Leading planning and implementation of variety of projects involved data management/analysis, and rolling out new software.
- Facilitating the definition of project scope, goals and deliverables.
- Defining project tasks and resource requirements.
- Develop full scale project plan timeline, design sessions, build reviews, test scenarios for unit testing, user acceptance test UAT , develop cut over document, etc.
- Coordinating project staff and vendors.
- Planning and scheduling project timeline.
- Tracking project deliverables using traceability matrix.
- Organizing weekly status meetings with stakeholders and team members and writing weekly status reports.
- Writing reports for project steering committee.
- Implement and manage project changes.
- Develop data migration / cleanup plan.
- Map data from legacy systems t new software, define meta data.
- Providing training/user support and writing software documentation.
- Interviewing stakeholders/clients t gather requirements, writing use case scenarios, developing test scripts for unit testing and UAT, and communicating requirements t developers.
- Designing and modeling databases using RDBMs like MS Access/SQL Server t develop user-friendly databases that incorporate graphic interfaces t automate workflow and enhance production while maintaining data security and integrity.
- Customizing complex reports with related sub-reports, charts, and graphics displays .
- analyzing and converting data from spreadsheets and legacy files t database systems.
- Experience defining and establishing software development processes, enforcing company policies and procedures, and managing cross-functional teams.
- Experience in SQL, T-SQL, DTS, SSIS, SSRS, and Stored-Procedures Database Triggers in SQL Server 2000/2005/2008
KNOWLEDGE AND SKILLS
| .Net Technologies Programming | Visual Basic, ADO.NET, Visual Basic for Applications, C , ASP.Net. |
| Databases Tools, and Technologies | MS Access 2.0/95/97/2000/2002/2003/2007/2010 SQL Server 2000/2005/2008 ADO, DAO, ODBC,UML, FrontPage, Windows XP/NT, Visi, Adobe Acrobat, Adobe Illustrator, Omni Page Pr, MS Office, MS Project, ARCHIBUS, TRIRIGA, and geologic software applications e.g., Peloton's Wellview, and Production Analyst . |
PROFESSIONAL EXPERIENCE
Confidential
Senior Business Systems Analyst / Data Project Manager
Responsibilities include:
- interfacing with business users to prepare and update Business Process Requirements BPR , Software System Requirements SSR , User Requirements Specification URS , and functional requirements
- managing IWMS software Tririga roll out project that involved managing several teams developers, consultants, business , coordinating with the software vendor, putting together project plan and budget, documenting project requirements, writing documentations, test scripts, and training documentations.
- developing use cases, workflow, screen mock-ups, and conversion requirements
- developing strategy for data clean up and migration from legacy systems to the new system
- conducting unit testing and UAT
- Writing SQL queries in MS Access and MS SQL Server for data manipulations
- providing support for Tririga application after go live
Confidential
Senior Business Systems Analyst / Data Project Manager
Responsibilities include:
- analyzing the business needs of clients and stakeholders to help identify business problems and propose solutions
- serving as a liaison between business units and vendors/developers
- formulating and designing systems scope and objectives related to data integration, reporting, and management
- developing new tools and technologies to coordinate processes and to secure data integrity
- providing technical support and developing software documentation/training
Confidential
Founded a data management consulting company specialized in building custom back-end applications and relational databases t help bridge the data management gap between corporate workgroups and departments, while optimizing employee efficiency and performance.
Clients
- Oil Sector: British Gas, ConocoPhillips, ExxonMobil, Mitchell Energy, Ocean Energy, Seagull, Shell Oil
- Medical Sector: Burzynski Clinic, Burzynski Research Institute, The University of Texas M. D. Anderson Cancer Center Department of Behavioral Science
- Client Services/Financial Sector: IKON, International Cellulose, Spantran Translation Services, Sterling Bank
Responsibilities
- Developed and executed data management plans for data integration and cleanup based on individual client needs. This process involves:
- assessing existing data
- legacy data clean up
- data quality control
- data capture
- designing databases with import/export features t SQL server /Oracle 7.3 databases.
- creating data analysis reports, graphs, and charts
- developing software documentation
- providing employee training and support
- Built customized databases t handle different types of data including: clinical trials data, psychosocial questionnaire data, research participant and client tracking data, patient medical record and billing information, financial data, educational data, upstream oil exploration and production data, and engineering drilling, completion, well history data.
Management
Managed and coordinated diverse teams comprised of administrative staff, programmers, reservoir engineers, geologists, and lab technicians.
Training Classes
- Production Analyst OGCI
- WellView Peloton
- ASP.Net with C
- Requirements Management
- Business Analyst
