Pramod Kumar Email & Phone Number

Washington, Dc, Us

Washington D.C. Metro Area

• Creating automated web traffic projections and constant tracking of its performance using web Analytics, Time-series Analysis and Regressions and other statistical predictive methods• Develop a deep understanding of business data-sets through a combination of database queries, and exploratory statistical analysis using tools like (SAS, R, etc.) and visualization in Tableau• Design and develop a Revenue forecast model for Display Ads (Programmatic and direct) which bridges the gap between Business and Finance and assist the financial budgeting and regular forecasting cycles• Define, track, and provide key insights on performance indicators for the various business units within the AOL.• Provide business modeling, analysis and valuation support for new product development and marketing campaigns.• Data mining using Machine learning methods• Extending company’s data with third party sources of information when needed• Provide analytic support by assisting business units with accessing and analyzing data to inform strategic and tactical decisions.• Drive operational and process efficiencies through automation to minimize manual reporting

Revenue Management – Data Warehouse and Pricing Portal.● Revenue Management project is used for accurate forecasting of occupancy, lease starts and lease expiration, pricing, revenue premiums, optimal rents are controlled through management business rules, the system can deliver optimal rents each day. ● Involved in dimensional data modeling, creation of analysis cubes and report generation for pricing portal. ● Involved in extracting data from multiple relational OLTPs using ETL packages, writing SQL queries and web services for data integrations using SQL Server / ASP.NET.● Analyzed the historical and current data of the first clients to implement Revenue Management. Real Time Integration. ● Property Solutions has a robust real time integration with third party property management software keeps the property information on website updated automatically. The complete payment solution including online options for eCheck, credit card, check scanning, and cash payments. The lead sources, unit availability, floor plans, pricing, amenities, and property info pull from third party PM software and guest cards, applications, and online payments are posted too. Real time integration eliminating the data entry.● Analyzed third party property management software and its relational databases for integration.● Designed and exposed web services for data integration between source and target databases, e.g. porting data from SQL server to PostgreSQL.● Coding, code review, code optimization, performance tuning and troubleshooting the production issues.

● Worked as a software engineer, developed and supported numerous .Net based business critical applications: HealthCare Exchange, Reports Browser, and Karma.● Wrote SQL scripts and stored procedures for weekly and monthly data upload, and report generation.● Instrumental in implementing business logic using C# and SQL Server, bug fixing and minor enhancements in the application.

Master'S Degree, Management Information Systems, 3.85

Activities and Societies: MIS Club

B.E., Computer Science, 3.7