Candidate Information Title Business Intelligence Data Architecture Target Location US-IL-Chicago Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Data Engineer Business Intelligence Naperville, IL Business Intelligence Data Analytics Naperville, IL Data Analytics Business Intelligence Bartlett, IL Data Analyst Business Intelligence Oak Forest, IL Sql Server Business Intelligence Aurora, IL Artificial Intelligence Business Analyst Naperville Business Analyst Intelligence Chicago, IL

Asghar A.Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEAccomplished, 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 scalabilityApplying 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 CompetenciesMulti-tasking CapabilitiesResearch & DevelopmentSurvey & AnalysisVendor ManagementInfrastructure DesignBusiness IntelligenceApplication ArchitecturesETL Process optimizationProject ManagementRapid Project DeploymentSystem SupportData ArchitectureData ManagementData ModelingData GovernanceData WarehousingData Quality AssuranceMicrosoft TechnologyCareer SummaryData Architect, Impact4 LLC, Phoenix, USA[Multiple Clients, Audacy, Discount Tire]  Dec 2021 - till dateAnalyzed 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 2021Designed 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 dataAsghar A.Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEData Application Consultant, NTC, Chicago USA: - May 2011 to June 2015Worked 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 DQDCreated Model and Dashboard projects in Ataccama DQC and orchestrate DQ rules using Ataccama workflow capabilitiesPerform 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 ServerApplication Consultant, NTC, Chicago USA: - Aug 2007 to April 2011Responsible for developing a data pipeline using SQL, JAVA to ingest, transform and build a data layer for analytical consumptionDevelop Data Profiling solutions, run analysis jobs and view results, and create and manage data quality controls using IBM Information AnalyzerPerform 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 processWork with Business Analyst and application users to finalize Data Model, functional and detailed technical requirementsUtilized Problem Solving and analytical skills to develop an application suited for organizations 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.EducationMaster of Science Major in Computer Science (IIT, Chicago)Trainings & CertificationScrum Master, Scrum Alliance USAdotNet Advance Training, Microsoft, USASoftware Quality Assurance Training, USAAML Training, USATechnological ProficiencyPackage S/WMatrix(Rimes), BPCSLanguagesPython, Java, C#, RPG/400, C++, C, JAVA, COBOLFront EndPower Builder, Visual Basic, HTML and Oracle FormsDatabaseS3, DB2/400, MSSql Server, DB/2(Mainframe), Sybase, MySql and OracleCloud PlatformsAzure, Aws, PCF.Data Visualization ToolsPower BI.ETL ToolsSSIS, Informatica