SIVA ABBARAJU, AWS

Washington D.C. Metro Area 732-***-**** (Cell)

adaq70@r.postjobfree.com https://www.linkedin.com/in/siva-abbaraju-7b828023/ TECHNICAL MANAGER SOLUTIONS ARCHITECT

● 16+ years’ experience in systems analysis, design, development, architecting and implementation of Client/Server, Internet/Intranet, Data Warehouse/Data Mart & Business Intelligence applications using cloudbase and traditional environment using Agile and waterfall methodologies

● Expertise in AWS cloud computing platform, and its many dimensions of scalability - including but not limited to: VPC (Virtual Private Cloud), EC2, load-balancing with ELB, messaging with SQS (and scalable non-AWS alternatives), auto scaling architectures, using EBS under high I/O requirements, custom monitoring metrics/analysis/alarms via Cloud Watch, the AWS API and different toolkits for instrumenting it.

● Won award for architecting a solution using AWS Cloud for predicting house buying trend. Used sage maker machine learning to refine model using twitter data ingestion. This architect also includes google voice control, image recognition, and auto map coordination detection to find latest house sell data from neighborhood.

● POC for cross cloud platform data migration tool griddable.io (Data migrations service) a Microsoft Azure partner. It enables migration of database like Postgres, My SQL, and SQL Server 2017 from AWS to Azure.

● Implemented use cases for Dynamodb, AWS Redshift, MemSQL, AWS Aurora, Graph database (neo4j), and other RDS supported by AWS.

● Knowledge on R, R Studio and Python programming.

● POC and exploring Data lake architecture tools and techniques on cloud topology.

● Migrating oracle/informatica/cognos based BI reports to AWS based Quick Sight and Tableau reports using AWS databases and services.

● Extensive experience in complete Data Warehousing & Business Intelligence life cycle that include AWS, Data Modeling (Conceptual, Logical & Physical), Data Profiling, Data Analysis and ETL Architecture.

● Worked on Process Definition Document (PDD) and Solution Design Document (SDD) for RPA process.

● Proficient in many BI reporting tool Cognos,Tableau, Business Objects, Micro strategy, Jasper soft, Microsoft Power BI and Logi Xml

● Expertise in implementing Data Warehousing methodologies such as gathering Business Requirements, Application Design, Development, Testing, Implementation and Production Support for large-scale data warehouses.

● 4 + years of Scrum Master/ Project manager experience with proven ability to support multiple projects under tight deadlines often with competing priorities.

● An effective communicator, a proven leader and excellent team player. Mentored other team members and peers, through brown bag, Speak freely sessions.

● Provide training to various customers on different tools. EDUCATION/CERTIFICATIONS

Master of Computer Applications, India, Master of Science (P.G.) in Networking Engineering, Toronto, Canada, AWS Certified Developer Associate, IBM Cognos Certified Professional, Certified Scrum Master,CompTIA A+ Certified Professional,TOGAF Trained TECHNICAL SKILLS

● Cloud Tools: AWS Cloud, Google Cloud Services, Microsoft Azure Services, Griddable.io

● BI tools: Cognos, Business Objects, Tableau, Micro strategy Jasper soft, Thought Spot

● ETL Tools:Erwin, Informatica,Alation, Dataflux

● Databases:Oracle, SQL server, Netezza, MS access, SQL Programmer, MYSQL

● Data Modeling Tools/ Others:Erwin 4.1, Visio 2000,TOAD C, COBOL, HTML, DHTML

● Methodologies and Standards :Project Management Body of Knowledge, Agile, Waterfalls PROFESSIONAL EXPERIENCE

Fannie Mae, Reston, VA, Technical PM/Solutions Architect, October 2018 - Till date Projects: Common Securitization Services Reporting Platform (CSPI)

● Served as a Solutions Architect on working and Managing CSPI (Common Securitization services) Reporting stream and other engineering managers to architect, develop and deliver the best solutions.

● Lead a team of professionals who work within project teams using modern tools, techniques, and methods to develop, modify, or update applications used by business or infrastructure units.

● Lead development team in designing/migrating AWS cloud based solutions

● Knowledge of agile software development practices and release management

● Work with distributed teams to design and develop frameworks, solution accelerators, proofs of concept, and external customer facing products

● Migrated /Architected and designed Redshift views in AWS Cloud.

● Worked with Enterprise Data Infrastructure team and business users on all reporting issues.

