SUMMARY

• Over 17 years of professional work experience in Data analytics (design, development, data conversion)
• Involved in phased implementation of BI strategy and it’s evolution from Traditional BI Self - Service ->Augmented Analytics.
• Lead requirements gathering sessions with internal stakeholders about their "vision” for a Migration of Tableau /Cognos to Power BI.
• Rapidly iterate, prototype, and implement data visualizations using advanced/custom design (Python /R / mapbox visuals)
• Design, architect, document, develop, and implemented project solutions, provide support and training
• Years’ of experience in various role as BI Architect / Developer, Administrator across industries like Banking / Retail, Transportation, Education, Health care and e-commerce.
• Experience in Implementing BI project utilizing Waterfall / Agile /DevOps methodologies.
• Excellent experience/leadership in planning, estimation, coordination and Implementation of platforms Upgrade(s)/ App Migration(s) on POC/DEV/QAT/SIT/PROD environment
• Experience in Data management (Dimensional / Relational modeling)
• Strong attention to detail and ability to solve and troubleshoot problems during Design /Development and user training.
• Strong advocate of continues expansion of skill-set in response to a changing environment and new technological development and believe in increasing knowledge of self and others.

TECHNICAL SKILLS

• Microsoft Power BI Desktop /Report builder /Gateway /Report Server / Service /Mobile/ SSIS/SSAS/SSRS /
• Tableau 9.x /2018.1 Tableau Desktop / Server administration
• QlikView/ QlikSense/ ThoughtSpot/ AnwerRocket/ Spotfire/ AtScale
• Cloud Azure /Google
• HDFS, HIVE/Spark/LLAP/Presto
• Cognos 11, 10.x, 8.x Dynamic Cubes /DQM, ReportStudio, Framework Manager, Metrics Designer, Transformer Model, Cognos Workspace, Mobile
• Websphere, Tomcat
• Business Objects Central Management Console, Central Configuration Manager, LCM, Webi, Deski, Crystal, Universe Designer
• Netezza NPS 6/7, DB2 9.1, Oracle 11 g, MS SQL Server 2012/2016,
• MS SSIS, DataStage /Sqoop /
• C, SQL, PL/SQL, COBOL, UNIX Shell Scripting/JavaScripts
• AIX 7.1/6.0/5.3, Windows 2012/2008, Windows 7 /XP, VMware, LPARs

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Architect Consultant/Practice lead

Responsibilities:

• Implemented Power BI on Cloud and On-perm model, advocated Premium Capacity based on Data volume and Number of User and its Usage.
• Designed, developed and deployed several clean/creative dashboards with less visual clutter and more thru data story telling using Power BI / Cognos (on Cloud and on-prem) reporting solutions.
• Created multiple visual options for data presentations including Custom visuals using Python /R scripts.
• Created complete Power BI report solutions, build content, drilldowns, and parameters
• Designed and Managed ETL data management process to ingest in PostgreSQL/SQL servers and optimized data model for Dashboard performance / Adhoc analytics
• 2 Migration Implementation from Cognos to Power BI (eIAP, AML MIS projects)
• Implement Row level security with Power BI
• Developed optimized data model to support Natural Query processing (Q & A solutions)
• Created Workspace and Apps for business users to view the developed reports
• Performance Tuned SQL queries
• Focus on possibilities and probability of solving issues using critical and creative thinking

Confidential

Senior BI Consultant/Designer

Responsibilities:

• Successfully deployed multiple, User friendly Reporting/Dashboard initiatives for Executive /Vice-president / District Managers /Dealers Designed/Implemented to over 3000 business users across Canada.
• Work with development team/app support/QA /DA/BA/DBA/infrastructure /security/other stakeholder at all stages of SDLC for new development/ changes/enhancement ensuring regression testing of all deliverables and transition to support team with agreed SLA.
• Involved in all stages of Project Gating (IDEATION, DECIDE,DESIGN,DELIVER/DEPLOY)
• Work with project team to identify/track/report risk/issues using tools like JIRA/confluence/Trello /HP quality center and facilitated resolutions.
• Primary liaison between Vendor(s) and Management team for License usage, evaluate / implement new tools.
• Work with project manager in developing work breakdown structure and prepare project schedule, follow defined change management process and work with business/stakeholders for any scope changes, gap analysis and provide input to change request(RFC)
• Act as the primary liaison/facilitator between the project team and the business area to ensure business requirements are being met and provide technological solutions accordingly
• Work with Information Security Officer in making sure the Application confirms Security Scan and free of any Vulnerabilities and adhere to Canadian Tire IT Standards
• Create/maintain architectural artifacts and provide technical deliverables to steering committee for approvals
• Involved in designing of Scalable EDW by vertical scaling, prioritizing user/batch workload during peak and non-peak hours.

Confidential

BI Consultant

Responsibilities:

• Involved in Data Model/STM and independently designed Framework Manager model
• Involved in Designing GIC activity Dashboard
• Design Reports to capture bank’s various products and customer analytics.
• Design Reports based on dynamic tables (to get aggregate aware functionality)/custom grouping for product/region/district/branch analysis for weekly/monthly/yearly for levels.
• Involved in UAT support and Signoff
• Wrote Custom SQL for complex reporting requirements
• Collaborated with team’s members during project implementation and always enhance skill set in response to changing environment.