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.

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.

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

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

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

B.Tech, Metallurgy And Material Sc.

Hsc, Computes Science

Education record