V L Srinivas Kapilavai

Project: Risk Reporting & Group Functions (CEDA)

Environments: Azure, Scala, Spark, Parquet, Apache Kylin, Databricks

Description: Client started building reporting layer over data lake. Complexity of the project involves any query need to be sub-second response, implement security and all need to be driven from cloud.

• Architecting, Designing and implementing solution end to end
• Building Cuboids to provide sub-second response to different queries from Reporting layer
• Helping Team technically during development as well as lead them to grow both technical and business domains
• Optimizing developed spark code during project implementation
• Tuning & optimizing cluster resource utilization during processing
• Integration & testing the system to verify whether it matches the requirement
• Suggesting best practices of Spark & Ensuring code is not vulnerable
• Implementing security cell level
• Design & implementing frameworks / reusable components used across Data lakes.

Project: FinRisk Ware House & Denali (CT)

Environment: JAVA, Hadoop, MapReduce, HBase, Hive, Sqoop, Avro, Spark, Oozie, Control M, Autosys

Description: Client started off loading DW by augmenting Hadoop Cluster. As part of this project they want to build reusable utilities to ingest and transform across multiple source systems. Complexity of the project involves discreet systems to standardize ingestion & support required transformations and provide data for Machine Learning purposes.

• Architecting, Designing and implementing solution end to end
• Coordinating onsite & offshore day to day interactions
• Helping Team technically during development as well as lead them to grow both technical and business domains
• Optimizing developed spark code during project implementation
• Tuning & optimizing cluster resource utilization during processing
• Integration & testing the system to verify whether it matches the requirement
• Co-ordinate within the team members and monitor activities as per committed SLAs and plans
• Suggesting best practices of Hadoop Eco System & Ensuring code is not vulnerable
• Implementing security cell level
• Building CI/CD pipelines to improve overall productivity of team.

• Working on different RFP’s to come-up with solution architecture, estimations
• Suggesting best practices on Hadoop to different Customers
• Helping Team to develop technically on multiple Hadoop eco system components
• Mentor Team both Technical & Functionally
• Optimizing developed code during different projects implementations
• Involved suggesting best practices of Hadoop Eco System to team members.

Project: Storage Re-Engineering

Environment: JAVA, Hadoop, MapReduce, HBase, Hive, Sqoop, Avro

Description: Client started off loading DW by augmenting Hadoop Cluster. As part of this project they want to reduce cost involved with data marts by reducing the number of instances & providing faster access to data using In-memory store.

• Involved in cluster & project estimations
• Involved in architecting solution of Phase 1
• Involved in coordinating onsite & offshore day to day interactions
• Helping Team technically during development
• Optimizing developed code during project implementation
• Involved in the project documentation
• Involved in Integration & testing the system to verify whether it matches the requirement
• Co-ordinate within the team members and monitor activities as per committed SLAs and plans
• Involved suggesting best practices of Hadoop Eco System.

Project: Audience Measurement

Environment: JAVA, Hadoop, MapReduce, HBase, Hive, Sqoop, Oozie

Description: Belgacom started implementing Hadoop Cluster to identify the viewership information for TV Subscribers. Media creators have questions about whether they are reaching the right audience on the right device at the right time. Second-by-second household viewing data, harvested from millions of TV households, has the potential to revolutionize the way TV stations sell advertising, schedule programming and place on-air promotions. This data is huge and ever increasing with each passing second, a Big Data system is needed to understand and derive insights from this enormous data.

• Involved in cluster & project estimations
• Helping Team technically during development of MR, Hive, PIG Scripts
• Optimizing MR, Hive, PIG, HBase developed during project implementation
• Involved in the project documentation
• Involved in Integration & testing the system to verify whether it matches the requirement
• Co-ordinate within the team members and monitor activities as per committed SLAs and plans
• Involved suggesting best practices of Hadoop Eco System
• Involved in Integration & testing the system to verify whether it matches the requirement.

Project: Data Fabric

Environment: JAVA, Hadoop, Sqoop, Avro, Map-Reduce

Description: UHG willing to implement data warehouse on BigData platform. In future once data is available at single place they will be running Analytics on the same. And also all provisioning of data to different data warehouses will be achieved by Data Fabric itself.

