Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
BusinessAnalyst

Avik Mullick

IT Manager
Pune,Maharashthra

Summary

Instrumental in the current Role bringing 12+ years of experience achieving ambitious goals in challenging IT environment. Diligent, forward-thinking and adaptable to dynamic company, customer and project needs. Successful at motivating teams to meet demanding timelines.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
6
6
Certifications

Work History

Technical Lead Project Manager

Fiserv
Pune, Maharashthra
04.2020 - Current
  • Supervised team efforts, understanding PDLC policies and implement the Agile principles to establish consistent delivery and reliable resolution for the defects.
  • Implementing Agile principles made huge impact in the deliverables of the big releases and maintaining the coding standards.
  • Maintained accurate records of malfunctions, installations, configuration and integration according to fiserv guidelines.
  • Managed daily activities, assigned tasks to specific members as per discussion in daily scrum and utilized proven management techniques to cut work flow downtime.
  • Leveraged Lean Six Sigma expertise to reduce time dependency and enhance productivity by 20%.
  • Devised and implemented safety programs, encouraging team members to take time to analyze situations and determine best course of action.
  • Planned, scheduled and delegated daily work to team of employees.
  • Managed, fixed and maintained up-to-date knowledge on systems.
  • Part of the monthly meetings to discuss Current status from the release perspective also the service tickets received from support team and plan for the future.
  • Managed team performance by training, mentoring, disciplining and motivating employees.
  • Validated adherence to best practices, quality standards and customer specifications.
  • Developed corrective action plans and prevention strategies to improve product reliability.
  • Collaborated with Product, Professional services and Corporate services to understand new requirements/features of the product which helped phases to develop and verify design changes, coding and testing as well.
  • Realigned production plans to boost productivity without dramatically increasing costs.
  • Discussed and implemented Content security policy along with Voltage to hide PII/PCI information's both front end and backend side along with the reporting side as well
  • Always make sure no compromise in the coding standards

Technical Lead

Cognizant Technologies Solutions
Kolkata, West Bengal
02.2019 - 03.2020
  • Involved in requirement gathering and providing in put to categorize the requirement if it s a Change Request or a project.
  • Preparing Technical design document (TDD) document for the requirement
  • Involved in preparing Low level design document (LLD)
  • Providing support to developers while coding.
  • Preparing the operation manual by using Design document.
  • Involved in Report creation a nd Unit testing along with User Acceptance Testing for business sign off so that we can successfully deploy the same.
  • It w as needed to understand not only Cognos reporting area but also the complete data flow to get the proper idea of business requirement and do the testing same way so that error free
    code can be develop
  • Involved in Project planning, people management KRA discussion with the reporters
  • Involved in recruitment process of the Organization

Sr. Cognos Developer

IBM India Pvt Ltd
Pune, Maharashthra
09.2014 - 01.2019
  • Involved in requirement gathering and providing input to categorize the requirement if it’s a Change Request or a project.
  • Designed and developed analytical data structures and Prepairing Functional Requirement Specification FRS) & LLD document for the demand.
  • Created proofs of concept for innovative new solutions.
  • Involved in Report creation and Unit testing along with User Acceptance Testing for business sign off so that we can successfully deploy the same.
  • Developed conversion and system implementation plans for Currently in merger of Vodafone & Idea playing role as Solution architect for the existing data mart. In this scenario all the KPI’s are getting standardized respect to both VIL & Idea end
  • It was needed to understand not only Cognos reporting area but also the complete data flow
    to get the proper understanding of the exist in g data mart to meet the customers’ expectations.
  • KPI standardization ensures smooth transition at both end so that it can simplify the business both for client and vendor data comparison.
  • Played Scrum master role in the project while working with multiple competitors while helped in gathering the knowledge of working with multiple stake holders and work in a very competitive environment.
  • Tuned existing DB tables to boost report performance.
  • Supervised work of programmers, designers along with discussed and assigned tasks and monitored performance against targets.

ETL & Cognos Developer

TechMahindra
Bhubneswar, Odisha
05.2010 - 08.2014
  • The project involves study, analysis, finding the drawbacks of reports and even development as per business requirements in the existing EDW and to prepare reports from that.
  • Involved in tracking the source and even checking the logics in mapping of Informatica that pull data from different applications and bringing them into different datamarts like
    Telematics, MyFleetFacts, Billing through mapping.
  • Introduced a change in the logic of objects connection and table definition in the data mart to reduce the number of redundant output.
  • Developed mappings , sessions, workflows to implement the logic in pulling the data and dump into the ODS.
  • Created new reports as per logic an d also from BO to Cognos reporting tool changed, So implemented old reports in new tool.
  • Completed quality reviews for designs, codes, test plans and documentation methods.
  • To reduce the running time of reports in Production, we implemented some logic in ETL as well.
  • Introduced procedures to remove query override in the report level and to reduce the running time in the live mode.
  • Involved in creating Cube Reports as well as DB reports like Charts, List, Crosstab etc.
  • Introduced a change in the mapping level to identify the deleted records in the source and synchronize Target with Source

Education

B.Tech - Electronics And Communication Engineering

West Bengal University of Technology
West Bengal
07.2004 - 05.2008

Skills

Documentation Management

Quality assurance

Risk mitigation planning

Flexible and Adaptable

Excellent Communication

Problem-Solving

Dependable and Responsible

Training and Development

Organization and Time Management

Teamwork and Collaboration

Analytical and Critical Thinking

Interpersonal Communication

Accomplishments

  • Got appreciation for successful transition of reporting and application from onshore to offshore and making sure no gap is existing which can delay in testing or feature level development.
  • Supervised team of 15 staff members.
  • Resolved product issue through consumer testing.
  • Achieved identifying and resolving few bugs by completing Regression testing with accuracy and efficiency and make sure to release on the timeline communicated to the clients.
  • Collaborated with different team in the development of could based products.
  • Documented and resolved log4j remediation steps which led to resolve the criticality facing by the Financial Institutions. Got Appreciation from Director & Business Unit as well.

Certification

CSSC certified Lean Six Sigma Green Belt

Timeline

CSSC certified Lean Six Sigma Green Belt

10-2021

Microsoft certified Azure Data Fundamentals

05-2021

Technical Lead Project Manager

Fiserv
04.2020 - Current

Technical Lead

Cognizant Technologies Solutions
02.2019 - 03.2020

NPTEL certified R

10-2018

SCRUM ALLIANCE certified Scrum Master

07-2018

Sr. Cognos Developer

IBM India Pvt Ltd
09.2014 - 01.2019

IBM certified BI Metadata Models

12-2012

IBM certified Designer BI Reports

03-2012

ETL & Cognos Developer

TechMahindra
05.2010 - 08.2014

B.Tech - Electronics And Communication Engineering

West Bengal University of Technology
07.2004 - 05.2008
Avik MullickIT Manager