We provide IT Staff Augmentation Services!

Lead- Business Analyst Resume

PROFESSIONAL SUMMARY:

  • Information Technology professional with ten years of experience in software engineering and process improvement.
  • Business knowledge in healthcare, energy/utilities and financial (US government benefits, financial trading and US B2C media payment) domains.
  • Ability to collaborate with peers in both business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Software Development Life Cycle (SDLC) experience including requirements, specifications analysis/design and testing.
  • Experience in conducting Joint Application Development (JAD) sessions with end - users, subject matter experts, and project team.
  • Analysis and review of business and software requirement documents.
  • Expertise in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts & project risks.
  • Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
  • Gathering business and technical requirements that would best suit the needs of the technical architectural development process.
  • Strong experience in business and data analysis, data profiling, data migration, data integration and metadata management services using business tools like OBIEE, Tableau, SSIS/SSRS.
  • Good experience in data modeling with expertise in creating Star and Snow-Flake schemas, FACT and Dimensions tables, physical and logical data modeling using Erwin.
  • Experience in understanding stored procedures, functions, database triggers, and packages using PL/SQL and SQL.
  • Good data warehousing concepts including Meta Data and Data Marts.
  • Extensive experience in project management best practices, processes, & methodologies including Rational Unified Process (RUP) and SDLC
  • Excellent communicator focused on customer service.
  • Ability to understand current business processes and implement efficient business process.
  • Strong background in support documentation.
  • Team lead skills encompassing user interviews, coordination with tech lead, DBA's, developers, QA/QC analysts during the design phase.
  • Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.

TECHNICAL SKILLS:

Tools: /Utilities/IDE: MS Project, MS Office, MS Visio, TOAD, SQL Developer Tool, Tableau BI, Microsoft BI, IBM Rational, HP Quality Center, SOAP UI

Standards: CMMI, HL7, HIPAA, ICD9/10

Prog.: Languages PL/SQL, SQL, Visual Basic, COBOL, Java (J2EE), C++

Database: Mainframe, MS Access, MS SQL Server, Oracle EBS, OBIEE

Analytical Package: MS Excel, Tableau, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential

Lead- Business Analyst

Responsibilities:

  • Liaise with stakeholders to understand organizational structure, policies, and operations. In order to recommend solutions that enable organization to achieve its current goals
  • Assisting with the business case and create business requirement document (BRD), conduct cost/benefit analysis.
  • Implement strategies for gathering, reviewing and analyzing data requirements.
  • Perform requirement analysis to create functional requirement document (FRD), Software requirement document (SRS) and use cases
  • Analyze data for accuracy and validity with regards to organizational needs and provide solution.
  • Coordinate development of data architectures between development and reporting resources.
  • Prioritize requirements and create conceptual prototypes and mock-ups.
  • Translating and simplifying requirements to the project team.
  • Design and implement ODI Extract, Load and Transform (ETL) processes, programs and scripts
  • Analyze and define ETL loading strategy, Data archiving, Data reconciliation, Error Handling, standards and best practices.
  • Analyze data across multi-tiered databases and generate reports, tables, listings and graphs using SAS, Tableau, Qlikview and OBIEE.
  • Analyze database tables to determine the relationships and query application data using advanced SQL
  • Document data requirements and translate requirements into specifications for report developers.
  • Create business process models using flow charts and activity diagrams, perfor m relationa l dat a mappin g using entity relationship diagram s an d dat a modeling using Oracle , Toad, MS Visio & Drea m viewer
  • Creating Test plan and participate in integration testing, user acceptance testing (UAT) and Functionality Testing
  • Understand organizational future goals to analyze IT applications and its data to recommend solutions

Confidential

Business System Analyst

Responsibilities:

  • Assisting with the business case and create business requirement document (BRD)
  • Planning and monitoring business requirements.
  • Perform requirement analysis to create functional requirement document (FRD), Software requirement document (SRS) and use cases
  • Prioritize requirements and create conceptual prototypes and mock-ups
  • Support development team in technical documentation for process flow and development.
  • Monitor project progress by tracking activity; resolving problems; publishing progress reports; recommending actions
  • Expertise in analyzing and coordinating data, generating reports, tables, listings and graphs.
  • Use source data from various databases to analyze and develop datasets
  • Responsible for successful implementation of new functionalities for trade and equity modules like Collateral Management System, Equity Trade Locator
  • Understand and analyze the data and query application data schema using advanced SQL
  • Documents data requirements and perform data mapping and analysis
  • Creating Test plan and participate in integration testing, user acceptance testing (UAT) and Functionality Testing
  • As CMMI specialist responsible for meeting quality/process standards of development team. Have been appreciated and awarded by top management for assisting CMMI certification.

Confidential

Software Engineer

Responsibilities

  • Responsible for estimation, design, development, onsite testing and implementation of product modules; Developed new product functionalities like rule based reporting, internationalization, digital signature, mobile app interfacing using Java CAPS
  • Involved in client system migration with HL7 interface development, product feature client customization and fixes for production issues. As part of system migration, lead interactions with third party vendors (other system technical engineering staff)
  • Responsible to assess, evaluate, recommend and propose feasible technical solution on acquired products (PAML) for Outreach Advantage.
  • As technical specialist, responsible for product design reviews and conversion of analysts’ business requirements document into technical design document
  • As CMMI specialist responsible for meeting quality/process standards of development team. Have been appreciated and awarded by top management for assisting CMMI-Level III certification.
  • Assisted internal/client testing teams in creating functional/technical specifications for testing scenarios/test cases.
  • Proactively facilitate DBA/testing teams to improve software quality, test coverage, efficient and regression coverage by development of SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, fine tuning of SQL Queries using explain plan
  • Used Eclipse, logging files for troubleshooting and debugging Java applications
  • Exposure in running the java unit test cases of JUnit by configuring the JUnit testing environment

Confidential

IT Consultant

Responsibilities:

  • Created logical and physical database as per specifications, establish and maintain Security and Integrity controls.
  • Automated data loading into database tables from files using SQL*LOADER.
  • Taking the logical and physical backups, establish database recovery procedures.
  • Performed automatic monitoring of users, tablespaces, tables, indexes and Auditing of database.
  • Fixing of various performance issues identified by the end users and testing team.

Hire Now