Key accomplishment: In this senior technology leadership role, delivered high profile engagements at large enterprise customers involving architecture design of BI/DW/DB/SOA solutions, contributing to pre-sales efforts including RFP responses, thought-leadership for SQL/BI communities, mentoring and guidance to the internal consultants, etc.

As Senior Architect, I drove the creation of Enterprise Data Platform solutions from envisioning and architecture/design through technical development and implementation. Architected and delivered the DW and BI solutions involving complex OLAP databases/cubes, ETL pumps, scorecards, dashboards, and reports, as well as strategic CTO advisory assessments and roadmaps for Metagenics and First Solar.

Project 'BI GDPR' is to implement a solution for Data Warehousing and BI for the bank. The solution should:

Be separated from other OKQ8's DW / BI solutions.

Project 'Pi' successful implementation of Linear Analytical solution module to C level executives, Business Heads, and Media Analysts. The architecture of the data flow, data warehouse design, data model and data integration.

Offer reporting and analysis of the Bank's main processes.

Fulfill GDPR and bank compliance requirements regarding the confidentiality, security, and storage of personal data and bank data

• I worked with CIO and VP team on a key strategic opportunity for enabling the Enterprise Data Platform platform adoption that had challenging requirements based on their own SLA’s for their customers to support the advanced replenishment processes. Worked with the Strategic and Performance Engineering team product group in the entire sales process from initial CxO level presentations with follow up technical discussions. As an external consultant, developed and implemented BI/DW applications for Sales & Marketing and Financial Reporting
• Elicit and Lead - closely worked with the critical business functional teams in understanding the KPI’s, translated to technical specification. Along with senior developers, implemented the data warehouse design, ETL design, and data integration services.
• Lead change across large platforms / functional areas using cloud technology solutions and Provide deep SW / HW technical architecture expertise to ensure proper solution design
• Azure Solution Lead - Design, develop, Architect and Implement Python, Azure portal, PowerShell scripts, Azure CLI, Ansible YML, Playbook Automation DevOps includes PaaS Azure migration on-premise virtual machines SQL servers clusters, Data Migration Assistant (DMA) And perform failover for multiple servers with benefits of ROI.
• Manage and coordinate proof of concepts (POC’s). Develop POC plans with agreed use cases. Work with presales support teams to execute on the POC
• Took the lead in working with Solution Architects to define the complete customer solution, Developed customer-facing assessment reports documenting current state and future state recommendations
• Created solution vision and evangelize how the solution addresses technical, business outcomes, and Establishes the validity of a solution and its components
• Data Architect - The data warehouse solution architecture built on Big data and Azure SQL DWH platform for Media and Entertainment industry. After streamlining a bunch of flat files and trillions of data, bytes reduced 30,000+ person-hours of manual efforts. Around 10 minutes of data latency, the visual analytics platform layer provides critical data insight to C level executives & BU heads, and Media Analysts will perform deep-dive analysis of channel and program performance against the competitors.
• Tools and technologies: DevOps – CICD, Azure SQL DB, PowerShell, Azure SAS, Logic Apps, Azure Data Factory, SQL Data Warehouse, Azure blob storage, PolyBase, SSIS, SQL Server 2016 and Power BI.

Key accomplishment: Successful implementation of Commercial Property Insurance for Underwriters. Architected the data model to support the Business Intelligence and Visual Analytics reporting platform for Global Exposure Risk Management, global property causality reporting system

Key accomplishment include: Successful implementation of 8 modules off 18 modules for enterprise Data Warehouse and BI Reporting, enable BI Key Development process and Support process.

• BI Architect & Enhanced the OLTP database built on DB2 for Commercial Property Insurance for underwrites and enabled enterprise BI Reporting platform. Proposed and implemented end to end solution for the Global Exposure Risk Management team, including system design. Involved in complete SDLC process. Recommended process enhancement which will enable improvements to system performance.
• Assessed mission–critical Global Exposure Risk management system and proposed in-house team skill metrics requirement. Recommended the system design and flow.
• Trained 20+ consultants on MicroStrategy technology and non-technology staff in change management and business process improvement.
• Recommendation - as Data and BI expert with the recommendation and Best practices in setting up BI Platform.

