SUMMARY

• Over 14 years of IT experience in Project Management, Analysis, Design, Development, Testing and Implementation of Client/Server Applications.
• Over 2 years of experience as a Cloud Data Architect in Amazon Web Services including EC2, S3, Database Migration Service, IAM, Elastic Beanstalk, CORS, VPC, RDS, CloudWatch, Athena, Glue and Security Groups.
• Over 6 years of experience working as a Tech PM and Tech lead involving onsite and offshore model in Agile methodology primarily in Scrum and Kanban.
• Over 6 years of BI experience in Business Objects, Cognos, Actuate, Crystal Reports and BO/Crystal Java API’s.
• Over 2 years of experience as a Business Analyst working with the end user in gathering the requirements and working with the development team throughout the life cycle of the project in meeting the business expectations.
• Working experience on Big Data technologies.
• Experience Leading and Coordinating cross - functional, cross-departmental, cross-company teams that are responsible for all aspects of projects, from initiation to closure.
• Experience of working in SQL, PL/SQL & ETL implementation across projects throughout the career.

PROFESSIONAL EXPERIENCE

Cloud Data Architect

Confidential

Responsibilities:

• Architect the EAP platform to facilitate the existing CDW architecture across LATAM countries in BigData Platform for AML Monitoring system.
• Modelled the data migration from Oracle to AWS using Database Migration Services and Schema Conversion Tool.
• Setup AWS Athena for AML Suspicious Activity Report application using AWS Glue Crawler.
• Worked on Elastic Beanstalk to implement applications designed using dockers and containers.
• Coordinated the movement of documentum related files from AML Investigations and Monitoring systems in S3 buckets.
• Implemented IAM roles, Security Groups and Access Control Lists for accessing HDFS based of country specific access criteria.
• Implemented CORS for accessing data across regions.
• Enabled VPC flowlogs in conjunction with CloudWatch to capture logging data.
• Modelled the ETL implementation of CDW data from the product processors into EAP system.
• Developed Hive Scripts, Hive UDFs for implementing the ETL logic within HDFS.
• Used Sqoop to import data into HDFS from Oracle and Access databases.
• Conceptualized the Data Warehouse for AML application using Oracle’s Data Vault technology.
• Lead the Build and Release aspect of the AIP application for all DB and ETL deployments by creating builds using eclipse and deploying using RLM.
• Implemented the VPD policies across AML application as part of Security implementation.
• Enhanced performance of Data Retrieval for downstream systems by implementing functional indexes, composite indexes based on business keys, in-memory tables and partitions.
• Experience using Hue/Hive to analyze the EAP application for consumption into AML Investigations Platform.

BI Technical Lead/PM

Confidential

Responsibilities:

• Customized the switch from Actuate to Business Objects involving 12000+ reports using Crystal Java API.
• Setup Issue tracking system across projects in SharePoint and HP ALM/QC for Business/End Users to track UAT issues.
• Displayed insight in highlighting the security concern associated with the project and coordinated the implementation of the fix.
• Interacted with users across the globe on a daily basis in resolving issues related to data, access, adhoc requests, training and security setup.
• Perform Data Analysis by merging data from BI tools and Database as required by the senior management.
• Prepared Test scripts for the migration of reports from Discoverer to Business Objects and Security related testing in the application.
• Collaborated with development and QA teams to plan project sprints, monitor workflow and make timeline adjustments as needed.
• Coordinated weekly project status meetings and provided project reports to the Senior Management.
• Guided teams to switch to CI/CD model for automating the deployment process to minimize the dependencies on admins.
• Helped teams to be self-reliant for fetching application logs and analytical queries by guiding the switch to CAS and Enquiry Framework.
• Coordinated COB tests across supported applications including planning, design and execution.
• Worked closely with admins and development team on Production failures in resolving the issues in a timely manner to minimize the impact on User community.

BI Developer

Confidential

Responsibilities:

• Delivered Complex Reports for an Intranet Analytical application using Actuate Reports meeting the tight deadlines.
• Modelled Business Objects Reporting Solution by creating a strong and scalable BI solution that could handle huge volumes and variety of data with integrity.
• Implemented the use of Store Procedures as against to the Reporting Functionalities for Performance Enhancement and Code Integrity.

BI Developer/Analyst

Confidential

Responsibilities:

• Fully involved in the design and implementation of CADDIS reports from simple to complex.
• Developed customized reports as per business requirements.
• Worked on domains like TRUST, FISCAL, PROVIDER, CONSUMER and Provider of Services in CADDIS.
• Developed highly complex budgeting reports.
• Developed libraries and global functions.
• Formulated SQL queries, SQL Packages and Stored Procedures.
• Worked on Performance Tuning of SQL queries and Actuate Reports.