Data Analytics, Alteryx, Xceptor, Python, Tableau, VBA, SQL, C#
Resume:
WORK EXPERIENCE
Associate - Project Manager
JPMorgan Chase & Co. - Mumbai, Maharashtra
September 2020 to Present
• Lead end-to-end delivery efforts for IA projects and demonstrate leadership by successfully managing medium to large projects.
• Process reviews to understand end to end operations processes based on identified opportunities.
• Provided recommendations on development feasibility in terms of required applications, technology and effort.
• Coordinated engagement & governance framework with key stakeholders throughout the development lifecycle – requirements, access management, testing, pre-production and go-live activities.
• Analysed and designed solutions using Intelligent Automation tools – Xceptor and Alteryx.
• Developed, maintained and enhanced automated solutions to improve the operations processes.
• Developed and maintained documentation for developed solutions and provided required support - solution design documents, test and production sign-offs, project plans and milestones.
• Reported/escalated, proactively reached out to all the required stakeholders on potential issues in a timely manner, tracked and reported status of all Intelligent Automation projects.
• Delivered productivity, quality, customer satisfaction, efficiency to the business through these automated solutions.
• Communicated and demonstrated self-learning, self-motivation attitude by enhancing my knowledge on latest technologies and shared best practices with other leads during the regular engagements. Senior Associate - Projects
Cognizant Technology Solutions - Mumbai, Maharashtra January 2019 to August 2020
• Designed workflows and models with ETL techniques, using RPA tools - Alteryx and Xceptor, for different clients with different approaches to business.
• Created interactive dashboards by using Tableau, Power BI to prioritise, optimise and design data story, KPIs for better storytelling and enabling informed business decisions.
• Overhauled and optimised processes by capturing and transforming data of any format, for intelligent use, using Xceptor.
• Used Alteryx for Data Profiling - by blending in supplemental data, eliminating nulls, investigating issues, normalising and MILLAN
SAHOO
Mumbai, Maharashtra
adhjc5@r.postjobfree.com
A Techno-Functional professional with cross-cultural experience and in-depth knowledge on application development, support, automation and team leadership. Bringing 9 years' experience in IT services, dedicated to maximising customer satisfaction and exceeding business objectives with organised approach and strong multitasking abilities.
#readytowork
Willing to relocate: Anywhere
standardising values; Data Blending - to effortlessly connect, prep, cleanse, blend, and join data from databases, cloud and on-premise apps, social sources, unstructured data, spreadsheets, and more; Data Wrangling - frictionless connectivity to sources and targets, drag-and-drop visual workflows, repeatability through reuse, and sharing all work together to maximise productivity.
• Used In-Database processing in Alteryx to push down queries, formulas, and filters and joins directly to Sql Server using native database operations to maximise performance and scalability.
• In Alteryx used Reporting tools - to create graphs and tables with header, footer, layout and export to presentation files such as PDF; RegEx tools - to define search patterns using Perl syntax; R Code and Predictive tools - for time series forecasting using ARIMA and ETS models; Export business reports as TDE Extracts for Tableau.
• Used Alteryx to create reusable workflows (Macros and Apps) for reading headers, adding new sheets, downloading files, calculating network days, prior business days, picking up latest files, etc.
• Created and executed batch files in runtime from Alteryx to perform actions like copying, renaming, moving files, etc.
• Automated reconciliations, integrated BOTs (Automation Anywhere), ML, Python scripts with Alteryx to customise automations to interact with on-premises apps, outlook, web downloads, business logics and out of the box solutions.
• Used Python libraries Pandas, NumPy, Math, SciPy, Scikit in quantitative finance solutions that process and analyse large datasets, big financial data, statistical calculations and data visualisations.
• Collaborated with Business, Robotics Automation team, Risk and Controls, and other stakeholders to enhance supportability and identify performance bottlenecks.
• Documented Scope, BRDs, Software development methodologies in technical manuals to be used in future references. Senior Project Engineer
Wipro Technologies - Bengaluru, Karnataka
October 2011 to January 2019
• Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval and indexing.
• Built outstanding and dynamic team of software engineers and developers which significantly boosted overall success of organisation.
• Devised innovative solutions, troubleshooting methods, root cause analysis for Wall Street Office (WSO) application at Boston, MA - USA, that used a vendor tool named 'IHS Markit', a loan portfolio software.
• Led development initiative as Subject Matter Expert and primary point-of-contact for over 62 Portfolios / Clients and project management staff.
• Integrated Amazon S3 buckets to store application files and data, worked on Amazon event driven - Serverless computing platform Lambda to create EC2, ECS Cluster to run applications.
• Developed Excel Macros, Access applications using VBA to book/browse huge volume of data from Mainframes, DB2, SQL Server databases to generate business reports.
• Designed and developed software with C#, VB.Net, ADO.Net, ASP.Net across multifaceted team to meet client needs for functionality, timeline and performance.
• Led migration activities of C#.Net, VB, Web applications, SQL jobs from windows 2008/12 to windows 2016 servers using MS SQL, ClickOnce deployment, Application Packaging - Windows, Visual Studio 2017, ServiceNow requests and IIS.
• Participated in agile ceremonies like story grooming, daily stand-ups, demos and retro meetings to complete the sprints and project backlogs.
EDUCATION
Master of Technology in Software Engineering
Birla Institute of Technology and Science - Pilani, Rajasthan 2011 to 2015
Bachelor of Computer Applications
Hindustan College of Arts & Science - Chennai, Tamil Nadu 2008 to 2011
SKILLS / IT SKILLS
• RPA, Data Analytics, Alteryx, Xceptor, Tableau, Power BI, Python, AWS, C#.Net, VBA, SQL Server
• Domain Knowledge: Securities and Capital Markets, Finance Solutions, Insurance ONLINE PROFILE
http://www.linkedin.com/in/millan-sahoo-3492b165
AWARDS / ACHIEVEMENTS
Feather In My Cap
Awarded for outstanding performance in projects GMAS and VIT - COE, Wipro Developed India’s largest database of technical projects "www.techpedia.in" Techpedia, a portal developed for Govt. of India in collaboration with IIM Ahmedabad, NIF and SRISTI Won Sahodaya Cup 2002 & 2003
The annual football tournament held by CBSE schools in Odisha
Contact this candidate