Project#5 :
Jan 2018 to Till date | RPA Technical Architect (Associate Manager) | Designed 50+ Automations
Clients: Nestle, AIG, Roche, Baker Hughes, Equinor, Bayer and Vodafone - Bangalore, India
- Performing discovery workshops and check the feasibility of automation followed by deriving the complexity for implementation
- Conducting PDD Workshops and capture the click level details of process, drafting the business rules and exceptions along with AHT details.
- Checks the possibility for process optimization or standardization by conversing with business teams.
- Discussing with Process SME’s, Application owners to understand the gaps
- Prepares Solution Design Document with all the modules of to be process
- Analyzing the reporting and notification needs of costumer and design accordingly
- Ensures the design will be complaint for GDPR, HIPA and other regulatory norms where applicable
- Defines the granularity level of logging methodology to follow as per customer needs and optimized logging
- Ensures to incorporate customer defined BCP and DR methodologies while designing to be process.
- Notifies the in scope and out of scope modules based on Judgmental or rule based analysis approach
- Review and create gap assessment report for RPA Solutions that are migrating from one tool to another
- Developing Proof of Concept where required, especially on evolving tech areas
- Designing workflow automations with Microsoft Power Automate cloud flows
- Intelligent Document Processing with MS AI Builder and other OCR tools by using pertained models or creating custom models.
Environment : Blue Prism, MS Power Platform, MS AI Builder, ABBY Flexi Capture, Document Automation tool kit, Decipher, Capture, Automation Anywhere
Target Applications : SAP, Team Site, PDF Files , Excel Macro, Service Now, Argus, Nessoft, Neilsen portal etc..
Project#4 :
Oct 2016 - Apr 2018 | RPA Technical Lead (Assistant Consultant) | 5 Automations
Client : Credit Suisse - Bangalore, India
- Requirements Gathering and OE Fitment: Gathered requirements to assess the suitability of incoming data for process automation.
Standardized template formats for efficient processing.
- Feasibility Analysis: Evaluated existing processes for automation feasibility.
- Client Engagement: Conducted meetings to showcase RPA capabilities to ongoing projects and potential clients.
- Process Optimization: Reviewed process flows and naming conventions, ensuring compliance using Credential Manager.
Collaborated on documentation with RPA consultants (IPA, FDD, etc.),
- Analyzed manual flows for each OE level and standardized templates, dynamically updated processes and business objects to accept environment variables instead of hard-coded inputs.
- Proof of Concept (POC) Development: Implemented enhanced business requirements through POCs.
- Process Monitoring and Optimization: Monitored control room processes and resolved issues by analyzing built-in workflows.
Collaborated with the Central RPA team to identify and address bottlenecks.
- Surface Automation: Overcame limitations through workarounds to implement surface automation where needed.
Environment: Blue Prism 5x, Oracle, MS Office,
Target applications: GRACE, BWise
Project#3 :
Jan 2016 – Sep 2016 | Reporting Team Lead | Multiple reports
Client : Credit Suisse United Kingdom (London)
- Analyzing Requirements and creating reporting sample templates to capture in FRD.
- Coordinating with DB Team in creating required database views which further used to create/generate reports.
- Updating BO universe as per requirement and creating new Webi reports.
- Enhancing existing report functionality like query level or formatting level and scheduling the reports.
- Implementing the security levels to restrict the access as per required user groups.
- Managing BO server, updating the BO application release patches whenever required since we don’t have dedicated admin teams.
- Responsible to deploy the reports and BWise classes from lower to higher environments (Non PT environments) as we don’t have separate release management teams for not PT environments
- Monitoring the server loads through Central Management Console to make sure no bottles necks will hit to bring the server down.
- Coordinating with L2 Teams whenever support required.
Environment : Business Objects 4.1, Oracle 11x, .Net Frame Work, BWise (GRC Tool).
Project#2 :
Dec 2013 - Dec 2015 | ETL Developer (IT Analyst) | Multiple ETL Transformations
Clients : Credit Suisse - Singapore & Bangalore, India
- Worked on Power Center client tools like Source Analyzer, Mapping Designer and Transformations Developer.
- Applied various types of validation rules for source data.
- Created Reusable Transformations for Multiple Mappings.
- Used Mapping Parameters and Variables.
- Developing Informatica mappings & tuning them when necessary.
- Run the source files by using KRI portal and updating the status tables
- Deploying the code from DEV,SIT,UAT and PROD
- Supporting phase 1 application
- Analyzing and resolving issues identified by Business users
- Attending weekly Status calls about enhanced requirements
- Providing KT to L2 team about new feed release happens usually bi monthly.
- Creating LLDs and Run books about the feeds
- Monitoring and optimizing performance for ETL jobs
Environment : Informatica Power Center 8.6.1, Oracle 10x, .Net Framework, Business Objects.
Project #1 :
Apr 2011 - Dec 2013 | ETL Developer | ETL Transformations
Clients : Swiss Re, Deutsche Bank
- Analyzing and solving Issues which were a bottleneck for over a year
- Worked on Power Center client tools like Source Analyzer, Mapping Designer and Transformations Developer.
- Analysis, design and coding of the business process as per the technical spec.
- Enhance/Develop the mapping, load the database tables and files unit test the data.
- Written Unix Shell Scripts to process files as per technical spec.
- Create the Batches to run the batches through Auto batch and TWS.
- Worked with SCM Platform (SR Host) to promote the jobs.
- Used P&C tool to submit the created jobs.
- Extensively worked on transformations like lookup, expression, source qualifier, filter, router and XML Sources, Flat files.
- Involved in the status calls to discuss and clarify business requirement details with on-site Coordinator. And updating status about regular assignments in status calls.
- Used Informatica Version Control for check-in and check-out the objects in the development repository to keep track of the changes as versions.
- Attending the calls with users on a regular basis for providing the support over phone for the day to day issues.
- Interaction with technical team for functional specifications, clarifications for Mapping / workflow customizations.
- I have extensively worked on Period Closure Issues.
- Interact with the Users regarding the business issues.
- Preparing technical specification documents, Run books for Support team
- KT to Support team for newly deployed code into Production
- Co-ordination with Upstream and Downstream systems to ensure smooth running of feeds.
- Involving Status Meeting for Critical Issues. Excellent knowledge on the End to End process.
- Investigate the data mismatch/feed not delivered/files not arrived issues and solve them at the earliest.
- Attending status calls on Incident tracker
- Identifying Performance issues and providing permanent solutions
- Creating KB articles on recurring data issues.
- Participate in the Global Change Management call representing DB Feeds.
- Given various KT sessions to the newly joined associates
Environment : Informatica Power Center 9.5.1, Oracle 11g, UNIX