Rupesh Kolte Email & Phone Number

Stockholm County, Sweden

Stockholm County, Sweden

Stockholm, Stockholm County, Sweden

Lead Data Analyst with experience in designing, developing, and implementing requirements pertaining to Capital & Credit Risk area• Understanding of Risk Management particularly in the Credit Risk domain with good functional knowledge of Basel guidelines and banking in general.• Elicit, validate and document functional and non-functional requirements• Assist in ensuring alignment and transparency of requirements - bridging the business and IT worlds• Implementing solutions to meet end-to-end regulatory requirements • Conducting Functional and Integration Testing, validating functionality and transactions, and breaking the code through innovative negative scenarios.• Responsible for leading the team of designers who ensure the delivery of defect-free products and that the requirements standards are aligned with the target architecture• Created the Architecture runway and technical solution design for the major banking model change initiative• Acting as an ETL (IBM DataStage) technical SME to support developers with the issues • Proposed and implemented strategic data masking solution

Pune, Maharashtra, India

Business Intelligence consultant for the global leader in agricultural products, services, and solutions• Designing and implementing Data modeling and ETL framework for the agriculture-related manufacturing client• Technically leading the team of DataStage, Erwin, Cognos, Webfocus developers to deliver the complex projects• Implementing end to end Projects, from requirement gathering, solutions, database design, ETL, and reports development and maintenance • Migration of IBM DataStage tool from version 8.7 to 11.5• Performance tuning of the DataStage Codes and database queries as well as introducing process improvement in the existing design to ensure before-time delivery of reports. • Capacity planning of DataStage servers for future growth

Pune, Maharashtra, India

ETL – DataStage SME in GSOR -Global Sales Operation Reporting for global Automobile Manufacturing client• Understanding the requirement and business needs to provide the design and solution • Make the data model architecture of proposed solutions • Implemented solutions using Dimensional modeling – Star and Snow flacking • Designed and developed ETL jobs using various stages like Pivot, SCD etc in DataStage complex transformations • Analyze the current manual work by business and automated process thru BI techniques

Birmingham, England, United Kingdom

Datawarehouse Analyst for Automobile Manufacturing client• Performing the role of IT analyst to scope requirement from the business and co-ordinate offshore teams for the delivery • Involved in preparing the mapping document for source to target • Extracting data, cleansing, transforming, integrating, and loading data into Data Warehouse • Used Sequential file, Oracle Enterprise, file set, datasets, change capture, filter, Lookup, Merge, Join, Transformer etc stages for designing the parallel jobs in the DataStage • Developed and implemented strategies for performance tuning, including parameter sets for easy maintenance, partition key in Parallel Extender job for bulk loading, reusable shared containers for code standardization • Performed testing based on the higher environments to ensure defect free delivery

Pune, Maharashtra, India

DataStage expert during the IT transition of Automobile Manufacturing client• Understanding of existing technical client architecture and taking charge of overall infrastructure • Migration of Jobs from existing DataStage 7.5.1 to DataStage 8.7 • Monitoring, stabilization, and performance tuning of daily batch load • Set up a process for code deployment to higher environment involving UAT and Production gateway review checkpoints • Documentation of existing infrastructure and code components including preparing mapping document for source to target• DataStage and database job design and development for change request

Mumbai, Maharashtra, India

DataStage Developer for Material Science and manufacturing company specialising in sticky labels• Involved in High-level and low-level DataStage design and implementation of different data modeling layers and structure using dimensional Modeling • Used DataStage Designer for developing various jobs and sequences to extract, cleansing, transforming, and load data into Data Warehouse • Standardization and parameterization using shared containers for smooth portability and flexibility during runtime• Creating real time jobs using XML and MQ stages to read data from Message Broker queue • Data validation through reconciliation scripts • Facilitated Unit Testing, System Integration Testing, Functional Testing and User Acceptance Testing

B.Tech, Metallurgy And Material Sc.

Hsc, Computes Science

Education record