Venkat Kameshetty

Sally Beauty Holdings, Inc. is an American international specialty retailer and distributor of
professional beauty supplies. Sally Beauty Supply offers more than 6000 products for hair, skin and
nails through professional lines such as Clairol, L'oreal, Wella and Conair.
Created IAM user accounts and role-based policies for access to AWS services
Created and manage users' permissions, directories, and files in both Window and Linux
environments
Provision AWS resources using AWS Management Console, Command Line Interface (CLI)
Used Route 53, ELB with Multi AZ, EC2 with Multi az autoscaling group to implement a project.
Create and manage AWS infrastructures using Infrastructure as Code (IAC) tools like Terraform
and CloudFormation
Responsible for launching EC2 instances and bootstrapping the instances using user data
Create EBS volumes from snapshots
Manage configuration of servers using Ansible.
I have implemented CICD using Jenkins, Git and Docker.
Created dev standards for puppet module development including best practices for version
control ( git).
Created automated pipelines in AWS Code pipeline to deploy Docker containers in AWS ECS
using services like cloud formation, Code build, Code deploy and S3.
Deploy Serverless Architecture using DynamoDB and Lambda.
Launch Amazon EC2 Instances using various images including Linux and Windows AMIs
Install application on AWS EC2 instances and configured the storage on S3 buckets.
Plan, build, and configure network infrastructure using AWS VPC and other network components
Good Experience in Architecting and configuring secure cloud VPC using Private and Public
networks through subnets in AWS.
Included security groups, Network ACLs, Internet Gateways and Elastic Ip's to ensure a safe area
for organization in AWS public cloud.
Launch database instances via RDS to support application functionality
Provision AWS systems that are highly available using Autoscaling Group and Load Balancing
Create and manage lifecycle rules to transition objects from standard S3 to cheaper storage
classes like Glacier and Deep Archive
Experience with CloudFront, Route53, AWS Config, CloudFormation, etc.
Implement, maintain, monitor alarms and notifications for AWS services using CloudWatchand
SNS.
Troubleshoot and resolve EC2 instance connectivity and availability issues
Knowledgeable in Virtual Private Network (VPN), Data Security, Backup & Recovery
Perform Monthly Patches on AWS servers.
worked on Amazon Route 53 for DNS (Domain Name System) management to register
domain,created records, TTL and Alias thus ensuring reliable and scalable domain routing and
resolution.
Create low latency website using S3, CloudFront, and Route53
Evaluating system-based configuration and security vulnerability to ensure compliance with the
organization's standards
Actively monitoring, researching, and analyzing ways in which the services in AWS can be
improved

• Worked closely with teams to design and develop technically compliant, cloud-native enterprise architectures to meet business outcomes
• Served as Subject Matter Expert (SME), and point of contact for internal and external clients and managed customer calls every day
• Performed as Lead Architect taking solution ownership and oversaw the completion of 6 projects
• Designed highly available, cost-effective and fault-tolerant systems using EC2 instances, Auto Scaling and Elastic Load Balancing
• Leveraged API Gateway, SNS and SQS to build architecture models with synchronous and asynchronous patterns to decouple, integrate and scale services
• Designed efficient database workloads to reduce latency and optimize throughput using read replicas and caches
• Configured EC2 Auto Scaling with Elastic Load Balancing in cross-AZ and multi-AZ for high availability and fault tolerant
• Optimized networking for global applications using S3 Transfer Acceleration, Route 53 latency-based routing, Global Accelerator and CloudFront
• Managed and monitored mission-critical systems for optimal performance and high level of availability
• Boosted network system, data availability and integrity through preventive maintenance and upgrade
• Implemented event-driven automation for quick respond and incidents remediation actions reducing MTTR by 20% using Amazon CloudWatch and AWS Lambda
• Utilized AWS Config and CloudTrail as part of the governance framework to enable compliance, auditing, troubleshooting, etc of AWS accounts and resources
• Collected and Analyzed metrics, logs and events with Athena, Quick Sight and CloudWatch Log Insights
• Optimized cost through a mixed of Reserved, Spot and On-Demand Instances, EC2 instance types, Auto Scaling and S3 storage classes
• Setup and configured systems for real time monitoring and alerts for log files, API calls and other events of importance
• Engaged in proactive resource optimization, capacity automation and resource planning which boosted operational performance by 10%
• Performed architecture/design reviews for applications, infrastructure, and network designs
• Participated in all phases of system development life cycle from requirements analysis through system implementation
• Ensured data protection and assurance by encryption with AWS KMS
• Analyzed and made recommendations in areas of costs optimization, performance, security, fault tolerance and service limits
• Experienced in AWS Organizations SCPs to centrally manage and govern environment as resources grow and scale out.

