We provide IT Staff Augmentation Services!

Data Analytics Architect Resume

SUMMARY

  • IT experience spanned over many years’ experience with special focus on Business Intelligence, Data Analysis, Data Mining, BI Reporting, Analytics, Meta Data Management, Data Quality, Data Discovery, Data Visualization, Predictive and Pervasive Analytics, Data warehouse, Big Data Lake, Dimensional Modeling and Management Dashboards related technical and management areas.
  • Comprehensive understanding of latest BI platforms and project execution that includes study, tool selection, analysis, architecture, design, development, optimization, automation, user authorization/entitlements, administration and support of many enterprise wide complex BI/DW initiatives across global organization.
  • Certified Project Management Professional (PMP). Program/Project management experience in leading cross - functional teams in the design and launch of cutting-edge solutions for complex, mission critical technology initiatives, process enhancements, and defining industry best practices and standards.
  • Excellent verbal and written communication skills to keep stake holders up to date with technological and delivery risk and their mitigation plan.
  • Excellent ability to motivate and empower high-performing and diverse teams with the capacity to make solutions-oriented and creative contributions in highly demanding situations.
  • Extensively used Agile and SDLC processes for the projects life cycles phases. Involved with Idea Inception, Analysis, Design/Architecture of Enterprise Business Intelligence and Reporting System, estimation, plan and successful execution of projects.
  • Identifying and proposing short term and long term BI/DW objectives and plan for their implementations.
  • Leading multi-disciplinary globally diverse technology team and managing project resources and deliverables.
  • Extensive experience with N-Tier architecture and related technology using web (UI), Middle and backend database architecture.
  • Good understanding of regulatory aspects and requirements of Investment banking, trading front end and back end processes, Basel I, Basel II, BASEL III, Sarbanes-Oxley SOX requirements and objectives and building compliant systems.
  • Implementation of Big Data technologies and Hadoop enterprise big data solution landscape in a cloud environment.
  • Expertise in system integration, security integration and application integration. Executed many upgrade and re-engineering projects.

TECHNICAL SKILLS

BI Tools: Qlikview, Qliksense, Tableau, Spotfire, Jasper, BIRT, Business Objects, Micro Strategy, Cognos, R, SAS, Azure, N-Printing, Crystal Reports, SSIS, SSAS, SSRS, Machine learning, NLP

ETL Tools: Informatica Power Center/Data Quality/MDM, Ab Initio

Databases/DB Tools: Oracle, DB2, MS SQL Server, Netezza, Hyperion, Essbase, Sybase, MS Access, PL/SQL, DB Artisan, UDB, TOAD, Rapid SQL, snowflake

Operating Systems: Windows NT, Windows 2003, Windows 2008, Linux, UNIX, Solaris

Other: Java, Salesforce, Cloudera, Hadoop, HDFS, Mongo DB, Hive, Pig, Map-Reduce,, data lake, Big Data analytics, Impala, ASP,JSP, Tomcat, SOAP, Azure, Azure cloud, ADF, Siebel, Visual Basic, Jboss Portal, MS Office, Shell Scripting, Perl, SVN, Share point, XML, Schedulers - Tidal/Autosys, C++, HTML, Visual Basic 5.0, Java Script, LDAP, VB script, Murex, Apache Thrift, scala, AWS Cloud, Cosmos DB, AWS S3, AWS Lamdba, Redshift, Jupyter, Machine Learning, NLP, beeline, sqoop, spark, pyspark, kubernates, sparksql, CLIPS, ontology, protégé

PROFESSIONAL EXPERIENCE

Confidential

Data Analytics Architect

Responsibilities:

  • Worked on data analysis, Data Quality, Data governance, data modeling for business use cases.
  • Worked on designing ADF pipelines, pre-processing and data ingestion process for MSCI ESG ratings data in to Azure SQL DW.
  • Designed Horizon pipelines for storing and delivering equities and options daily prices and greeks.
  • Used azure data migration process to lift and shift securities master database to azure.
  • Responsibilities include working on azure datalake for capturing different sets of data and process for automation.
  • Worked with regulatory and compliance groups to capture their requirements for data reporting requirements for various data reporting requirements for downstream systems.
  • Create data quality framework for data capturing and ingestion.
  • Created dashboard visualization objects for sharing purpose with reuse across different dashboards.
  • Create and distribute dashboard for transactions, portfolio risk, assets and performance analysis.
  • Created Azure REST API endpoints to deliver the performance and client reporting data feeds
  • Developed azure app service for delivering UI components for use in dashboards and presentation.
  • Created Market Abuse/DOI 13F/G, employee trading dashboard for pre-trade and post-trade compliance.
  • Delivered static and reactive dashboards to support drill downs and actionable dashboard components.
  • Worked on creating SOD/EOD processes and automation
  • Worked on creating process for audit and trade workflow for third party systems.
  • Built python process to produce tableau tde files for dashboard consumption to improve performance.
  • Writing various SQLs and performance tuning them for use into different dashboards for other data extraction processes.

