SUMMARY

• I have tremendous experience in analyzing complex business requirements, designing the semantic layer of data and identifying optimal business solutions to accelerate efficiency and revenue growth of the company.
• I have primarily worked on BI data warehousing and Reporting projects and expertise in MicroStrategy Architect, Developer, Command Manager, Integrity Manager, Object Manager and Distribution services.
• Have 9+ years with Tata Consultancy Services in BI Data warehousing and Reporting
• 7 years of experience in Banking Domain with BOA and Confidential which provides end - to-end technology and fulfilment solution to the key customer groups
• 2 years of experience in Life sciences with Confidential of New York.

TECHNICAL SKILLS

Primary Skills: MicroStrategy 10.x/9.x, Oracle 11g - SQL and PL/SQL,, MS SQL Server, Netezza

Secondary Skills: Tableau, Business Objects, Qliksense

PROFESSIONAL EXPERIENCE

Confidential

Computer Programmer

Responsibilities

• Project Management
• Requirements gathering and Business Analysis
• Design & Development
• Implementation
• Testing and documentation
• System Administration
• Played the role of Architect and Developer in designing the WorkForce Reporting application in Confidential
• Have collaboratively worked with Business Users in negotiating requirements as well as for User Acceptance.
• Have delivered the end user reports using Agile methodology and leading the scrum call and tracking the daily status update
• Have provided End User training of the application and involved in several demo.
• Designed the semantic layer of reporting by creating aggregated Views/ logical Views
• Developed Schema Objects and identifying the key relationship of dimensions and facts
• Created advanced metrics, filters and prompts using Apply Simple and Apply Comparison functions
• Developed of Intelligent Cubes and designing Report, Dashboards, Dossiers using Cube Blending
• Used Object Manager to create code packages to deploy in higer environments QA,UAT and PROD
• Have involved in ACL security set up of folder and Objects
• Worked on automation scheduling of reports to users using Distribution Services
• Worked on Project Configuration settings and VLDB Settings
• Used Command Manager and Enterprise Manager to get Project Statistics and configuration
• Have worked on Validation dashboard and Excels using SQls against database for Data Validations

Confidential, NJ

Computer Programmer

Responsibilities

• Requirement gathering and System Analysis
• Design & Development
• Implementation
• Testing and documentation
• Communicated with the business for collecting the requirements and documenting the same
• Interacted with UI specialists on Dashboard designs and come up with design prototypes.
• Developed MicroStrategy objects such Public, schema and configuration objects
• Developed MicroStrategy Reports and dashboards.
• Performed Unit testing and data validation of reports

Confidential

Computer Programmer

Responsibilities

• Requirement gathering and System Analysis
• Design & Development
• Implementation
• Testing and documentation
• Collaboratively worked with the business for collecting the requirements and documenting the same
• Designed the Schema as per the meta data mapping
• Developed MicroStrategy objects such Public, schema and configuration objects
• Developed MicroStrategy Reports and dashboards prototypes.
• Performed Unit testing and data validation of reports
• Have worked on different POCs for drill down functionality, hierarchy prompts, row level security
• Presented Demo to Business Users

Confidential, Charlotte

Computer Programmer

Responsibilities

• Requirement gathering and System Analysis
• Project Management
• Requirement Analysis
• Design & Development
• Implementation
• Testing and documentation
• System Administration
• Communicated with the business users for collecting the requirements and documenting the same
• Prepared the analysis document, design & Delivery documents.
• Designed Schema and mapping for the Microstrategy
• Developed MicroStrategy Public, Schema and configuration objects
• Developed MicroStrategy Reports and dashboards.
• Designed Intelligent Cubes
• Performing Unit testing and data validation of reports
• Developed reports with update functionality using Distribution Services
• Customized the dashboards in the iOS environment
• Deployed and distributed the app in Enterprise App Store
• Have worked on System Manager to automate several functionalities of Cube Refresh
• Have worked on security filters to implement row level security of data

Confidential, Charlotte

Computer Programmer

Responsibilities

• Requirement gathering and System Analysis
• Design & Development
• Implementation
• Testing and documentation
• Interacted with the Business for collecting the requirements and documenting the same
• Prepared the analysis document, design & Delivery documents.
• Designed Schema and mapping for the Microstrategy
• Developed MicroStrategy Public, schema and configuration objects
• Developed MicroStrategy Reports and dashboards.
• Performed Unit testing and data validation of reports
• Customized the dashboards in the iOS environment
• Involved in deploying and distribution the app in Enterprise App Store

Confidential, New York

Computer Programmer

Responsibilities

• Requirement gathering and System Analysis
• Design & Development
• Implementation
• Testing and documentation
• Prepared the analysis document, design & Delivery documents.
• Implemented the ETL mappings and sourcing data to the data mart tables
• Performed review and unit testing of data
• Prepared the analysis document, design & Delivery documents.
• Designed Schema and mapping for the Microstrategy
• Developed MicroStrategy Public, schema and configuration objects
• Developed MicroStrategy Reports and dashboards.
• Performed Unit testing and data validation of reports