Arjun Vasantham
Address: *** **** **** ****,
Contact:
Warwick, RI-USA-02886
Email: ******@*******.***
[pic]BUSINESS ANALYST-BI
[pic]
EXPERTISE PROFILE
Data Analysis Technically inclined BA professional with 4+ years of experience
Project Management in Project Management, Business Analysis, Requirements
BRD / FRD / SOP Gathering, Customized Developments, Data Warehousing and Data
SDLC/ Agile Modeling across Retail, Banking, Insurance & Manufacturing
Product Development industries.
OLTP/OLAP System Currently working as Business Analyst-IT at Met Life Insurance
Study Inc on BI projects.
BI-Cognos/Spotfire Efficient in Project Management Life Cycle involving analysis,
Reporting / SQL design, development, deployment, debugging, support, testing,
Writing documentation, implementation, user training and maintenance of
Data Warehousing application software, Defect management.
Requirement Analysis Instrumental in enhancing the UI of products and implementing
dashboard, analytic and strong understanding on agile
Software Evaluation methodologies- SCRUM & SDLC (Waterfall.)
Deft in developing Techno-Commercial proposals, supporting ramp
MS office tools ups & establishing product lines with experience in gap analysis
Process flow & data analysis.
diagrams Managing & operating in different environments & serving as key
Project Transitions point of contact for senior management & product owners.
System Analysis & Proven Expertise in building complex BI User end reports (List,
Design Cross-tab reports) and & Relational, Dimensional and
Test cases/ gap Multidimensional modelling using database techniques.
analysis Highly adept at multi-tasking on several projects, resolving
Team Management conflicts, mentor team members and possess excellent decision
making ability.
Enriched with the latest trends and techniques and a wide range
of skill in Project Management, Quality Initiatives, Technology,
Critical Thinking, Troubleshooting.
Extensive experience in providing strategic inputs and IT vision
for implementing new technologies.
[pic]
PROFESSIONAL EXPERIENCE
[pic]
Met Life Insurance Inc since Aug
2012
BI Analyst/Lead
Product implementation: Software development project: - Analysis, testing
plan, Discovery project.
Environment: requirement gathering, documentation - BRD, SQL, AQT tool,
databases-DB2, OLAP, Analysis & design, Data mining, Project Management,
Dev, UAT, Prod.
Developed test cases & project documentation for QA team to ensure
precision and references.
Assigned as a lead to track minor projects for the Auto & Home Insurance
department.
Designed and developed BI reports & data analysis, using multiple data
sources for analysis, supporting Incremental upgrades for the multi-
dimensional cube builds on a regular basis
Instrumental in gathering and defining business requirements to improve
business processes and translate the requirements into systems solution.
Proficient in identifying system issues and possible solutions by
researching and applying test cases.
Efficient in identifying and prioritizing tasks and implement relevant
solutions on multiple projects.
Design flow charts and prototyping for mock up models to satisfy users to
obtain sign-offs.
Co-act with development teams to lead them to the project goal and identify
task distribution.
Deft in using deployment services and change management tools- BMC remedy
tools.
Hands on experience with Brio, AQT- specifically used for data querying,
Data validation.
Trained to establish "Problem Management Record" (PMR)/ Service request for
problem resolution from IBM.
Managed a IT-development team, ensuring overall delivery and product
maintenance.
Provided technical & effective application solutions to complex business &
IT related issues.
Collaborated with clients to define engagement models along with project
development and resource estimates.
Established high coding standards & practices and exercising quality
control on all aspects of software development.
Ensuring client's issues are promptly addressed & documented; provide
resolution in a timely & professional manner and passing them to correct
channels- SDLC
Efficiently managing entire day-to-day activities covering wide functional
areas including designing & developing, debugging and troubleshooting.
Kohler Corporation, Sheboygan, WI Mar
2012 - Jul 2012
Business Analyst/BI/DW-Lead
Environment: Business reporting, BRD, Design & flow charts, MS Office
tools, PPI, SQL writing, Dev, UAT, Prod, relational/ multi-dimensional
databases, Agile, PPM.
Collaborated with project managers and functional team members on Multiple
development projects, ensuring the consistency within the project and to
keep high level of transparency.
Versed in writing Project data flows, Flow charts & test cases for
Manufacturing products like Generators, faucets.
Developed BRD templates and Created SOP's to preserve a common methodology
(Minor projects)
Proficiently provided estimates, identify potential problems and recommend
alternative solutions to users and IT teams.
Successfully developed BI reports with requirements gathered by documenting
and liaising between IT teams & stakeholders.
Skilful in identifying & evaluating commonalties and enhancements as
required and recommend solutions subsequently.
Assigned to lead minor projects using PPM tools and update it to ensure the
progress of each project and apprise Managers.
Arbitrating with teams to build ad-hoc reports using BI tools/ pivot tables
& establish test cases within QA.
Organize & schedule team meeting for requirements, feedback from users for
pr cised results and implement it stage by stage obtaining sign-offs from
product owners & Managers.
Adeptly modelled data from relational databases for data analysis by
writing SQL queries to retrieve data.
Strong in analysing and design of project documentation using process flow
& what-if scenarios (Use cases)
Coordinating with resources (OSC on minor projects) and providing thorough
documentation of all developed/maintained applications and processes and
manage the documentation to retain it when required.
Collaborated with the team members and senior management to maintain a
continuous stream of information regarding the project status and progress.
Instrumental in documenting the process flow & establishing
systems/procedures.
Lloyd's TSB Bank, Newport-Wales, UK Mar 2009 -
Jan 2012
Business Analyst- Retail Banking
Environment: Retail banking, Core banking analysis, Pre-sales, Project
management, Credit Risk and lending analysis, relational/ multi-dimensional
databases, data mining, analysis and design, demand management.
Complete understanding on retail banking products (Mortgages, Credit Cards,
and Accounts & Insurance.)
Active research on credit risk analysis & fraud data analysis team to
reduce fraud risk for lending office.
Expert knowledge making use of demand management and customer insight tools
as a predictive analysis task.
Attested business requirements from end-users and measuring business
processes, work-flows and systems to identify opportunities for improvement
for extensive requirements gathering and gap analyses.
Trained on BI tools for data analysis, visualization, slicing & dicing,
decision making, Predictive analysis.
Assembling requirements and documentation of project initiation PPI and
project estimation.
Amenable for translating high-level business and user requirements into
detailed functional & technical specifications.
Ensuring data precision, scope & accountability before testing the results
in production without affecting the flow.
Accountable for completing deliverables within defined timeliness,
including preparation/ maintenance of project plans, estimates and
schedules.
Actively involved in ensuring transparent flow of communication pertaining
to the program activities to the core team by conducting regular core team
meetings.
Strong hold, working as a leap support for the interns to train them on
Standard operating procedures.
Implemented Star Schema Grouping and Dimensional Hierarchy for quick
retrieval of data for analysis and user friendly.
Working knowledge of Product marketing by email, mail and internet
technology.
[pic]
EDUCATION
Masters in International Business Management, Middlesex University, London,
UK (Dec-2009)
Modules: Business Management, Cross Cultural Marketing,
Globalization & HRM, Structural Marketing, Quantitative Analysis.
Thesis: Empowerment of 'Corporate Culture' on Employees Performance-
IBM.
B E (Electronics & Telecommunication), Vishweswariah Technological
University, (VTU) Bangalore, INDIA (Mar-2008)
Electronics Circuits, Logic Design, Marketing Management, Signals &
Systems, Control Systems, C, C++.
[pic]