Kiranmai Maddula Email & Phone Number

Atlanta Metropolitan Area

Greater Atlanta Area

Greater New York City Area

- Effectively interacted with the end users for requirement gathering and defined requirement specifications document.- Organized meetings with Business users and Management to analyze the KPI's, reporting data levels and gaps.- Created a project plan with task categorization high, medium and low gaps with timelines.Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.- Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA- Worked in creating Autosys jobs- Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins- Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.- Created customizations in Informatica, Data Warehouse, RPD and in Dashboards- Created Reports and Dashboards based on User specifications.- Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.- Experience working on some Volcker reports based on Volcker rules.Working on implementing data level and object level security based on the requirements.- Helped refine and determine feasibility, correctness, and completeness of end-user's requirements- Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards- Worked on POC on Tableau to explore the features- Prepared and/or review monthly, quarterly and annual corporate and legal entity data (financial statements, board report data, management reporting packages.Took ownership of the month end close process (where assigned) by reviewing and resolving any exceptions to general ledger identified through financial analysis

- Gathered Report Requirement and Specification from the Business.- Performed Unit testing on the Data and customized the ETL & OBIEE to cater to the Clients Business operations.- Designed their custom reporting structure with few new Star schemas for their custom Datawarehouse.- Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.- Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins- Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.- Create customizations in Informatica, Data Warehouse, RPD and in Dashboards - Created Reports and Dashboards based on User specifications.- Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.- Involved in designing multiple hierarchies and Time series measures- OBIEE Report Development and Architecture Skills

Technically involved with the team for all the critical issues. SPOC for all the project deliverables from offshore and proactively involved in improving the process and mentoring the team to the perfect track to ensure smooth execution of the project- Translation of business requirements to High level design, detailed level design and functional code- Design of Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins- Design of OBI Custom Schemas- Merging multiple repositories- OBIEE Report Development and Architecture Skills- Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables- Assisting ETL team in functional understanding and design- Mentoring fresh resources in the project

- Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence - As a Project Manager and played critical role in the planning, scheduling, monitoring and execution of projects to support of business objectives for different clients in financial domain- Provided complex data structures, dashboards and ad hoc reporting- Proactively involved in modifying the existing design model- Worked with SQL Server SSIS Packages- Worked on automation of Score card report data - Developed various Ad Hoc reports for business- Worked on resource management, invoicing data and other management activities- Worked on EIM jobs for data manipulation