• Managed and overlooked different daily Operational activities in Business objects and Data services environment
• Was main point for any report or data related project needs across enterprise organization
• Met with Stake holders for any New Canned or ad hoc or data migration request and took care of their needs
• Installed and upgraded different version of business objects from BO 6.1b/4.0/4.1/4.2
• Installed and upgraded different version of Data Services e.g
• BODS 4.0/4.2/4.3
• Played Architect role in both BO and DS in procuring, installing and deploying of BOBJ environment
• Worked as administrator creating new users and in forklifting BO objects and workflows and Data flows from one environment to another during migration process
• Created and Maintained core universes like AP,AR,PO,OM,WMS,Pricing universes
• Build Canned and Ad hoc report againstabove Core universes.

• Involved in a major business objects migration from xir2 to BI 4.0
• Did the complete security model from scratch for all the enterprise business groups in the BI4.0 model
• Which had about 6500 users based, 102 universes and close to 5500 reports
• Experience with all facets of Business objects security including creating users, groups and access levels
• Experience monitoring physical servers and services
• Knowledgeable about the services and how they function
• Trouble shoot runtime errors such as login failures, reports not running or reports getting runtime errors
• Experience with web intelligence, Rich client, crystal reports, Desktop intelligence and universe designer
• Experince using Upgrade tool Manager, Lifecycle Manager, Report conversion tool
• Proactive system monitoring based on usage metric and forecasted usage
• Environment: SAP Business Objects 4.0, Designer( Unv, Unx) ,SAP BW 7.0, Web Intelligence,Crystal reports, SAP ECC 6.0, Oracle 11g,Jira, Siebel ICRM , UTM, RCT

• Worked for one of CTS client CIBA VISION which is a part of Novartis company
• Was involved in the complete life cycle of BI implementation at CIBA VISION for both Global and NADW divisions
• The Legacy system is SAP -BI 7.0
• Responsibilities: Involved in requirement gathering, analyzing the requirement and interacting with client functional leads
• Analyzing the business requirements and converting them into Functional requirement (FRS) for reporting
• Involved in creating universe for different logical groups like Field sales, Market share, Brand, Key accounts, AMEC and distributors
• Created universes on Bex queries and info cubes, implemented custom hierarchies and drill down functionalities
• Implemented the Security on Field sales hierarchy which was an important part of the project
• Created complex universes with complex functionalities with in the universe
• Created complex reports using webi and validated the data against the source system
• Used @ functions, averters, breaks, filters and derive table concepts while creating reports
• Created dashboards using xcelsius
• Used live office as the main connectivity source while creating the dashboards
• Also has knowledge on QWaas
• Created visualizations by using labels, filter, charts components
• Used webi and live office as the main connectivity source while creating dashboards and increased the performance of dashboard by using the latest instance of the webi report
• Involved in informal, formal and UAT testing and validated the data and reports
• Has Experience in Incident Management
• Created and resolved the tickets during the testing phase
• Worked on any deviations which came after the UAT and was involved in post production support
• Environment: Business Objects XIR3.1, Designer, Webi 6.0, , SAP BW 7.0, Live Office, SAP ECC 6.0,Xcelsuis , Oracle 10g,Mercury Quality Center, Sql Plus, IBM WebSphere 5.x

