TIMELINE
AREA OF EXPERTISE
PROFESSIONAL SKILLS
******@*****.***
https://www.linkedin.com/in/jancy-rosy-john-
I’m a result-oriented, self-motivated and dynamic individual with 5 years of Information Technology experience in the field of Busi- ness Intelligence.
Microstrategy Experience with experience in the development of pixel perfect dashboards, reports and documents for both Web and Mobile. Extensive knowledge in Microstrategy 9.x and 10.x product suite namely Microstrategy Desktop, Architect, Web, Report Services. Tableau Experience which includes Data blending, action filters, calculated sets, parameters, variables, graphs, charts, data source, publishing dashboard etc. Specialized in advanced widgets such as Map widget, Heat Map, advanced OLAP features for re- ports and documents. Hands on experience with Oracle, SQL Server and Netezza Databases solutions. Excellent analytical skill, Ability to interpret data to create information, Problem solving, report design, and excellent computer skill. Quick learner in understanding industry, business process, and related products. Excellent knowledge in Data warehousing concepts. Knowledge on MS Excel, MS Dubai UAE
JANCY ROCY JOHN
BUSINESS INTELLIGENCE DEVELOPER 5 years Exp
MICROSTRATEGY TABLEAU
ADVANCED WIDGETS SQL SERVER
ORACLE
BUSINESS INTELLIGENCE
2013
1991 Birth
2009 Higher Secondary School
B.E in computer Science Engg
2009
Programmer Analyst
Cognizant Technology Solutions
2017
2014
BI Consultant-MicroStrategy
Present ADXP Consultancy 2 +yrs
2017
3.01yrs
Data Analysis
Build Dynamic Reports & Documents
Excellent Problem Solving Skill
Analysis & Unit Testing
Microsoft Office Suite
PROFESSIONAL DASHBOARD
• Developed and delivered 80+ dashboards (incl reports) for web and mobile.
• Studied and understood the business of insurance, media and communicaton, tele- com and automobile industries
• Served as a single member for a project and direct interaction to client
• Extensive knowledge in Data warehousing concepts
• Developed schema objects, application and public objects.
• Conversion of excel safety net reports to MSTR 10.1 reports.
• Tableau experience which included development of 20 dashboards .
• Scheduling and subscription of dashboards and datasets
• Used level metrics,custom visualizations and complex fact extensions for various dash- boards
• Converting around 20 excel safety net reports which included complex excel macros to MicroStrategy dashboards
• Personalized the reports as per user requirements, which includes customizing and formatting
• Implemented email subscription for reports
• Performance Tuning.
• Creating test plans and Unit testing.
• Co-ordinated with the onsite team to assess UAT defects and distributed across the team
• Post production validation.
• Production Support
ACADEMICS
B.E in Computer Science Engg 78%
SCAD College of Engg & Tech, TN, India
Science Major Higher Secondary School 86%
Mar Dionysius School, Kerala, India
2+ Microstrategy BI Consultant. Since April 2017 – Present ADXP Consultancy, Dubai
• Worked as the MicroStrategy Consultant for the Road and Transport Au- thority (RTA) Dubai
• Developed and Delivered around 40 + dashboards and VI for both web and mobile, exclusive dashboards for Chairman.
• Involved in data model design, dashboard design, report development, dashboard inte- gration, unit testing and delivery.
• Analysis of data, studying requirements and verifying data model for reporting solution.
• Led offshore team to develop Project Management Dashboards
• Formatting of the dashboards to pin point precision and fixing of data issues and bugs in an effective manner.
• Configuring dashboards for both iPhone and iPad.
• Designing dashboard mock up using Powerpoint and GIMP softwares.
• Unit Testing and debugging of data related issues 3 + Programmer Analyst Jan 2014 –Jan 2017
Cognizant Technology Solutions
PERSONAL SKILLS
Communication & Creativity
Interpersonal & Presentation
Leadership & Team Work
Critical Thinking & Problem Solving
Effective Time Management & Commitment
SOFTWARE SKILLS
MicroStrategy Developer
MicroStrategy Architect
Microsoft Word
Microsoft Power Point
GIMP
MicroStrategy Mobile
Tableau
• GW Claims Reporting,Cognizant Technology Solutions Client : US Based Insurance Company
Technologies : Micro Strategy 9.4.1, Netezza
The scope of the project was to define the Target state architecture for GW Claims Reporting solution based on the findings of the deep dive analysis. The architecture is a combination of EDW (includes DataMart), Data Stage and Replication DB based on reporting needs. The scope includes development of 47 Claims reports (37 existing reports & 10 new reports) from new comprehensive data model for claims in align- ment with industry best practices.
Roles & Responsibilities:
Development of objects.
Involved in the implementation of the business requirements and logics
Unit test plan and unit testing
Analysis of existing GW Claims reporting requirements and architecture
Developed documents, drill downs, and visualizations to analyze the report data and anomalies
• Sales Ops and Distribution, Cognizant Technology Solutions Client : US Based Motor Company
Technologies : MicroStrategy 9.3, Oracle 10g
Objective was to develop Sales Distribution reports as well as Pace reports for Web and Mobile devices (Android and iPhone). The scope of the project was to implement Automation of Sales Distribution reports and Pace reports and Automated Email ap- plication for client. It included development of 2 Distribution reports, 2 Pace reports, and one Email report and development of portrait version of one mobile report on smart phones for Sales Ops and Distribution.
Roles & Responsibilities:
Requirement gathering, Functionality analysis and design.
Regular Client interaction and requirement analysis
Used MicroStrategy Web to offer interactive reporting to the end users through a web browser
Created Reports, Documents and Objects
Personalized the reports as per user requirements, which includes customizing and formatting
Implemented email subscription for reports
Performance Tuning.
Creating test plans and Unit testing.
Co-ordinated with the onsite team to assess UAT defects and distributed across the team
Post production validation.
Production Support
KEY PROJECTS
DOMAIN KNOWLEDGE
TRANSPORTATION MEDIA
INSURANCE AUTOMOBILE
LANGUAGES KNOWN
English
Hindi
Malayalam
Read Write Speak
CHARACTERISTICS
“Can Do” Attitude Enthusiastic
Creative Tech Savvy
Proactive Motivate Others Team Builder
Flexible
Leadership
Mr. Binod Krishna Purushothaman
Executive Manager- Talent Relation HR
Deloitte, Hyderabad, India
**************@********.***
Mr. Magdy Mamdouh
Project Manager
ADXP Consultancy
Dubai, UAE
PERSONAL WALL
DOB
Birth Place
Nationality
Marital Status
26.Aug .1991
Kerala, India
Indian
Married
LEISURE ACTIVITIES
PASSION & OTHER INTERESTS
READING BOOKS
POETRY
FASHION DESIGNING
RECOMMENDATIONS
• CommDesk Dashboard Project, Cognizant Technology Solutions Client : US Based Communications Company
Technologies : Tableau 9.2, SQL Server
The CommDesk Dashboard project is used to receive data from various business units and functional units on their handled calls, working hours and revenue details. The system used Tableau 9.2 to develop reporting solutions to showcase the client in which area the revenue became a loss. This dashboard mainly shows an alert to the clients based on thresholds. This dashboard uses doughnut chart, bar graphs, maps, line graph, bubble chart etc. On page drilling is used in these dashboards to give a user friendly visual insight
Roles & Responsibilities:
Business Analysis
User Requirement Document
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
Created action filters, parameters and calculated sets for preparing dash- boards and worksheets in Tableau.
Developed Tableau workbooks from multiple data sources using Data Blending.
Provided post production support for Tableau users.
Technical Lead from Customer Side for Tableau
• Smart Audit – Roads and Transportation Authority - Dubai Technologies Used: Microsoft SQL Server 2012 PDW, Microstrategy 9.5 Building Exceptions Reports and Dashboards for internal Audit of RTA, and Intelli- gence Alerts System that tracks use cases within different Systems across the organi- zation
Responsibilities:
Requirement Gathering
Business Consultant
Report Designs
MicroStrategy Reports Design, Development, Testing, Deployment and support
ETL Development
KEY PROJECTS
ACHIEVMENTS/CERTIFICATIONS
• Appreciation from RTA for successful delivery of a Chairman Dashboards within a time period
• Appreciation from the manager at Universal theme Park, Orlando for solely con- verting excel reports into MicroStrategy within the tiem period.
• MicroStrategy 9 Certified