Sandeep Ray
Guadalajara
Summary
Business Intelligence Technical Architect with 12 year career in building data intensive applications, tackling challenging architectural and scalability problems in Datawarehouse. Possess comprehensive knowledge and hands on experience in ETL Abinitio. Proven track record of taking ownership with details oriented approach to identify the root cause of issues, troubleshoot and deliver solution to real world data related problems with minimal supervision.
Overview
12
12
years of professional experience
Work History
Technical Architect
Wipro Technologies
Guadalajara
04.2017 - Current
- Analyzing user requirements involving critical risks and regulations data using Agile methodology.
- Designing, Developing and modification (data transformation and data movement) of complex systems using ETL/Ab Initio, SQL,Linux, Express IT,Conduct IT, Control Center as key tools.
- Support ongoing ETL efforts for development , QA and production environments.
- Providing application design guidance and consultation, utilizing thorough understanding of application technology, tools and existing designs.
- Analyzing test results and recommending modifications to applications to meet project specifications.
- Used Python to preprocess data and attempts to find insights.
Team Leader
Tata Consultancy Services
Guadalajara
08.2015 - 03.2017
- Developed several generic Ab Initio graphs to support reusability that saved up to 50 % on development times.
- Automated ETL process, making it easier to wrangle data and reducing time as much as 40%.
- Built Unix scripts that was used across multiple products which calculates business for particular month along with it does various validation of files such as File Name validation, record count validation, trailer record validation, duplicate record validation and orphan record validation.
- Successfully implemented high visibility project like Optima warehouse which consolidates risk data form various source systems like SAS datasets, Oracle table, Manual files.
- Played key role in server migration project, CPU enhancement,COB server implementation project.
Senior Developer
Tata Consultancy Services
Guadalajara
04.2013 - 07.2015
- Played key developer role for Datoteca migration project where the requirement was to engineer the existing code from Mainframe (with DB2 as database) to ETL Abinitio (Teradata as database)
- Prepared design document, coding standard document, naming convention document, defect log document for project outflow.
- Developed Ab Initio graphs as part of reverse engineering by following mapping shared from Mainframe team followed by unit testing of data and integration testing to match data between DB2 (loaded from Mainframe) and Teradata (loaded by newly created Abinitio jobs)
- Job scheduling(JIL creation) using Autosys tool.
- Coordination between offshore and Onshore team by knowledge sharing.
Developer
Tata Consultancy Services
Bangalore
04.2010 - 03.2013
- Understanding existing business model and customer requirements.
- Extensively used Ab Initio to load data from flat files and Oracle.
- Performed unit testing of developed graphs and enhancement upgrade of transformation as per business rule.
- Developed Unix script which runs jobs and send status of execution in colorful email to respective users.
Education
Bachelor of Technology - Electronics And Telecommunications
Biju Patnaik University of Technology
Bhubaneswar, Odisha06.2009
Skills
Ab Initio
Unix shell scripting
SQL
Autosys, Control Center
Python
Passport
Country of Issue - India
VISA- Mexico Permanent Resident
VISA - USA B1 & B2
Languages
Oriya
Native language
English
Advanced
C1
Spanish
Upper intermediate
B2
Timeline
Technical Architect
Wipro Technologies
04.2017 - Current
Team Leader
Tata Consultancy Services
08.2015 - 03.2017
Senior Developer
Tata Consultancy Services
04.2013 - 07.2015
Developer
Tata Consultancy Services
04.2010 - 03.2013
Bachelor of Technology - Electronics And Telecommunications
Biju Patnaik University of Technology
Similar Profiles
Sourav PalSourav Pal
Senior Software Engineer at Wipro Technologies, WiproSenior Software Engineer at Wipro Technologies, Wipro
Abhishek PawarAbhishek Pawar
Financial Analyst at Wipro TechnologiesFinancial Analyst at Wipro Technologies
PRIYANKA GOPUPRIYANKA GOPU
Manual QA Engineer at Wipro TechnologiesManual QA Engineer at Wipro Technologies