Vikas Choudhary Email & Phone Number

Hyderabad, In

Hyderabad, Telangana, India

• Established, Led & Architect Data Integration & BI Team: Created and directed a new Data Integration & BI team, building the end-to-end BI solution from the ground up using Informatica, IICS, OBIEE, Oracle Analytics Cloud (OAC) & DAC.• Coordinated with Stakeholders and Partners: Conducted regular synchronization meetings with stakeholders, business units, and partners to ensure alignment with the project roadmap and timely delivery of project milestones.• Managed BI Projects and Resources: Oversaw the management of BI projects and resources, taking ownership of BI delivery from offshore locations. Ensured efficient project execution and adherence to project goals and deadlines.• Led and Mentored Team Members: Guided and mentored team members to enhance their capabilities in providing effective BI solutions. Fostered a collaborative environment to achieve optimal performance and solution delivery.• Architecting, Designed and Developed BI Solutions: Architected and developed BI solutions using Oracle Business Intelligence dashboards. Created insights into procurements, spend analysis, regulatory compliance, and asset tracking to support informed decision-making.• Optimized Data Integration and Executed Upgrades: Enhanced data integration processes to improve batch execution time by 50%, increasing system efficiency and availability. Proposed and implemented BI application upgrades in-house, achieving significant cost savings for the company.

• Sales & Marketing Customization: Established and managed the Sales & Marketing subject area, incorporating custom design, development, and testing of Prebuilt SDE, SIL using Informatica 8x, OBIEE RPD, and DAC.• BI Applications Upgrade: Led the end-to-end upgrade of BI Apps 7962 for Sales & Marketing Analytics, integrating new features to enhance dashboards and reporting capabilities.• Data Integration Configuration: Customized and configured DAC to implement change data capture, facilitating incremental loads while enforcing full loads as needed.• DW/BI Environment Optimization: Optimized the DW/BI environment by refining the Person Dimension, including dropping unused tables, indexes, partitioning, and tuning queries to reduce ETL batch execution time.

• ETL/BI Development and Data Modeling: Developed and enhanced existing data warehouse integrations using Informatica 5x and Business Objects for various functions, including Customer, Call Center, Billing, and Cash Collection, while building new data marts, such as Property Management, to track occupancy status.• Stakeholder Coordination and Requirement Gathering: Collaborated with stakeholders and third-party partners during a visit to the UK for requirement gathering and user acceptance testing (UAT), facilitating high-level and detailed design processes and ensuring design reviews received necessary approvals.

Btech, Computer Science & Engineering

Data Structure & Algorithm, C, C++, Theory of Computation, Databases, Applied Mathematics, Operating Systems, Systems Programming etc

Education record