SUMMARY:

• Business/System Analyst, experienced in IT project methodologies and use of frameworks, including Agile & Waterfall along with proficient in Analyzing business needs, interpreting business user requirements and translating them into reports, with good knowledge of SDLC process.
• Expertise in business needs analysis and capturing functional and technical requirements to accomplish the project objectives efficiently and effectively.
• Possess extensive knowledge in all phases of Software development activities i.e. planning, requirements, design, implementation, testing, deployment and maintenance.
• Experienced in system application configuration, administration, user account creation, and troubleshooting as well as technical support and training to business users.

TECHNICAL SKILLS:

Methodology: Agile, Water - Fall

BI Tools: Cognos, SSRS,BO, Tableau,OBIEE, Business Object

Operating Systems: Windows NT/2000/XP, MS-DOS, LINUX

Database Technologies: DB2, Oracle 9i, Oracle 10G, SQL Server 2000/2005/2008, MS-Access, ODBC/JDBC, T-SQL, ODS, Oracle SQL and PL/SQL

DB Development Tools: SQL Navigator, ETL, Erwin, TOAD, Decision Stream

Testing Tool: Quality Center/ALM, QTP

Languages: PL/SQL, C, C++. HTML, Java, PHP, XML

Other Software Product: Compass Point, HP ALM, DOORS, iCART, BMC Remedy, ServiceNow, Rally, JIRA,GEMS, XML, PEGA, SCRUM, Kanban Boarbs, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C.

Business/System Analyst

Responsibilities:

• Worked with internal customers for leading the functional requirements gathering team to understand the business environment and needs.
• Lead projects in Confidential from its inception to its completion. The projects included enhancements to COTS product that not only provided Traders with increased functionality but also led to operational efficiency.
• Assisting in determining test strategy and defining the Test plan, Test case and Test data creation for functional testing.
• Participated in daily SCRUM/KANBAN meetings, and inform software developers on release testing success.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram, ER diagrams & Data Mapping.
• Developed and executed SQL Queries to verify the database updates, inserts and delete of the records, to extract data from target tables and validate reports.
• Constantly verified Requirement Traceability Matrix (RTM) to determine if each and every Functional requirement is taken care of and a test script is developed and executed for the same.
• Extensive experience in using HP ALM (Test Planning, Test Lab and Defect Tracking)
• Directly involved in Functional Testing, Regression Testing, Smoke Testing, Security Testing, End-to-End Testing and coordinating UAT Test efforts.
• Test execution for Functional, Regression and Integration Testing and documentation of test results.
• Identified relevant design, process and specification issue, validated inbound/outbound XML messages
• Experienced in building and executing manual test cases for Systems (Regression), UAT and Unit Testing.
• Used MS Visio to create process flowchart and workflow diagrams.
• Facilitate with technical and analytical support to corporate finance users as need in timely manner.
• Identified project interdependencies and communicate requirement/scope issues and participate in driving them to resolution for inclusion in the functional specifications
• Regular meeting with finance controller to analyze best and effective way for reporting services.
• Fully involved in UAT in QA environment, smoke testing and writing SQL to fetch backend data.
• Worked on change management process for PROD deployment & raised incident tickets.

System Analyst

Responsibilities:

• Interacted with corporate finance users to understand financial reporting requirements and transform them into business and functional requirements.
• Performed a GAP analysis which involved understanding the reports in the old financial management system
• Provided application and production support to corporate system departments.
• Developed and maintains a thorough knowledge of system capabilities and functionality, including knowledge of the underlying data model.
• Facilitated Joint Application Design (JAD) sessions with Financial Analyst and Subject Matter Experts (SME) to identify business rules and requirements and document them in a format that can be reviewed and understood by both business and technical people.
• Worked with business users to understand and define needs above and beyond requirements provided by the business and converted business requirements into functional specifications.
• Facilitate with technical and analytical support to corporate finance users as need in timely manner.
• Involved in UAT session by using TFS (team foundation sever), create test script, logged the bugs.
• Implement SDLC (System Development Life Cycle) methodologies Agile.
• Identified project interdependencies and communicate requirement/scope issues and participate in driving them to resolution for inclusion in the functional specifications
• Regular meeting with finance controller to analyze best and effective way for reporting services.
• Fully involved in UAT in QA environment, smoke testing and writing SQL to fetch backend data.
• Experienced with testing planning and execution, data mapping and migration, preparation of user interface wireframes and page mockups desirable.
• Develop test plans testing documentation, drive User Acceptance Testing and work with the business users to validate sign-off criteria.
• Extract, analyze, identify, and solve complex issues with data available in reporting environments in support of business decision-making reporting efforts.
• Reporting to PM/ISO on project cross-functional updates and progress.
• Worked on change management process for PROD deployment & raised incident tickets.

System/business analyst

Responsibilities:

• Work with business users to identify and prioritize their business requirements
• Preparing project documentation including technical & function specifications, requirements gathering, use-cases and test cases.
• Analyzing the specifications provided by the clients and creates specification documents for reports as per client requirements, Interact with business users assisting with requirements and developed various reports using Report & Analysis Studio.
• Developed advanced dashboards in business insight for commercial sales department which includes Activity, Alignment, Sales and Prescriber data.
• Prepared project requirements and identified new data elements to be mapped into a new system design.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graphical BPMN representation and Map reports.
• Strong experience in using tools like Service Now, Quality Center, PVCS Tracker, PVCS version manager and iCART.
• Monitor and troubleshoot data feeds and systems health using tools, procedures and documentation provided by Information Services.
• Demonstrated expert level knowledge in all systems, processes and data relating to the assigned business or project.
• Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
• Involved in Gap Analysis and assisted the development team to understand the To-Be process.
• Leveraged technical knowledge & business acumen to manage effective working relationships with technology teams and business partners at management and end user levels.
• Identified multiple data sources, generating mapping documents and writing business required documents (BRD).
• Expertise in creating Dashboard reports and using Java Script in Report studio
• Fully involved in UAT in QA environment, smoke testing and writing PL/SQL to fetch backend data to verify Cognos reports.
• Reporting to PM/ISO on project cross-functional updates and progress.
• Worked on change management process for PROD deployment & raised incident tickets.
• Experienced in Change Management.

BA/BI system Analyst

Responsibilities:

• Closely Involved in Requirement gathering and Analysis for developing OLAP analysis, Dashboards, Complex Reports, Data mapping using Reports Studio and Query Studio, Business models and Packages using Framework manager and cubes using transformer for end users.
• Participated in analysis of financial statement reports (Monthly/Quarterly/Yearly) supported them and maintains existing reports in Cognos8 BI environment.
• Identifying project objectives, key issues, approaches, performance metrics, resource requirements, timeliness and results.
• Coordinate the creation of new, and audit existing systems support components to ensure data availability for effective reporting and analysis.
• Implement SDLC (System Development Life Cycle) methodologies like waterfall.
• Developed SQL query to validate various data elements against DB2.