Confidential

Data Analytics Architect

Responsibilities:

  • Responsibilities include designing datalake on Azure infrastructure for the application for performance optimized environment.
  • Worked on data analysis, Data Quality, Data governance, data modeling for business use cases and DDL creation using Erwin.
  • Designing sqoop infrastructure using python support data ingestion from SQLServer and Oracle data sources.
  • Designing and setup of HBASE for data storage for analytics purpose.
  • Designing and building Hive tables and views for aggregated and detail level representation.
  • Creation of process for data profiling used in datamodel design and for performance optimization purpose using python.
  • Creation of link tables external tables in hive for providing single source for all analytic data.
  • Designing process for various Claims and Prior Authorization workflows for automation using rule based engine.
  • Developing multiple data reconciliation process using ADF and automation process using cron jobs and sqoop jobs.
  • Worked with sparksql on the graph database (RocksDB) and Redshift for creating automation, data enrichment and export process using pyspark connectivity using python.
  • Creating and managing various source-based system centric ontologies and merged ontologies for MDM.
  • Building azure bigdata lake for analytics in graph DB integrating claims,billing, prescription, pharmacy,drug and adjudication data.
  • Design and deliver SelfService BI Solution using spark, and ML NLP algorithm on Bigdata platform.
  • Generate billing and claims Analytics dashboards in Tableau connection.
  • Create data visualization using geo-spacial data on maps dashboard for Claims and billing scorecard.
  • Designing stories/dashboard for senior management for KPIs., Design and development of the data exploration, preprocessing and model generation for Predictive analytics using Jupyter Lab.

Confidential

BI/DW Architect/Lead

Responsibilities:

  • Worked with CXOs to discuss the BI and analytics strategy establishing short term and long-term goals.
  • Worked with corporate technology teams to architect the BI and predictive solution meeting technical and business standards.
  • Worked with data sourcing team to understand the implementation and designing the data integration using SSIS and process automation to meet the scheduled data availability from SSAS.
  • Worked on defining Data Quality, Data governance process and Data Lineage, data procurement strategy and building an automated process to support it.
  • Closely worked with end clients for identifying key matrices and fact analysis for global finance analytic solution.
  • Worked with cross functional database, ETL, web support team to ensure co-ordination and co-operation for infrastructure and technology support.
  • Identifying operational gaps, defining process follow-ups and controls to ensure a quality product delivery and minimizing financial, resource and schedule risks.
  • Design and implement n-tier security architecture and data models, datamarts architecture sharable design framework..
  • In i tiate d and manage d global data quality initiative for 360 degree view of the clean corporate data.
  • Evaluate and analyze data and automate integration with data sources for data warehouse processes.
  • Design and implement BI Application security and access rules for the applications.
  • Created mashups for Salesforce Integration providing KPI analysis interface with Qliksense dashboard.
  • Create GIS Map based visualization dashboard mashups for distribution analysis.
  • Development of highly interactive visualization dashboard with fully automat ed process
  • Design and delivery of the Qlikview datamodel for use in BI management dashboards.
  • Setting up hadoop infrastructure for evaluation and plan for enterprise data lake with both structured and unstructured data ingestion from multiple sources.
  • Worked on setting up the environment and plan for dashboard migration from qlikview to tableau.
  • Setting up unstructured data storage on AWS S3 for various external feeds.
  • Creat ed data exploration, preprocessing and recommendation model using K-Means ML algorithm for product recommendation for clients.
  • Designing sqoop infrastructure to support data ingestion from multiple sources including oracle, sql server, log files.
  • Designing and setup of HBASE for big data storage and Hive queries in sqoop to analyze and export the data.
  • Setup automation process using cron jobs and sqoop jobs and execution of end to end data ingestion process.

Confidential

BI Architect/Tech Lead/SME

Responsibilities:

  • Worked with business users in identifying technology needs and defining technology components for an optimized highly available and scalable architecture solution.
  • Worked on defining data capture strategy, transformation and integration of multiple data sources for datawarehouse .
  • Worked with end clients for identifying key matrices and fact analysis for global expense analytic solution.
  • Lead onsite and offsite teams for application development and support activities.
  • Showcasing innovative data visualization for enterprise users to get concise, effective active data representation.
  • Worked with cross functional database, ETL, support team to ensure co-ordination and co-operation for infrastructure and technology support.
  • Identifying operational gaps, defining process follow-ups and controls to ensure a quality product delivery and minimizing financial, resource and schedule risks.
  • Delivered multidimensional data model in qlikview to integrate diverse data from various expense categories.
  • Worked on the setting up automation process to ensure the smooth execution of the process.
  • Implementing custom user defined data entitlement security using region, product and countries
  • Design and delivery of the Qlikview datamodel for use in BI management dashboards.
  • Evaluated BI tools for self-service data discovery application for better analysis of data and its presentation.

Hire Now