Business Intelligence Data Architecture

Asghar A.

Phone: 630-***-**** Email: ************@*****.***

Accomplished, goal-oriented, competent IT professional with valuable knowledge and 20+ years of experience in data architecture, database management, data warehouse, data science and business intelligence. Comprehensive knowledge of the skills needed in facilitating various business domains, multiple project development lifecycles, and implementing troubleshooting in a competitive, high-impact, and fast-paced environment.

Versatile, forward-thinking and optimistic professional possessing an impressive work ethics and desire to achieve a high standard of work.

Performance-driven professional with broad experience in developing data models, databases and data warehouses for business operations system.

Experience in defining standards, policies and procedures for data architecture, application development platform, web technologies, cloud computing, end user platforms.

Comprehensive knowledge of implementing data compliance, security, integrity, optimizing database performance and scalability

Applying statistical analysis, machine learning and data mining techniques to extract patterns, trends and insights from data.

Collaborating with cross-functional teams to identify business opportunities, develop data-driven solutions and communicate data findings to stakeholders through reports, visualization and presentations.

Experience in working with agile scrum team for facilitating application development.

Exhibited technical expertise in DB2, SQL Server, Oracle, S3, MySQL, PostgreSQL, Microsoft Visual Studio, Python, Java, C#, COBOL, RPG/400, C++, Kafka, MQ, MS Report Builder, and MS Office Suite; utilized proficiency in Java and dotNet technologies.

Core Skills and Competencies

Multi-tasking Capabilities

Research & Development

Survey & Analysis

Vendor Management

Infrastructure Design

Business Intelligence

Application Architectures

ETL Process optimization

Project Management

Rapid Project Deployment

System Support

Data Architecture

Data Management

Data Modeling

Data Governance

Data Warehousing

Data Quality Assurance

Microsoft Technology

Career Summary

Data Architect, Impact4 LLC, Phoenix, USA[Multiple Clients, Audacy, Discount Tire] – Dec 2021 - till date

Analyzed existing data structures and provided recommendations for improvements.

Skilled in analysis of entity relations and recommending effective changes for enhancements.

Interacted with DBA teams and vendor(s) to strategize data structure design that support long term objectives.

Analyzed the data and dataflow solutions with product owners, application owners and developed effective data lineage, data mesh products.

Design and re-engineered database of business applications using Object Oriented designing technique, data flow diagrams and entity relation diagrams with CASE tool Erwin(S-Designer).

Developed conceptual data model for reporting systems.

Designed and implemented data quality assurance processes.(Consistency, completeness)

Database performance improvement through query optimization, index creation, tuning.

Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis in the DQ tool, IBM Information Analyzer (IBM IA)

Sr. Data Application Consultant, NTC, Chicago USA - July 2015 to Nov 2021

Designed and developed Oracle 12c data model for OTC cleared products trade flow process.

Designed and developed SQL Server data structures for OTC Margin processing report.

Developed data solution for client reporting and analytics using Oracle 12c .

Used native support for JSON in Oracle 12c to optimize ETL process.

Used PL/SQL Loader and Korn shell script to load data from various sources into an Oracle database.

Created data dictionary for business application data structure and ODS.

Perform Structured and Unstructured Data Source scanning in Master data sources to find the PII data

Asghar A.

Phone: 630-***-**** Email: ************@*****.***

Data Application Consultant, NTC, Chicago USA: - May 2011 to June 2015

Worked closely with programmer teams and vendor(s) to strategize solutions that support long term objectives.

Analyzed the technical and workflow solutions with architects and developers and developed effective data solutions.

Developed a code automating accounting tasks that significantly increased the revenue collection.

Simplified and implemented the quality assurance to increase efficiency.

Data import and export from traditional Databases like Microsoft SQL Server, IBM DB2 to Hadoop system. Create conceptual Data Quality rules in Ataccama by binding logical variables to the appropriate Data sources.

Create Data Quality Rules in Ataccama IDE and Ataccama ONE applications based on business requirements and created Data Quality Dashboards in Ataccama DQD

Created Model and Dashboard projects in Ataccama DQC and orchestrate DQ rules using Ataccama workflow capabilities

Perform Structured and Unstructured Data Source scanning in Enterprise data sources to find the PII data.

Troubleshoot framework-related work to ensure data ETL process.

Extract data from heterogeneous sources like Oracle, SQL Server

Application Consultant, NTC, Chicago USA: - Aug 2007 to April 2011

Responsible for developing a data pipeline using SQL, JAVA to ingest, transform and build a data layer for analytical consumption

Develop Data Profiling solutions, run analysis jobs and view results, and create and manage data quality controls using IBM Information Analyzer

Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis in the DQ tool, IBM Information Analyzer (IBM IA)

Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process

Work with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements

Utilized Problem Solving and analytical skills to develop an application suited for organization’s requirement.

Orchestrated improvement and technical solutions to complex problems.

Conducted research security trends and best practices to improve system security.

Researched and debugged complex technical problems.

Coordinated and tracked component test plan for in-house software development.

Education

Master of Science Major in Computer Science (IIT, Chicago)

Trainings & Certification

Scrum Master, Scrum Alliance USA

dotNet Advance Training, Microsoft, USA

Software Quality Assurance Training, USA

AML Training, USA

Technological Proficiency

Package S/W

Matrix(Rimes), BPCS

Languages

Python, Java, C#, RPG/400, C++, C, JAVA, COBOL

Front End

Power Builder, Visual Basic, HTML and Oracle Forms

Database

S3, DB2/400, MSSql Server, DB/2(Mainframe), Sybase, MySql and Oracle

Cloud Platforms

Azure, Aws, PCF.

Data Visualization Tools

Power BI.

ETL Tools

SSIS, Informatica

Contact this candidate