Aruna Sankaran

Role aims to work along with Enterprise Architect in identifying the right tool for a data capability. Provide solutions to set up the platform in the estate and also provide designs for the system built using the data capability platform.

Key Achievements:

• Performed proof of value to assess and evaluate new data tools such as Aperture data quality, Immuta, Policy based data access control, BigId for data discovery, Collibra for Data Catalog
• Strong knowledge in data spaces such as data movement, data lake, master data management, reference data management, data quality, data discovery, data catalog, data access, data privacy, data sharing and data collaboration.
• Provide solution architecture guidelines, principles and architecture patterns to the data capability
• Provide solutions using the tools and technologies available in the data space
• Experience in design and build data governance controls within the solutions
• Experience in working along with the data architects and information architects to represent the right data in the right way in the solutions
• Collaborated with the business and data leaders in forming the Business data strategy framework for the organization.

Client: Astrazeneca – Patients: (Sep 19 – Sept 22)

Role: Data Engineer

Project aims to build a Data product for patients and study data. The project also aims to index the clinical datasets, facilitate the search and find patients' dataset for further detail exploration and advanced analytics.

Key Achievements:

• Built and Implemented data pipelines doing complex clinical data indexing on large clinical datasets.
• Implemented integration between reference data management tool to enrich the clinical datasets with enterprise reference data.
• Built complex data pipelines jobs to Integrate with Collibra Data cataloging tool via APIs.
• Used AWS Services such as SNS, SQS, S3, EC2, Glue
• Explored S3 file data using AWS Athena service.
• Implemented a prototype/proof-of-value to integrate clinical data to build knowledge graphs using Neo4J.

Client: Astrazeneca – Data Hub: (Nov 18 – Aug 19)

Role: Data Engineer

Project aims to build a Data foundation, putting data at our heart and in the cloud and putting data and analytics at their fingertips. The project aims create the data platform and services to deliver the single source of truth for decision making and easy data access for descriptive and advanced analytics.

Key Achievements:

• Perform Source discovery and Source system analysis.
• Built data profiling tools using PL/SQL procedures and Python to analyze source system data.
• Built a complex NLP processing tool to identify personal Information in entities and mark for masking.
• Built a Gamification tool to score the performance of the team based on Jira parameters.
• Built complex ETL jobs to extract data from various sources such as database, files and loaded S3 buckets.
• Implemented jobs using powerful dynamic schema feature to extract data from varying schema source tables.

Client: Astrazeneca - Datalake and Central Operational Data Store System:

Role: Data Engineer

Project aims to build a Datalake system to store all data in raw format and to build an Operational Data store by integrating data from multiple sources, transforming data using additional operations for reporting and planning systems of a large Finance transformation programme.

Key Achievements

• Built complex data pipelines from various sources such as database, files and loaded into target databases.
• Built and Implemented data pipelines using powerful dynamic schema feature to extract data from varying schema source tables.
• Performance tuning of Talend jobs, MySQL queries and design jobs to load in parallel nature.
• Have used AWS services such as SNS, SQS, S3.
• Built reusable components using Joblets and Java routines
• Extensive use of GIT version control tool
• Implemented Rest Services, Talend ESB features and Webservice calls from Talend Jobs.
• Performed Data Profiling using Talend.

Client: Target - Synergy – One Vendor – Multi-Channel Integration (Jul 12 – Mar 13)

Just in Time Promotional Replenishment (Mar 12 – Jul 12)

Pricing Systems – City Stores with Multiple Competitors (Mar 11 – Feb 12)

Pharmacy Pricing (Aug 09 – Feb 11)

Market Pricing (Oct 07 – Jun 08)

Role: Technical Lead

Worked on project building systems for integrating Vendor management systems, Replenishing with reduced backrooms, implementing different pricing systems such as competitive shop pricing, Pharmacy pricing and Premium pricing.

• Lead a team of 20 across onshore and offshore, working on different technologies
• Explored and acquired complete knowledge on Retail concepts and pricing knowledge.
• Did AS-IS analysis of the systems and Conceptualized the To-Be part of the Systems.
• Carried out complete feasibility study for technical integrations across systems.
• Devised design solutions for various modules of Retail systems and pricing systems of the retailer.
• Reviewed Code, Unit Test Case and System Test case, and provided support to business team in UAT.
• Built many complex modules of the system which directly has impact on pricing, replenishment and order management for the retail business.
• Built a prototype of the current and To-Be business rules to avoid the post-production impacts and helped clients decide the business rules
• Provided solutions for recovering the critical pricing data of the system, post implementation
• Provided extended Implementation assistance for new offshore store opened in Alaska and Hawaii
• Built recovery methodologies for the system on the go to provide support in the price sensitive stores
• Defined and established a co-ordination process between multiple COEs
• Defined Project scope and involved in requirements gathering and defined high level requirements
• Devised Project plan and project estimations
• Performed Project monitoring and metrics reporting
• Managed and mentored the team working on the technical analysis of vendor systems
• Measured key business benefits of the project as part of scoping
• Resolved project schedule crisis during construction phase

Awards:

• Best Team Award for implementing the critical project by resolving the project schedule crisis in the Construction Phase of the Project (Nov 11)
• Received Bravo Award for effective management and result oriented leadership skills while executing Pharmacy Pricing Project (Feb 10)
• Received Star of the Month Award for the innovative contributions in the Pricing System Solutions, from Tata Consultancy Services Limited (Sept 2009)
• Won Ring Award for formulating the complex Pharmacy Pricing rules for Target (Dec 08)
• Received Star of the Month Award for outstanding performance in Cross-Team collaboration by rescuing another project out of crisis (Aug 08)