Hello Everyone, I would like to present the consultant currently available, It’s my pleasure to work with you. I would love to partner up and work on C2C requirements on a daily basis, Please share your requirements to Email: – pavan@paramountsoft.net or Call on 770-456-5348. Rajesh Skillset in brief:- Professional Summary:- - Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
- Good team player, strong interpersonal and communication skills combined with self-motivation initiative and positive attitude.
- Working in the latest technologies like Snowflake, Snowpipe, Data Base Tools (DBT), AWS S3.
- Worked on Oracle Database supporting OLTP and Data Warehouses.
- Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
- Strong experience with Informatica tools – Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
- Created worklets by grouping different sessions related to a subject area.
- Have knowledge about the Informatica PowerExchange.
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
- Developed effectively different type of SCD’s based on the specifications.
- Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger project.
- Successfully co-coordinated for the project activities in offshore/onsite model with a team of 12 members.
- Experience in interacting with onsite clients while being responsible for deliverables.
- Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
- Quick to learn.
- Working in Agile environment.
- Handle the work independently.
- Had a good knowledge and completed training in Oracle Data Integrator (ODI)
- Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
- Good in Onsite-Offshore work co-ordination.
- Organizing timely meetings with Business and other teams, then sharing the MoM based on the meeting outcome.
Professional Experience: Client: MRC Global, Houston, TX 01st Nov 2021 – Till Date Role: Senior Data Engineer Description: MRC Global is the largest distributor of infrastructure products and services to the energy industry, based on sales. Through approximately 260 service locations worldwide, and with nearly 100 years of history, MRC Global provides innovative supply chain solutions and technical product expertise to customers globally across diversified end-markets including the upstream, transmission & gathering, gas utilities and downstream (including industrials). MRC Global manages a complex network of over 200,000 SKUs and 10,000 suppliers simplifying the supply chain for its over 14,000 customers. With a focus on technical products, value-added services, a global network of valve and engineering centers and an unmatched quality assurance program, MRC Global is the trusted PVF expert. Responsibilities: - Discuss with Business users to understand their current requirements
- Analyze the list of existing workflows at each subject area level.
- Prepare the technical design documents.
- Estimate the efforts (in terms of hours) based on the tasks assigned to team and guide them accordingly.
- Design and develop new workflows wherein the functionality were not incorporated in existing code.
- Purge a part of the existing code that is not required anymore and enhanced where needed.
- Used Informatica Cloud to extract the data from Salesforce to Oracle database.
- Track the issues and work on them on priority issues.
- Pull the data from different sources like Salesforce, flat files, and load into Azure database.
- Tune the workflows that are having performance issues by taking the statistics from the production environment.
- Created PL/SQL procedures in the instances wherein PL/SQL works much more efficiently than IICS.
- Prepared the test cases and got the sign-off from Business.
- Created deployment groups and migrated the code from Dev to QA environments
- Performed the unit testing and integration testing as per test cases.
- Involved Business wherever needed and got necessary approvals by contacting various teams (like Business users, Informatica Admins, Change Management)
- Deployed the code to Production following the process from end to end.
- Update the Business and Managers about the timely status of work completion and projected timelines.
Technologies used: IICS, Snowflake, Salesforce, Python, Azure database |
