SUMMARY:

• Gathering requirements to provide fit gap analysis and create effective technical solutions for the business needs
• Conducting Strategic planning to identify the organization’s business need.
• Business model analysis to define the organization’s policies and market approaches.
• Analyzing system requirements and determining system functional specifications.
• Understanding of business processes and process design to standardize the organization’s workflows.
• QA techniques, i.e. testing data and backend databases; Waterfall and Scrum, Agile Methodologies
• Test script, Test case, System, Functional, Integration, Manual Testing, Regression testing and UAT
• Requirement gathering, Data Collation and analysis.
• Tackles complex business/systems problems and conveys this information to stakeholders.
• Formulates and define scope (requirements) and objectives based on user needs and thorough
• Working with stakeholders on process improvement projects designed to improve results.
• Experience supporting business process reengineering efforts.
• Identifies process, technology and organizational role change necessary to support business goals and objective.
• Evaluate/researches business process and their relationship to technology.
• Organizes and present ideas in a convincing and compelling manner.
• Business requirements - project plan, business plan, Key Performance Indicator.
• Functional requirement - use case scenarios, work flow instruction, technical specification and data models
• Non- Functional requirements
• AS-IS & To-Be Processes
• Business case
• Data Modelling
• Stakeholder analysis
• Ability to dialogue and negotiate with all levels of stakeholders.
• Evaluation and interpretation of business rules & requirements for technical system.
• Business Architecture - Defines the business strategy, governance, organization and key business processes.
• Data Architecture - Describes the structure of an organization’s logical and physical data assets and data management resources. (data mining, data warehousing, data modeling, data analysis and reporting)
• Application Architecture - Provides a blueprint for the individual applications to be deployed, their interactions, and their relationships to core business processes of the organization.
• Technology Architecture - Describes the logical software and hardware capabilities required to support development of businesses, data/application services including IT infrastructure, Middleware, networks, communications and processing standards.
• Development/SQA within the Software Development Life Cycle(SDLC), V-Module, Waterfall and Agile methodologies along with Project Development Life Cycles. UAT Testing and Regression Testing.
• Good knowledge of Project Management, Risk Management, knowledge management and project deliverables.

TECHNICAL SKILLS:

Programming: Java, C#, XML, VBA, PHP,PL-SQL/SQL

Scripting: MYSQL,T-SQL, Linux, UNIX, SAS Pro SQL, MS SQL

Server: SSRS,SPSS,RIO

System and Associated Interface Tools: Windows Operation System, Installation and Administration (MS-DOS, ’95,’98,NT 4vis.0, 2000, 2003, XP, Window 7,8 and 10), Oracle 9i/10g

Crystal Reports: Tableau, ETL, MS Office Suite (Excel, Word &PowerPoint ) & tool ( VISIO and SharePoint), Scorecard & Dashboard, Wireframe, Data Mapping.

PROFESSIONAL EXPERIENCE:

Management Consultant- Business Support Analyst

Confidential, Towsom, MD

Responsibilities:

• Help the organization to solve issues/problem around improving performance and efficiency
• Gathering and analyse information and provide recommendations to address and resolve root problem
• Conducting elicitation activity with stakeholders
• Conduct gap analysis, complex data analysis (T-SQL) and reporting.
• Creating values/ solution and maximise growth in the business by finding new & better ways of doing things.
• Evaluations of documents and verification & validating of requirements
• Working on scope by improving some part of business functions
• Plan requirement management process
• Conduct /Managing business requirements, stakeholder requirements and solution requirements.
• Manage business analysis performance
• Writing of functional and non- functional requirements
• Evaluate solution performance

Confidential

Data Warehouse / Information Analyst

Responsibilities:

• Hospital Contract Monitoring; PBR (Payment By Result), SUS (secondary User Services) and HRG4
• Monthly Cost analysis and account reconciliation with commissioners and account / financial team.
• Running of ETL Process, data mapping and Responsible for enhancing, supporting and maintaining application within Organization.
• Use Microsoft suite to perform analysis, removing duplicate data,Pivot table & Chats and VLookup.
• Monthly Stakeholder requirement on Inpatient and Outpatient challenges with commissioners. Weekly and monthly management Operational reports.
• Data warehousing: Movement of clinical data from Electronical Patient Record system (CENER) to PARC SQL Server System using ETL, creating Data Mart, Data Mapping, Restore and Back-Up clinical data.
• Activity counting by POD; Application of Tariffs; Billing for Commissioners, Implementing Contract Agreements, Base Lining, Bench Marking and Planning, Clinical Activity Reconciliation with Cost of Treatment, Freedom of Information FOI(Information governance) reports on behalf of organization.

Confidential

Divisional Information Analyst

Responsibilities:

• Writing SQL queries and Running day to day activities reports and ad-hoc request.
• Developing Performance Reports/Services Line Reports, Ad hoc and Statutory Reports for Department of Health.
• Regular meetings with Service Managers, Senior Managers and the Director in the directorate on improving weekly, monthly and quarter services line reports for IMRS.
• Analyzing and reporting services and business processes to meet the highest accreditation of standards.
• Weekly, Monthly and Quarterly activities/performance reports to IMRS service leads.
• Developing monthly 18 week Referral to treatment RTT report for Adult services.
• Developing ACERS dashboard.
• Improving Access to Psychological Therapies (IAPT) dataset.

Confidential

