Akankhya Mohapatra

About the Candidate

AKANKHYA MOHAPATRA akankhya.mohapatra93@gmail.com|438-725-7499 Ottawa,K2V0J3 https://www.linkedin.com/in/akmohapatra/

SUMMARY

As a seasoned IT Analyst with 5 years of experience in the public service and finance sectors, I utilize my expertise in data analysis, business requirement interpretation, and programming languages to drive business growth and navigate complex platforms, leveraging ETL tools and data-driven insights to optimize operational efficiency and foster innovative solutions.

TECHNICAL SKILLS

• Programming languages: Python, R, SAS • Databases: MySQL, MS SQL Server • Tools Used: Aginity, DBeaver, IBM DataStage, IBM Cognos, Control M, Salesforce, SAP BI/BW, SAP ERP, RPA(BluePrism, UiPath), Jupyter, GitHub, Excel, SharePoint • Analytics Tool: Power BI, JIRA • SDLC Model: Agile, Waterfall • Certifications: Microsoft programming in C#(70-483), BluePrism Developer Accreditation exam

PROFESSIONAL EXPERIENCE

Role: CS02 IT Analyst/Developer, CRA, Ottawa (Jul 2023 – Present) • Spearheaded the end-to-end implementation of multiple data mart solutions tailored to meet the distinct needs of benefit programs governed by stringent validation and control parameters. • Developed several data jobs leveraging strong hands-on experience in creating server jobs, parallel jobs, job sequences and batch jobs in IBM Information Server (DataStage). • Created data views using SQL queries and incorporated new variables to deliver business-relevant data. • Performed code fixes by analyzing and aligning the dimensional and relational database design of the data warehouse ensuring data consistency and integrity across both models. • Proactively identified and rectified source of errors in ETL jobs and enhanced data reliability. • Successfully mitigated data loss by overhauling outdated legacy system design and logic formulation leveraging ETL techniques to meet client requirements. • Ensured accurate data outcome and enhanced datamart performance through unit testing and integration testing. • Leveraged Jira to efficiently manage and prioritize multiple tasks, ensuring completion of issues and accurately update status following agile method to understand and develop adequate BI solutions. • Utilized Cognos to perform thorough data validation through scenario-based testing and created queries that joined multiple tables to meet client reporting requirements. • Created comprehensive costing estimates for new ETL and Cognos reporting initiatives, ensuring accurate resource allocation and budget planning to meet business objectives. • Involved in interdepartmental interactions to identify and scope business requirements for high priority projects. • Delivered presentations to diverse clients with tailored solutions highlighting the implementation process and the strategies administered to meet business needs. • Created source to target documents for designing, reporting and knowledge sharing. • Created comprehensive system design documents and wrote bash scripts for migrating jobs from UT to UA and PR and streamlined processes. • Monitored job run, alerts and notifications in Control-M and Remedy and coordinated with scheduling team in evaluating and resolving failed jobs. • Contributed to peer reviews, provided constructive feedback and mentoring to ensure high-quality development.

Role: Data Integrity Analyst, Chep, Mississauga (Oct 2022 – Jan 2023) • Identified pallet leakage of $20 million across retail chains in North America ensuring target corrective insights. • Identified areas with maximum pallet losses with the top 16 major retailers and proposed implementing a python-based tool to detect transaction faults in pallet distribution to retailers. • Developed comprehensive business reports using Power BI for multiple internal and external business stakeholders and facilitated informed decision-making. • Developed dynamic dashboards leveraging DAX and M query with precise drivers of transaction anomalies effectively highlighting suspicious transactions. • Independently led technical discovery meetings with commercial account owners and raised tickets in Salesforce for seamless issue tracking. • Proactively monitored and identified issues in migrated data from SAP ERP to Salesforce ensuring data reliability and accuracy. • Assessed and interpreted transactional errors using SAP BI/BW and recommended corrective measures in SAP ERP. • Collaborated with Brambles digital team to explore data integrity projects within CHEP Canada and determined feasibility scopes to ensure seamless transaction and red flag detection. • Performed testing in BluePrism for RPA – based automation solutions adopted to streamline lengthy invoice generation processes for digital and non-digital transactions to increase overall productivity as part of digital onboarding and automation uptake initiatives.

Role: Data Science researcher, HEC Montreal, Montreal (Jun 2021 – May 2022) • Spearheaded a research endeavour in collaboration with IVADO and CFREF organizations, focusing on leveraging big data technologies like Apache Hadoop to drive cutting-edge insights. • Analyzed detailed project requirements and synthesized qualitative and quantitative data using R that substantiated project objectives. • Identified unique methods to maximize the amount of information that could be sent from one end to another with minimal burden on node memory using monte-carlo method. • Explored and compared between various R libraries by creating visualizations, graphs and plots to facilitate a deeper understanding of their strengths in application. • Identified and implemented acceptance measures to compress data and assisted node-to-node data transfer operating within a designated communication budget ensuring seamless data exchange.

Role: Associate Consultant/Automation Developer, Capgemini, India (May 2016 – Jun 2019) • Developed an automation solution to detect payments fraudulent or otherwise saving the client $30 million annually across the EMEA and the NA. • Supported the build of a database containing historical transactions to showcase the fraudulent payment proportion within the system reducing the time spent on creating financial reports by 300+ FTE hours. • Championed the identification of automation initiatives as the Prima Facie for a team of 5 directly under the VP head of intelligent automation services driving strategic automation adoption. • Provided on-going support for active dashboard run and assisted in incident management to conduct prompt issue resolution. • Used Agile process to collaborate with SMEs, developers, business analysts and various stakeholders to create BRDs, PDDs, SDDs and SOP documents underlining clear solution requirements, implementation and execution. • Performed User Acceptance Testing and executed complex code corrections for quality assurance. • Mentored two offshore teams to identify issues in automation projects and performed code reviews. • Created reusable business objects using C#.Net enhancing scalability. • Implemented try-and-catch statements for exception handling during run. • Implemented selectors for interacting with web and windows applications for continuous bot navigation. • Extracted structured data by using datascraping methods and loaded documents in CSV files or spreadsheets and uploaded them to sharepoints for SMEs to review later. • Created excel automation for repetitive entries into table like structures by appending new and comparing columns wherever needed. • Created stored procedures for faster query execution on a periodic basis improving system performance. • Interacted with cross functional teams to identify gaps and determined RPA best practices in designing efficient solutions, quality processes and user experience. • Used Jira to track quality defects, bugs and run issues in collaboration with SMEs for faster resolution. • Developed bot workflows and schedules and used orchestrator for deployment, monitoring and managing bots.

EDUCATION

• HEC Montréal, MSc Data Science and Business Analytics, Montreal

• S’O’A University, BTech Electronics and Communication Engineering, India (Aug 2022) (Jun 2016)