Krishna Kottapalli Email & Phone Number

Houston, Tx, Us

Pittsburgh, Pennsylvania

𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 -❖ Serve as Senior BI Consultant, responsible for analysis, architecture, design, and development of ETL, data warehouse, and business intelligence systems.❖ Design, build and test data warehouse architecture, and ETL solutions. Work closely with other ETL / BI Developers and Business Analysts to convert business requirements into optimized solutions.❖ Collaborate with business users to understand business processes, gather business requirements, evaluate concepts, and present solutions.❖ Support company’s suite of DW applications, interfaces and batch schedules. Develop multiple high level tableau dashboards per business requirements.❖ Maintain a high level of data quality and work with internal customers to ensure timely resolution of incidents and data issues.❖ Ensure that best practices are met and maintained with adherence to the SDLC.❖ Provide design recommendations, develop application and custom integration solutions, including major enhancements and interfaces.❖ Keep up to date with industry trends with regards to Business Intelligence, Reporting & Analytics, Data Warehousing, and Big Data.

𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 -❖ Involved in end-to-end implementation of Data warehousing projects, which include business requirements gathering, analysis, system study, prepared functional & technical specifications, design (Logical and Physical model), coding, testing, code migration, implementation, system maintenance, support, and documentation.❖ Delivered an ETL solution to summarize the curtailments, FCC and plan data from various sources. This solution eliminated the laborious manual process for Daily Sales Volume reporting.❖ Worked together with the Infrastructure and DBA teams to configure new hardware, build new databases, and restructure architecture to upgrade the GDW.❖ Collaborated with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.❖ Mentored the team to install, configure and upgrade the Informatica Power Center from 9.1.0 to version 9.6.1 and from 9.6.1 to 10.2.❖ Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from DB2, Oracle, SQL Server, Flat files and XML files to load into Staging, ODS and Data warehouse.❖ Reviewed and analyzed functional requirements, mapping documents, assist in problem solving and troubleshooting. Managing the transformation, delivery, and exchange of data between both internal and external business systems across all business units - Upstream, Downstream.❖ Performed audit on ETLs to validate source data Vs target table loads. Developed Complex TSQL scripts to do data transformations and integrated them with Informatica programs.❖ Created the efficient Cognos framework packages and trained the Business Users to develop the Adhoc reports by using Cognos Advanced Work Space tool.❖ Established Batches and sessions to schedule the loads at required frequency using Tidal Scheduler.

𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 -❖ Architected and implemented an ETL solution to support the Safekeeping project which provides custodial services such as settlement of book entry and physical securities through JP Morgan as a custodian.❖ Designed and developed an ETL framework to create multiple in-bound and out-bound interfaces between a new system Polypaths and existing systems to support fixed income portfolio analysis and risk management.❖ Developed full SDLC project plans to implement ETL solutions and identify resource requirements. Performed an active, leading role in shaping and enhancing overall ETL Informatica architecture.❖ Conducted impact assessment and determine the size of effort based on requirements.❖ Identified, recommend, and implement ETL process and architecture improvements. Assisted and verify the design of the solution and production of all design phase deliverables. Introduced the process to migrate the Informatica objects through Deployment Groups.

𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 -❖ Architected and implemented an ETL solution to support the Safekeeping project which provides custodial services such as settlement of book entry and physical securities through JP Morgan as a custodian.❖ Designed and developed an ETL framework to create multiple in-bound and out-bound interfaces between a new system Polypaths and existing systems to support fixed income portfolio analysis and risk management.❖ Developed full SDLC project plans to implement ETL solutions and identify resource requirements. Performed an active, leading role in shaping and enhancing overall ETL Informatica architecture.Conducted impact assessment and determine the size of effort based on requirements.❖ Identified, recommend, and implement ETL process and architecture improvements. Assisted and verify the design of the solution and production of all design phase deliverables. Introduced the process to migrate the Informatica objects through Deployment Groups.

Atlanta, Ga

Sr ETL Developer

Hyderabad Area, India

Hyderabad Area, India