Tejal Jawale

• OSKAR is part of client on-boarding platform of J.P.Morgan, Provides all flavors of Business Intelligence like canned report, KPI reporting, Dashboards
• In OSKAR we follow Agile Methodology for effective development process
• Always keep the reporting experience enriched with Latest Technologies.

Contribution :

· Gathering information from Business Users & MIS team to get them translated into JIRA stories. Prioritizing requirement as per Business need & team’s capacity.

· To decide the load strategy for the newly designed data base tables- could be one time load, truncate load or using any of the SCD strategy – SCD 1 or 2.

· Working with Vendors & managing their work.

· Develop Informatica mappings by applying business logic and improvements into existing Informatica code.

· Peer Review for Informatica and BO code.

· Informatica installation and Admin console setup for 10.1 version in all environment.

· Developed UNIX scripts to automate jobs.

· Developed Python scripts to handle JSON data from api and load into data mart

· Production support for monitoring Control-M jobs and coordinating with various team to resolve issue on failure.

· To develop universe and reports in Business Objects 4.1.

Create backend queries for QlikView and Tableau dashboard.

· Setup ARM automation deployment methods for Database, Informatica and Unix component.

· Qlikview and Tableau development for adding fields into Export and changing logic for existing fields.

.Take care of Informatica, BO, Unix, Qlikview, Tableau, and Control-M deployment into Production.

· Informatica, database and Unix Environment management.

. Lead in GOS migration project to take care of DB, Informatica installation, and setup on servers, code migration, and connectivity testing for reporting and dashboard tools.

. Currently Leading AWS migration project where we need to point dashboards to Databricks.

Technology Used :

Informatica PowerCenter 10.5.5 ,Business Object 4.3 Oracle, SQL server, Unix, Qlikview, Tableau, Control-M, Bitbucket, Python, Ni-Fi.

• TeliaSonera is Leading Telecom Company in Sweden and Finland which offers a large range of telecommunication services in Sweden and is the leading supplier in the Swedish telecom market
• BI-TS is a central data warehouse created to replace the existing legacy systems in TeliaSonera with an intension to have a single version of truth making it easy for the client to manage the operations of TeliaSonera
• This data warehouse maintains information with respect to Subscription, Product, Revenue, Party, Multi-Access, and Network Activity related data.

Contribution:

• Requirement gathering, solutioning and effort estimation of small development proposals and change requests

• Was involved in requirements, design, development, testing and deployment phases of the project involving developments in Informatica, Teradata and Unix

• Migrating from Cascade Scheduler to Control-M Scheduler

• Bug fixes in daily production loads as part of Maintenance activities.

Technology Used:

Informatica 9 PowerCenter, Teradata, and Unix.

• JPMorgan is a leading financial firm
• OSKAR is a part of Shared Services stream under RDT Global
• Onboarding Sponsorship KYC Analysis and Reporting (OSKAR) is used to generate a mixture of ad hoc and Canned MIS reports for various Reference data Applications like CDD, COLT, SKYC, SCOT, UAS, CSP, CASII, Adoption Metrics etc
• The ad hoc reporting would enable the Business users to extract desired information from the Application and canned reports will provide necessary data already formatted
• Not all data for all these Applications is available in OSKAR as of now
• The WCOB Portal will be the single point of entry for on boarding activities associated with a client relationship within the Wholesale Bank, based on User’s entitlements.Also the portal supports the complete workflow of approval of KYC request till client gets KYC complete.

Contribution :

· To analyze and develop Informatica objects including mapping, sessions, workflows as per the new reporting requirements

· To decide the load strategy for the newly designed data base tables- could be one time load, truncate load or using any of the SCD strategy – SCD 1 or 2.

· To design and build the Data mart as per the reporting needs, so as to capture changed data using power exchange in near real time.

· SIT,UAT, PreProd deployment for ETL,Unix script and BO.

· Informatica installation and Admin console setup in SIT,UAT and PreProd environment.

· Production support for monitoring Control-M jobs and coordinating with various team to resolve issue on failure.

· To understand the system and do the impact analysis of the new requirements in order to keep the old system intact and running.

· Unix script development to run the workflows through script.

· To develop universe and reports in Business Objects XI3.1.

· To carry out the test driven development, automated deployment using the AIM script and automated regression testing.

· To test the new developments and the enhancements done to the database.

· To ensure that all the processes are in place for the development/enhancement.

Ensure configuration management through Subversion maintenance.

Technology Used :

Informatica Power center and power exchange, SQL, Business Objects, Unix, Control-M