SM
Message

Satyajit Mukherjee

Professional IT trainer with extensive experience in Microsoft’s range of software solutions. An expert at designing training courses with technical content, I am effective at imparting knowledge through my superior verbal communication skills and active listening style. I have proven success in utilizing cutting-edge technology to devise training exercises for all types of learners.

Key Skills

Microsoft ASP.NET MVC
SQL Database Management
Business Intelligence
Oracle
JavaScript Frameworks
XML
Unix
Database Administration

Professional Experience

Sep 2014
Present
BI Analyst
Tata AIA Kolkata, IN
  •  Achieved 93.5% customer self-service levels by implementing new web based systems such as Online Troubleshooting Guides, 5 dedicated customer portals, online video instructions, product registration programs, and implementing a Customer Complaint Email Management System. 
  • Documented and designed new operations and procedures manual that is currently being used by employees in the training and developing process that brought metrics within satisfactory levels. 
  • Developed training programs such as: online troubleshooting guide, over 1,000 Frequently Asked Questions, and online video instructions that contributed to a 35% reduction in errors and 10% productivity increase. 
Dec 2011
Oct 2014
Team Lead
Geosmart Technology India Pvt. Ltd. Kolkata, IN
  •  Analyzed and recommend system enhancements that complement and expand the functionality of the Consumer Service and Customer Service departments. Performed cost-benefit analyses of proposed system enhancements. 
  • Participated in design reviews, recommended specifications for business applications and system capabilities. 
  • Defined and documented specification requirements, established timeframes for completion of projects, and determined resources needed. 
  • Performed continuous system maintenance and identify opportunities for improvements to meet the business needs and assure rapid and effective resolution of issues. 
  • Wrote training manuals for end-users and oversee technical training. 
Mar 2011
Jun 2011
Senior Consultant- ERP
Cognizant Technology Solutions Kolkata, IN
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and
  • Collections to implement business logic using SQL Navigator. 
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances. 
  • Participated in change and code reviews to understand the testing needs of the change components. 
  • Worked on troubleshooting defects in timely manner. Involved in creating UNIX shell Scripting. 
  • De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. 
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain. 
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle. 
  • Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing. 
  • Extracted data from the XML file and loaded it into the database. 
  • Designed and developed Oracle forms & reports generating up to 60 reports. Performed modifications on existing form as per change request and maintained it. 
  • Used Crystal Reports to track logins, mouse overs, click-through, session duration and demo graphical comparisons with SQL database of customer information. 
  • Worked on SQL. 
  • Loader to load data from flat files obtained from various facilities every day. Used standard. 
  • Packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module. 
  • Used principles of Normalization to improve the performance. 
  • Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures. 
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. 
  • Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes. 
  • Built databases and table structures following n-tier architecture methodology for web applications. 
  • Analyzed and designed relational databases using ER Studio and Erwin Data Model tool. 
Jan 2011
Apr 2011
I.T. Analyst
Tata Consultancy Services Kolkata, IN
  • Worked with Help Desk people to solve problem and create batch job. Created monthly campaign manifesto work for business improvement. Worked with Middle Tire for Design and Development for project.
  • Wrote complex PL/SQL package, functions, procedures, batch processes using bulk processing, ref cursors and Pl/Sql Tables.
  • Did Design Document and create ER Diagram for project development. 
  • Designed Data Flow, Entity Relation and others Diagrams with Erwin, Visio, SDPRO, Oracle Data Modeler tools. 
  • Coordinated with DBA in creating and managing Indexes, Db Links and Privileges. Exclusively followed all phases of System Development Life Cycle SDLC 
  • Created complex program unit using PL/SQL Records, Collection types Nested Tables and Varrays in complex backend packages 
