| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate 3741 Casual Ridge Way
Candidate's Name Loganville, GA-Street Address
EMAIL AVAILABLE
Ph: PHONE NUMBER AVAILABLE
SUMMARY
US Legal Status:
8+ years of experience in the IT industry with expertise in business intelligence, data Green Card
warehousing, ETL processes, database management, Workday integrations, and reports.
6+ years of experience with ETL tools, including IICS, Datastage, PowerCenter, and
Pentaho, and 10 months specifically in Workday integrations and reports.
Proficient in data integration with Workday, Salesforce, databases, Amazon S3, and
SFTP/FTP.
Skilled in troubleshooting, optimizing, and tuning IICS transformations for performance.
Strong background in databases, including Oracle, SQL Server, Teradata, and MS Access,
including expertise in SQL, PL/SQL procedures/functions, triggers, and packages.
Experience in maintaining history retention tables using Slowly Changing Dimensions
and a solid understanding of views, synonyms, indexes, joins, and sub-queries.
Knowledgeable in data warehouse techniques and practices, including dimensional data
modeling (Star Schema, Snowflake Schema, Fact and Dimension Tables), and writing SQL
queries and PL/SQL for business rule implementation and validation.
Familiarity with database tools such as SQL Server Management Studio, MySQL
Workbench, and TOAD, and working knowledge of BI tools like Power BI and OBIEE.
Experience with UNIX operating systems and shell scripting.
Strong interpersonal skills with the ability to build effective working relationships,
understand support requirements and manage team collaboration.
Excellent communication and presentation skills, with a proven ability to work
independently and as part of a team.
Technical Skills
Operating Systems: ios, Windows XP/Vista/7, UNIX, MS-DOS, and Linux
Databases: Oracle, MySQL, MS SQL Server, Teradata, Netezza, MS Access
Languages: SQL, PL/SQL, C, C++, Unix Shell Script, Batch Scripts
ETL Tools: Informatica Cloud, Datastage, Teradata, Pentaho, Informatica PowerCenter
Other Tools: SQL plus, Toad, Pentaho, Git, SPLUNK 6.2, CA Service Desk Manager (CA SDM),
Postman, SoapUI, Workday
EDUCATION
Mahatma Gandhi University
Bachelor of Technology, Computer Science & Engineering June 2010 June 2014
EXPERIENCE
RTD (Regional Transportation District) October 2018 February 2024
Worked as a Sr.Software Engineer in the Workday team. Received training in Workday HCM and
developed various Integrations and Reoports for RTD.
Worked as an Interface Developer in the Business Intelligence team. Responsible for developing,
testing, and deployment of ETL in mainly Informatica Intelligent Cloud Services (IICS).
Senior Software Engineer (Workday)
Designed, developed, and deployed Workday integrations using EIBs, Core Connectors,
and Workday Studio.
Created customized reports using Workday s Report Writer to meet business needs.
Collaborated with cross-functional teams to ensure seamless data flow between
Workday and external systems.
Supported troubleshooting and optimization of existing integrations and reports,
ensuring data accuracy and compliance with business requirements.
Modified existing reports and integrations to accommodate new user requirements and
enhance system functionality.
Interface Developer
Designed and developed 80+ ETL Integrations using Informatica Cloud.
Extracted data from multiple sources including Workday, Salesforce, Databases, flat files,
file lists, and XML.
Developed and maintained various Workday ETL Integrations such as employee
demographics, deferral file, employee and manager hire rehire, function worktag, cost
center, absences, bus and rail time upload, EBS general ledger, wage garnishment, and
demographics data into third-party system using APIs.
Developed and maintained various IICS APIs that use Workday built-in APIs such as
Absence Management, leave balances from various systems into Workday, and Badge
Info into Workday.
Developed Data Integration Processes to call Workday custom report APIs and get the
data which is then sent to third-party systems.
Developed and maintained ETLs for ERP systems such as secure file transfer with various
banks and insurance companies, risk management like workers comp claim payment,
checks for claims, etc.
Experience in data transformation and data loading to various target systems.
Developed APIs using Data Integration to enable a third party to trigger an ETL process.
Developed Data Integration Processes to call third-party REST APIs to load data.
Created swagger file using Informatica cloud.
Developed APIs using Application Integration to process JSON/XML payloads.
Tested the APIs using Postman and SoapUI.
Experience in SFTP/FTP file transfer, file copy, and file encryption/decryption in
Informatica Cloud.
Migrated ETL processes from IBM Datastage to Informatica Cloud
Migrated ETL processes from Informatica Power Center to Informatica Cloud.
Managed ETL migrations on various environments - Dev, Test, Prod.
Supported existing ETL processes in Datastage and Informatica Power Center.
Performed Unit testing by executing the SQL scripts and comparing the source with
target data and resolving issues if any.
Created and documented ETL test cases and validations.
Develop reusable integration components and transformation.
Modified existing mappings for enhancements of new business requirements.
Created Pre/Post SQL, Pre/Post process commands, and batch scripts in mappings and
mapping tasks.
Telefund June 2018 Aug 2018
BI Developer (Contractor)
Works as a BI developer to assist them in data migration. Responsible for creating Transformations
and Jobs in the Pentaho Data Integration tool to execute and test ETL processes.
Develop and optimize SQL queries, Stored Procedures, and Functions from on-prem ERP
system.
Develop ETL processes using Pentaho PDI to extract the data from various sources and
load it into the BI data warehouse.
Perform Data Extraction, Cleansing, Transformation, Integration and Data Analysis
Test the target SQL database once the loading is completed.
Nexgen Inc. March 2016 December 2017
Developer (Contractor)
Created and optimized database objects, including tables, views, stored procedures, and
triggers, while ensuring data quality and integrity.
Designed, implemented, and managed database systems and developed SSRS reports,
extracting data from the internal data warehouse.
Participated in the development and maintenance of Workday integrations using the
Workday Integration Cloud platform and assisted in creating reports for various
modules.
Collaborated with developers to test and validate Workday integrations, reports, and
custom applications, ensuring they met business requirements.
Worked with IT teams to ensure Workday applications were secure, stable, and
performant.
Scheduled and managed daily, weekly, and monthly sales and operational reports based
on business needs.
Engaged with offshore teams and participated in weekly meetings and project
walkthroughs.
Tech Mahindra September 2014 February 2016
Systems Engineer
Joined through campus recruitment and underwent training and certification in database
administration and data warehousing. Worked on projects for global clients, implementing,
configuring, and managing Oracle 10G in both internal and client environments.
ETL Testing
Client: Australian Telecom Service Optus
Collaborated with a team of five engineers to design, execute, and test ETL processes,
enhancing user experience through dynamic redistribution of roaming traffic.
Managed and executed data extraction, transformation, and loading (ETL) into Teradata,
handling projects independently from offshore under the guidance of an onsite lead.
Performed manual functional testing on telecom applications, creating test plans, test
cases, and test scripts.
Utilized HP ALM and JIRA to manage test cases and track defects in scripts and loading
processes, coordinating with developers to resolve issues.
Executed commands and ran scripts in Linux, preparing test data through database
queries and validating data transformations against business specifications.
Developed test scenarios in Teradata to ensure proper loading workflows and created,
tested, and executed macros.
Tested target databases post-loading and generated reports using Cognos ReportNet.
Documented QA processes and communicated updates to team members, actively
participating in weekly meetings and discussions with onsite leads.
Oracle Database Administration
Certified Infrastructure Support Professional for Red Hat Linux and Oracle Database
Administration.
Implemented, configured, and managed Oracle 10G and Red Hat Linux systems.
Installed Oracle RDBMS and applied patches, handled upgrades, backups, recovery, and
migrations.
Created database structures (tablespaces, tables, views, indexes) and
developed/modified SQL queries and stored procedures for QA and analysis.
Planned and executed database backup/recovery strategies while enforcing security
measures.
Administered database objects and controlled user access, including creating new users
and assigning permissions.
Tools Administration
Client: Telkom, South Africa
Implemented, configured, debugged and administered CA Service Desk Manager (SDM)
in alignment with ITIL processes.
REFERENCES
Professional references provided upon request
|