• Ball Aero Space is a leading Manufacturer of Satellite equipment and supplies it to government
• Involved in the reconciliation of Ball SAP Legacy System “COST POINT” to “IFS”
• Worked on the project called “Short” Was part of the infrastructure team, created, maintained and done reporting against SAP BW-BI 7.0
• Created user/user groups through Central Managemant console (CMC) and involved in giving privileges to these groups in the BOBJ 3.1 version administration set up
• Using CMC Maintained all the universe, Webi, Crystal reports, Dash boards across different environments and given security privileges to different users in different departments
• Involved in Migration of reports, universes from Xir2 to Xir3.1 version and implemented web interface as a standard for the users
• Involved in design and development of Universes for Accounting, GL, Labor, Purchasing, logistic groups, supply chain
• Was involved in integration SAP with BOBJ using SAP Integration KIT
• Was involved in moving the legacy data warehouse to SAP BW and ensured there compatibility
• Involved in data mapping session from the SAP BW
• Build Universes and define the universe connections based on SAP Bex queries
• Has set up Group level, user level and row level securities in BOBJ universe
• BOBJ development on top of SAP ERP/ ECC directly
• Used Data Integrator to extract the data from different data sources like SAP, SQL Server Tables flat files and loaded into data warehouse
• Worked on Commitment report, PCARD, Short, GL , Direct and indirect reports
• Experience creating query definitions with the BEx Query Designer and the BEx Web Analyzer
• Environment: Business Objects XIR2/XIR3.1,Crystal Reports 2008, Designer, Webi 6.0, Data Integrator, SAP BW 7.0, Live Office, SAP ECC 6.0,Xcelsuis 2008, Oracle 10g,Data Integrator, EQM, IBM WebSphere 5.x, 6.x,MS Project.

• Worked on a project called STAR2 which is Pepsi’s Primary DWH system and was being fed by a SAP legacy system
• Worked on a bottler delivery project called “Masking” which involved in Masking and unmasking of bottler data
• The warehouse was huge and was mainly used for Analysis, Data Mining, Decision Making, and Reporting
• Responsibilities: As a Business Objects/Crystal XIr2 Architect/Admin and performed installation, configuration and deployment of Business Object Enterprise
• Performed Client installation and application specific installation on client machines
• Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up Categories
• Set rights and privileges, managed Authentication and License keys using CMC
• Created user/user groups through Central Management console (CMC) and involved in giving privileges to these groups
• Using CMC maintained all the universe, webi, Deski report across environments
• Supported STAR2 analytical and operational reports
• Analyzes SAP requirements, designs and codes ABAP programs to meet the specifications
• Develops, communicates and implements SAP Security Profiles and ABAP Report procedures
• Has merged data between SAP BI/BW and other external data sources (e.g., an Oracle database, flat files, etc.) Environment: Business Objects XIr2/ XIr3 (CCM, CMC, Web, Info View), SAP BW 3.5, , Designer, Webi 6.0, Oracle 10g, STAR Team, IDM, Peregrin2.0,CAT, PL/SQL, Dashboard, EQM, Informatica 7.1

• Philips Van-Heusen is a leading company in the Apparel Industry; the brands include Van- Heusen, Arrow, IZOD, DKNY, and Calvin Klein
• The project scope was to design and build a warehouse for DSS system
• The warehouse was built from Licensing, Retail, Wholesale, distribution, financial data
• Role: As a Business Objects/Crystal XIr2 Architect/Admin and performed installation, configuration and deployment of Business Object Enterprise
• Created user/user groups through Central Management console (CMC) and involved in giving privileges to these groups in the BOXIR2 version administration set up
• Created user/user groups through Central Management console (CMC) and involved in giving privileges to these groups
• Using CMC Maintained all the universe, webi, Crystal reports, dash boards across different environments and given security privileges to different users in different departments
• Used Import Wizard in migrating the Webi and Crystal Reports into one Crystal Enterprise repository
• Using Import Wizard migrated the reports and universes across DEV2, UAT and SOT
• Created universes for controllers and operation department Hyperion Essbase as thedata source
• Involved in Migration of reports from 6.1b to XIr2 version and made sure they are work fine without any changes to formatting
• Have experience in requirements gathering and testing planning/scenario creation/test case creation
• Designing the tables using star and snowflake schema and confirmed granular dimensions with the FACTS tables
• Created a BOBJ universe for Jaguar and Supply Chain Tracking
• Created Linked universes and Cascading prompts
• Created canned and adhoc reports from custom queries generated from Hyperion
• Created corporate dash board through Dash board Manager
• Created Metrics and used different analytics in displaying the Business requirement of the company
• Environment: Business Objects XIR1/XIR2, SQL Server 2005, .net 3.5, Web intelligence 2.x/6.x, Crystal Reports XI/10, intellimatch, SRC, Toad, Erwin 4.0, Reqpro, EBI, CVS

