Aziz Akhtar

• Create and recruit team of resources consisting of Data Scientists, Data Analysts and Machine Learning Engineers.
• Manage hybrid Financial data model consisting of Churn Model, Propensity Model, Penetration Model, Random Forest and Decision Making models as inputs, to provide output of areas to invest and create new wire centers for fiber expansion to the home (FTTH). Project budget of around 2.5 billion dollars, the information provided impacts where investments were made
• Required to proactively assess competition footprint to determine risk/threat to proposed locations and assess current state market share and forecast market share.
• Design and deliver data-driven insights and automation for telecommunications
• Monitored expenditures to mitigate risk of overages.
• Support Ad hoc data analysis requirements as needed •Stay on top of technologies and trends in data science in marketing •Leverage machine learning techniques to develop hybrid data model
• Fostered work culture of collaboration and inclusion to increase morale and reduce turnover.
• Prioritized and allocated valuable resources to meet business targets.
• Leverage Spotfire Visualizations to display insights & finding
• Migrate Spotfire Dashboards to PowerBI
• Instituted formal operating procedures and enforced adherence to policies and regulations that impacted bottom-line.
• Drove strategic improvements to enhance operational and organizational efficiencies.
• Standup and Manage AWS Cloud Sandbox Environment (Redshift,Athena,Glue,Sagemaker,S3,Policies,IAM)

Description : Build and manage team consisting of Data Scientists, Data Analysts and Machine Learning Engineers. Manage complex Financial data model which consumes Churn, Propensity, Penetration, Random Forest and Decision Making models as inputs, to provide an output of areas for Frontier to invest and create new wire centers within the USA for fiber expansion to the home. Maintain budget of around 2.5 billion dollars, and the information provided directly impacted where investments were made, as well as predicted the IRR, NPV, and attractiveness of new locations. Additionally required to proactively and reactively assess competition footprint to determine risk/threat to proposed locations

• End to end stand-up of GCP Cloud platform
• Involves datawarehousing, data architecture, data modeling, ETL and automating pipelines in Data factory and managing internal product for cross functional use
• Design and deliver data-driven insights and automation for banking (using statistics, NLP, data mining, machine learning, and deep learning techniques as applicable)
• Worked closely with organizational leadership and board of directors to guide operational strategy.
• Support Ad hoc data analysis requirements as needed
• Oversaw operations and provided corrective feedback to achieve daily and long-term goals.
• Work with various client marketing teams to understand their challenges and create solutions
• Thought leader for your team on projects and about leading technologies
• Stay on top of technologies and trends in data science in marketing
• Monitored expenditures to mitigate risk of overages.
• Leverage Tableau Visualizations to display insights & findings
• Communicate findings to leaders and help create strategy
• Proactively implement data/reporting strategy for business processes and identify need's of business lines with operational or activity reports and insights.

Description: Manage and lead day to day data science team with daily standup, project management and enable cross functional leaders with customer and market insights. Includes sales data, marketing data and spearheading development of new database environments in the cloud environment as well as connecting to existing database sources; analysis consisted of optimizing phone prices at launch, optimizing field workers in relative distance to brick & mortar locations and managing CDP for other cross functional units to use.

• Utilize SQL, Hadoop and Teradata to query data to provide information requested by business users
• Perform Data exploration using R Studio via R Scripting & Python
• Provide Strategy to leaders for virtual channel's roadmap and prioritizations in terms of servicing
• Proactively implement data/reporting strategy for business processes and identify need's of business lines with operational or activity reports and insights
• Onboarded new employees with training and new hire documentation.
• Utilize BI Tools such as Microstrategy, Tableau to create visualizations for data analysis
• Package findings and analysis within Powerpoint deck to walk through end user/audience for findings and a better understand of key metrics as well as socializing insights and operational benefit for use case or business case(s)
• Accomplished multiple tasks within established timeframes.
• Develop ML & AI solutions leveraging EDW data to save business time for key metrics on fraud use cases and NLP around call listening
• Query multiple databases via Teradata (aster etc)
• Maintain Sandbox environment for data analytics
• Create volatile tables for ad hoc analysis & provide ad hoc data solutions on the fly
• All reporting & strategy provided via presentations to leadership for WFVC within Wells Fargo - present the analysis and reporting to the audience and clearly communicate findings and strategy
• Manage deliverables for multiple business partners
• Create intake form to prioritize requests
• Business knowledge includes mobile platform, online banking, fraudulent activity, customer behavior tracking, and operational management
• Resolved staff member conflicts, actively listening to concerns and finding appropriate middle ground.
• Develop complex analyses in the Rstudio both base and modern packages (e.g.,tidyr, ggplot2).
• Controlled costs to keep business operating within budget and increase profits.

Description: Manage and lead day to day data science team with daily standup, project management and enable cross functional leaders with customer and market insights. Includes sales data, marketing data and providing product owners support in enhancing their products. Leveraged NPS and CSAT scores to dive deeper into problematic customer sojourns which needed optimizing.

