SUMMARY:

• Around 11 years of IT experience as Business Intelligence Developer using Microsoft Power BI, Tableau, Oracle Tools, Dremio and SSRS, SSIS and SSAS in various domains like Healthcare, Banking and Telecom.
• Involved in all the phases of SDLC including Requirement’s collection, Design and Analysis, Development and Customization of the application with Waterfall and Agile SCRUM methodologies.
• Expertise in Microsoft Power BI, Structured Query Language (SQL) and Tableau with good knowledge on SQL Server Integration service (SSIS) and SAL Server Analysis Services (SSAS).
• Experienced ETL developer using PL/SQL and oracle DB for over 6 years.
• Developed complex reports and dashboards and supported the existing reports using Power BI based on the end - user requirements.
• Design, develop and implement reporting and dashboard solutions using Power BI, Tableau.
• Experience implementing and supporting Self-service BI tools such as Microsoft Power BI and Excel (PowerPivot, Power Query, and Power View).
• Hands on Bigdata Hadoop Ecosystem as HDFS, Hive, Sqoop, Spark with Pyspark Dataframe.
• Used AWS EMR to transform and transport huge amounts of data into and out of other AWS data stores and databases like Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDB.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema, also have vast experience in slowly changing Dimensions and Meta data management.
• A high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.
• Performed ETL using Azure Data Factory where data is moved from different sources like Azure Data Lake, SQL database to Azure DB and SQL Data warehouse.
• Experience in creating various reports like table, matrix, drill down, drill through, parameterized, cascaded, linked and sub-reports.
• Multiple file ingestion including but not limited to json, Csv, txt etc.
• Knowledge and Hands on experience on scripting languages like Python and Power Shell.
• Experience working in Agile environment with 2 weeks sprints and tracking work done with stories.
• Big Data Maintenance (3yrs)
• Hadoop Administration (3yrs)
• ETL Development (8yrs)
• Oracle PL/SQL( 5yrs)
• SSIS (2yrs)
• Azure SQL (2yrs)
• Dimensional Modelling (3yrs)
• Data Warehouse Design & Management (2yrs)
• OOP programming (10yrs)
• Database Management (HDFS, Oracle Database, MySQL)
• E-marketing
• Enterprise Solution Architecture and Design

TECHNICAL SKILLS:

