Manoj Kumar Email & Phone Number

San Jose, Ca, Us

San Jose, California, United States

Seasoned Manager of Business Intelligence with expertise in managing Salesforce, Microsoft Navision, Informatica, and other BI applicationsProven track record of successfully leading strategic planning and execution of BI and analytics initiatives resulting in increased revenue and cost savingsEstablished and maintained strong partnerships with key stakeholders to ensure BI and analytics initiatives are aligned with overall business objectives and meet organizational needsPossess strong communication and leadership skills, effectively managing cross-functional teams and driving initiatives forwardTechnical expertise in managing the entire data integration fabric, including internal and external integrations, master data management, on-demand data loads, disaster recovery, and analytical on-demand reportsSuccessfully led cross-functional teams to ensure BI applications are aligned with overall business objectives and meet organizational needsProven ability to effectively manage vendor relationships and work with third-party providers to implement and support applications, including negotiating contracts and ensuring vendor solutions align with organizational needsPassionate about leveraging data and analytics to drive business growth and innovation

San Jose California

Drive and Own Financial and Predictive Analytics Reports involving requirements gathering, collaborating with cross-functional teams to source data and understand workflow, and developing automated dashboards, and data visualizations in tools like Tableau, SQL Server Reporting Services (SSRS).Implemented Revenue recognition 606, created VSOE, BESP, and FV report. Design and developed Contribution Margin report for FPA department. Automated Financial Reports, created recon reports, developed programs to monitor the health of the replicated environment and created alerts to report inconsistencies. Designed and developed GL Reports (P&L, Balance Sheet, Consolidated P&L and BS, BS and PL recon Reports, Trial Balance) and other variation of the base reports. Design and developed Revenue dashboard, revenue recon reports and revenue forecast and trajectory reports.Design and developed Predictive analytics reports for Proactive Support Department. Document techniques and train team members on self-service reporting. Design and developed the Data staging and Data Mart for Finance team, Implemented SQL Server transaction replication to replicate production ERP data to Stage.

Santa Clara, California Area

Designed and Developed ETL Packages for DSNOP project, Marketing Dashboard for Top management and System reconciliation reports for Product Team.

Kuwait

Orchestrated the ETL design, defined standards, Lead the team of ETL Developers, developed the utility programs, defined the database service programs, Integrated systems and generated the system reconciliation reports.Defined the ETL development standards (naming convention, Configuration Design, Deployment and TFS Structure).Architected framework for managing incremental ODS data load on daily transaction data tablesDesigned various Data Marts for National Bank of Kuwait Finance Team (GL Mart, Loan Mart, CBK Mart, IVR Mart) Developed ATM to Base24 to Core Banking System Reconciliation program to help ATM support team to Manage ATM cash and incomplete transactions.Implemented data integration program (Ci-Net) between the National Bank of Kuwait and the Central Bank of Kuwait.Integrated Fair ISAAC Debt Manager with Core Banking System. Developed customer portfolio/profitability database utility services for the internal CRM System.Developed Modules for external customers to get the respective transaction feed to automate the Bank to customer integration. Migrated Trans24 data to the Base24 system.Developed a dynamic stored procedure to load CRM unstructured data to ODS. Designed and implemented database objects repository management through TFS Developed ETL packages audit and monitoring framework.Created jobs, SQL Mail, Alerts and schedule SSIS Packages using $Universe and SQL Server Agent.Created ODS Documentation for support and helpdesk team.

Design and Development of Marts and Cubes.Design and Development of ETL Packages.Implementation of Industry Standards and Best practices. Define Standards and Policies for DevelopmentBusiness Requirement gathering and Transformation of Requirements into Technical Specifications for Development.Design and Development of Template Packages for RAPID ETL Development.Migration of existing Data warehouse Solution from legacy system to new one andSupport and maintenance of the existing projects.

Developed In-House ERP (SmartERP) GL Module, worked on ERP initialization setup scripts, developed data migration programs to import client data to ERP. Designed and Developed Financial Reports module of ERP.Developed a web-based Program (ExchangePlus) for Currency Exchange Company. Kalsoft Company being a premium Microsoft Certified Gold Partner, the Kalsoft got the opportunity to train other Gold partners staff on new tools and technologies so part of that campaign I got an opportunity to train Microsoft Gold Partners on SQL Server 2005.

Master'S Degree, Computer Science, A

Mcs, Computer Science

Artificial Intelligence Database Theory of Computer Science and Automata Computer Architecture Operating System Data Structure Algorithm.

Bcs, Computer Science