Business Systems/data Analyst Resume
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.