BI Architect
Agilisium
2021 – Current
Project 1
Client : UMG
Project Type : Media Environment
Tools : MicroStrategy, Google Big Query
Team Size : 10
Role : BI Architect
Period : From March 2021
Roles and Responsibilities:
- Led (team of 6) Project team to develop scope, conduct project development and implementation activities for Dashboards (BI reports)
- Played architect role in driving solution for building MicroStrategy BI dashboards for Digital and physical sales across various regions (US, Europe).
- Completely involved in building Datawarehouse from Flat files to ETL (Cleansing, aggregating, loading) , then to Semantic layer(MSTR)
- Maintained 5 MicroStrategy admin servers from different versions, Informatica (Daily transaction sales monitoring)
- Digital sales data flow model was built using Microsoft azure and SAML authentication were using for user login.
- Designed and developed Power BI dashboard solutions using various features including calculated fields, parameters, table calculations, row level security, data blending, dashboard actions etc.
Technologies : MicroStrategy, Google Big Query
Project Lead
Infocepts Technologies Ltd
2017 – 2021
Project 2
Client : Dr Reddy
Tools : MicroStrategy, Oracle, Redshift
Team Size : 6
Role : Project Lead
Period : June 2017 – Feb 2021
Roles and Responsibilities:
- Supervise a team of 5 (developer, Tester) for Report development and delivery.
- SQL Optimization, Report optimization through cubes
- Provided various Dashboard solutions for Sprint application (Russian users) and Astra application (India users)
- Developed custom mobile based reporting app which helps in users sales monitoring for various drugs
- Upgraded MSTR 10.11 to MSTR 2020, configured I server, Enterprise manager, Platform analytics, Collaboration server, MSTR Library, Tomcat SSL configuration
Technologies : MicroStrategy, Oracle, Redshift
Architect
Infocepts Technologies Ltd
2020 – 2020
Project 3
Client : Changi Airport
Tools : MicroStrategy, Tableau
Team Size : 4
Role : Project Lead
Period : Mar 2020 – Aug 2020
Roles and Responsibilities:
- Gathered business requirements from multiple stakeholders and converted them into detail technical specifications for developing the data visualizations using for good decision-making purposes
- Worked as a liaison between client and ETL and Tableau development team
- Created parameters, quick filters, complex if else calculated fields, LOD functions to create Tableau reports / dashboards
- Effectively used data blending feature in Tableau to combine the data from different sources into a single report. Developed various dashboards, using context filters, sets, pivots, parameters, and groups while dealing with huge volume of data. Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes
- Designed and developed Tableau dashboard solutions using various features including calculated fields, parameters, table calculations, row level security, data blending, dashboard actions etc.
Technologies : MicroStrategy, Tableau
Architect
Infocepts Technologies Ltd
2018 – 2020
Project 4
Client : SCB
Tools : MicroStrategy, Oracle
Team Size : 10
Role : Project Lead
Period : June 2018 – Feb 2020
Roles and Responsibilities:
- Using MicroStrategy Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc.
- Worked on creating complex calculations which are key for many of the requirements which will help business in taking the right decisions
- Extraction of large data sets, Data Manipulation, Data Analysis, Data quality and validation
- Developed and maintained business intelligence models to design, develop and generate both standard and ad-hoc reports using MicroStrategy.
- Web based dashboards covering end users of around 100.
- Created individual layouts and incorporated it into Dashboards with the appropriate filters.
- Scheduled frequency and time to refresh data for the data sources are published or extracted to server
- Created Mockup Dashboards using sample data sets and suggested different Data visualization
Technologies : MicroStrategy, Oracle
Architect
Infocepts Technologies Ltd
2017 – 2018
Project 5
Client : SCB
Tools : MicroStrategy, Hive
Team Size : 5
Role : Project Lead
Period : July 2017 – May 2018
Roles and Responsibilities:
- Played an architect role in designing the layouts of the dashboards.
- All the deliverables are in MicroStrategy office PPT.
- Gathered Business requirements interacting with Businesspeople in Various product domains.
- Have delivered 30 dashboards as part of MSTR office for 220 users.
Technologies : MicroStrategy, Hive
BI Onsite Architect
Cognizant
2016 – 2017
Project 6
Client : C R Bard
Tools : Tableau
Team Size : 5
Role : Project Lead
Period : Jan 2016- July 2017
Roles and Responsibilities:
- Leading the team of 6 in knowledge Transfer from Client IT Team to Cognizant and received go sign without any escalations.
- Defining daily, weekly, and monthly schedules for newly added jobs and involved in scheduling through control M.
- Responsible for designing and developing Tableau worksheets, dashboards, data extracts, scheduling, performance tuning and stories in Tableau Desktop and Tableau Server.
- Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
- Pulled data from multiple data sources like Oracle, flat files and Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output for the Tableau Report
- Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
- Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
Technologies : Tableau
BI Architect
Cognizant
2014 – 2016
Project 7
Client : Astrazeneca
Team Size : 10
Role : Project Lead
Period : Jan 2014- Jan 2016
Roles and Responsibilities:
- Have worked as a team lead in Simon application handling team of 9 at reporting end.
- Have ensured all deliverables like Simon, Simon exec, User management, Maps, Executive maps, HQ, EM reports were delivered to the end users before SLA.
- Have obtained proper documents for any production deployment like Business requirement, Test cases, testing, RM document, blanket approval, Sign off from Business.
- Created ETL Parallel jobs to extract and reformat the source data so that it can be loaded into the new data warehouse schema.
- Created Public Objects like Grid Report, Report Service Documents, Graph, Dashboard, Prompts, and cubes, Filters, Compound Metrics and Smart Metrics.
- Created Schema Objects like Attributes, Facts and Logical Tables based on requirement.
- Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
Senior Developer
Cognizant
2013 – 2014
Project 8
Client : Bayer Pharmaceuticals
Tools : MicroStrategy
Team Size : 10
Role : Senior Developer
Period : May 2013- Jan 2014
Roles and Responsibilities:
- Have Developed Neurology, Radiology, Oncology and WHC dashboards.
- ADS validation against Semantic layer validation (Query output from MSTR where views are used).
- Played a vital role in Cube refresh activity for Neurology, Hematology, Radiology, Xofigo, oncology, WHC dashboards in Field force reporting.
- Have been responsible for preparing IPAD usage report from the Enterprise Manager.
Technologies : MicroStrategy
Developer
L & T Info Tech Ltd
2011 – 2013
Project 9
Client : Citi Bank
Tools : MicroStrategy
Team Size : 10
Role : Developer
Period : Oct 2011- May 2013
Roles and Responsibilities:
- Created Public Objects like Grid Report, Dashboard, Prompts, and Filters.
- Created Schedules and Events. Worked on Narrowcast Server
Technologies : MicroStrategy
Developer
L & T Info Tech Ltd
2010 – 2011
Project 10
Client : Citi Bank
Tools : MicroStrategy
Team Size : 10
Role : Developer
Period : Feb 2010- Sep 2011
Roles and Responsibilities:
- Created Public Objects like Grid Report, Report Service Documents, Graph, Dashboard, Prompts, and cubes, Filters, Compound Metrics and Smart Metrics.
- Created Schema Objects like Attributes, Facts and Logical Tables based on requirement
- Worked on creating new or modifying existing MicroStrategy application objects like reports, metrics, prompts, and filters for simple and complex reports
Technologies : MicroStrategy
.png)
