Application Design and Development
Mohammad Aurangzaib
Senior Business Intelligence And Data Analytics
Karachi, Sindh
Summary
Empowering the business functions, users, and to transform their routine data driven activities, Which can help them for the analytical decision making for the effective progress.
Overview
15
15
years of professional experience
4
4
years of post-secondary education
9
9
Certifications
3
3
Languages
Work History
Unit Head Data Branch Banking Analytics
Habib Bank Limited
Karachi,Sindh
2022.05 - Current
- Excellent communication skills, both verbal and written.
- Demonstrated strong organizational and time management skills while managing multiple projects.
- Demonstrated respect, friendliness and willingness to help wherever needed.
- Paid attention to detail while completing assignments.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
- Skilled at working independently and collaboratively in a team environment.
- Proven ability to learn quickly and adapt to new situations.
- Learned and adapted quickly to new technology and software applications.
- Developed strong communication and organizational skills through working on group projects.
- Cultivated interpersonal skills by building positive relationships with others.
- Demonstrated leadership skills in managing projects from concept to completion.
- Resolved problems, improved operations and provided exceptional service.
- Participated in team projects, demonstrating an ability to work collaboratively and effectively.
- Self-motivated, with a strong sense of personal responsibility.
- Assisted with day-to-day operations, working efficiently and productively with all team members.
Unit Head Data Warehouse & Business Intelligence
JS Bank Limited
Karachi,Sindh
2012.07 - 2022.05
- Learned and adapted quickly to new technology and software applications.
- Self-motivated, with a strong sense of personal responsibility.
- Proven ability to learn quickly and adapt to new situations.
- Proved successful working within tight deadlines and a fast-paced environment.
- Skilled at working independently and collaboratively in a team environment.
- Cultivated interpersonal skills by building positive relationships with others.
- Excellent communication skills, both verbal and written.
- Strengthened communication skills through regular interactions with others.
- Demonstrated creativity and resourcefulness through the development of innovative solutions.
- Worked effectively in fast-paced environments.
- Proven ability to develop and implement creative solutions to complex problems.
- Participated in team projects, demonstrating an ability to work collaboratively and effectively.
- Demonstrated strong organizational and time management skills while managing multiple projects.
- Developed strong communication and organizational skills through working on group projects.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Utilized data visualization tools to effectively communicate business insights.
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
- Participated in requirements meetings to understand business needs.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Tested data prediction algorithms based on historical data.
- Documented effective and replicable methods for extracting data and organizing data sources.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Used statistical methods to analyze data and generate useful business reports.
- Implemented code solutions to answer analytic questions and test and assess new methods.
- Designed and implemented tools to support strategic value chain optimization initiatives.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
- Built databases and table structures for web applications.
- Monitored incoming data analytics requests and distributed results to support [Type] strategies.
- Designed and developed analytical data structures.
- Designed and implemented effective database solutions and models to store and retrieve data.
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
- Explained data results and discussed how best to use data to support project objectives.
- Developed, implemented and maintained data analytics protocols, standards, and documentation.
- Compiled, cleaned and manipulated data for proper handling.
- Implemented randomized sampling techniques for optimized surveys.
- Improved data collection methods by designing surveys, polls and other instruments.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Devised and deployed predictive models using machine learning algorithms to drive business decisions.
- Developed polished visualizations to share results of data analyses.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Collected data from wide-ranging sources.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Queried [Type] and [Type] teams to define intelligence needs, structuring subsequent information gathering efforts accordingly.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
Senior Technical Consultant
Sapphire Consulting Service
Karachi, Sindh
2008.05 - 2021.11
- Recommended technology upgrades to improve client security.
- Collaborated with stakeholders to transform client requirements into turnkey solutions.
- Troubleshot systems comprised of security alarms and Internet connectivity.
- Analyzed client business processes to propose optimal software applications for unique requirements.
- Designed, implemented and monitored web pages, plugins and functionality for continuous improvement.
- Applied emerging technologies to update and maintain site applicability.
- Planned website development, converting mockups into usable web presence with HTML, JavaScript, AJAX, and JSON coding.
- Adopted engineering best practices and delivered highest quality scalable solutions.
- Designed and implemented scalable application programming interfaces.
- Paired with fellow engineers to brainstorm ideas, debug problems and review code.
- Understood full technology stack and underlying applications, services and databases, resulting in optimal program performance.
- Delivered documentation for design decisions, estimating assumptions, code modules and performance metrics.
- Performed development, debugging, optimization and automation to support implementation of products and applications.
- Developed complex software and systems deploying one or more programming languages.
- Created and maintained service desk diagnostics and job aids and reviewed with technicians to confirm clarity.
- Worked with customers to define requirements and troubleshoot issues and architected and implemented new engineering applications to meet needs.
- Followed and supported change management practices and internal controls standards.
- Communicated with product managers and UX designers to translate project requirements and business objectives into polished user interfaces.
- Improved and expanded project platforms using JavaScript to develop rich User Interfaces.
- Collaborated with teammates to deliver valuable features meeting business and customer needs.
- Employed SDLC methodologies during multiple projects, streamlining cross-discipline development.
- Verified program logic using testing and debugging best practices.
- Estimated work hours and tracked progress using Scrum methodology.
- Translated technical concepts and information into terms parties could easily comprehend.
- Built databases and table structures for web applications.
- Coordinated deployments of new software, feature updates and fixes.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Tested functional compliance of company products.
- Conducted data modeling, performance and integration testing.
Program Analyst
Arpatech (Advance Research Projects & Technologies
Karachi, Sindh
2011.11 - 2012.07
- Adopted engineering best practices and delivered highest quality scalable solutions.
- Designed and implemented scalable application programming interfaces.
- Reviewed code and debugged errors to improve performance.
- Developed applications and software to increase department efficiency.
- Developed robust Java code for [Type] applications.
- Worked with business teams to understand needs and address production questions.
- Adjusted design parameters to incorporate new features.
- Conducted data modeling, performance and integration testing.
- Translated technical concepts and information into terms parties could easily comprehend.
Education
Bachelor of Science - Software Engineering
University of Sindh
Jamshoro 2004.01 - 2007.12
Skills
Data analytics proficiency
Unit-level Data Analyses
Data Analytics
Data protection
File and database management
Qualitative data analysis
Community project development
Application database architecture
SQL database expertise
Data Gathering
Data collection and management
Data policy enforcement
Business unit collaboration
Data aggregation processes
Database-savvy
Database Management
Python
Business Intelligence Management
Business intelligence analysis
Business intelligence
Business intelligence tools
Structure designs
Staging tables
Warehousing expertise
Solution development
SQL
Software-as-a-Service Development
System Architecture Design
Teamwork and Collaboration
Data warehouse maintenance
Database objects creation
Database development
Application design
Process improvements
Project coordination
Data visualizations
Agile Methodology
T-SQL coding
SQL analytics
SQL development
Java
Software development proficiency
Analytical and Critical Thinking
Microsoft ASPNET
Business analytics
Database Model Conversion
RDBMS
Operational analysis
Software
Business Intelligence Design and Development
Data warehouse design and development
Data Analytics
Technical Team Lead
Project Coordination
Data Engineering
Data Modeling
Business Process Automation
Banking CRM
Customer 360
Customer Profitability
Application Implementation
Certification
IBM Certified System Administrator - WebSphere Message Broker V6.1 - IBM
Interests
Traveling
Music
Sports
Current Affairs
Timeline
Unit Head Data Branch Banking Analytics
Habib Bank Limited
2022.05 - Current
Implementing a Data Warehouse SQL Server 2019 - LinkedIn
2022-03
SQL (Basic) Certificate - HackerRank
2022-02
SQL (Intermediate) Certificate - HackerRank
2022-02
Learning Data Analytics - LinkedIn
2021-09
Learning Transact-SQL - LinkedIn
2021-08
Power BI Essential Training - LinkedIn
2021-08
Data Visualization for Data Analysis and Analytics - LinkedIn
2021-08
Analyzing and Visualizing Data with Microsoft Power BI
2020-05
Unit Head Data Warehouse & Business Intelligence
JS Bank Limited
2012.07 - 2022.05
Program Analyst
Arpatech (Advance Research Projects & Technologies
2011.11 - 2012.07
IBM Certified System Administrator - WebSphere Message Broker V6.1 - IBM
2011-08
Senior Technical Consultant
Sapphire Consulting Service
2008.05 - 2021.11
Bachelor of Science - Software Engineering
University of Sindh
2004.01 - 2007.12