Venkata Phani Pavan Kumar

Designing and implementing a cloud-based solutions on Informatica Cloud, Informatica PowerCenter, Snowflake, Qlik Talend, Azure Data Factory, IBM DataStage for North America, Europe & APAC clients
Collaborating with cross-functional teams to define and document system requirements
Collaborating with stakeholders to develop and implement a system integration plan
Working closely with project managers and technical leads to finalize resource planning in design, development, testing and implementation
Evaluating technologies and tools, leading to the adoption of a cloud-based infrastructure
Providing technical guidance and support to other teams

• Developed and implemented performance improvement strategies and plans to promote continuous improvement
• Increased customer satisfaction by resolving issues
• Fine tuning Informatica Workflows and Oracle conditions to reduce existing timelines
• Resolved problems, improved operations and providing exceptional service
• Working with cross functional team to get expected results on time and improve comprehensive credit report

• Collaborating effectively with regional managers, alliance managers and business leaders for successful proposal document
• Evaluated customer impact risk, reputation risk and regulatory risk
• Implementation of POC documents and creating presentations for demo use cases
• Developed suggestions for technical process improvements to optimize resources
• Using established tools and best practices to improve overall writing quality and efficiency
• Walking through on demo use cases to vendors and clients
• Creation of write-up's on solution architecture, technology capabilities
• Contribute to continuous performance and quality improvement efforts for proposal process
• Manage proposals to ensure deadlines and quality standards are met
• Ensure consistency, completeness and accuracy of proposals and estimates
• Proficient in design and layout

• IICS CDI design analysis and creating Data Mapping documents.
• Hands-on in IICS CDI and can create complex mappings.
• Prepared status charts for daily management meetings in Excel and PowerPoint.
• Assisted product owners with prioritization of backlogs.
• Communicating with cross-functional teams, technology leaders across analysis, architecture, build, quality assurance, deployment and support teams on project execution.
• Managed implementation of new technological improvements resulting in increased efficiency.
• Reaching clients to gather and understand requirements and coordinating with system administrators and directors to plan and schedule project activities.
• Gathered requirements and maintained communication between project teams, internal clients and external stakeholders.
• Recruited and trained team members.

• Analyzing requirements and designing Data Mapping for ETL framework
• Handled importing of data from various sources, performed transformations using Pig and loaded data into HDFS and Extracted data from MySQL into HDFS using Sqoop.
• Experienced in implementing different kind of joins to integrate data from different data sets like Map and reduce side join.
• Pushing source data to Staging Area using Informatica cloud
• Extracting data from UNIX file system to HDFS.
• Creating rules for data profiling using IDQ
• Developing mappings and rules using different transformations like Parser, Address Validator, Key Gen and Match.
• Design logic using Mapping Document and load data
• Unit Test Data and send it for User review
• Creating Migration Document and assign tickets for migration
• Mapped processes to holistically examine business flow and identify improvement opportunities
• Supported and aligned efforts to meet business and customer needs
• Managed customer relations by developing effective communications process

• Obtained, organized and developed training procedure manuals, guides and course materials
• Organized daily/weekly/monthly loads and ensured appropriate process to provide optimal service
• Periodic inspections over long running jobs and provided optimal performance tuning for better execution
• Prepared documents, such as knowledge base, error handling techniques and performance tuning optimal solutions to team
• Set overall vision and provided team leadership
• Implemented variety of process improvement initiatives by establishing performance goals
• Performed ad hoc deep-dive analysis for specific problems

• Developing Informatica mapping as per the requirements
• Parameterizing mappings and increased re-usability
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle delta Loads
• Creating Test cases for mappings developed and then creating integration Testing Document and Unit Testing requirements
• Migrating code after all requirement checks
• Creating Technical Design Documents after go live
• Participated in project meetings, transcribed meeting minutes and tracked project statuses
• Coached new employees on functional procedures, project policies and performance standards

• Implementing new Informatica mapping as replica of old design with new changes
• Understanding business requirements and schedule recurring meetings with clients for sprint planning and progress
• Testing end to end OBIEE reports
• R&D of Informatica Cloud installation and execution process
• Troubleshot issues, diagnosing root cause and coming up with effective solutions
• Participating in Unit testing and creation of Test case documents
• Streamlined installation process for entire department by implementing methods and reducing bottlenecks
• Determined areas for improvement and implemented processes to alleviate problems

• Configuring Data Quality checks for track data like Adjustments, Security, Financial Attribution, Reference and Parameter Data, CDS and iHub
• Configuring additional PL/SQL Procedures/Functions as part of custom DQ processing
• Configuring Data Quality Groups to execute the checks
• Configuring batch using OFSAA Data Quality batch framework to execute Data quality groups housing DQ checks
• Inserting test data in database tables as part of DQ Validation
• Testing Dashboard reports
• Resolving issues and problems arising during project execution
• Improved performance, hiring practices and management systems to facilitate success of client's organization

• Creating Stage, Dimension and Fact table structure in the database
• Developing Informatica mappings, sessions and workflows
• Unit Testing and Functional Testing
• Scheduling Informatica workflow using Control M
• Documentation of ETL Process
• Participating in client meetings regarding upcoming project sprints
• Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements
• Worked with project managers, developers, quality assurance and customers to resolve technical issues

• Creating Mappings using various transformations like Lookup, SQL Transformation, Router, Joiner, Aggregator and Expression
• Tracking partner by partner information regarding file name and field name changes
• Trained on Informatica B2B Data Exchange and exploring files to format them as per the requirement
• Documentation of errors and their resolutions
• Resolving UAT and Production Issues
• Unit testing and Functional testing
• Conducted regression testing, analyzed results and submitted observations to development team