TOOLS: AWS Cloud Services (S3, EMR,* Power BI * Python * PHP * SQL * Tableau * Alteryx * Toad * SAS * Microsoft Azure * OBIEE Administration Tool (Data Visualization) * Dremio * Use of Informatica * Remedy * Jira/Confluence * GIT versioning tools (Gitlab, Github) * Web Development (PHP, MySQL, JQuery, JS, CSS, REST, SOAP) * Microsoft Office Applications (Access, PowerPoint, Visio, Word, Excel)

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI Architect

Responsibilities:

• Working with business stakeholders to capture requirements and design efficient data models to transform raw data into meaningful insights.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Modeling the Data from multiple sources in Power BI to perform combined analytics then published to Power BI Service by implementing incremental refresh
• Designed, developed, and tested various power BI and Tableau visualizations for dashboards by connecting from different databases.
• Master Data Management
• Worked on creating Azure Data Factory Pipelines for moving and transforming the data.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using, Bullet charts, Heat
• Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Created Cross- filters relationships and maintained Row- Level Security for Embedding Power BI reports for Customers.
• Created look up tables in Power BI and imported fact table from Oracle and designed the data model.
• Created complex DAX Queries to meet the business requirement of conditional hiding of data and created conditional columns and measures.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Created Workspaces and content packs for business users to view the developed reports.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Worked in Agile methodology following 2 weeks sprint and update the stories with a status in story board on daily basis.
• Involved in Database Design, Query optimization and performance Tuning.
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
• Developing and deploying Supply Chain BI reports on Tableau/PowerBI servers with multiple data sources like Oracle, DB2, Snowflake, SharePoint and Excel.
• Developing, maintaining, and managing advanced reporting in Tableau
• Developing, maintaining, and managing advanced reporting/Performance Analytics
• Design and develop user-friendly reports and dashboards in Tableau.
• Will publish on Tableau Servers or on the ServiceNow instance
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Worked on all types of transformations that are available in Power bi query editor.
• Maintain accurate and complete technical architectural documents.
• Define BI standards, guidelines and best practices for business groups and technical teams.
• Support BI tools upgrades in development, testing, and documentation.
• Analyzed data from various databases and formatted it into various visuals using Tableau Desktop.
• Perform maintenance and troubleshooting activities for BI tools.
• Diagnose and resolve BI tool capacity issues.
• CI/CD implementation
• Creating custom visuals where necessary.
• Recommend strategies to improve performance and capacity of BI tools.
• Address customer queries and issues in a timely manner.
• Provide BI administration and technical support
• Provide technical on BI tools to junior staffs.

Confidential

BI/Data Engineer

Responsibilities:

• Data visualization using different tools (Power BI, OBIEE etc.)
• Use of cloud technologies (AWS S3, EC2, EMR, Glue, VPC, RDS etc.)
• Optimizing, and configuring Tableau and associated product suite applications.
• Hand on developing and Tableau Dashboards and Power Bi Reports.
• Develop reports, visualize dashboards, and prepare ad-hoc reporting using advanced Tableau features.
• Azure data factory pipeline POC
• CI/CD implementation using GitLab, docker, K8s and Nexus repository.
• Involved in the development of new Tableau Dashboards and publishing them to Tableau Server.
• Business Intelligence and Analytics support.
• Maintain Splunk dashboards for monitoring all processes.
• Assume roles of a Site Reliability Engineer.
• Data migration of on-premises MongoDB data to Cloud Mongo DB
• Maintenance of databases (HDFS, MySQL and MongoDB)
• Research and Implementation of latest technologies
• Implement One Time Data Migration of Multistate level data from SQL server to Snowflake by using Python and SnowSQL.
• RBAC or Row base access control to ensuring privilege access modes.
• Enforcing implementation of Data Governance
• Data dictionaries maintenance and automation.
• Data analytics and operation support for business users.
• Data wrangling using with SQL, Pandas, Numpy etc.
• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Created data models and worked on ETL Informatica to make data changes and load multiple datasets into tableau.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Works with stakeholders including Product owners, Design teams with data-related technical issues and support their data needs.
• Work with data and analytics experts to strive for greater functionality in our data pipeline systems.
• Using Gitlab and Github for code repository.

Confidential

Big Data Engineer

Responsibilities:

• Development and management of tools for operational activities.
• Data Migration: Led the Migration of over 300TB of Data from legacy system (Oracle DB Data Warehouse) to big data platform.
• Design data warehouse for new platforms
• Developing OBIEE reports and dashboards.
• Develop ETL process for ingestion of data from other source systems
• Use of Cloudera/Hortonworks Hadoop
• Manage a team of five for big data environment management
• Report developments with respect to business rules
• Use of Jira/Confluence
• Develop ETL process for ingestion of data from other source systems
• Exported data from Hive to AWS s3 bucket for further near real time analytics.
• Use of different tools (PySpark, Spark, Presto, Hive, Zabbix, Ambari, Fileops, Kafka etc.) for data warehouse management.
• Programming with Perl, Python, PL/SQL etc.
• SSIS and SSRS for migrating and reporting financial activities.
• Manage database and ETL processes in PostgreSQL (PL/pgSQL)
• Design and development of Power BI Dashboards
• User creation in Linux for Hadoop and its components in the ecosystem
• Capacity planning, monitoring of connectivity and security of Hadoop cluster
• Performance tuning and running of jobs in Hadoop clusters
• Review and Management of Hadoop log files
• Management and monitoring of HDFS file system
• Maintaining HDFS and providing necessary supports
• Maintaining RDP for OBIEE

Confidential

Business Intelligence Consultant

Responsibilities:

• Analyze and interpret complex data on target systems and analyze and provide resolutions to all data issues for report development
• Perform various tests and validate data flows
• Data Migration: Migrated from over 6TB of Data from Legacy system to inhouse developed Oracle DB Data Warehouse.
• Use of Informatica for file ingestion and ETL.
• Prepare ETL processes according to business requirements and in corporate all business requirements into design specifications
• Develop data warehouse models and prepare reports for all meta data integration into systems
• Collaborate with the developers and business users to gather required data and execute ETL programs and scripts on systems
• Use of tools/programming (PL/SQL, PL/pgSQL, Informatica, OBIEE, Shell Scripting, PHP, API etc.)
• Create shell scripts for daily extraction, transformation and loading of data from heterogeneous sources into the MTN data warehouse
• Document the technical and system specifications documents for all ETL processes and perform unit tests on all processes
• Developing OBIEE reports and dashboards.
• Prepare shell scripts for ETL processes
• Normalize data and ensure the data is properly modelled
• Coordinate with the ETL team for the implementation of all ETL procedures for all new projects and maintain existing procedures
• Maintain metadata and provide updates to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.
• Implement all data warehouse activities and prepare reports for same.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases.
• Develop and perform tests on ETL codes, analyze the data and design data mapping techniques for data models.
• Document the necessary test procedures for systems and processes and coordinate with business agencies.
• Provide optimal and cost-effective solutions to business teams in achieving business objectives
• Provide functional and technical guidance to business teams when needed
• Attend business meetings with customers to determine requirements
• Analyze the business performance and develop reports on performance metrics
• Develop best practices to achieve project objectives and deliverables
• Assist in developing BI reporting and analysis applications
• Stay updated with ongoing business developments and latest market trends
• Assist in pre-development planning efforts to help evaluate business and data requirements for BI initiatives/projects

Confidential

Team Lead E-Marketing/Software Developer

Responsibilities:

• Collate and report back monthly on performance statistics for all digital communications across all channels, using these statistics to influence future digital activity.
• Use of ETL processes to extract information from different source systems
• Loading of reconciliation files using ETL tools
• Overseeing PPC campaigns monitoring their performance and return on investment.
• Writing informative and effective search engine optimized copy for the website and external blog postings.
• Using the CRM to maximize online marketing opportunities.
• Managing the company’s digital marketing campaigns.
• Monitoring return on investment for the different online marketing campaigns.
• Managing the organizations Social Media accounts ensuring all copy is relevant for the different platforms.
• Managing the content diary for social media content.
• Keeping up to date with changes and advances in social media and advising on new channels and approaches to adopt.
• Monitoring social media for company mentions and engaging with customers where relevant.
• Design and develop E-commerce solution
• Analyze and manage traffic.
• Integrate payment solutions where necessary

Confidential

Web Developer

Responsibilities:

• Develop and manage web portal for tertiary institutions
• Payment integration to solution for seamless payment
• Enhancing solution with new features
• Researching different software programs, maintaining software documentation
• Implementing contingency plans in case the website goes down
• Maintaining and expanding/enhancing the website once built