● Design and verify the technology solution meets business and technical requirements and is in compliance with enterprise architecture guidelines, technology standards and methodology, and compliance and security standards.

● Lead technical team of 5 to deliver 35 tableau reports and 6 self-serve reports.

● Architected reporting solutions using AWS services.

● Initiated CI/CD process using Docker, Jenkins and python scripting for Tableau reports refresh schedule.

● Won award for architecting a solution using AWS Cloud for predicting house buying trend. Used sage maker machine learning to refine model using twitter data ingestion. This architect also includes google voice control, image recognition, and auto map coordination detection to find latest house sell data from neighborhood.

● Educate customers of all size on the value proposition of managed services on AWS, and participate in architectural discussions to ensure solutions are designed for successful deployment in the cloud

● Perform data migration from on premises environments into AWS The College Board, Reston, VA, Technical Architect/ Scrum Master,Feb 2009 – Sep 2018 Projects – College bound Seniors Reporting, Staff data resource software Reporting, AP Online Score Reporting, SAT, PSAT/NMSQT, Accuplacer Reporting

● Led a team of 8 people to implement reporting solution. Acted as Cohort lead for AWS Developer Associate program. Acted as Scrum Master/ Project Manager for Product teams with a focus on guiding the teams towards improving the way they work.

● Expertise knowledge of AWS cloud computing platform, and its many dimensions of scalability - including but not limited to: VPC (Virtual Private Cloud), EC2, load-balancing with ELB, messaging with SQS (and scalable non-AWS alternatives), auto scaling architectures, using EBS under high I/O requirements, custom monitoring metrics/analysis/alarms via Cloud Watch, the AWS API and different toolkits for instrumenting it.

● Organized project planning, daily scrum meetings and reviews. Used Kanban board and Jira to track the sprint stories. Facilitated various sprint ceremonies such as retrospectives, sprint, release planning, demos, and other Scrum-related meetings.

● Tracked and effectively communicated team velocity, Sprint burn down and sprint/release progress to all stakeholders and management

● Worked on developing POC from RPA process using Blue Prism,UI Path

● As road map change for reporting architecture to use Tableau,migrated/converted 50+ Cognos reports.

● Designed and developed Cognos Report Studio and Tableau visualization solutions.

● Established Best Practices for Enterprise Tableau Environment and Cognos environments and application intake and development processes.

● Involved in performance and tuning and testing report in different environments

● Conducted BI Community of Practice (COPS)meetings and created BI best practices for Reporting. Mentored other team members and peers, through brown bag, Speak freely sessions. Vanguard Group Incorporated, Malvern, PA, Lead BI Architect, Aug 2007 – Feb 2009 Projects - Institutional Client Reporting, Client Report Card, Plan Sponsor Reporting, Risk and Treasury Applications, Plan analytics, Participant services, Participant Educational services and Online Beneficiary changes

● Gathered and refined requirements from the customer for developing reports. Scheduled and Distributed reports through Schedule Management in Cognos Connection and Maintaining Files through File Management.

● Involved in helping vanguard business users in various reporting issues.

● Created cubes and used as a data source in Framework Manager and Published Packages.

● Involved in object level, data level and report level security, Performed performance and tuning and testing report in different environments.

Cartus, Danbury, CT, Lead BI Consultant, Oct 2006 – Aug 2007 Projects - Edge reporting Applications

● Involved in Edge reporting Applications for different clients based upon the requirements

● Extensively given Training for more than 15 members in Reporting Department

● Created 5 Cubes using Framework manager IQD’s, Involved in User administration and Portal Administration

● Created more than 100 complex reports using Report Studio including conditional blocks, conditional formatting, stored procedures, and materialized views

● Used Analysis Studio for multidimensional analysis and exploration of large data sources.

● Involved in Troubleshooting for both Production and Development issues. Key Projects Experience – 2000-2006

Role Client, Location Sector Start Date End Date

Senior BI Consultant Vanguard Group

Incorporated

Malvern, PA

Financial Oct 2005 Sep 2006

BI Consultant Eaton Corporation,

Southfield,MI

Manufacturing Jul 2005 Sep 2005

Senior Software

Engineer

VISU Consultants

Ltd,Hyderabad, India

Education Feb 2001 Apr 2003

Software Engineer Sunshine Software

Services, Hyderabad, India

Consulting Apr 2000 Jan 2001

Contact this candidate