Home

Nagarjuna Chilukuri - Lead Business Data Analyst

[email protected]

Location: Overland Park, Kansas, USA

Relocation: Yes

Visa: H1B

Nagarjuna Chilukuri [email protected] +1 614-573-5583 Professional Summary: Accomplished Business Intelligence/Data Warehousing professional with around 8 years of experience in Oracle BI Apps, specializing in data transformations and reporting. I am a highly skilled Business Development Analyst with 5+ years of experience in mining complex data structures, developing fundamental metrics, and supporting business analysts with reporting and demonstrating skills being a business development analyst. Proficient in Informatica, OBIEE, SQL, DAC, and Active Batch, ensuring seamless implementation and optimization of BI solutions. Skilled in Agile Scrum methodologies, facilitating efficient project management and adherence to SDLC protocols. Proven record of accomplishment of on-site engagements in the U.S.A., facilitating business requirement gathering and coordination between offshore and onshore teams for seamless project delivery. Supported business analysts with ad hoc data analysis projects & reporting by providing timely and accurate data analysis, contributing to enhanced decision-making processes, and demonstrating strong time management and problem-solving skills. Hands-on experience in Qlik View to Power BI migration, leveraging Azure Data bricks for streamlined transitions and data processing. Extensive expertise in Oracle Informatica Power Center Repository Manager, Designer, Workflow Manager & Monitor, ensuring robust project workflows and monitoring. Proficient in creating mappings with reusable components and leveraging diverse transformations for data enrichment and accuracy. Extensive experience in dimensional modeling techniques such as star schema and snowflake schema to design efficient data warehouse structures that support OLAP (Online Analytical Processing) queries. Implemented Slowly Changing Dimension (SCD) techniques within Informatica PowerCenter mappings to handle dimension table updates, inserts, and historical data tracking, maintaining data consistency and accuracy. Expertise in OBIEE, encompassing Data Source Creation, RPD Creation, Dashboard, and Reports Creation, optimizing insights delivery. Strong analytical skills in analyzing Oracle functionalities and implementing custom RPD development using RDBMS best principles. Experience in designing and implementing complex data models and database schemas using Oracle Database Management System (DBMS) concepts, such as tables, views, indexes, and constraints. Skilled in performance tuning and optimization techniques, including query optimization, index tuning, and database partitioning, to enhance the efficiency and scalability of Oracle PL/SQL applications. Proficient in using Oracle's built-in functions, data types, and control structures to manipulate data, handle exceptions, and implement business rules effectively within PL/SQL code. Proficient in crafting and executing both Data Definition Language (DDL) and Data Manipulation Language (DML) statements within Oracle SQL Developer using PL/SQL, ensuring efficient database management, schema design, and data manipulation. Skilled in designing and developing database solutions using Oracle SQL, including creating tables, defining constraints, and implementing data integrity measures to maintain the accuracy and consistency of stored data. Experienced in utilizing SQL queries to filter, aggregate, and analyze data sets, employing advanced functionalities such as joins, aggregate functions, and views to extract valuable insights and meet project specifications effectively. Experienced in designing and developing intuitive and visually appealing dashboards in OBIEE, displaying key performance indicators (KPIs), trends, and insights to support strategic business analysis and monitoring. Experienced in automation tools like DAC & Active Batch, driving operational efficiency and scalability. Proven record of delivering modules related to Banking Financials like Mortgages, Dealer Flooring, Forex Rates, and more, with meticulous attention to detail and quality. Project management experience includes leading cross-functional teams, analyzing data points, and ensuring thorough data validations. Versatile in handling multiple applications through Azure Analytics service, Azure Data bricks, and SQL endpoint, facilitating seamless integration and performance. Proficient in utilizing Oracle SQL Developer tool to design, develop, and debug SQL queries, scripts, and stored procedures, ensuring adherence to database standards and best practices. Expertise in data modeling using AWS Redshift DB, supporting Tableau reporting needs and enhancing data visualization capabilities. Proficiency in Azure technologies, including Azure Data bricks and Azure Analytics service, enhancing cloud-based data processing, and reporting capabilities. Utilized Azure Data bricks to streamline QlikView to Power BI migration process, ensuring efficient data transformation and integration. Adept at coordinating with onsite teams, gathering requirements, and leading task force teams for successful project outcomes and client satisfaction. Committed to continuous improvement through knowledge transfer sessions and ongoing professional development, staying abreast of industry trends. Proven ability to meet fiscal bottom-line results through effective project management and exceeding customer expectations. Attained Tableau Desktop Specialist Certification, enhancing proficiency in data visualization and analytics. Recognized with multiple Distinguished Performer of the Quarter awards for exemplary dedication and contributions to project success. Keywords: access management business intelligence database active directory procedural language