Description
Summary * Possess 12 years of experience in Software Engineering in technology, Architecture & service stream * Expertise in Informatica Power Center, Power Exchange and Data Transformation, and Reporting and Data Modelling * Expertise in end to end Business Intelligence technical, process and delivery * Strong knowledge in Informatica Master Data Management and Data Quality * Expertise in data modelling for BI and Customer MDM application * Experienced in leading Master Data Management (MDM) initiatives * Skilled in all SDLC phases including design, coding, testing, implementation & support * Showcased polished leadership skills and actively motivated team & individuals * Experienced in developing BI strategy and roadmaps, and setting up BI Competency Centers * Broad understanding of the Kimball, Inman, and hybrid methodologies * End-to-end data warehousing experience across full SDLC from inception to deployment. * Ability to effectively lead, build, deliver, and execute complex global BI initiatives. * Extensive experience in writing UNIX shell scripts and automation of ETL processes using shell scripting. Written number of shell scripts to automate the manual process. * Extensive experience in developing Stored Procedures, functions, views and Complex SQL queries in ORACLE. * Used agile development methodologies such as Scrum and involving in Daily Scrum, Sprint Planning and Sprint Review Meetings. * Designed and implemented BI solutions that lowered operating costs by $500K annually by providing timely access to actionable data for production control executives and leaders in auto manufacturing. * Work along with enterprise architect group establishing enterprise initiatives, standards in areas including solution, data quality, and data security. * Ability to quickly assess, learn, integrate, and apply new technologies to market and customer requirements and for driving project goal attainment and business development expansion. * Designed, developed and implemented complex BI solutions & Reporting for various domains (Customer Data Automobile, Finance, Compensation planning, and Vehicle Accounting) * Designed and developed Data Model, Cubes in AtScale and presented data in Tableau, Power-BI and Excel Reporting * Expertise in performance tuning in data load, business data process, queries and in reporting. Executed sub second results in Tableau, Power-BI reporting for 800 million plus data * Developed and implemented active adhoc reports in Hyperion for Vehicle Accounting to perform 360* degree cost and revenue analytics to close monthly Accounting books and to find revenue leaking on various financial stages * Developed and implemented Reconciliation reports with source data and BI layer after every single financial batch load process to identify data issue. Subject Matter Expertise Technical and Agile Project execution, Business domain knowledge including BI Analytics, RFPs, Business Cases, architecting Customer Automotive, Manufacturing, Self-service BI, Traditional ETL / BI Technical solution Presentations Accounting, Finance and Hybrid model, Industry trending tools (ETL/BI), Big Data Software and Systems Integration execution and Scrum master
Accomplishments
Highlights:
Keywords