• Data Architect, developed self-service Business Intelligence application, worked on cutting edge technology of columnar and in memory databases. in the deployment of a custom built ETL strategy in supporting the implementation of an Enterprise Data Warehousing initiative that collected, cleansed, and integrated the company’s data (i.e., Global operations, inventory, allocation, owner/customer, etc.) from a newly developed North America transactional business systems. Worked closely with other team members and business users in understanding the business requirements and the source operational systems. Performed detail data analysis of both data elements requested by the business and transactional source systems.
• Design Elicitation, requirements gathering, signoff, involved in system sizing, understanding the existing standards, design, development, co-ordinate and managing deliverables. Created and managed the data model, developed the physical model, written SQL scripts for creation of tables and views.
• BI Architect and Led 13+ member team in major system design and implementation project for Retail Global Operations team, planning team, and Americas Sales team.
• MicroStrategy Project Configuration Process: Worked closely with the client IT team in setting up the governance and enabling the migration process, closely worked with the IT team in setting up the governance and enabling the migration process. Also, aligned with MicroStrategy administrator in setting up the project, project configuration, and user management. Worked closely with the business analyst, project managers, and project lead in gathering the requirements, created POC, and converted technical specifications.
• Quality Governance: Very often closely work with project manager in managing the project schedule and deliverables, achieving the milestones, estimation, attending the project review meeting, worked closely with QA catalyst for certifying on CMMI 5.
• Delivered by working on the schema section such as attribute, facts, transformations, hierarchies, also involved in developing report service document, report design, prompts, filters Consolidation, Custom Group, etc.… against the enterprise data warehouse environment. Extensively worked in enabling the analyst to work in Ad-hoc and Standard Reporting Environments.
• Implemented a reliable problem and incident management process through a 1st, 2nd and 3rd line support team at offshore and managed escalation procedures.
• Communicated detailed product knowledge to support consulting engagements.
• Collaborated with customers, partners, and internal constituencies to ensure successful implementation of solutions; mentored and assisted associate services staff.
• Tools and technologies: EXASOL, SAP BW, SAP HANA and MicroStrategy 9.4.1; DB2 8, Netezza 7.2, SQL Server 2014 and MicroStrategy 10.2.

Responsible for building the 2 projects: PHS and MMA, and Enhanced 2 projects: GRCR, CSI, and BSD.

Responsibilities:

• Worked on onsite and the offshore model was responsible for the coordination and managing 3 offshore resources.
• Worked directly with the business users along with project managers in gathering the requirements, creating the POC, and converting to technical specifications.
• Design, implementation, and delivery of BI architecture changes, reports, narrowcast services, using dynamic dashboards solutions developed Flash Dashboards in 9.0.2 using Widgets and Selectors for summary level reporting.
• As MicroStrategy administration was responsible for BI projects administration or application lifecycle management such as managing user base, creating and migrating the project, supporting business users with their data issues and BI platform related issues
• Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data. Managed projects through the entire Systems Development Life Cycle, including creating timely/through status reports and leading status meetings.
• The client had appreciated for leadership and quality of work delivered as a result was awarded
• Tools and technologies: MicroStrategy 9.3 and Oracle

Role: MicroStrategy Architect, Report Developer, Administrator

Responsibilities:

1. Organized meetings with business analysts, power users, and key business end-users to determine business requirements, level of granularity and create project definition and scope and analyzed the needs of the end-users.
2. Conducted business user training for all levels of users in all aspects of a MicroStrategy Web provided the detailed plan, expertise, identifying and communicating the best practices.
3. MicroStrategy platform administration, BI projects administration, application lifecycle management, supporting business users with their data issues and BI platform related issues
4. Design and development of narrowcast services, proactively delivering business date through static emails, dynamic emails, and flat files (PDF & Excel).
5. Worked directly with Business users on impacts of timely delivery and quality of the data (creating and updating balancing reports between multiple systems).
6. Completely managed the upgrade process of MicroStrategy and Narrowcast Servers from 8.1.2 to 9.0.0 hotfix 2.
7. Managed and mentored fellow team members MicroStrategy developers.
8. Worked with back end Database Administrators to provide requirements for necessary back end tables.
1. Involved in various back end ETL development tasks and Production Support activities.

worked on ETL scripts in Teradata

Implement a solution for Data Warehousing and BI for the bank. The solution should:Be separated from other OKQ8s DW / BI solution.Offer reporting and analysis of the Banks main processes.Fulfill GDPR and bank compliance requirements regarding the confidentiality, security and storage of personal data and bank data

Successful implementation of Linear Analytical solution module to C level executives, Business Heads, and Media Analysts. Architecture the data flow, data warehouse design, data model and data integration.