Skills

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

IT System Analyst / ETL Lead

Responsibilities:

• Created Job Specification Document based on sample prototype.
• Worked closely with business to analyse, formulate and document Job Specification for the off shore team.
• Maintained constant contact with offshore team to provide guidance and clarification.
• Performed GAP analysis to identify complex technical and business issues.
• Performed cursory QA review of delivered work packages.
• Conducted joint Application Development JAD sessions to clarify business requirements.
• Worked with management team to identify and prioritize work packages for offshore execution.
• Extensive background on Business Process Re-engineering, Business Performance Improvement.
• Facilitated cross-functional problem solving sessions to arrive at optimal solutions accounting for stakeholder needs e.g. business requirements and delivery dates to ensure successful project delivery.
• Participated in ETL design and development efforts, performing code reviews, reporting project status and leading projects.
• Collaborated with other technology team members and internal customers to define customer requirements, assess available technologies and present solutions.
• Worked as an intermediate between the business requirements and the technical resources to ensure technical design, development and testing meet the needs of the business.
• Experienced in collaborating with supporting resources across business and functional lines.
• Performed interviewing non technical end users to determine and document current business process flows.
• Worked with user requirements to create clear and verifiable systems requirements.
• Worked with end users to define requirements and provide technical advice and assistance in large scale environment
• Worked with development team to create design specification in business requirements
• Experienced in Detailed, analytical, planning, problem solving and decision making skills
• Provided data mappings extract, transform and load analysis of the data marts and data feed systems in the aggregation efforts.
• Worked with BI team to apply the business rules for online analytical processing OLAP , and for designing the Frame Work models.
• Involved in the meeting with Business Process Owners, SME Subject Matter Experts and store users for Requirement gathering in Definition Stage.
• Worked with a BI Developer, Created Universes for report generation using Designer module in Business Objects.
• Manage Scope throughout the SDLC process of the product.
• Experience creating UML diagrams-business model diagram, process flow, flow charts etc, i.e. Visio Diagrams
• Experienced in coordinating and supporting User Acceptance Testing UAT .
• Mapped the old requirements with the new requirements and communicated it with the business groups for the gap analysis.
• Worked with the ETL architects and database developers to convert the functional specification to technical specification.
• Coordinated with different team members to resolve the issues that are related to the new application.
• Performed UAT based on Requirements Document and prepared the Test Cases using.
• Extensive knowledge of Microsoft EXCEL, Sharepoint, Visio and Project.

Environment: SAS Data Integration Studio 4.4, ER Studio, Windows 2007 server, Agile, Microsoft Office Suite, Microsoft Visio, Teradata.

Confidential

Sr. Business Analyst

Responsibilities:

• Gathered and documented Business Requirements.
• Involved in all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Extensive background on Business Process Re-engineering, Business Performance Improvement.
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity and sequence diagrams UML Diagrams .
• Involved in the meeting with Business Process Owners, SME Subject Matter Experts and store users for Requirement gathering in Definition Stage.
• Conducted joint Application Development JAD sessions to clarify business requirements.
• Collaborated with project team to ensure current state business process and future state business requirements are fully developed and documented.
• Responsible for writing Functional Requirement Specifications FRS and point of contact for System Requirement Specification SRS .
• Conducted FRS and SRS reviews and walkthroughs with designers, developers and stakeholders.
• Created Activity diagrams and Use case Diagrams UML Diagrams using Rational Rose.
• Worked with the technical architects and database developers to convert the functional specification to technical specification.
• Coordinated with different team members to resolve the issues that are related to the new application.
• Performed interviewing non technical end users to determine and document current business process flows.
• Experienced in collaborating with supporting resources across business and functional lines.
• Worked with user requirements to create clear and verifiable systems requirements.
• Worked with end users to define requirements and provide technical advice and assistance in large scale environment
• Worked with development team to create design specification in business requirements.
• Experienced in coordinating and supporting User Acceptance Testing UAT .
• Experienced in Detailed, analytical, planning, problem solving and decision making skills
• Involved in preparing Test Plans based on User Requirements Document URD and prepared the Test Cases using Test Director/Quality Center.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Resolved issues related to requirements during system testing and UAT plan preparation.
• Provided end user support for day-to-day use of the business intelligence reporting platform.
• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Involved with the Test planning, test development and test execution.
• Responsible for scheduling meetings with users, SME's and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Extensive knowledge of Microsoft EXCEL, Sharepoint, Visio and Project.

Environment: WebSphere DataStage 8.5, Saleseforce.com, Pega BlueLYNCS, BlueServe Connect, Web Portal BCBSRI.com , Oracle - 10g database, DB2 database, Windows 2007 server, Cognos, BluePrint, Agile, EDI, UML, Microsoft Office Suite, Microsoft Visio, SharePoint, Business Objects, Quality Center.

Confidential

Business/Data Analyst

Responsibilities:

• Performed Business Intelligence and ETL tool selection and implementation for enterprise initiatives.
• I was responsible for all project deliverables and the technical architecture supporting the Business Intelligence environments including all aspects of data warehouse construction.
• Conducted joint Application Development JAD sessions to clarify business requirements.
• Gathered the high level business needs from the directors and prepared the High-level Business Needs.
• Extensive background on Business Process Re-engineering, Business Performance Improvement.
• Involved in the meeting with Business Process Owners, SME Subject Matter Experts and store users for Requirement gathering in Definition Stage.
• Worked with data migration ETL development , document data manipulation processes and scripts
• Worked with end users and business analysts in understanding business requirements, defining business objects and managing development process for the project life cycle.
• Actively participated in the enrollment of a large group of provider community to have their ANSI X12 transactions
• Created workflow diagrams to better demonstrate the processes adopted in the EDI group and accounting groups of the company.
• Experienced in coordinating and supporting User Acceptance Testing UAT .
• Experienced in collaborating with supporting resources across business and functional lines.
• Performed interviewing non technical end users to determine and document current business process flows.
• Worked with user requirements to create clear and verifiable systems requirements.
• Worked with end users to define requirements and provide technical advice and assistance in large scale environment
• Worked with development team to create design specification in business requirements
• Experienced in Detailed, analytical, planning, problem solving and decision making skills.
• Wrote Test Script in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Mapped the old requirements with the new requirements and communicated it with the business groups for the gap analysis.
• Created Process Flow diagrams, Use case diagrams UML using MS-Visio
• Worked with the technical architects and database developers to convert the functional specification to technical specification.
• Coordinated with different team members to resolve the issues that are related to the new application.
• Prepared Test Strategy, Test Plan, test report and Gap Report
• Handled the requirement traceability and defect tracking thru Quality center
• Review requirements and create a test strategy to be implemented.
• Extensive knowledge of Microsoft EXCEL, Sharepoint, Visio and Project.

Environment: Agile, Crystal Reports, PL/SQL, HTML, MS Office, MS Visio, UML, IBM WebSphere DataStage 8.5, Oracle 10g database, TOAD 8.6, SQL Developer, Cognos