Business Information Analyst

Responsibilities:

• Coordinating production in areas of team work - analysis, datasets, technical specs and briefing.
• Appling specialist technical expertise to develop ways of handling, analyzing and presenting data.
• Using knowledge of data flows and sourcing data to advise on information usage while focusing on quality.
• Managing a variety of development and service work streams within the team including ensuring timely load and transformation of record level datasets, identification and resolution of data issues.
• Complex analytical work using aggregate and large patient level datasets.
• Managing a team of analyst, database and business specialists and additional team members.
• High level of autonomy for making decisions around outputs that affect a wide range of reports.
• Involvement in projects within Clinical Analysis area or across wider Information Centre.
• Freedom of Information FOI reports on behalf of organization.

Confidential

Senior Information Analyst

Responsibilities:

• Supporting Community Sexual Health Clinic, Adults and Children and Family Services of the Organization in areas Extraction, Manipulation, Analyzing clinical datasets and Developing Reports.
• Analyzing highly complex data from a variety of sources and presenting these in a user-friendly format.
• Developing Trust Performance Reports/Services Reports, Ad hoc Reports for Dept of Health.
• CDS/SUS submission, Monthly Activity Report (MAR), QAR, Ethnicity Report, Referrals, Clinical Outcomes, Waiting list Reports, designed Commission for Quality and Innovation Pathway report.
• Creating and Configuring Databases, Table Views, Stored Procedures using T-SQL.
• Use VBA and Macro in MS Excel to update spreadsheet.
• MS SQL Server 2005 Database Administrator (new users policies, backup, shrinking Log files).
• Supporting the Data Quality and the Information Management Teams in Technical areas of writing advanced T-SQL scripts, data quality issues and ad hoc reports.
• Visual Studio, SQL Server 2005 Reporting Services SSRS to design and deploy over 150 user reports.
• Working closely with Senior Management in developing strategy and gathering requirements for reports.
• Analyzing highly complex data from a variety of sources and presenting these in a user-friendly format.
• Ensuring that the business processes reports meet the highest accreditation of standards.
• Ensuring that deadlines for the reports specified in the Analyses and Reporting annual plan are consistently met.
• RIO Clinical System Download, Server Migration, Data Mapping and Script writing using T-SQL.

Confidential

Senior Information Analyst

Responsibilities:

• Providing statistical support for commissioning and support to the Information Team; Analyzing and compiling returns for submission, ensuring they are available for completion.
• Managing and developing a range of Microsoft Access Databases that store and report performance information using SQL queries and Microsoft Server Reporting Services.
• Use VBA and Macro in MS Excel to update spreadsheet.
• Extracting and manipulating data from other systems to complete the Department of Health central returns and internal outpatient activity reports.
• Production of timely, accurate, clear and insightful monthly performance reports for the Board and performance reports to support day to day management of services.
• Providing advice on data quality issues and data standards and definitions as defined in the data dictionary /DSCNs.
• Communicating complex or ambiguous notes to non-technical staff in a clear and precise manner.
• Estimating activities and checking accuracy against historical data.
• Involved in the development of PCT's info system and the feasibility studies of Data Warehouse.
• Ensuring accuracy of information by liaising with managers.
• Use VBA and Macro in MS Excel to update spreadsheet.
• Elicitation with different stakeholders.
• Visual Studio, SQL Server 2005 Reporting Services SSRS to design and deploy over 150 user reports.
• Highlighting data quality issues through analyses of information and working closely with Data Quality Officers and Information Service Manager to ensure that reports sent out are timely and accurate.
• Involved in maintaining and updating the department’s policies and procedures within the Information Team.

Confidential

System Test Lead

Responsibilities:

• Browser compatibility testing and advice on testing issues.
• Test data creation, define entry and exit criteria.
• Script writing, execution, performing tests on static and dynamic sites.
• Integration testing between various interfaces and performance regression testing.
• Production of test summary reports to keep project managers and test managers updated.
• Regression Testing and Functional testing.
• Electronic Document Management System: Software Test Lead- Ensuring regular communication with developers and project managers to resolve issues/queries/error/defect during test execution.
• Monitoring and tracking project progress using a project tracker and daily and weekly status report.
• Appropriate task delegation to team members and monitoring task completion progress.
• Information Architecture project: I designed an Information Blog or Portal called Software Test Analyst defects and bug using Web 2.0 architecture that covers most areas of Software Development Life Cycle.

Confidential

Senior Information Analyst

Responsibilities:

• Data extraction on NHS Strategic Tracing Service, Cost Activity for PCT, Data Quality Control, Data Validation. Advanced skill in Excel, Producing regular and ad-hoc information report for the Department Of Health, Experience in extracting Out-patient activities, Reports Development and Generation

Confidential

Information Analyst

Responsibilities:

• Experience in Electronic Patient Record (EPR), Info Database, CDS and PAS and data capture processes for data extraction under formal Services Control; Preparing Weekly and monthly Performance Reports
• Service Level Agreement, Secondary Users Services (SUS); Data Warehouse, Business Intelligent Services; Data Extraction, Manipulation and Analysis using SQL, MS-ACCESS; Produced regular and ad-hoc information report for Department Of Health
• Other PCT’s; Data Modeling and Data Analyst ; Extraction, Transformation and Loading (ETL);
• Designed and developed computerized Student Examination Information system (Visual FoxPro)