• Involved in improving existing architecture
• Mentor Team both Technical & Functionally
• Co-ordinate within team members and monitor activities as per committed SLAs and plans
• Involved suggesting best practices of Hadoop Eco System
• Involved in Integration & testing system to verify whether it matches the requirement.

Project: Audience Measurement System

Environment: JAVA, Hadoop, Sqoop, HBase, Hive, Flume, PIG, Map-Reduce

Description: Telenet started implementing Hadoop Cluster to identify the viewership information for TV Subscribers. Media creators have questions about whether they are reaching the right audience on the right device at the right time. Second-by-second household viewing data, harvested from millions of TV households, has the potential to revolutionize the way TV stations sell advertising, schedule programming and place on-air promotions. This data is huge and ever increasing with each passing second, a Big Data system is needed to understand and derive insights from this enormous data.

• Involved in requirements study & Project estimation
• Involved in architecting solution
• Design & Develop map-reduce jobs to meet business requirements
• Mentor Team both Technical & Functionally
• Co-ordinate within team members and monitor activities as per committed SLAs and plans
• Existing Data Migration into Hadoop cluster
• Involved in project documentation
• Involved in Integration & testing system to verify whether it matches requirement.

Project: Master Use Royalty Upgrade

Client: Warner Music, London

Environments: Oracle 10g & 11g, ASP.net, Silver Light

Description: MUR, handles International Royalty between different affiliates of Warner Music or any 3rd Party companies. Existing Application is unable to process Royalty Statements for Sales reported from different distributional channels across world due to exponential increase in sales. During Process of Upgrade its planned to upgrade DB Character set. Using Agile Methodology this project is getting implemented to have smooth migration into new application.

• Determine and elaborate business user requirements
• Analyze existing data to drill into business requirement validation & suggest new approaches
• Improving Existing systems performance to make sure Royalty Statements are generated
• Design & Develop new Database to meet business requirements
• Re-design Business Process to improve the productivity
• Co-ordinate with in the team members and monitor activities as per committed SLAs and plans
• Existing Data Migration into new Upgraded Application
• Detailed Design Review, Code Review and Testing to ensure Zero Defect code deliverable.

Project: Data Warehouse – Migration of Distribution Channel to Arvato.

Environment: Oracle 10g

Client: Warner Music, London

Description: Warner Music UK, Physical Products distribution has been switched from Cinram to Arvato during 2011. During switch over different applications interfaces, which used to ensure supply chain management need to be re-written to support new distribution channel.

• Determine and elaborate business user requirements
• Attend meetings Warner Music & Arvato Business to capture issues in interfaces
• Documenting Captured Requirements
• High Level Impact Analysis of different applications of Warner Music for migrating Distribution Channel to Arvato
• Review estimates for application development and implementation effort and schedules
• Review and approve document deliverables like High Level Design, Low Level Design
• Creating Acceptance test cases & testing the delivered product from developers
• Co-ordinate with Warner Music application manager for project management of all maintenance and development activities within clusters, including 3rd party vendor interactions
• Co-ordinate with in the team members and monitor activities as per committed SLAs and plans.

Project: DIP – Performance Improvement

Environment: Oracle 10g, ASP.NET, Power Builder

Client: Warner Music, London

Description: WMG planned to make all the sales processing in central DB and distributing the amount to the DSPs. With this centralization more burden will be on server to process more sales transaction files. Hence, planning to reduce the process file time to run more files in less time. Have done tuning work on the existing code.

• Analysis existing functionality and tuning PL/SQL scripts to process file in less time using oracle 10g features
• Re-Design and development some packages and procedures as part of tuning this application
• Coding and Unit & Integration Testing of the application
• Providing pre-emptive bug fixes for application related problems
• Preparing and executing plans for enhancements required by the client
• Debugging of issues on production environment and managing application deployment and Configuration Management.

Project: WARS – Warner Artist Royalty System & MUR – Master Use Royalty

Client: Warner Music, London

Environments: Oracle 11 & 10g, ASP.NET, Power Builder

Description: WARS, handles creation of statements & statement summaries for all artists who are in contract with WMG. Those statement or statement summary contains about the royalty earnings, recoupable costs, final amount payable to artist etc.. Royalty calculations are based on sales on catalogues created by the artists. Sales information comes to application from different systems. This application has got around 40 instances all around the globe.

