Home

Aejaz Ahmed Habibi - Senior Data Analyst

[email protected]

Location: Boston, Massachusetts, USA

Relocation: yes

Visa:

Name: AEJAZ AHMED HABIBI Email Id: [email protected] Contact: +1 719-239-7099 LinkedIn: https://www.linkedin.com/in/aejaz-a-b840a9298/ Senior Data Analyst Summary Over 9+ years of experience in data analysis, the Analysis, Design, Modelling, Development, Implementation, and Testing of Data Warehouse applications and acquired excellent analytical, coordination, and interpersonal skills for leadership. Proficient in Python, R, and various data analysis tools. Experienced in designing and implementing data models and maintaining data quality. Possess strong Documentation skills and knowledge sharing among the Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, and participated in requirement sessions to identify logical entities. Extensive Experience working with business users as well as senior management. Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, and Star and Snowflake schema modeling, Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching, and buffer tuning. Core Competencies: Python, MS Excel(Lookup formulas VLOOKUP, Lookup; Pivot Table and Graph), Pandas, Advanced SQL, EDA & Data Visualization -Power BI, Tableau, Snowflake, MS SQL Server, Power BI Integration, ETL, Machine Learning (in-depth understanding of ML algorithms), Data Structures & Algorithms, TimeSeriesForecasting, Inferential Statistics, Analytics & Reporting, Data bricks, Base SAS, Scikit-learn, Seaborn, Stats models, A/B testing, NLP, Supply Chain, Procurement Specialist, Fleet Management, People Analytics, Finance, Auditing. Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management, and Business Intelligence. Extensive experience in relational Data modeling Dimensional data modeling, logical/Physical Design, ER Diagrams, and OLTP and OLAP System Study and Analysis. Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management, and Business Intelligence. Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, forward and reverse engineering data models, and publish data models to Acrobat PDF files. Expertise in transforming business requirements into analytical models, designing algorithms, building models, and developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data. Excellent leadership, organization skills, and requirement-gathering skills such as JAD. Strong experience in databases such as Microsoft Access, Oracle 11g/10g/9i/8i, SQL Server, DB2, Teradata, on Windows 2000/NT/98/95 platforms and the latest. Experienced in writing Toad and PL/SQL Stored Procedures, Triggers and Functions. Technical Skills: Data Modeling Tools Erwin, Power Designer Project Management MS Project Methodologies SDLC, JAD Sessions, Ralph Kimball Technologies Databases MS Access, SQL Server, Teradata ETL Tools Informatica Power Center Reporting Tools BO, MOBILE Languages PL/ SQL, SQL, HTML OS Windows Others MS Project, MS Office, TOAD Education: Bachelor of Electronics and Telecommunications at the University of Mumbai. Experience: Master Card, New York, NY Jun 2022- Till Date Senior Data Analyst Responsibilities: Responsible for creating reporting dashboards, and performing data mining and analysis to understand customer purchase behavior. Working with the reporting lead to prepare monthly, quarterly, and annual forecasts of parts pricing and sales variance financial results in collaboration with the Aftermarket business resource team. Compiling, analyzing, and communicating on global sales variance spend including reconciling sales variance data with the general ledger systems, Snowflake, and SQL. Building Statistical models using different buyer s price and sales variance data for future forecasting. Completing presentations and providing business insights for monthly business reviews with internal business partners. Work with business partners to enhance existing forecasting processes in the Parts Pricing and sales Variance space using Machine Learning techniques. Completing ad hoc reporting analysis and participating in special projects Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives. Involved in information-gathering meetings and JAD sessions to gather business requirements, and deliver business requirements documents and preliminary logical data models. Performed requirements gathering and design analysis for customer contact history for customer relationship management. Experience in Python, Jupyter, and Scientific computing stack (numpy, scipy, pandas, and matplotlib). Worked as a business requirements analyst with subject matter experts to identify and understand requirements. Supported data warehouse projects with logical and physical data modeling in the Oracle environment and assured accurate delivery of DDL to the development teams. Documented the data requirements and system changes into detailed functional specifications. Took ownership of Source to Target Mapping and tracked and maintained changes. Performed Extraction, Transformation, and Loading (ETL) using Informatica power center. Designed and implemented data profiling and quality improvement solutions to analyze, match, cleanse, and consolidate data before loading it into the data warehouse. Worked on Business forecasting, segmentation analysis, and Data mining and prepared management reports defining the problem; documenting the analysis, and recommending courses of action to determine the best outcomes. Automate different workflows, which are initiated manually with Python scripts and Unix shell scripting. Extensively used Erwin to design Logical, Physical Data Models, and Relational databases and to perform forward/reverse engineering. Responsible for designing new FACT or Dimension Tables for existing Models. Implemented stored procedures, functions, views, triggers, and packages in PL/SQL. Environment: ERWIN 4.0, Oracle 8i/9i, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Informatica Power center Cigna, Bloomfield, CT Nov 2019- May 2022 Senior Data Analyst Responsibilities: Collaborated with End Users, Business Analysts/Architects to gather detailed requirements for data analysis. Developed the SQL Joins, and SQL queries for data retrieval, accessed for analysis, and exported the data into CSV, and Excel files. Created Data Quality Scripts using SQL to validate successful data load and quality of the data Developed various types of data visualizations using Python and Tableau Extracted large volumes of data feed from different sources, performed transformations, and loaded the data into target structures. Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization, and performed Gap analysis. Analysed business requirements, system requirements, data mapping, and requirement specifications and communicated them to developers effectively. Created drill-down reports, Drill Through Reports by Region. Documented functional requirements and supplementary requirements. Contributed to Setting up of test data and the range of functionalities to be tested as per technical specifications in the test environment. Developed CSV files and reported offshore progress to management using Excel templates, Excel macros, Pivot tables, and functions. Maintain and perform data mining, cleansing, and validation using Excel VLOOKUP and other Excel functions Manage all UAT deliverables to completion by the requirements. Worked on Tableau Desktop and created dashboards, graphs, summaries, and calculated expressions. Worked extensively with the Erwin Model Mart for version control. Created Logical/physical data model in Erwin and worked on loading the tables in the Data Warehouse. Imported the Excel Sheet, CSV, Delimited Data, and advanced Excel features into Tableau as per business needs. Built Factor Analysis and Cluster Analysis models using Python SciPy to classify customers into different target groups. Created Dashboards for the higher management for the visualization of the status in Tableau. Conducted Scope Analysis, Stakeholder Analysis, Gap Analysis, and Traceability Matrix and used Visio for Business Process Modelling adopting UML standards. Setting up notification service through Amazon SNS (simple Notification service) which in turn triggers AWS (Amazon Web Services) Lambda function to pick the data from one S3 to a centralized S3 location. Experience in working with EC2, Lambda, and S3 buckets in AWS (Amazon Web Services) using cloud formation templates. Applied Tableau features including calculated fields, parameters, table calculations, data blending and advanced calculations, demographic and geographic fields for creating visualizations Environment: AWS Skills, Oracle 10g/11g, SQL, MS Access, MS Office, MS Excel, Tableau, PL/SQL, Erwin. Samsung Electronics, India Mar 2016- Sep 2019 Data Analyst Responsibilities: Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Oracle Staging/Target Area. Verified and validated data model structure and E-R modeling with all related entities and relationship with each entity based on the rules using Erwin as per the business requirements. Worked in the implementation of loan and risk management system applications. Writing and executing Test Cases with Test Data. Used SQL Queries to verify the data from the Oracle and MS SQL Server databases. Performed backend testing using SQL queries and analyzed the server performance on UNIX Tested mappings and SQL queries in transformations such as Expression transformation, Filter transformation, Lookup transformation, Joiner transformation, XML transformation, Aggregator transformation, and Update strategy transformation. Extensively used Informatica Debugger to validate maps and to gain troubleshooting information about data and error conditions. Interacted with client user personnel to ensure continuing adherence to requirements and user standards. Tested formulas for various loan, interest calculations, and currency conversions required for reporting purposes. Actively participated in System testing, integration testing and coordinated UAT Environment: Informatica Power Centre 8.6/8.1.1, Workflow Designer, Power Centre Designer, Repository Manager, COGNOS Power play 6.6, XML, SQL server, DB2, Oracle 9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting Ericsson Global Services, India Jun 2013- Feb 2016 Data Analyst Responsibilities: Interacted with business users to identify and understand business requirements and identify the scope of the projects. Identified and designed business Entities and attributes and relationships between the Entities to develop a logical model and later translated the model into a physical model. Developed normalized Logical and Physical database models for designing an OLTP application. Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables. Work with users to identify the most appropriate source of record and profile the data required for sales and service. Involved in defining the business/transformation rules applied for ICP data. Define the list codes and code conversions between the source systems and the data mart. Developed the financing reporting requirements by analyzing the existing business objects reports Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling. Reverse Engineered the Data Models identified the Data Elements in the source systems and added new Data Elements to the existing data models. Created XSDs for applications to connect the interface and the database. Compare data with source documents and validate Data accuracy. Used reverse engineering to create a Graphical Representation (E-R diagram) and to connect to an existing database. Generate weekly and monthly asset inventory reports. Evaluated data profiling, cleansing, integration, and extraction tools (e.g. Informatica) Coordinate with the business users in providing appropriate, effective, and efficient ways to design the new reporting needs based on the user with the existing functionality Also Worked on some impact of low quality and/or missing data on the performance of data warehouse client Worked with NZ Load to load flat file data into Netezza tables. Good understanding of Netezza architecture. Identified design fl in the data warehouse Executed DDL to create databases, tables, and views. Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis. Involved in Data Mapping activities for the data warehouse Created and Configured Workflow, Worksheets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager. Extensively worked on Performance Tuning and understanding Joins and Data distribution. Experienced in generating and documenting Metadata while designing applications. Coordinated with DBAs and generated SQL codes from data models. Environment: SQL/Server, Oracle9i, MS Office, Embarcadero, Crystal Reports, Netezza, Teradata, Enterprise Architect, Toad, Informatica, ER Studio, XML, Informatica, OBIEE Keywords: machine learning business intelligence sthree active directory rlang information technology microsoft procedural language Connecticut Florida Idaho New York