SUMMARY

• Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.
• Continuously managed and improved the build infrastructure for global software development engineering teams including implementation of build scripts, continuous integration infrastructure and deployment tools.
• Leveraged AWS cloud services such as EC2, auto - scaling and VPC to build secure, highly scalable and flexible systems that handled expected and unexpected load bursts.
• Manage amazon redshift clusters such as launching the cluster and specifying the node type as well.
• Used AWS Beanstalk for deploying and scaling web applications and services.
• Designed AWS Cloud Formation templates to create custom sized VPC, subnets, NAT to ensure successful deployment of Web applications and database templates.
• Implemented automated local user provisioning instances created in AWS cloud.
• Setup and build AWS infrastructure various resources, VPC EC2, S3, IAM, EBS, Security Group, Auto Scaling, and RDS in Cloud Formation JSON templates.
• Provide highly durable and available data by using S3 data store, versioning, lifecycle policies
• AMIs for mission critical production servers for backup.
• Maintained the user accounts (IAM), RDS, Route 53, VPC, RDB, Dynamo DB, SES, SQS and SNS services in AWS cloud.
• Designed and implemented scalable, secure cloud architecture based on Amazon Web Services.
• Defined branching, labeling, and merge strategies for all applications in Git.
• Build servers using AWS, Importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Deployed applications on AWS by using Elastic Beanstalk
• Created monitors, alarms and notifications for EC2 hosts using Cloud Watch.
• Migrated applications to the AWS cloud.
• Involved in DevOps processes for build and deploy systems.
• Created Python scripts to totally automate AWS services which includes web servers, ELB, Cloud Front distribution, database, EC2 and database security groups, S3 bucket and application configuration, this script creates stacks, single servers, or joins web servers to stacks.

PROFESSIONAL EXPERIENCE

Confidential

AWS Architect/ DevOps Engineer

Responsibilities:

• Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.
• Continuously managed and improved the build infrastructure for global software development engineering teams including implementation of build scripts, continuous integration infrastructure and deployment tools.
• Leveraged AWS cloud services such as EC2, auto-scaling and VPC to build secure, highly scalable and flexible systems that handled expected and unexpected load bursts.
• Manage amazon redshift clusters such as launching the cluster and specifying the node type as well.
• Used AWS Beanstalk for deploying and scaling web applications and services developed with Java
• Designed AWS Cloud Formation templates to create custom sized VPC, subnets, NAT to ensure successful deployment of Web applications and database templates.
• Implemented automated local user provisioning instances created in AWS cloud.
• Setup and build AWS infrastructure various resources, VPC EC2, S3, IAM, EBS, Security Group, Auto Scaling, and RDS in Cloud Formation JSON templates.
• Provide highly durable and available data by using S3 data store, versioning, lifecycle policies, and create
• AMIs for mission critical production servers for backup.
• Maintained the user accounts (IAM), RDS, Route 53, VPC, RDB, Dynamo DB, SES, SQS and SNS services in AWS cloud.
• Designed and implemented scalable, secure cloud architecture based on Amazon Web Services.
• Defined branching, labeling, and merge strategies for all applications in Git.
• Build servers using AWS, Importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Deployed applications on AWS by using Elastic Beanstalk
• Created monitors, alarms and notifications for EC2 hosts using Cloud Watch.
• Migrated applications to the AWS cloud.
• Involved in DevOps processes for build and deploy systems.
• Created Python scripts to totally automate AWS services which includes web servers, ELB, Cloud Front distribution, database, EC2 and database security groups, S3 bucket and application configuration, this script creates stacks, single servers, or joins web servers to stacks.

Confidential, Irving, TX

AWS Developer

Responsibilities:

• Migrated existing on premise infrastructure into cloud using AmazonAWSand its associated Services
• Designed and deployedAWSsolutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups, Ops works.
• Created Instances, balanced load, assigned security and managed communication between different instance
• Automated software deployment using chef and provisioned Linux hosts
• Configured and monitored distributed and multi-platform servers using chef. Defined chef server and workstation to manage and configure nodes.
• Setup and maintained RHEL 6.8 and installed SAP Data Services with Oracle client
• Branching, Tagging, Release Activities on Version Control Tools like GIT
• Setup and configured web servers with Apache Tomcat and nginx
• Installed Oracle database with AMI image and updated the database with schemas and scripts to run Data Services and Cognos
• Successfully Installed and connected IBM Cognos with the Data Services and Oracle instances in a singleAWSVPC with different subnets
• Troubleshoot Linux installation problems encountered when connecting with RHEL 6.8, RHEL 6.5 and Oracle instances and successfully resolved them
• Implemented Chef to deploy the builds for Dev, QA and production.
• Managed build results in Jenkins and deployed using workflows