MUR, handles International Royalty between different affiliates of Warner Music or any 3rd Party companies.

• Determine and elaborate business user requirements
• Completing coding within the time lines
• Attend Warner Music technical and issue resolution meetings
• Review estimates for application development and implementation effort and schedules
• Review and approve document deliverables
• Co-ordinate with Warner Music application manager for project management of all maintenance and development activities within clusters, including 3rd party vendor interactions
• Co-ordinate with Warner Music application manager for managing deployment and support activities
• Co-ordinate within the team members and monitor activities as per committed SLAs and plans.

Project: TPFC (Third Party Fee Central)

Client: CFC International – India Services

Environments: ASP.NET, .NET, Java Script, MS SQL Server

Description: Countrywide Financials is US leading Mortgage Banking. Before Loan gets approval, applicants Credit History Report, Land appraisal Report will be created. For generating these reports there are many third party vendors. They charge money for the same. A web portal is created to keep track of all third party vendors payments, applicants applicable charges, etc.. for each & every loan application.

• Involved in requirements study & Project estimation
• Involved in System & Software Design
• Developing programs according to the specifications prepared in analysis phase
• Involved in the project documentation
• Involved in Integration & testing the system to verify whether it matches the requirement.

Project: ZSR

Environments: ASP.NET, .NET, Java Script & PDF (Acrobat), Adobe Document Server
Client: CCH (A WoltersKulwer Company)
Description: CCH is one of the leading website for the filling of sales & use tax returns in US (all states) for their clients.

• Code the PDF’s released by states every month, which are used for online filing
• Creating 3 test environments for the same web site using ASP.NET & Java Script
• Designed and developed a Web-based Issue Tracking / Reporting system using ASP.NET& MS SQL Server which enables tracking of Issues from entry to the Project till their exit and provides for generation of accurate reports for High Management
• Creating back office windows based applications for the 3 test environments
• In that duration I got knowledge about the taxation & it also helped me to analyze the requirements in detail
• Enhancing the programs & performance by analyzing the requirements and designing for the same
  Involved in peer reviewing the enhanced programs and project documentation
• Understanding functional & technical requirement of the role & framing effective processes, quality improvements and cost reduction measures
• Assisting in complex coding/client issues i.e
  Playing the role of a domain expert & mentor
• Managing, Training team members & Competency building of the team
• Project status reporting and escalation on timely basis.

Description: Developed software for in-house to streamline all departments’ (Marketing, Production, Inventory, Purchase & module for Salary generation) process flow & to improve productivity. In Marketing module, gives suggestions about prices to Quote. It automatically picks up Engineering Drawings related to that Particular offer & helps user to create offers with zero delay for collecting data. In Production Module, it gives suggestions for engineers regarding Production Planning and calculates time required for manufacturing product. It helps to create bill of material for products, which must to be manufactured. It keeps tracks of manufacturing of products. In Inventory module, it keeps track of raw material and gives value of stocks in stores at any instance. It generates automatic indent for shortage of materials. In Purchase module, it collects indents raised from stores and production departments and suggests best vendor. It prepares reports like Vendor Rating. In Salary module, it prepares monthly salary sheets & Pay slips and keep track of expenditures for statutory provisions. It keeps track of Attendance and OT’s.

• Developed software for in-house to streamline all departments’ (Marketing, Production, Inventory, Purchase & module for Salary generation) process flow & to improve the productivity
• In Marketing module, gives suggestions about the prices to Quote
• It automatically picks up Engineering Drawings related to that Particular offer & helps the user to create offers with zero delay for collecting data
• In Production Module, it gives suggestions for engineers regarding Production Planning and calculates the time required for manufacturing the product
• It helps to create the bill of material for the products, which must to be manufactured
• It keeps tracks of manufacturing of the products
• In Inventory module, it keeps track of the raw material and gives value of the stocks in stores at any instance
• It generates automatic indent for shortage of materials
• In Purchase module, it collects the indents raised from stores and production departments and suggests the best vendor
• It prepares the reports like Vendor Rating
• In Salary module, it prepares monthly salary sheets & Pay slips and keep track of the expenditures for statutory provisions
• It keeps track of Attendance and OT’s.