Akshay Kasekar

• Consult with client to gather information about program needs, objectives, functions, features and input/output requirements.
• Managing a team of 10+ members for assignment of tasks using JIRA board following Agile model.
• Handle Scrum meetings with peer leads to discuss inter team status and dependencies.
• Promoted more than 2000 DQ Rules, 100+ Scorecard/Profiles and handled 500+ critical data elements.
• Design the Data Quality measures and their outputs using Collibra DQ, IDQ, Oracle SQL, Unix Scripting, Pentaho, and other technologies.
• Creating a Data Governance strategy for client. Collaborate with Data Stewards to gather requirements around DQ Rules and propose optimization if applicable, then design and develop these Rules with Collibra and IDQ.
• Create profiles and datasets using Collibra DQ jobs and adding rules based on requirements.
• Design Logical Data Objects, Profiles, Scorecards, Mappings and Workflows using Informatica Developer.
• Extraction and transformation of source data with Informatica Developer. Deploy mappings and workflows that will run in a scheduled, batch, or real-time environment. As per business requirements, perform thorough Data Profiling with multiple usage patterns, root cause analysis and data cleansing.
• Design Scorecards based on the DQ rules and graphically represent the quality of each critical data element to the business. Providing recommendations for modification or creation of business rules based on data results. Creation of Unix Scripts for automating source feed extraction/loading and IDQ components execution.
• Writing complex Oracle SQL queries for fetching source data. Resolve production issues by analysing logs using Splunk tool.
• Execute the required ETL processes using Pentaho for loading metadata. Follow the Agile methodologies for deployment of all the release components.
• Support project personnel in resolving fairly complex program problems and making recommendations on resolutions.
• Demonstrate new features developed to all the stake holders. Document the work done and upload them in Confluence.

Tools: Collibra DQ/DG, Informatica IDQ 10.4.1, Axon, EDC, SQL Developer,Putty and WinSCP, GitHUB, JIRA

Achievement: 3 Spot Awards for multiple automation tasks, 1 Team award, 1 Innovation Award

• Collaborate with client to gather requirements around Critical Data Elements and propose optimization if applicable, then design and develop matching techniques for de-duplicationof records using Informatica Data Quality transformations.
• Designing Logical Data Objects, Mapplets, Mappings, Workflows and Applications using Informatica Developer (IDQ). Data cleansing, transformation and generation of unique records using standardization, parsing, address validation, grouping and matching process. Developed the reporting module in IDQ used to generate QlikView reports.
• UNIX scripts for execution of IDQ applications, workflows and develop file extraction process.
• Writing oracle procedures, functions and complex queries for data loading process. Schedule IDQ jobs and perform required changes through Control-M. Handle activities related to releases in production. Build and Deployment using IBM RTC.

Tools: IDQ 10.1, SQL Developer, Putty and WinSCP, IBM RTC, Control-M, Qlikview

Achievement: Team award for automating the build and deployment process, Rise award for individual performance

• Analyzing the data generated by business processes, source to target mapping of the data elements, creating indexes and aggregate tables for data warehouse design and development using ETL tools like Data Integrator and Informatica PowerCenter. Designing source to target mappings on the critical data elements and apply transformation on data for loading into target warehouse.
• Creating Oracle scripts such as procedures, functions, and views and for data conversion and migration process. Migrating client schemas from a lower version to a higher version. Import/Export of critical data elements and their workflow setup using Data Integrator.

Tools: Informatica PowerCenter, Pervasive Data Integrator, SQL Developer, Unix Shell

Achievement: Spot Award for period Aug – Dec 2015.

• To code and unit-test the new features in APEX® and enhance the existing features using Pro-C. Enhancement of the migration procedures, functions, packages etc.
• Identify the mismatch in tax calculated in the system by debugging the data. Creating import and export scripts for data migration activities. Data extraction from files in different formats and loading it into the database. Shell scripting to monitor and develop the daily data loading process.

Tools: Informatica Powercenter, PL/SQL Developer, Linux, Pro-C

Achievement: Accelyance Award Nov 2015 – Jan 2016