Confidential, Cupertino, CA

SAP BW/BO Lead

Environment: SAP BW 3.5, 7.0, 7.3, BOBJ XI 3.x, ECC 6.0, SAP RMCA (for iTunes), ABAP/4, Oracle, Teradata EDW Mac OS X and Windows 7

Responsibilities:

• As a BW lead, responsible for managing both Onsite and Offshore teams.
• Works closely with Business to understand and resolve the issue especially during Month end, Quarter close. Also educate the business user on some critical BW related issues and understand the gaps to and fix the issues.
• Have strong relationship with Projects team, Business users and Functional teams.
• Support data extracts from SAP and non-SAP systems
• Participate in efforts to gather requirements analysis for new BI/BW projects along with Dev Team (for Smooth Transition to Support)
• Participate in the creation of BI/BW development standards while adhering to policies, methodologies, standards, and guidelines
• Responsible for meeting all assigned/agreed on target dates for projects as well as individual tasks
• Responsible for Maintaining the BIA server so that reports are smoothly delivered to Business users.
• Automated weekend activities like PSA Deletion, Change Log Deletion, Cube Compression, Deletion of data from Cubes.
• Involved in improving the system performance by correct procedures during data modeling, Data Staging, Reporting and BIA. Also worked with SAP on improving the performance of BW system.
• Implemented Decision nodes in Process chains so that they will not be executed on weekly system downtime.
• BW Reporting - Strong Experience of BEx Query Designer, Calculated & Restricted Key Figures, RRI jumps, Conditions, Exceptions, Variables, Queries on Multi Providers, Web Application Designer (WAD) with table interface related development and documentation for end users
• Developed a utility to fill the set up tables in ECC for MM, PO (for Numerous docs not in sequence). Utility can be used for other areas also.
• Built aggregates, compression and partition on InfoCube to increase performance of a query.
• Built Stats for all the objects DSO Cubes to increase the performance while reading and loading.
• Worked on Bug Fixes both front end and Backend. Fixed issues in Query Designer, WAD in the front end. Fixed some routines, SE38 Programs, FM's in the Backend
• Modified reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters

Confidential, Phoenix, AZ

SAP BI Systems Analyst

Environment: SAP BI 7.0, ECC 6.0, SRM, ABAP/4, Teradata EDW and Windows XP and Windows 7

Responsibilities:

• Involved in understanding the business requirements and preparing the functional specification document.
• Prepared technical design document for the functional specifications for P2P, SRM, Capital and Finance Project
• Created custom data sources using functional module, view and table and enabled generic delta.
• Worked on LO cockpit to extract the Purchasing, Material Movements and Invoice. Enhanced SRM Extractors. Customized the Data Sources like 2LIS 03 BF, 2LIS 02 ITM, 2LIS 02 HDR, 0BBP TD SC 1, 0BBP TD SC APPR 1
• Installed standard business content Data Source, DSO and cubes.
• Involved in enhancing the standard data source using BADIs.
• Created InfoObjects, Data store Objects and generic data sources.
• Loaded the data from ECC to BI using transformations and Data transfer Process (DTP).
• Worked on open hub services and InfoSpokes to pass the data from BI to EDW (Teradata).
• Involved in migration of development from Dev system to cons system.
• Involved in the functional, bench marking and UAT testing.
• Created process chain to send the data from Source to BI and from BI to EDW using InfoSpokes.
• Involved in Validation of Data between ECC, BI and EDW.
• Fixed bugs in Start routines, End routines and extractors in source system.
• Worked closely with Business Community to understand the issue and provide the required solution
• Improved the load performance by optimizing the code while loading the data to DSO’s.
• Worked closely with SAP in closing the issues and have good exposure in creating Customer message.
• BW Reporting - Strong Experience of BEx Query Designer, Calculated & Restricted Key Figures, RRI jumps, Conditions, Exceptions, Variables, Queries on Multi Providers, Web Application Designer (WAD) with table interface related development and documentation for end users
• Part of Production Support team for P2P module which involves monitoring of Process Chains, Correction of data loads, closing the issues raised by customers, modifying the existing objects based on the new requirement, working with SAP and closing the issues.
• Involved in Training activities to Customers on BI technology and also on the projects, which were developed by me.
• Used Solution Manager to Create the CHaRM Request and transport the BI and ECC/Source Transport Request to Quality and Production systems.
• Monitor the BI Jobs by using Autosys.

Confidential, Bellevue, WA

SAP BI System Analyst

Environment: SAP BI 7.0 SAP R/3 ECC, SQL Server 2005, SD, MM-Purchasing, MM-INV, HR, and Windows Vista