• Provide support to all line of business for scalable dynamic dashboards
• Stand-up data environment and presentation layer from scratch for BI & Data Analytics which is used for day-to-day and supervise direct reports consisting of analysts and developers to deliver dedicated support via data and ad hoc reporting to their assigned line of business(es)
• Supervise & manage Data Analytics Team to ensure quarterly milestones and key initiatives are properly executed and met
• Transform business needs into technical needs by collaborating with key stakeholders
• Create and ensure policies are being met
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Hands on Data Migration ETL work within On Premise and Cloud services
• Perform data warehousing activities using Dimensional Modeling, Star, Snowflake, Hybrid Schemas, and Data Mart
• Establish best practices for coding, development, and implementation processes
• Leverage SQL within MS SQL and Oracle Operational Data Store for reporting purposes on business processes
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Proactively implement data/reporting strategy for business processes and identify need's of business lines with operational or activity reports and insights
• Create documentation for business procedures
• Manage day-to-day delivery for analytics and visualizations with reporting ( Tableau, Business Objects,Microstrategy)
• Hands on experience with complex querying, including data manipulation, stored procedures, and report
• Provide transparency within data delivery and communicate to business partners anything that can delay requirements
• Provide Data Strategy to accommodate business needs
• Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
• Manage projects through entire BI software development lifecycle
• Manage the delivery of projects through entire BI software development lifecycle including, gathering data, acceptance testing, and packaging the final product for end-user adoption and consumption
• Manage team responsible for designing and building data and reporting assets used to gather business intelligence (BI)
• Lead the technical solutioning, delivery, and support of deliverables for data, reporting, and analytics
• Create intake form to prioritize requests
• Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
• Business knowledge includes mobile platform, online banking, fraudulent activity, customer behavior tracking, and operational management
• Develop complex analyses in the Rstudio both base and modern packages (e.g.,tidyr, ggplot2)
• Develop ML & AI solutions leveraging Azure to save the business time for key metrics on fraud use cases and NLP around CSAT/Survey Data
• Create scatterplots, correlation analysis via charts and linear regression models as well multivariate linear regression, cluster algorithms,decision trees, logistic regression.

Description : Build a data shop from the ground up. Create and recruit a new team and hone talent to fulfill operational day-to-day reports. Stand up on-prem database and later migrate into cloud. Perform pricing analytics to determine what price point to set for Ally mortgage rates.Leverage Salesforce and other vendor data & extracts to provide a holistic view of the mortgage loan from lead to fulfillment and its respective customer experience. Provide insights using data that would improve product development. Provide day-to-day insights working along side strategists for research and analysis to provide recommendations to stakeholders.

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
• Developed and maintained ETL (Extract, Transform and Load) mappings to extract the data from source Netezza database and loaded it into Oracle tables
• Involved in Database migrations from legacy systems, SQL server to Oracle
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files
• Extensively worked on the packages, including a variety of transformations
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server
• Involved in Maintenance and Deployment of SSIS Packages
• Developed Custom Reports by Ad-hoc Reports using SQL Server Reporting Services (SSRS)
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Ability to perform duties in a very fast pace environment and ability to learn new technology
• Developed POC for Design Studio versus Lumira
• Integrated drill through from Lumira to WEBI
• Convert visualizations from other reporting tools into Lumira
• Developed multiple dashboards with Lumira depicting differing KPIs for business analyses
• Leveraged Lumira to provide solutions for end user requirements
• Understand existing data environment for potential future changes
• Excellent functional understanding of Real Estate with its several sub villages (origination, mortgages, underwriting, fulfillment, business controls, credit risk etc.).

• Lead team of BA's and Developers for converting existing reporting solutions to BI Platform, including creating documentation, leveraging Business Analysts and training junior
• Created ETL packages where various control flow and data flow items are utilized to perform Transformations over OLTP data before loading into data warehouse
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files
• Debugged various SSIS packages using data viewers, break points and event handlers
• Contacted source team for missing source file issues, reordering the flow etc
• Cases
• Designed ETL packages to deal with multiple data sources and load the data into target data sources by implementing multiple transformations using SQL Server Integration Services (SSIS)
• Trouble shooting of Reports by cross checking the Report Layouts, Datasets, Stored Procedures and SSIS Packages
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services
• Analyze Root cause for certain jobs that failed to load and followed by a defect fixing procedure
• Understand and analyze new problems encountered in the monitoring
• Identified long running jobs and fix them
• Understand and design the mapping from the source to target
• Provided mail communication to the whole team everyone hour starting 6AM CST on the status of the flow
• Identified the missing sources files for the day, by communicating with the source team and skip the flow accordingly
• Extensively worked with production team for scheduling jobs and provided support from the onsite team towards holding/executing.