We provide IT Staff Augmentation Services!

Business Systems/data Analyst Resume

0/5 (Submit Your Rating)

SUMMARY

  • Nearly 5 years of Excellent IT Experience as Business Analyst and Data Analyst in development and testing of business and commercial applications.
  • Thorough understanding customer needs, converting those into business requirements (BRD) and functional requirement specifications (FRS).
  • Adept in identifying and converting business needs into functional and non - functional requirements.
  • Actively involved in business process re-engineering, process mapping, gap analysis and business refinement process.
  • Use MS Project to monitor and track tasks and resources. Use charts using VISIO and other means as part of teh specification.
  • Exemplary communication skills, with ability to interact efficiently with teh stakeholders, developers, testers and end users.
  • Experience in conducting JAD sessions, project meetings, reviews, walkthroughs, and stakeholder interviews.
  • Strong R Programming Skills for Data Analytics on large datasets using R Studio
  • In-depth knowledge of Project Management Methodologies, Process Improvement and Change Management
  • Strong ability to document, validate and transform business requirements at different stages of software development life cycle.
  • Worked in Iterative and Waterfall model as well as Agile methodology of software development.
  • Participated in daily/weekly scrum meeting.
  • Experience in developing web-based application using JavaScript, HTML5 and CSS.
  • Sound knowledge and experience in RDBMS concepts, SQL, PL/SQL and Stored Procedures on Oracle 11g database
  • Extensive knowledge of Java, JSP, JDBC and concepts like multithreading and exception handling techniques
  • Foundation knowledge of IT Auditing Concepts applied to IT Security in organizational environment
  • Ability to identify policy frameworks, legal and compliance implications
  • Ability to Identification of audit requirements for PCI DSS, COBIT 5.0, ISO 20001/2, ISO 27001/2
  • Ability to recognize patterns and best practices among teh auditing standards
  • Knowledge of auditing best practices and performance requirements from ISACA
  • Expert in using SSRS, Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports, Cross-Tabbed Reports.
  • Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data sources.
  • Strong R Programming Skills for Data Analytics on large data sets using R Studio.
  • Analyzed various datasets with R Programming, MS Excel’s Pivot table, Charts and delivered reports with beneficial insights
  • Experienced in administrating teh reports to assign permission to teh valid users for executing teh reports.
  • Possess excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills

TECHNICAL SKILLS

Languages: Java, R Language

Java Technologies: JSP, JDBC, JVM

Data Analytics and BI/BA Tools: QlikView, R Studio, SSRS Informatica ETL, Tableau, ERwin

Web Technology: HTML5, Java script, CSS

DBMS Package/Tools: Oracle 11g, SQL, PL/SQL, MS SQL Server 2005/2008/2008 R2/2012, SQL Server Integration Service 2005/2008/2012

Operating Systems: Windows 7, Windows XP, MAC OS, Linux

Methodologies/SDLC: Agile, Waterfall

Application Tools: Oracle 11g Client, R Studio, Microsoft Office Suite, Eclipse IDE, SQL Plus, Visual Basic 6, Microsoft Project, Tableau, SQL Server Analysis Services 2005/2008/2012 , MS Access, PL/SQL, Power Pivot, Microsoft Office SharePoint Server

PROFESSIONAL EXPERIENCE

Confidential

Business Systems/Data Analyst

Responsibilities:

  • Participated in weekly scrum meetings and followed Agile Methodology.
  • Performed database performance monitoring and implements efficiency improvements including capacity planning.
  • Led Scrum development teams in teh development and deployment of different B2B and B2C initiatives.
  • Assisted development staff with teh application design to facilitate TEMPeffective use of database languages, methodologies and established standards.
  • Conducted Joint Requirement Planning (JRP) and Joint Application Development (JAD) sessions with end-users, SMEs' and development team for project meetings, walkthroughs and customer interviews.
  • Created Requirement Traceability Matrix (RTM) to list all teh requirements and ensured all required documents like Use Cases, Test Cases are written and compiled.
  • Proficient in analyzing and creating Use Case diagrams, Sequence diagrams, Activity diagrams, Businessflow diagrams using MS Visio.
  • Created reports by current market analysis using QlikView and Google Analytics.
  • Created and integrated user defined functions and stored procedures for reporting purposes.
  • Generated reports that ca handle dynamic grouping and dynamic sorting.
  • Organised walk- throughs and Q&A sessions for teh Dev and Testing team.
  • Maintained Non- Functional Requirements.
  • Reviewed Test Scenarios and Test Cases.
  • Assisted testing team to develop Test Data.
  • Coordinated with business for facilitating User Acceptance Tests.
  • Enhanced requirements as per teh Change Requests (CRs) raised during UAT.
  • Involved in teh orientation and on boarding of new System Analysts into teh team and mentored System Analyst interns.

Confidential

Business/Data Analyst

Responsibilities:

  • Analyzed teh business requirement and functional specifications provided by teh data specialist.
  • Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within teh company.
  • Performed Gap Analysis, SWOT Analysis, Risk Analysis and Impact Analysis.
  • Proven excellence in analyzingbusinessprocesses, eliciting requirements, definingbusinessneeds and translating it to BRD, FRD, and Technical Requirement Documents.
  • Assisted with user Acceptance testing of systems (UAT), with developing and maintaining quality procedures, and with ensuring that appropriate documentation was in place.
  • Created teh Training manual for teh End Users.
  • Involved in making Test Plans, Test scenarios, expected results and testing execution.
  • Documented system enhancements and coordinated with project team by facilitating JAD sessions.
  • Involved in loading data from various data sources using MS Data Transformation Services (DTS).
  • Responsible for making sure reports are scheduled and delivered in a timely manner.
  • Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.

Confidential

BI Developer/Analyst

Responsibilities:

  • Created/Updated database objects like tables, views, stored procedures, function, and packages.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
  • Reviewed, developed and designed data models, in conjunction with teh application development team.
  • Translated requirements into physical database structures that integrate with existing or proposed database structures.
  • Worked with databases to optimize database performance and resource usage.
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
  • Involved in monitoring and tuning report performance by analyzing teh execution plan of teh report.
  • Monitored teh overall performance of teh database to recommend and initiate actions to improve/optimize Performance.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Confidential

Technology Analyst Intern

Responsibilities:

  • Work with teh business analyst to understand teh requirements clearly.
  • Work with development team, team lead and project manager to understand teh project and goal for teh project.
  • Verification of results and reporting defects/issues identified to teh development team.
  • Work closely with development team to understand workflow and implementation delivered for testing.
  • Provide input for defect triage meetings with higher management.
  • Monitoring and reporting data for system performance.

We'd love your feedback!