Content Creation
ARIFUDDIN MOHAMMAD
Business Intelligence Engineer | Data Analyst | SQL | ETL | Python
Commerce,Texas
Summary
Data Engineering professional with solid foundational skills and proven tracks of implementation in a variety of data platforms. Self-motivated with a strong adherence to personal accountability in both individual and team scenarios.
Experience in Data Analysis, Data Profiling, Data Integration, Migration, Data Architecture, Data governance and Metadata Management, Master Data Management and Configuration management. Expertise in designing complex Mappings and have expertise in performance tuning and slowly changing Dimension Tables and Fact tables.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
4
4
Languages
Work History
Data Engineer
Silicon IT Solutions, Eli Lilly
Indianapolis, IN
10.2022 - 03.2023
- Developed and maintained ETL processes for data ingestion from various sources into centralized data warehouse using ETL tools
- Designed and implemented data models for efficient data storage and retrieval
- Optimized data processing and storage systems for performance and scalability
- Developed and maintained database systems and managed backup and recovery procedures
- Worked collaboratively with cross-functional teams to deliver high-quality data solutions
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls
- Identified and documented detailed business rules and use cases based on requirements analysis
- Researched and resolved issues regarding integrity of data flow into databases
- Identified, analyzed and interpreted trends or patterns in complex data sets
- Analyzed transactions to build logical business intelligence model for real time reporting needs
- Developed ETL tool to load data from given source to target using python, PySpark, Sqoop, Unix and hive
- Participated in requirements gathering and worked closely with architect and SMEs in designing and modeling
- Handled data ingestions from various data sources, performed transformations using spark, and loaded data into
- HDFS
- Hive context in partitioned Hive external tables maintained in AWS S3 location for reporting, data science dashboarding and ad-hoc analyses
- Skills : ETL Tools ,PySpark ,UNIX ,Hive, Python, Data Modeling ,SQL Data Architecture ,Tableau.
Graduate Teaching Assisstant
Texas A&M University Commerce
Commerce, TX
01.2021 - 07.2022
- Checked assignments, proctored tests and provided grades according to university standards
- Documented attendance and completed assignments to maintain full class and student records
- Mentored students through office hours and one-on-one communication
- Coordinated homework and assignments for absent students
- Planned and delivered lectures and course materials to communicate course content and provide students with subject matter knowledge
- Collaborated with staff in curriculum reviews to improve course and program offerings
- Implemented CI/CD tools and concepts for continuous integration of updates to maintain computer science department website
- Taught 40 users concepts of Information Security and work on SIEM tools Used languages such as, XML, HTML,
- JavaScript and CSS to maintain and troubleshoot EMR application
- Used SQL queries and other tools to perform data analysis and profiling for optimizing queries and performance
- Skills :SQL , PL/SQL.
Team Leader
Cognizant Pvt Limited
Hyderabad, India
01.2019 - 11.2020
- Built strong relationships with customers through positive attitude and attentive response
- Mentored and guided employees to foster proper completion of assigned duties..
- Support Associate Representative gathering and analysis, design, development, implementation, testing and deployment of client/server and Web-based applications.
- Conducted training and mentored team members to promote productivity and commitment to friendly service.
- Creation of Analytical reports on progress/status of project and scope of improvements and drawbacks.
- Involved in creating Dashboards reports as needed using Tableau Desktop .
- Building Data extraction queries using SQL & Develop various automated scripts/Tools using SQL .
- Generate and distribute management reports in accurate and timely manner.
- Maintain TAT for all client requirement and specifications .
Trainer
Wipro India Pvt Ltd
Hyderabad, India
06.2017 - 01.2019
- Evaluated training needs and developed appropriate class offerings
- Maintained compliance with company standards, regulatory requirements and quality goals
- Quickly adapted training plans for client needs, keeping timelines, budgets and desires in mind
- Scheduled and taught in class and online courses to increase learning opportunities.
- Monitored participant workflow and behaviors throughout training process.
- Mentored new hires, resulting in stronger staff development and increased productivity.
- Performed continuous evaluations of content and plans to enhance delivery and improve effectiveness.
- Recorded and edited videos to facilitate remote learning.
- Supported productivity increase and business growth through new hire training and mentoring.
GIS Analyst
GIS, Minvesta Infotech
Hyderabad, India
11.2014 - 06.2017
- Combined remotely collected and on-site data acquisition to generate unified geographic mapping information.
- Researched and resolved issues regarding integrity of data flow into databases
- Used statistical methods to analysed data and generate useful business reports
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
- Developed tables, views and materialized views using SQL
- Map creation using polygons, lines, and points to represent visual data
- Updated, standardized, and geo referenced outdated AutoCAD data in ArcGIS, which ensured accurate scaling of
- CAD models
- Contributed to centralized GIS portal and ArcGIS database, correctly inputting data on new job sites and revising data on changing conditions
- Implemented the GIS Globally.
Education
Master's - Commerce, Computer Science and In formation systems Commerce
Texas A&M University - Commerce
Commerce, TX 01.2021 - 05.2022
Bachelor's - Electronics & Communication
Deccan College of Engineering & Technology
Hyderabad ,India 06.2009 - 05.2013
Skills
Programming languages :Python, SQL
Database Systems: MySQL, Oracle, PL/SQL
ETL tools: Informatica, AWS Glue 1 year
Cloud Platforms: AWS
Data Visualization: Tableau
Operating Software : UNIX Shell ,BASH Shell script
MS Office Tools : Excel, Word, Microsoft Teams, PowerPoint, Outlook, Onedrive
Interests
Timeline
Data Engineer
Silicon IT Solutions, Eli Lilly
10.2022 - 03.2023
Graduate Teaching Assisstant
Texas A&M University Commerce
01.2021 - 07.2022
Master's - Commerce, Computer Science and In formation systems Commerce
Texas A&M University - Commerce
01.2021 - 05.2022
Team Leader
Cognizant Pvt Limited
01.2019 - 11.2020
Trainer
Wipro India Pvt Ltd
06.2017 - 01.2019
GIS Analyst
GIS, Minvesta Infotech
11.2014 - 06.2017
Bachelor's - Electronics & Communication
Deccan College of Engineering & Technology
06.2009 - 05.2013