SUMMARY:

• TABLEAU 10 CERTIFIED DESKTOP ASSOCIATE having 2+ years of experience on both advanced visualization, administration with implementation experience on AWS.
• MICROSTRATEGY CERTIFIED ENGINEER With the experience of Adv. Visualization, ESRI Integration, Mobile Configuration, Transaction Services, I - Cubes, Distribution Services and Admin Tools along with User & Security implementation.
• TERADATA CERTIFIED DATABASE ADMINISTRATOR - upgraded to Version 14.0 & specialised on Performance tuning, having hands-on with Teradata Analyst toolset.
• 11.5 + years of Total IT Experience and 6+ years of experience in MicroStrategy and 4+ years of experience of Data & Dimensional modelling.
• Cloud based Bigdata implementation with AWS S3, Athena, Quick Sight, Glue, Data Pipeline, Redshift and DynamoDB.
• Cloud based Database & Storage implementation experience on AWS S3, EBS, EFS, DynamoDB & Redshift along with other AWS services like EC2, Load Balancer, VPC etc…
• MSTR hands on work experience on Seven versions ( MSTR 7.2.3 to MSTR 10.10 )
• Hands on with both SQL and NOSQL Databases like Redshift & DynamoDB.
• Hadoop/Hive BigData implementation experience in analysing PB’s of Smart-Meters data with advanced visualisation in MSTR for NV Energy utility company (POC).
• Developed 130 + complex data transformation mapping in Informatica along with mapping document and testing those mappings.
• Hands on experience with Logical / Physical Data (Relational & Dimensional) modelling using Erwin, starting from defining domains, Forward/Reverse engineering, complete compare.
• Meet with business users from different business division to gather business requirements & Dashboard expectations and translate those requirements into technical requirements which involve multiple different Databases.
• As a Reporting and Data Architect resource, I got an opportunity to work on “Evaluation of Cloud environment” for its Database and Bigdata solutions to evaluate how best we can use them for the current and future requirements of business. As part of which I worked on below use cases on AWS.
• As part of AWS cloud environment evaluation, I explored all major cloud services related to Networking, Storage and Database services and implemented various POC projects and came up with detailed documentation on how to implement those solutions on specific requirements, best practices and challenges.
• Estimated the compute capacity based on number of users and workloads.
• Created VPC, Subnet and Security group which defines access traffic requirements
• Created a Load balancer as a front end.
• Installed tableau server on primary and two worker nodes for failover.
• Connected to the Redshift database running in another private subnet.
• Created users, Roles, Policy to access AWS Glue
• Analysis and preparation of environment for both Source (CVS file) and Target (AWS S3)
• Defined a crawler to create a catalog of source file schema.
• Configure the job task and convert the source file of CVS into Parquet.
• Create an external table to access the data from S3 by accessing its metadata through Glue Catalog.
• Access the external table created in Athena using Quicksight and came up with Visualization.
• Launch the RDS instance in a VPC and configure and connect Aurora Database.
• Install the SQL tools and AWS schema conversion tool and test the connection with both source (SQL Server) and Target (AWS Aurora)
• Prepare an assessment report using AWS schema conversion tool and validate the assessment.
• Launch a Replication instance and create source and Target end points.
• Create a Migration task and monitor the migration progress.
• Create a NOSQL schema in DynamoDB based on the application logic of the source application.
• Load a sample data in the DynamoDB database and migrated the data intoS3 bucket using Data Pipeline
• Understood the schema/table structure using Glue catalog
• Understanding the source application which Kinesis enabled, which pass PUT RECORD
• Configure S3 bucket / create Redshift table, which is same as source stream structure.
• Create a Firehose delivery stream with Direct PUT option and set the target as S3/Redshift

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Microstrategy / Tableau

Sr. Software Developer

Responsibilities:

• Design, build & support the self-service BI/Analytics considering the evolution of BI Industry’s best practices.
• Building the dashboard for specific department with multiple sources.
• Research on new features in Microstrategy and provide and define/develop implementation strategy for newly released features.
• Lead BI design and development activities, identify risks and recommend risk mitigation plans.
• Manage and track action items, issues, and risks associated with a suite of applications. Follow up on items with appropriate parties to ensure their resolution and/or escalate issues in a timely fashion.
• Interact with business teams and other stakeholders to understand and recommend BI solutions to meet diverse, complex business needs.
• Testing of MSTR Reports after upgradation of MSTR 10.2 to MSTR 10.10

Confidential

Technology: Microstrategy / Tableau / ORACLE

Tech Lead/Architect

Responsibilities:

• Responsible for overall Microstrategy architecture design and standards of reports
• Participated in ETL and data model approach/design for the transformed reports and made sure the model fit into existing Enterprise Architecture.
• Understand complex business challenges & translate them into requirements/solutions.
• Designed Star schema and Snowflake schema and identifying FACT & Dimensions tables.
• Created complex schema objects for Hierarchical business structure and provided drilling up/down navigation using most impressive dashboards.
• Building cubes for huge dataset and performance tuning for the cube loads.
• Designed Interactive and visually stunning Dynamic Dashboards using visualisations like Graph Matrix, Gauges, Heat Map, Time Series, Interactive Bubble graph, Geo Maps etc.….
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.

Confidential

Technology: Microstrategy / Tableau / SYBASE

Tech Lead/Architect

Responsibilities:

• Responsible for overall Microstrategy architecture design and standards of reports
• Microstrategy Schema Design understanding, Requirement gathering, Design and Development of VI Dashboard/Report.
• Created schema objects such as attributes, facts and Logical Tables and public objects such as reports, metrics (simple and Compound), derived metrics, prompts, filters using Microstrategy
• Dashboard/Report, Cubes and Database Performance Tuning.
• Initiate a new proposal which serves the reporting needs of Top level management
• Designed Web Dashboards and Mobile Dashboards for IPad.
• Worked extensively on object manager, command manager, integrity manager and cube performance.
• Designed tables and implemented the naming conventions for Logical and Physical Data Models.

Confidential

Technology: Microstrategy / ESRI ARCGIS / ORACLE

Tech Lead/Architect

Responsibilities:

• Implemented BigData Visualization on Hadoop/HIVE on 1.5 million customer data.
• Performed Location Intelligence for Asset information for Gas/Electricity.
• Creating Transaction Service based reports for work order review and approval.
• Upgraded MSTR from 9.3.0 to 9.4.1 and testing after migration with Integrity Manager.
• Assisted in developing a Conceptual model based on business requirements.
• Developed Logical based on data requirements.
• Worked with the ETL developers and DBA's to come up with the best fit Physical model.
• Implemented Transaction Services for BI to store Managers comments for work orders.
• Assess Business Requirement documents and translate them into technical designs.
• Developing Report Service Documents as per the Client design requirement.
• Perform code reviews and tune new and existing reports for Performance.
• Participation in unit, system & integration testing.
• Promoting objects between environments (DEV, TST, PROD)
• Handling performance tuning for overall BI perspective.