PROFESSIONAL SUMMARY:

• Over 21 years of experience in data warehouse industry, and over 17 years of professional experience in implementing Business Intelligence projects, expertise in Data warehousing and BI architecture, Data modeling and ETL architecture design for SQL Server / Netezza / AWS Redshift, BI reporting and dashboards design and development for data analyzing by variety of Business Intelligence tools like Microstrategy, Power BI, Tableau, Cognos, etc.
• Served variety accounts in life insurance, auto insurance industry, retail, healthcare, pharmaceutical and life science, consumer goods and FMCG, with strong domain knowledge.
• Extensively worked in Business Intelligence architecture, data modeling and development based on the project requirement and implementation the same with BI tools like Microstrategy, Power BI, Tableau, Cognos.
• Extensively worked and hands on creating and integrating business intelligence standard reports, documents and dashboards for both web and mobile portals with variety of visualizations and components.
• Over 17 years’ experience in MicroStrategy Enterprise Manager, Metadata Management, Migration and Integration, Object Manager, Command Manager, Visualization, VLDB Setting for the Performance Tuning, Cubes Monitoring and Distribution Service
• Over 3 years’ experience in Power BI and Tableau Desktop development, App creation, Dashboard/Report/DAX development, Data Modeling and Dataset development, automation of scheduled refresh, Share Gateway configuration, Caching configuration, Query and Performance Tuning, Security and Access control.
• Over 5 years’ experience in Java/JSP AJAX coding for Microstrategy SDK and Customization development, Web Server, Mobile Server configuration and publish.
• Strong experience in providing highly efficient and reliable business solution for business teams to measure, manage and improve the key performance, including best practice design, full life cycle implementation for small, medium and large Data Warehouse/Business Intelligence projects in either waterfall or Agile mode (Scrum, Kanban, Srumban), from requirements gathering and analysis, architecture and design, to the detail development, testing, deployment, and warranty
• Strong Knowledge in data warehousing concepts and SQL development, data modeling and BI development, good knowledge on ETL design and development in Informatica, SQL Server and SSIS, AWS Redshift, Netezza, Oracle, etc.
• Excellent troubleshooting skills with strong technical background and good interpersonal skills.
• Excellent communication skills, analytical, problem solving and Self - motivated to work individually as well as in a team.
• Requirement gathering, business solution analysis, best practice design
• Design the DWH data model and solution architecture
• BI design, dashboard/report design, semantic layer design of schemas and objects
• Microstrategy/Cognos server installation and configuration in Windows/Linux environment with clusters
• Project migration or publishing from development environment to production
• Multi-level model design for various cases based on business process and workflow
• Lead and Work with development team, giving knowledge transfer and guidance to the team and hands on development
• Performance tuning and tracing, troubleshooting the issues and defects, providing the appropriate solution

TECHNICAL SKILLS:

Database: Amazon AWS S3 / Redshift, SQL Server, Netezza, Oracle PL/SQL, DB2, Sybase

Business Intelligence: Power BI, Microstrategy, Tableau, Cognos, Powerbuilder,Domo, Qlikview

Operating System: Linux, Windows Server

Programming Languages: SQL, DAX, Java, JSP, AJAX

ETL Tools: Informatica, SSIS

Other Utilities: Apache Tomcat, IIS server, Tivoli, JIRA, IBM QC, VSS, CVS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Power BI, Microstrategy, SQL Server, AWS Redshift, JIRADevelopment Tools:Power BI, Microstrategy, DB Visualizer, SQL Studio, Informatica

Responsibilities:

• Involved in all the meeting with to discuss and finalize the requirements gathering, analysis and design of the reports.
• Communicate critical technical choices, specify technical requirements and constraints for design and implementation.
• Working on best practice solution and data model design in AWS Redshift, delivering to team with some best practice from BI model perspective.
• Infrastructure management for all environments DEV/QA/PROD, working with DBA and System team to finalize the server, storage, memory, service, etc.
• Source data profiling and provide necessary inputs to business users, working with data team on the ETL process design to transform the data from source application to target warehouse data mart and data lake.
• Completely work on both development and architecting the solution focusing on reusable components and all the semantic layer schema design and leading team to complete the entire project development.
• Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
• Troubleshooting and investigate the ETL/Reporting code and figure out the root cause and fix the issues, including the performance tuning if need.
• Liaison with client SMEs and stakeholders for all clarifications.
• Claims, Landlord, Underwriting, Financial self-servicing RSD and dashboard solution, a comprehensive data mart for all these application systems in alignment with industry best practices which can also accommodate current and scalable for future reports.
• Billing, near-real-time operational reporting solution for billing team which would help providing quick access to data being entered/modified in application system.
• Customer executive End-to-End analytic solution, including all key data elements influencing the customer experience analysis
• Cloud migration from on-premise to AWS Redshift, remodel based on the existing data architecture which is a combination of EDW (includes Datamart), Data Stage and Replication DB from different application database (Netteza, SQL Server, etc.)
• Policy Renewal Conversion, build a reliable solution to convert and migrate legacy policy data to new operational application using an automated and reusable data conversion approach.