• Nomura securities are a global investment banking firm
• They Implemented a data warehouse project on Xenos application, which is replacing the old legacy system NTAPS
• Data warehouse has 12 components of finance trading that includes Reference, EPM, EUC, General Ledger, Accounts Payable, and Corporate actions, Brokerage Effects, SLR, Settlements CAM and CAX
• Role: Involved in design and development of universes for different component models like CAM,CAX, TAX, TRD, SLR, Settlement
• Worked directly with people in Trading Floor to get data and created reports on MBS and repo and reverse repo
• Has Experience in Financial Data created reports based of EPM/FMS data like EPM Attestation and Balances reports
• Worked on Creating Reports on Budgeting/Scheduling/Forecasting using BOXIR1/BOXIr2/Src tool
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Designed and Built Universes, Classes and objects, employing integrity check
• Resolved loops using Contexts, and Aliases
• Wrote VBA macros to suppress the “Query does not have data” error
• Customized reports refresh process using Business Objects SDK on Broadcast Agent Server (BCA) and delivered to Intranet portal in Excel, PDF and HTML format
• Involved in intregating Business objects in Visual Basic
• Developed Java script for client end validations and Vbscript for server end validations
• ASP was used to provide a graphical Front-End to Business Objects Reports
• Exported the universes to the Repository to make resources available to the users
• Extensively used alerter and filters in reports
• Worked on the Master, Kernel and Component approach during the linking of universes
• Created reports for various Portfolios using the Universes as the main data Providers
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc
• Trained and provided support for first time Business objects users
• Helped transitioning from 6.1 to 6.5 version providing all ground work including installation and upgrading and training
• Created Schedulers to monitor Broadcast Agent
• Created Business Objects Repository while building Business Objects solution
• Set up groups and users for Business Objects deployment
• Managed user profiles using Supervisor
• Created and tested classes and objects to organize the universe
• Published and scheduled Business Objects Reports to users using Scheduler
• Environment: Business Objects 6.5/6.1b, Tera data , Web intelligence 2.7/6.0, BCA, Windows NT, PVCS, Erwin 3.5, VBA Macros,VB 6.0,Asp

• This is a rapid development project team, which delivered a comprehensive data warehousing and OLAP Financial reporting solution for Honda Motor Company
• Fast (Financials @ the Speed of Thought), is a warehouse and reporting solution that provides the primary customer interface for a newly created fifty-million-dollar financial system, and was developed at half the cost/report of comparable projects, by a multidisciplinary team of Ten People
• The very large-scale data warehouse allows the customer to provide financial reporting and Forecasting via direct linkages to operational (e.g
• Manufacturing systems) providing far more accuracy and timeliness of information than previously available
• Reporting team is four people strong and is responsible for developing complex reports for business analysts
• As a part of the project, the Business Object’s Universe, queries and reports were created for various user groups
• Also used Web Intelligence and Infoview to deploy the reports
• Role: Used Supervisor to create Users and Groups as well as assign profiles to them
• Maintained resources, authorizing user access to universes, reports and documents in a specific infrastructure setup for Repository domains
• Designed Universes in two phases, the first phase involved in creating the structure like tables and columns of a database joined by joins and also resolving the loops with aliases and contexts
• The second phase involved in enhancements of universe like complex classes, objects, joins or conditions
• Worked with Business Objects Supervisor module in the process of controlling universe and restricting reports
• Exporting & importing universes across different domains
• Created reports using Business Objects functionalities like Queries, Graphs, Charts, Section based, Cross Tab, Master Detail and Macros (VBA), etc
• Worked through enhancement requests, created canned and adhoc Reports
• Converted Crystal Reports to Business objects
• Business Object reports were provided to the users in various formats like PDF, Excel and HTML formats
• Data from different source systems put in a centralized database for this system
• Developed Unix shell scripts and used FTP for file transfer
• Interacted with end users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering
• Assisted in creation of Star Schema design for the Data Warehouse database
• Population of Fact and Dimension tables
• Creation of various objects like variables, dimensions, formulas and relations
• Population of multidimensional cubes (variables) from fact tables
• Installing Business Objects 5.0/5.1 and WebIntelligence 2.5/2.6
• Designing, creating universes and reports using Business Objects/WebIntelligence as front end and Oracle as Database
• Used Informatica PowerMart for carrying out ETL process
• Used Informatica PowerMart Designer to create Source, Target, Transformations and Mappings
• Upgrading existing universes and reports from Business Objects 5.7 to Business Objects 6.1b and WebIntelligence 2.5/2.6
• Exported the universes to the Repository to make resources available to the users
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, Macros, etc
• Import and export reports to and from repository
• Exporting the reports to the Broadcast Agent Server to Schedule and Monitor Reports
• Environment: Business Objects 6.1b, oracle 9i, Toad, pvcs, webIntelligence 2.5/2.6, Erwin 3.0

