Solution Architect Resume Example
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
|
|
Experience
08/2016 to 06/2017
Solution ArchitectHp Inc － Atlanta , GA
- 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/DeveloperMicrosoft Corporation － Memphis , TN
- 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 － City , STATE
- 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 － City , STATE
- 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
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.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Length
- Clear contact info
- Typos
Resume Overview
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