Responsibilities:

• Involved in understanding of the business process for accounts receivables and payables and MM-Purchasing, MM-Inventory and Sales and Distribution.
• Gathering business requirements from users by conducting meetings and workshops and giving questionnaire to them.
• Defined business success criteria for AR and AP.
• Prepared GAP Analysis, design and development of technical specifications. Prepared functional requirement and specification documents for HR, AP, AR and MM-Purchasing.
• Involved in the process play back of accounts receivable and accounts payable
• Prepared test plan and test cases.
• Reviewed user acceptance criteria for UAT testing.
• Created generic extraction by using View to extract data from SAP R/3 to BW.
• Activated and utilized the business content according to the functional requirements.
• Created custom InfoCube, DSO, MultiProviders, Info Set, InfoObjects and DTP.
• Enhanced standard data sources, customized start routines and end routines.
• Involved in Migration of 3.5 objects to 7.0
• Prepared Unit test scripts documents.
• Scheduling and Monitoring background jobs.
• Coordinating with on-site team lead and updating day-to-day activities.
• Created user defined prompts and complex conditions at universe level for better performance.
• Involved in Level 2 Production Support. This involves On Call monitoring of Jobs, Correction of Process Chains and modifying any objects that are required according to the new specification.

Confidential

SAP BI Developer

Environment: SAP BI 7.0, SAP R/3, FI/CO, SD, PP and Windows XP.

Responsibilities:

• Extensively involved in analyzing, customizing and activating standard delivered BI Business Content in the Financial and Logistics area.
• Extracted data from R/3 system (FI/CO, SD, MM, PP) into BI system through LO, CO-PA, FI-GL and Generic R/3 data extraction techniques.
• Activated and installed standard Business Content for MM, SD, FI/CO and created DSO & Info Cubes for Accounts Payable: Line Items, Transaction Data (Profit Centers, Cost Centers, Product costing), Statistical Key Figures, Sales Order, and Sales Delivery cube.
• The Design and development of the LO cockpit standard extractors 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDHDR, 2LIS 13 VDITM.
• I also enhanced the structure with the custom defined fields. The reports coming out of this application are Net orders actual vs budget, net sales units actual vs. budget, net sales by product, sales district, sales order analysis, etc.
• Designed custom InfoCubes and DSO Objects by enhancing existing Info Sources and Info Objects. Created Transfer Rules, Update Rules, Update Routines, Aggregates and Hierarchies.
• Developed flexible queries on (sales orders, billing, and material movements) based on requirements from various organizations ranging from executive management using FI/CO data to functional departments using SD, PP and MM data.
• Resolved and implemented BW Query faults (Day to Day) and change requests.
• BW Reporting - Strong Experience of BEx Query Designer, Calculated & Restricted Key Figures, RRI jumps, Conditions, Exceptions, Variables, Queries on Multi Providers, Web Application Designer (WAD) with table interface related development and documentation for end users
• BEX customer exit variable, Virtual char /KF user exit, IP variable user exits,
• BW Operations - Data load management, Job scheduling with events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Data Reconciliation with Remote Cubes, Data Mart, Open Hub Services, importing OSS Notes, and BW Transports.
• Generated reports on cost center and product costing.
• Involved actively in supporting the various issues addressed by the users and providing them with required solutions.

Confidential

SAP BI Analyst

Environment: R/3 4.6C, SAP BI, FI/CO, SD, Windows XP

Responsibilities:

• Work extensively on Data Warehouse Workbench and customized InfoObjects, InfoCubes, DSOs, Data Sources, DTPs, Transformations, MultiProviders
• Set up of periodic Data loads
• Involved in extracting the data from the ECC system
• Installed and created BI objects like InfoObjects, DSOs, and InfoCubes. Created and managed dataflow using DTP, Transformations and Info Packages
• Data Source enhancement as per customer requirements
• Experienced in writing start routines, end routines
• Designed and developed queries to generate reports using BEx Query Designer and BEx Analyzer
• Involved with performance tuning of queries by compression, repartitioning of InfoCubes. Created aggregates for InfoCubes to improve query performance.
• Extensively worked on LO Cockpit and performed activities like deleting set up tables, filling up of set up tables and loaded data from SAP ECC to SAP BI and used initialization update and delta update
• Created custom InfoObjects, DSO, DTPs and InfoCubes
• Scheduled DTP for loading transaction data from PSA to Info Provider using process chains.
• Involved in the transportation of BI objects from development to quality and production
• Worked extensively on BEx Query Designer and created custom queries using variables, calculated Key Figures, restricted Key Figures, new selection, new formula, exceptions and conditions
• Worked on report-to-report interface (RRI)