• This is a rapid development project team, which delivered a comprehensive data warehousing and OLAP Financial reporting solution for Honda Motor Company
• F@st (Financials @ the Speed of Thought), is a warehouse and reporting solution that provides the primary customer interface for a newly created fifty-million-dollar financial system, and was developed at half the cost/report of comparable projects, by a multidisciplinary team of Ten People
• The very large-scale data warehouse allows the customer to provide financial reporting and Forecasting via direct linkages to operational (e.g
• Manufacturing systems) providing far more accuracy and timeliness of information than previously available
• Reporting team is four people strong and is responsible for developing complex reports for business analysts
• As a part of the project, the Business Object’s Universe, queries and reports were created for various user groups
• Also used Web Intelligence and Infoview to deploy the reports
• Role: Used Supervisor to create Users and Groups as well as assign profiles to them
• Maintained resources, authorizing user access to universes, reports and documents in a specific infrastructure setup for Repository domains
• Designed Universes in two phases, the first phase involved in creating the structure like tables and columns of a database joined by joins and also resolving the loops with aliases and contexts
• The second phase involved in enhancements of universe like complex classes, objects, joins or conditions
• Worked with Business Objects Supervisor module in the process of controlling universe and restricting reports
• Exporting & importing universes across different domains
• Created reports using Business Objects functionalities like Queries, Graphs, Charts, Section based, Cross Tab, Master Detail and Macros (VBA), etc
• Worked through enhancement requests, created canned and adhoc Reports
• Converted Crystal Reports to Business objects
• Business Object reports were provided to the users in various formats like PDF, Excel and HTML formats
• Data from different source systems put in a centralized database for this system
• Developed Unix shell scripts and used FTP for file transfer
• Interacted with end users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering
• Assisted in creation of Star Schema design for the Data Warehouse database
• Population of Fact and Dimension tables
• Creation of various objects like variables, dimensions, formulas and relations
• Population of multidimensional cubes (variables) from fact tables
• Installing Business Objects 5.0/5.1 and WebIntelligence 2.5/2.6
• Designing, creating universes and reports using Business Objects/WebIntelligence as front end and Oracle as Database
• Used Informatica PowerMart for carrying out ETL process
• Used Informatica PowerMart Designer to create Source, Target, Transformations and Mappings
• Upgrading existing universes and reports from Business Objects 5.7 to Business Objects 6.1b and WebIntelligence 2.5/2.6
• Exported the universes to the Repository to make resources available to the users
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, Macros, etc
• Import and export reports to and from repository
• Exporting the reports to the Broadcast Agent Server to Schedule and Monitor Reports
• Environment: Business Objects 6.1b, oracle 9i, Toad, pvcs, webIntelligence 2.5/2.6, Erwin 3.0