VIJAY KUMAR

Dedicated and disciplined IT professional, seeking a competitive and challenging position in ETL and Report developing through different tools with SQL as basic Language to contribute to the company growth and in turn ensuring personal growth within the organization.

• Farmers Insurance (US), 07/2024, Till Date, Working on Informatica PowerCenter to enhance mapping and workflows to Load staging, Dim and Fact Snowflake tables From Mainframe Tables. Working on Snowflake for Analyzing different SQL Scripts and Enhance According to the Changes Required. Working on IBM Data Studio in DB2 Databases. Using Service Now for Raising Incidents for any failures and resolve them on Priority Basis. Using Rally Tool for User Stories, Task and Estimate Updates for Each Sprint.
• Prudential Financial (US), 08/2021, 06/2024, Worked on Informatica PowerCenter to develop and enhance mapping and workflows to Load staging, Dim and Fact tables with the help of raw files. Worked on Informatica PowerCenter to Transfer files From Locally generated target file to remote server through Cyberfusion Unix process. Worked on Informatica B2B Exchange for Scheduling, Parameterization and automation of workflows. Developed and enhanced the SQL procedures in MSSQL Server 2018. Created Releases for SQL procedure, Function or Any Script from Dev to Prod Through CI/CD Tool Visual Studio (TFS) which helps in syncing of code in All Environments.
• SOUTHWEST GAS CORPORATION (US), 01/2020, 07/2021, Worked on Informatica ETL tool for data enhancements. Worked on SAP HANA for creating calculation views, Stored procedure and creating SQL scripts for data quality enhancing. Worked on SAP BODS for automated data cleansing for increasing data quality provided by the client with usage of transformation like Query, Merge, geocoder, Address Cleanse, Table Comparison. Data Profiling Document and Each Job creation documents was prepared for future validation purposes. Done with Go- Live for the project by taking care all testing and development scenarios with zero defects.
• DOWJONES(US), 08/2018, 12/2019, Modified front end forms in sales Logix using VB Script as a coding language and SQL as database. Having strong knowledge on crystal reports and deployed the reports in the Application. Worked on IBM Cognos Analytics with EDW Datawarehouse to help in enhancing the already developed reports with working on Framework manager by creating business & presentation layer and to enhance reports and dashboards with drill through properties to check to see the other dependent reports as well.
• NISSAN IT(US), 07/2017, 07/2018, Developed Mappings in Informatica to load Data warehouse. Interacted with business users to understand their requirements and provide updates. Worked on the WFS (Wholesale Floorplan Lending System) which involved creation of many ETLs by using various transformation to bring in data from new WFS system via files.