Apr 2008
Jan 2011
Senior Consultant
PricewaterHouseCoopers Pvt Ltd. Kolkata, IN
  • Interacted with Business Analysts and stake holders to gather business requirements. Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. Created derived columns from the present columns for the given requirements.
  • Used SQL Server to load tables in support of de-coupled, pluggable architecture to manage data flows between service providers and LIPA.
  • Created SSIS packages to get data from different sources, consolidated and merged into one single source.
  • Created detailed design and requirements documents with logic to help team members understand the requirements and design.
  • Designed and implemented relational databases, data marts and developed reports to allow users to easily access data.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
  • Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into the Data warehouse.
  • Designed custom Dimensions and Facts Tables to extend data warehouse.
  • Worked on the project that involved development and implementation of a data warehouse. Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.
  • Involved in Code Review, Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.
  • Conducted system tests, troubleshoot customer issues and correct database defects. Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks.
  • Use customer requirements to improve functionality (speed, performance / usability). Created, tested and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.
  • Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools. 
  • Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse. 
  • Worked on knowledge transfer and documentation of various jobs developed and deployed into production. 
  • Coordinated/Involved in deployment/migration of change requests to testing (System Integration Testing) and production environment. 
  • Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools. 
Oct 2007
Apr 2008
Senior Software Engineer
Accenture Services Pvt Ltd Kolkata, IN
  •  Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database. 
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures. 
  • Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g. Involved in Logical & Physical Database Layout Design. 
  • Set-up and Design of Backup and Recovery Strategy for various databases. Performance tuning of Oracle Databases and User applications. 
  • Used SQL. 
  • Loader as an ETL tool to load data into the staging tables. 
  • Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g. Provided user training and production support. 
  • Improved the performance of the application by rewriting the SQL queries. 
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links 
Dec 2004
Jan 2020
Freelance Corporate Trainer
Freelance, self-employed Kolkata, IN
  • Prepared all training material for courses, including PowerPoint presentations, skill exploration and exercises, and assessments.
  • Trained technical staff in developing in Visual Studio with the GUI editor tool and using Visual Basic and C# with the .Net framework.
  • Conducted training on site and via video conferencing.
  • Supervised the scheduling of training programs while remaining flexible to new training demands.
  • Gauge the effectiveness of training programs and adjust for optimal results.
  • Assessed the training needs of individuals as well as work teams.
  • Created lesson plans tailored to employee needs.
  • Implemented course progressions and programs for staff.
  • Trained staff on the use of Microsoft reporting system software with Microsoft
  • SQL Server and associated reporting tools.
  • Taught Microsoft desktop courses to satellite locations using video conferencing.
  • Advanced personal IT Skills and updated training courses including new product functionality.
Dec 2003
Aug 2007
Senior Software Engineer
Wipro Technologies Ltd Kolkata, IN
  •  Developed ETL jobs like data transformation using Microsoft SQL Server Integration services. Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.
  • Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
  • Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services.
  • Administered minor databases of the facility using SQL Management Studio. Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.
  • Wrote stored procedures using T-SQL and implemented them. Conducted code review.
  • Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment. 
Jul 2003
Jan 2004
Programmer
Gigabyte Information Technology Kolkata, IN
  •  Assisted senior programmers in designing, coding, developing, testing, debugging, and implementing various software applications in a Windows NT environment using Visual Basic and SQL Server. 
  • Performed analysis of user requirements or specifications to develop flowcharts regarding software program or application design details as well as collaborated with team members to ensure smooth progress and on-time delivery of project work. 
  • Assisted in performing system integration testing and troubleshooting programming issues as well as developed modules and new features or advanced functionalities to reduce processing time. 
  • Assisted in creating application user guides or manuals as required as well as updating software documentation according to established standards. 

Education

Mar 1999
Mar 2003
B.Tech in Computer Engineering in Institute of Engineering and Management
University of Kalyani

Achievements

End User IT Trainer
  • Delivered classroom based training on the Microsoft suite of products such as Microsoft Office, Excel, Access, and PowerPoint for entry-level technical staff.
  • Created classroom materials to facilitate skills training.
  • Developed practice exercises for experiential learners.
  • Gave feedback to class participants and provided individual coaching as needed.
  • Provided assistance to the support department with end-user refresher training.
Quality Assurance Corporate Trainer
  • Created quality scorecard and wrote accompanying quality manual.
  • 21 person team has maintained a 98% quality 2014 YTD compared to team goal of 94%.
  • Rebuilt new hire training program.

Languages

English
(Fluent)
Bengali
(Native)
Hindi
(Basic)

Get in touch with Satyajit