Pradeep Kumar

• Installed, configured, tested and maintained Informatica PowerCenter software.
• Responsible for reviewing and understanding requirements and translating them
• Responsible for building of data mappings, sessions and workflows to meet requirements
• Responsible for development of job schedules that integrate the upstream and downstream
systems using Control-M.
• Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy
Accountable for on-time delivery of all documentation, design, build, testing, and deployment
• Working with production support teams as required to support production activities, including
production migrations, continuity testing, environment migration activities
• Impeccable written and oral communication skills in framing mapping documentation
level
• Documentation capturing, maintained, understood by and available to business

• Investigated and addressed system issues to enhance usability and improve functionality.
• Mentored junior team members, providing educational expertise on technical concepts and ETL tools
• Evaluated and adopted new technologies to address changing industry needs.
• Held final responsibility for architecture, design and implementation of company-wide platforms and applications.
• Successfully implemented POC for processing HL7 format data via Informatica Developer client and did perform review on TCO with existing traditional approach.
• Individual contributor for technical solutions and reviews of vendor technical documents and codes for C3 Application.
• Conducting Reviews for all technical related data documentation, including data dictionaries, data lineage, and data flow diagrams, enhancing understanding and accessibility of organizational data assets
• Demonstrated ability to collaborate with cross-functional teams to analyze Cloud Migration requirements and design efficient solutions using Java and microservices
• Developed features along with cross-functional teams, including DBA, ETL team, business analyst to understand requirements and design architecture to meet requirements
• Managed Operations for go Live systems and analyzed incident logs and proposed areas of improvement to various Ops leads
• Chaired Weekly Technical meeting with vendor to review proposed solution, standardizing review process. New Phase development design review.
• Analyzed Change request and bug fixes Proposed solution review and secure endorsement from management.
• Actively contributed by liaising with Multiple ETL vendors(Informatica IDMC,Talend, to propose matching product both in terms of cost and features.
• Performed evaluation and selection of data management technologies, such as databases, data warehouses, and cloud-based platform
• Investigated system issues and implemented resolutions to reduce downtime.
• Offered input on technical and platform-related strategic planning initiatives.
• Provided educational expertise and mentoring to junior team members.
• Drove technical initiatives for large enterprise systems to align with long-term business strategies.
• Advised management, business and technical staff on solutions using specific domains or technology.

• Recommended data standardization and usage for protection of data integrity.
• Designed and developed schema data models.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Analyzed raw data to build logical business intelligence model for near to real time reporting needs.
• Developed tables, views and materialized views using SQL.
• Documented business workflows for stakeholder review.
• Participated in requirements meetings and data mapping sessions to understand business needs.
• Compiled, evaluated and reviewed engineered data for internal system.
• Trained employees on software to improve data management, monitored use and suggested improvements.
• Design, development, and implementation of overarching business intelligence solution with Big Data cluster as backend.
• Hands-on people manager solving BI problems while also enabling team through prioritization and project management
• Collaborate with Big-data Engineers on Design aspects of architecture in terms of Semantic Layer.
• Provided technical leadership and mentorship to junior team members, fostering collaborative and innovative data-driven culture
• Mentoring and providing guidance to junior members of BI development team.
• Worked with business intelligence software and various reports to glean insights into trends and prospects.

• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Trained and mentored junior developers and engineers, teaching skills in code deployment and working to improve overall team performance.
• Improved system performance by making proactive adjustments and resolving bugs.
• Led software development initiative as subject matter expert and primary point-of-contact for project management staff.
• Collaborating with project managers, development teams, and stakeholders to understand deployment requirements and objectives.
• Creating a deployment plan that outlines the necessary steps, timelines, needed for successful implementation.
• Setting up the required infrastructure and environments for deployment, including servers, databases, networks, and software configurations
• Configuring and managing version control systems and deployment tools to ensure efficient and reliable deployment processes

• Led identification of process improvements and changes to methodology based on project experience.
• Demonstrated consulting-based leadership experience on specialized projects and displayed overall knowledge of information systems.
• Hands-on operationalizing Hadoop and its ecosystem to solve business problems for our large Retail and banking and telco Clients.
• Interact with stakeholders in various Big Data initiatives, understand the Data needs and define Data Services product requirements
• Provide consulting to customers in identifying Big Data use cases and then guiding them towards implementation of use cases.
• Senior Developer handling a team Bigdata CoE team on different Big Data Solutions/PoCs for multiple customers and verticals.
• Have hands-on expertise on Installing Various Hadoop distributions.

• Explained technical information in clear terms to non-technical individuals to promote better understanding.
• Responded to support requests from end users and patiently walked individuals through basic troubleshooting tasks.
• Assessed system hardware and software and suggested modifications to reduce lag time and improve overall speed.
• Served as primary point of contact for support relating to owned solutions and products.
• Analyzed Sev 1 issues to identify troubleshooting methods needed for quick remediation.
• Performed root cause analysis of reported issues to decisively discern and enact corrections.
• Followed up with clients to verify optimal customer satisfaction following support engagement and problem resolution.
• Worked with software development team on reported errors and bugs on newly released software and assisted in deployment of release fixes.

• Developed databases, programs and processes for integration and implementation across enterprise.
• Created and implemented development strategies for impactful projects.
• Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues.
• Gathered and defined customer requirements to develop clear specifications for project plans.
• Trained new developers and programmers on company standards for design and review.
• Designed and documented systems based on results of analysis.
• Analyzing UV and Error cases, raising a CIA (Change Impact Analysis) after brainstorming with source system and various Warehouse analysts.

• S29/27 MAS Report design integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and Manual feeds.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Interpreted data models for conversion into ETL diagrams and code.
• Participated in coding advanced Teradata utilities FastLoad,MultiLoad, excelling at writing views and procedures for achieving ETL requirements.
• Responsible for analyzing information from source team. attending review meeting with Data Management Team.
• Created Sunopsis loading and transformation packages to bring the data into EDW.
• Created Teradata views to load the data mart tables as per the report requirements.
• ELT Developer and Tester for upstream and downstream.
• Involved in development of Sunopsis Packages, interfaces and scenarios to fit in the business requirement.
• BASEL & Islamic Sources extraction from Oracle using Datastage Jobs.
• Writing test scripts for various knowledge module.

• Prepared technical design documents and specifications for ETL Development.
• Implemented business logic parameters for FSLDM execution.
• Collaborated with business analysts to understand and define requirements.
• Identified, troubleshot and corrected bugs and bottlenecks.
• Created Mappings to implement business logic.
• Developed complex source qualifier SQL queries for Mappings.
• Conducted quality checks for code to adhere with Client's Convention.
• Developing Informatica mappings and workflows for mainframe systems especially Treasury (MUREX) systems (TQSP, FASP, and TZSP) & Network Systems (NCSP).