Technology Architect Resume

SUMMARY

Highly competitive and resourceful software professional with more than 14 years of work experience and around 7 years of experience in BI technologies. Expert in implementing solutions such as Data Lake on HDFS, Data Masking and Enterprise Data Marts.

TECHNICAL SKILLS

UNIX shell scripting

SQL Server / T - SQL

Excel Macros

Microsoft APS

Oracle

Powershell

Sqoop

SSIS

Vikram Goyal (Solution Architect)

PROFESSIONAL EXPERIENCE

Technology Architect

Confidential

Responsibilities:

Created data ingestion framework for loading varied data such as multi-structured VSAM, XML, JSON, zip, fixed width files, SQL server, Oracle etc. to a Data Lake on HDFS using HIVE, SQOOP, SSIS and python.
Led a team of 4 software professionals to create two complex Data Marts using T-SQL on Microsoft PDW implementing load strategies such as SCD1, SCD2 and Fact Upsert. Enhanced the code of common data warehouse load strategies that helped reduce the development time by nearly 30%.
Implemented a solution to ingest data of a complex XML (both in terms of structure and data volume) to Data Lake using HIVE. This solution resulted in cost saving of USD 300K for the client.
Created reusable components in PySpark for implementing data load strategies such as SCD1, SCD2 and Fact Upsert. This led to a development effort saving of 30%.
Led a team of 3 software professionals to migrate the HDFS layer of Data Lake from HDInsight on windows platform to Cloudera on UNIX platform.
Took initiative to analyze the complete application Autosys batch which helped reduce the batch run time by around 2 hours. Optimal job dependencies, performance optimization of certain long running processes and coordinating with the upstream teams to define SLAs contributed to this saving.
Created two frameworks, one using PowerShell to send data extracts from views created on mart tables to external systems and another one using SQL server to create / update stats automatically on all tables for a given database.
Analyzed Informatica mappings on legacy platform and converted them to T-SQL procedures on Microsoft PDW.
Worked on onboarding the application code to Bitbucket and automating the production deployment process to use XLDeploy instead of manual deployment.

Technology Lead

Confidential

Responsibilities:

Headed a team of 3 software professionals to develop Application Data Profiling and Masking solution using Informatica Power Center and Informatica TDM.
Automated the complete process of data masking, right from getting the data from source databases till saving off the masked copies, by building an entirely new framework using UNIX shell scripting and Oracle. This helped in reducing the processing time for creating masked copies of application data by nearly 50%.
Created data comparison tools using excel macros to compare source and masked data copies to ensure the integrity and completeness of masked data which helped save around 70% of validation effort.

Technical Analyst

Confidential

Responsibilities:

Business requirement analysis, requirement gathering, functional design, application design, coding and unit testing of ELT framework created on Mainframes using COBOL, JCL and DB2.
Mentored a team of 10 software professionals for undertaking the design, development, testing, integration testing and preparing test completion reports etc.
Created the ELT framework for migrating data for customer output applications such as Alerts, Statements, Advices, Tax Reports and Certificate of Interests etc.
Design and code reviews for internal team and other projects (of same client) as external reviewer.
Performed code configuration and management using Endevor.

Software Engineer

Confidential

Responsibilities:

Business requirement gathering and analysis, design, development, unit testing, integration testing, bug-fixing and deployment of Cash flow management system for various products like Bonds, ABS, Deposits, IRS/CRS etc. The Cash flow management system was entirely built from scratch on AS400 using COBOL, SCL and DB400.
Worked in close association with the client team for two years at the client location in Brussels, Belgium.
Supported production support for the Back Office system on Mainframes and Front Office system on AS400.
Monitoring the EoD batch jobs for the MRMa and SOPHIS applications.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship