Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. Be sure to respond with the years of experience for each skill and the last time each skill was used.

Add or delete rows, as needed.

Employment History

Confidential

IT System/Data 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.
• Good Understanding of data centers, network communications, server utilization, virtual environments, storage
• Worked with end users to define requirements and provide technical advice and assistance in large scale environment
• Previous experience working with data models, data analytics and data mining, scripting, report building, etc
• Experience in managing the issues with technical teams in a production environment.
• Had good knowledge and application of relational database concepts
• Had good skills and experience in formulaic logic such as MS Excel if statements, vlookup
• Troubleshooting data issues and understands how data feeds impact the application pivot tables, macros, etc.
• Worked with development team to create design specification in business requirements
• Experienced in detailed analytical skills for financial modeling and analysis 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, HTML, SQL, MS Excel, Access, BI tools, etc.

Confidential

Sr. Business/Data 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 multiple levels of management and staff across the organization
• Had good knowledge of IT services and financial management processes and best practices such as budgeting, cost allocations
• Capable of motivating and managing organizations or teams to deliver desired results
• Worked with end users to define requirements and provide technical advice and assistance in large scale environment
• Previous experience working with data models, data analytics and data mining, scripting, report building, etc
• Experience in managing the issues with technical teams in a production environment.
• Good Understanding of data centers, network communications, server utilization, virtual environments, storage
• Had good knowledge and application of relational database concepts
• Had good skills and experience in formulaic logic such as MS Excel if statements, vlookup
• Troubleshooting data issues and understands how data feeds impact the application pivot tables, macros, etc.
• Worked with development team to create design specification in business requirements.
• Experienced in coordinating and supporting User Acceptance Testing UAT .
• Experienced in detailed analytical skills for financial modeling and analysis 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, HTML, SQL, MS Excel, Access, BI tools, etc.

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.
• Good Understanding of data centers, network communications, server utilization, virtual environments, storage
• 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
• Previous experience working with data models, data analytics and data mining, scripting, report building, etc
• Experience in managing the issues with technical teams in a production environment.
• Had good knowledge and application of relational database concepts
• Had good skills and experience in formulaic logic such as MS Excel if statements, vlookup
• Troubleshooting data issues and understands how data feeds impact the application pivot tables, macros, etc.
• Worked with development team to create design specification in business requirements
• Experienced in detailed analytical skills for financial modeling and analysis 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
• Worked with multiple levels of management and staff across the organization
• Had good knowledge of IT services and financial management processes and best practices such as budgeting, cost allocations
• Capable of motivating and managing organizations or teams to deliver desired results
• 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, MS Office, MS Visio, UML, IBM WebSphere DataStage 8.5, Oracle 10g database, TOAD 8.6, Cognos, HTML, SQL, MS Excel, Access, BI tools, etc

Confidential

Business Analyst Internship /Data Analyst

Responsibilities:

• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Organized Joint Application developments JAD , Joint Application Requirements sessions JAR , Interviews and Requirement Elicitation sessions.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Used Microsoft SharePoint to create sites to support specific Content Management, Records Management, and/or Business Intelligence Needs.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Experience creating UML diagrams-business model diagram, process flow, flow charts etc, i.e. Visio Diagrams
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Helped with Data Mapping between the data mart and the Source Systems.
• Previous experience working with data models, data analytics and data mining, scripting, report building, etc
• Experience in managing the issues with technical teams in a production environment.
• Had good knowledge and application of relational database concepts
• Had good skills and experience in formulaic logic such as MS Excel if statements, vlookup
• Troubleshooting data issues and understands how data feeds impact the application pivot tables, macros, etc.
• Good Understanding of data centers, network communications, server utilization, virtual environments, storage
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Worked with multiple levels of management and staff across the organization
• Had good knowledge of IT services and financial management processes and best practices such as budgeting, cost allocations
• Capable of motivating and managing organizations or teams to deliver desired results
• Experienced in detailed analytical skills for financial modeling and analysis planning, problem solving and decision making skills.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Developed automated Test Scripts in Win Runner using Test Script Language TSL for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Extensive knowledge of Microsoft EXCEL, Sharepoint, Visio and Project.

Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS Office suite, MS Visio 2003, GuideWire, Crystal reports, Mainframes, HTML, SQL, MS Excel, Access, BI tools, etc.