SEARCH

Solution Architect Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
SOLUTION ARCHITECT
Summary
Solution-oriented Data Engineer with more than 8+ years of diverse career experience in IT systems development and maintenance, systems and exploratory data analysis, quality assurance, project management and system implementation well versed in latest ETL Methodologies.
Skills
  • Results-driven,Customer-focused ,Team Player and Quick learner
  • Full Software Development Life cycle expertise with strong experience in ETL Framework Development
  • Proficiency in Data Engineering, Data Migration , EDW Build and Maintenance
  • Data Mart build and implementation
  • Performance Engineering
  • Data Analytics and Automation Expertise
  • Finance, Insurance and Telecommunications domain expertise
  • Reports and Dashboard build,analysis and troubleshooting
  • Analytical, programming, and inter-personal skills
  • Informatica Power Center and Data Quality
  • Expert SQL Writing and analysis skills
  • RDBMS Teradata,Load Utilities,Oracle, Netezza, Redshift
  • Shell Scripting with Unix and Perl
  • Performance Tuning and optimization
  • Cloud Implementation using AWS
  • Big Data Technologies - HDFS, Sqoop, Hive
  • Machine Learning knowledge with R and Azure
  • Front end web development using angular,html5,css
  • Reusable component development
  • Dashboard development using Tableau
Experience
08/2016 to 06/2017
Solution ArchitectCapgemini Us LLC － Bellevue, WA
  • Conducted analysis to address the CPNI data leak issue reported by the Security Team which led to the Encryption Solution in preventing data leak throughout the ETL process
  • Planned and executed the Data Encryption Project where my responsibilities include attending Business Meetings, identify the Technical Work needed to meet their Needs to Designing,Developing and Deploying a Solution that is fool-proof and doesn't impact the performance of the existing data processing steps
  •  
  •  
  •  
  •  
  • Work with the DBA's to provide Decryption Key to the Users who have a Business Case to access the CPNI data
  • Review code, Test plans and Documentation and provide necessary support
02/2016 to Current
Data Quality Analyst/DeveloperCapgemini Us LLC － Bellevue, WA
  • Identifying the anomalies in Data, doing the root cause analysis and applying the appropriate fix
  • Provide Rapid Response Support for any production failures to ensure daily data delivery deadlines are met
  • Co-designed the reconciliation process framework called ABC (Audit-Balance-Control) to ensure that the data delivered to the Business is correct
  • Work with the Marketing,Finance and Accounting Teams and ensure that their weekly,monthly and quarterly reporting needs are fulfilled
  • Acted as Solution Architect and Subject Matter Expert for Legacy Data Migration Project
  • Prepare the Design, co-ordinate with the Business Users, Development, QA and the Deployment Teams
07/2013 to 01/2016
Team Lead /Etl DeveloperInfosys Ltd － Des Moines, IA
  • Development and maintenance of Data warehouse that maintains the Commercial Insurance Policies division of Nationwide Insurance
  • The business objective of the project is to have a centralized data repository that helps the users in their business development decision making
  • End-to-end application development project involving requirements elaboration, design, build, testing, implementation, maintenance and support
  • Designed Control Framework with Informatica and Teradata with benefits like Trace ability of Data Lineage from Source to Target, ,Row level auditing - Audit trails of how the data got to where it is, Standardized Code, re-usability, faster development using easily scale able architecture
  • Building the Reconciliation process using SQL and Shell Scripting
  • Designed and Developed a Code Review Automation Tool and Mapping Generator tool using VBA which greatly reduced the development and peer-review effort
  • Development is traditional waterfall as well as agile development methodologies
  • Working with various source teams that deliver data in variety of formats – Flat Files, VSAM, XML Files, Oracle, DB2 tables
  • Delivering the data to heterogeneous targets – Teradata, Netezza, Oracle, Salesforce, Third Party ftp locations, Mainframes     
  • Review code, test plans and documentation        
  • SIS (System Information & Specification) documentation
  • Support the QA team in their testing (Iteration, System)/Defect resolution
06/2009 to 06/2013
Senior Systems EngineerInfosys Ltd － Hyderabad, India
  • Rewriting an entire application existing in Mainframe/Data Stage/DB2 to Informatica-Teradata
  • Developing mappings and mapplets to transform the data according to the business rules
  • Created a hand-shake mechanism between UNIX and Mainframe so that the audit reports can be transferred to external teams where validation is performed
  • Worked on consolidation of all the 17 existing billing systems for an Investments Client
  • Created an Automated ETL Based Pick and Load Mechanism that helped to eliminate the manual intervention needed during History Catchup.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values
  • Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
  • Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
  • Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
  • Performed data quality analysis to validate the input data based on the cleansing rules.
  • Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql queries.
  • Prepare the run books for testing environments.
  • Prepare the Implementation Plan for Production Deployment
Activities and Honors
  • Received Awards of Excellence and The Most Valuable Player Award for Outstanding performance in the projects ‘Information Management Team' and “Alternate Investments” at Charles Schwab.
  • Received numerous Client Appreciations for my analytical skills in breaking down problems, driving the team through issues and arriving at solutions.
  • Awarded a Bravo at Nationwide for my dedicated support in the continued Success of E-Product
  • Received the Hercules Award for my dedicated support in the success of Data Migration Project at T-Mobile.
Education and Training
2009
Bachelor of Technology: Computer SciencesAcharya Nagarjuna UniversityIndia
Coursework in Data Science and Data Engineering
Machine Learning using R and Azure - 5 Day Bootcamp
Trained in Amazon Web Services
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Capgemini Us LLC
  • Infosys Ltd

School Attended

  • Acharya Nagarjuna University

Job Titles Held:

  • Solution Architect
  • Data Quality Analyst/Developer
  • Team Lead /Etl Developer
  • Senior Systems Engineer

Degrees

  • Bachelor of Technology : Computer Sciences

Similar Resumes

View All
Solution-Architect-resume-sample

Solution Architect

Wipro

O Fallon, Missouri