I have accumulated 13.3 years of experience as an IT professional specializing in the design, development, and implementation of Data Warehousing Technology and Data Analysis. During this time, have dedicated 7 years to working with Informatica Power Center and the last 6 years as an Alteryx developer.
My expertise covers all phases of the Data warehouse life cycle, encompassing Analysis, Design, Development, and Testing of Data warehouses using ETL.
Furthermore, I possess extensive experience in ETL design, development, and maintenance using Oracle SQL, Teradata, TSQL, Alteryx (2022.3), and Informatica Power Center v 9.1.
Experienced in Alteryx to prep, blend, and analyze data. Designed macros to load multiple files into db. Extracted data from SQL Server, Flat Files and API.
Have good knowledge in formula, join, unique, xml and json parse, Transform, append, dynamic input, dynamic rename
Using Alteryx have done Data integrationfrom different source system, Data analysis, Data Validation and did performance tuning in source and target
Well versed in developing the complex SQL queries, unions and multiple tables joins and experience with Views
Experienced at Creating effective Test data and development of thorough Unit test cases to ensure successful execution of the data
Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning
Have knowledge in UNIX shell scripting
Have basic knowledge of reporting tools such as QlikSense and Power BI.
Overview
13
13
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Senior System Analyst
Artech Infosystems Private
07.2023 - Current
Client: Ford- Cyber Security and Data Protection
Analyzed existing systems and databases and recommended enhancements to run workflow effectively
Proactively integrate data from various sources including JAMF, SACM, Easset, SEPM, and HX to identify and address any broken or malfunctioning clients.
This streamlined approach empowers policy deployment team to efficiently deploy necessary packages and engage with affected machines, ensuring compliance and optimal functionality.
System Analyst
Hexaware Technologies
11.2017 - 07.2023
Client: IQVIA - ITAM Hardware Discovery
The asset details are integrated from different source system like SCCM, SNOW, JAMF, Antivirus, Nexthink, Intune and Snow License Manager to check on device status and compliance.
The Server details, last logged in user, no of logins for respective servers are tracked.
Hence system compliance and non-compliance status is tracked
Client: IQVIA - ITAM User Integration
The employee information, including details such as contact information, job title, and department, is stored in Active Directory and workday table.
This data is then seamlessly integrated into ITAM User table and carefully managed in EBX.
Any changes to this information, such as when user leaves organization, supervisor change occurs, or there are updates to asset allocation, are captured and incorporated into system to ensure accurate and up-to-date records.
Client: Inchcape Shipping Services
Inchcape Shipping Services, as one of largest cargo shipping companies with extensive experience, aims to provide customers with comprehensive information about their cargo. This includes details such as origin port of container, specific operations conducted on commodity, duration spent in each port, and overall sailing time.
To accomplish this, we gather data from port agents and extract it from source database on daily basis.
We meticulously process each set of data, calculating duration for each operation, and carefully analyze active and idle time of each operation, presenting findings in detailed reports in Tableau dashboard.
Technical Lead
HCL Technologies
04.2017 - 11.2017
Client: Tyco
Tyco is fire fighters and many other fire intrusion manufacturing and logistics company.
Tuned systems to boost performance.
Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
Automated monitoring and security measures to reduce required employee attention.
Associate
Cognizant Technologies Solutions
02.2011 - 03.2017
lient: Abbvie Pharma
Abbvie is pharma company which sales medicines in all geography and maintains trademark of it
In order to effectively analyze a specific market, it is necessary to accurately calculate volume of previous month based on required month.
If data for particular month is not available, the system will generate the corresponding month and replicate the previous month's volume.
This approach is designed to support the gradual growth of the representative and to help achieve future targets.
The entire development process is carried out using Teradata PL/SQL procedure, ensuring a robust and efficient implementation.