Ahmed Khan Email and Phone Number
Ahmed Khan work email
- Valid
Ahmed Khan personal email
- Valid
- Valid
Over 7+ years of experience in business and data analysis, developing BI applications, statistical analysis and reporting in Banking, Construction, Healthcare and Retail industries using RDBMS, BI, and Big Data technologies.Excellent understanding of the Software Development Life Cycle (SDLC) and Testing Life Cycle (TLC) in Waterfall, Agile (Scrum), Adapt (Scrum + KANBAN), LEAN development environments.Experienced working in Cloud/DevOps environments (Azure & AWS).Extensively worked with tools like Jenkins and Team City to implement build automation.Expertized in using JIRA and Rally software with Jenkins and Github for real time bug tracking and issue management.Experienced QA Analyst/ETL Analyst/Tester with excellent understanding of ETL processes, OLAP Systems, data warehousing, Star and Snowflake Schema and Slowly Changing Dimensions.Expert in writing complex SQL queries, PL/SQL to perform back-end testing on databases like Oracle, SQL Server, and Teradata and Big Data.Experienced in preparation and execution of Test Strategy, Test Plan, Test Scenarios, Test Procedure, Test Scripts, and Test Data for SIT and UAT.Experience working on complex, data-driven assignments that require an ability to understand and navigate large data structures, manipulate and cleanse data.Advanced knowledge and experience in relational databases (Teradata, DB2, SQL Server, Oracle), Data Warehousing and ETL/ELT technologiesPerformed analysis to help clients gain insights into their business and customer behavior through analysis of campaign data, transactional data, customer profile data etc.Experience in Cloudera Hadoop (CDH), Microsoft Azure cloud service and Hortonworks Hadoop environment.Experience in analyzing and translating business requirements to technical requirements and modeling the Logical and Physical Data Models.Experience in supporting and working with cross-functional teams in a dynamic environment.Experience in designing and implementation of continuous integration, continuous delivery, continuous deployment through Jenkins.Hands on experience in writing Python and Bash Scripts.Implemented various Test cases for Functional Testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance Testing (UAT).Good experience using Teradata RDBMS, its utilities (SQL, BTEQ, FastLoad, Multiload, Fast Export, SQL Assistant).Hands on experience testing third party ETL tool jobs including IBM DataStage, Informatica and Talend.Excellent understanding of Software Development Life Cycle and dimensional modeling.
-
Senior Quality Assurance AnalystAmerisourcebergenMckinney, Tx, Us
-
Manager - Quality AssuranceCencora Nov 2024 - Present -
Lead Analyst - Quality AssuranceCencora Aug 2020 - Nov 2024
-
Sr. Data Test EngineerBlue Cross And Blue Shield Of Illinois, Montana, New Mexico, Oklahoma & Texas Aug 2017 - May 2020Chicago, Il, Us• Interacted with the SME’s of each project and gathered the migration information to develop the test strategy and user acceptance criteria.• Worked on Agile Software development methodology and participated in daily scrum and seed meetings to update the progress to all stake holders. • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.• Prepared the complete data mapping for all the migrated jobs using SSIS.• Wrote complex T/SQL queries, PL/SQL to perform back-end testing on databases like Oracle, SQL Server, and Teradata and Big Data.• Experience in analyzing and translating business requirements to technical requirements and modeling the Logical and Physical Data Models.• Worked on Retail Membership, Claims, clinal and providers data for E2E testing and UAT.• Worked on Medicare, Medicaid and MedSupp data validations and build automated source to target scripts.• Worked on GPD, HEDIS, TMG data which comes under Affordable Care Act Medical Insurance system for retail.• Designed, Developed and executed test cases and test reports using QTEST, ToscaBI AND HP ALM. • Wrote SQL queries to perform compare data when it was moved from Teradata to Hadoop.• Collaborated with the offshore team, reviewed their tasks and provided status updates to the onshore team on daily basis. • Performed Target to Target testing after running the jobs in both 8.5 and 11.5 Datastage versions.• Involving in writing complex HQL queries to verify data from Source to Target using Hive.• Used the connector migrator tool before migration of the Datastage jobs.• Familiar with Health Insurance Portability and Accountability Act (HIPAA regulation), Sensitive Personal Information (SPI), Protected Health Information (PHI) standards -
Etl TesterBank Of America Dec 2015 - Jul 2017Charlotte, Nc, Us• Collaborated daily with an Agile teams and work with system developers, database architects, application and principle systems engineers to break-down any issues or impediments relating to banking systems.• Responsible for end-to-end regression testing to provide qualitative data for UAT and Business.• Prepare quality test cases, as well as test plans in accordance to Agile team deliverables. • Involved in preparing Source to Target Mappings and other Technical Specification Documents for the ETL jobs.• Extensively involved in Reconciliation and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.• Developed Complex SQL queries to fetch the data from the Database as per the business requirement and use the SQL queries for further processing.• Tested the Data Validation, Data Conditioning, and Interacting with Acxiom for standardizing Name and Address Information and entire Delta Processing for different Line of Businesses.• Developed and executed test cases and test reports using HP ALM and ToscaBI. • Use various high-level tools and databases in testing, triaging, trouble shooting, and error analysis.• Identified various Data Sources and Development Environment.• Worked as a team member for the testing of Automotive insights data mart and integrating it with Global Data Warehouse.• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.• Tested complex Talend mappings that loaded the data from various sources using different transformations like tMap, join files, expression, aggregator, filter, normalizer. -
Data Quality Analyst / Big Data TesterTarget Mar 2014 - Oct 2015Minneapolis, Mn, Us -
Etl Tester / Data Quality AnalystParsons Corporation Jun 2012 - Dec 2013Chantilly, Virginia, Us -
Student Worker - Senior Event CoordinatorMinnesota State University Sep 2008 - Dec 2010Coordinate and execute events at MSUAssign tasks to student workersAssign traffic controllers for various locations during eventsCreate purchase reports Lease out state-vehicles to customers
-
Assistant Student ManagerSodexho - Campus Dining Services Sep 2008 - Dec 2009Check-in studentsReceive cash or credit cards for meals
-
CashierSodexo Sep 2008 - Dec 200992866 Issy Les Moulineaux Cedex 9, Fr
Ahmed Khan Skills
Ahmed Khan Education Details
-
University Of New HavenGeneral -
Minnesota State University, MankatoInternational Business
-
Minnesota State UniversityBusiness Administration
Frequently Asked Questions about Ahmed Khan
What company does Ahmed Khan work for?
Ahmed Khan works for Amerisourcebergen
What is Ahmed Khan's role at the current company?
Ahmed Khan's current role is Senior Quality Assurance Analyst.
What is Ahmed Khan's email address?
Ahmed Khan's email address is ah****@****ail.com
What schools did Ahmed Khan attend?
Ahmed Khan attended University Of New Haven, Minnesota State University, Mankato, Minnesota State University.
What skills is Ahmed Khan known for?
Ahmed Khan has skills like Leadership, Information Technology, Banking, Test Automation, Data Validation, Load, Troubleshooting, Azure Data Factory, Data Analytics, Agile Methodologies, Hadoop, Management Systems.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial