Skills

Please use this table to list the skills noted in the Required/Desired section of the 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

Business Analyst

Responsibilities:

• Responsible to conduct field visits to perform investigations on allegations of child abuse or neglect
• Handled interviews of family members and other child care professionals to assess child safety
• Perform assessment of the risk of future abuse or neglect of children in the household.
• Coordinate with staff, family members and service providers to evaluate safety interventions to reduce risks for children
• To enter and maintain accurate records of all case information in computerized systems.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Assist families to navigate government agencies and access entitlement benefits.
• Responsible to file petitions and testify legal proceedings.
• Perform investigations of home conditions to protect children from harmful environmental areas.

Environment: Child welfare, MS Share Point, QTP, SFDC, SDLC, Team Track, Unix/Linux, SNAP, MS Visio, MS Office Word, Excel, powerpoint .

Confidential

Business Analyst

Responsibilities:

• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Gathered business requirements from end users keeping in mind their need for the application, and documenting it for the developers.
• Coordinate with staff, family members and service providers to evaluate safety interventions to reduce risks for children.
• Understanding data marts, maintaining records, issues surrounding data warehousing and important business principles.
• Worked on 3 layers of functions like staging, integration, and access.
• Involved in ETL tools Informatica power center, OALP tool business objects.
• Created work flow diagrams to depict the interaction between the various actors and the system.
• Acted as a liason between the technical staff and the users staff and management . Also was responbile for communications between Project Team and other related departments.
• Coordinate, mentoring of various tools and process flow of the application.
• Analyze and design Use Case diagrams, Class diagrams, sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations.

Environment: RUP, Java, JSP, Oracle, MS Share Point, QTP, SFDC, SDLC, Team Track, Unix/Linux, SNAP, MS Visio, MS Office Word, Excel, powerpoint .

Confidential

Business Analyst

Responsibilities:

• Identify, research, Realize, investigate, analyze, define and document business processes and Use Case Scenarios.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Assist with user testing of systems UAT , developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Execute SQL queries to test the back-end application database and Informatica Reporting database.
• Involved in Comparison of mappings, designing the data mart for specific usages.
• continuously track and produce analyzed Informatica ETL reports on the macro and micro activities affecting products
• Captured Business Process Flows and Reengineered Process to achieve maximum outputs.
• Responsible for identifying and documenting business rules and creating detailed Use Case.
• Conduct User Acceptance Testing.
• Extensively work on Access, Excel, Word, PowerPoint, SQL, and MS Project.

Environment: RUP, Java, JSP, Oracle, XML, EDI, QTP, SFDC, Team Track, HIPAA, MS Share Point, SNAP, Unix/Linux, AGILE, MS Visio, MS Office Word, Excel, and POWERPOINT .

Confidential

Business Analyst

Responsibilities:

• Involved in all phases of Project Life Cycle.
• Analyzed the Business and System Requirements of the application.
• Interacted with user groups to derive the functional requirements.
• Performed System Analysis and Design using UML.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Developed operational / business results reporting and implemented FTP for data warehousing needs. Prepared sample plans and participated in Unit Testing major releases.
• Responsible for the project management activities of a Java based consumer web application including web games, call center application, data warehousing, customer relationship management, account data management, and finance .
• Involved in documentation during various phases of development life cycle.
• Developed Use case, Functional, Object diagrams using Rational Rose.
• Developed the Test plans for quality assurance based on functional requirements.
• Performed database testing using SQL.
• Interacting with the development and testing teams to improve overall quality of the software.
• Followed Rational Unified Change Management Process.

Environment: RUP, MS Office, EDI, HIPPA, Rational Requisite Pro, SFDC, QTP, MS Visio, Unix/Linux, SNAP, JAVA, SQL, MS project Word, Excel, powerpoint , Win Runner.

Confidential

Business Analyst

Responsibilities:

• Conducted data warehouse requirement-gathering sessions with users from different business areas including asset management and marketing.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Identified dimension and fact data elements, designed and developed the logical data model of the data warehouse/mart.
• Developed supportive source to target data mapping and data transformation rules.
• Participated in the quality assurance and testing of data load and report data accuracy.
• Developed functional specification documents.
• Assisted in developing use cases, test scenarios and implemented test plan.
• Participated in UAT test and user training.
• Assisted in project documentation.

Environment: EDI, Waterfall, UML, MS Visio Professional, SFDC, QTP, MS-Office Word, Excel, powerpoint , SDLC, ASP.NET.

Confidential

Business Analyst

Responsibilities:

• Involved in analyzing the application's requirements and development of test cases.
• Developed test scenarios and test procedures based on the test requirements.
• Participated in Preparing Test Plans.
• Identified the test requirements based on application business requirements and blueprints.
• Performed manual testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance, Performance, and Black Box.
• Involved in doing System testing of the entire applications.
• Performed Database testing.
• Wrote SQL queries and stored procedures to validate data.
• Documented errors and implemented their resolutions.
• Created test scripts, executed test scripts.
• Participated in user training and Submitted status reports weekly.

Environment: Visual Basic, SQL Server, MS-Word, Ms-Excel, DB2, Windows98/NT, Mainframe, MVS, JCL and Cobol.