I'm a seasoned IT Management Professional with over 13+ years of experience specializing in Data Analytics, data warehousing, Data Management, and complex Reports/Data integration across diverse industries. My expertise is leveraging advanced technologies to drive business efficiency and decision-making processes, translating complex data into actionable business insights.🔧 Technical Mastery: I am proficient in various technologies, including MSBI (SSIS, SSRS & SSAS), SQL, Power BI, .NET (C#, ASP.NET, VB.NET), Oracle, and Python. My hands-on approach with these tools has enabled me to deliver robust solutions in data analytics, reporting, and application development.📊 Project Leadership: My career highlights include leading significant Data Warehouse/BI projects for sectors such as financial services, capital markets, e-commerce, and BPO. For instance, my project for NTT, USA, involved developing a Quality Analysis Dashboard that enhanced performance evaluations through sophisticated data visualizations and ETL processes. I hold 7+ Years of hands-on experience in the BFSI Domain with Projects for SBI Mutual Fund, SBICAP Securities, and IDBI Bank.🌐 Client and Stakeholder Engagement: I am adept at managing client interactions and project communications, ensuring compliance with milestones and fostering relationships that enable future opportunities and collaborations.📈 Achievements:• Implemented a comprehensive BI system for Hindustan Platinum Ltd that streamlined operations and provided deep market insights.• Developed and optimized IT solutions that increased efficiency and data integrity for major clients like Millennium One Solutions, NTT America, SBI Mutual Fund, IDBI Life Insurance, and SBI CAP Securities.🎓 Educational Foundation: I hold a Master of Computer Applications and a Bachelor of Science in Computer Science and gained a solid technical and analytical base.🔍 Looking Forward: I am eager to connect with professionals passionate about leveraging technology to solve real-world problems. Whether you’re looking for advice, collaboration, or exchange ideas, feel free to reach out!💬 Let's Connect! I’m open to discussing technology, project management, and data-driven strategies. Thank you for visiting my profile, and I look forward to connecting with you!
-
Project Manager – Data ManagementBirlasot Ltd Jul 2023 - Mar 2024India• T-SQL Proficiency: Expert in crafting T-SQL stored procedures, Indexing, triggers, and user-defined functions and implementing security protocols alongside DML and DDL commands• Query Optimization: Adept at optimizing queries for improved performance and efficiency in data retrieval processes• Reporting and Dashboards: Skilled in generating ad-hoc reports and dynamic dashboards using Power BI and SSRS, tailored to immediate user requirements and strategic KPIs like billing hours and QA details, Implementation of Role and security.• SSRS Reporting: Competent in creating diverse report formats (tables, matrixes, charts) and developing Drilldown/Drillthrouh/sub-reports and linked reports using SSRS, based on client specifications, Implementation of Role and security.• ETL and Data Warehousing: Extensive experience in ETL processes using SSIS, with a strong understanding of data warehousing concepts, OLAP, and dimensional data modelling (Star Schema/Snowflake Schema)• SSAS Tabular Model: Proficient in Designing and Deploying SSAS Tabular Cube and Measures as the analytic layer.• Data Transformation and Integration: Proficient in developing ETL mappings and transformations such as Derived Columns, Conditional Splits, and Lookups for staging and data warehouse loading• Data Management and Release Policy: Developed and implemented data management policies and procedures like Data Archival, De duplication, Partition, and Role securities that resulted in a 60% increase in data accuracy. Implemented Project Release Governance policies on UAT and Production Servers.• Configuration and Scheduling: Implemented checkpoint and package configurations in SSIS for enhanced package reusability; experienced in creating scheduled jobs and alerts• Error Management: Established systems for error logging and handling within SSIS packages to ensure data integrity and process continuity
-
Manager Data AnalyticsGlobal Software Resources Oct 2022 - May 2023Mumbai, Maharashtra, India -
Assistant Manager Bi & ApplicationHindustan Platinum Sep 2021 - Oct 2022Navi Mumbai, Maharashtra, India -
Senior Consultant – Bi & OptItsp Inc. May 2018 - Sep 2021Ontario, Canada• Responsible for writing T-SQL stored procedures, triggers, user-defined functions, parameters, constraints, security, and utilizing various DML and DDL commands• Playing a vital role in query optimization and performance tuning, Data Archival/Partition, removal Deduplication • Conducting data extraction, transformation, and loading (ETL) using SSIS• Performing data warehousing, OLAP, and dimensional data modeling, such as star schema and snowflake schema for FACT and dimension tables using Analysis Services• Create report model on SSAS Cubes• Utilizing Power BI for creating analytical dashboards displaying KPIs like billing hours, QA details, and modeling for PowerPivot/View• Developed Complex calculated measures using DATA Analysis Expression Languages (DAX)• Demonstrated expertise and proficiency in Power BI/Tableau reports using parameters, filters, calculated sets, and Implemented security guidelines using filters and Row level Security • Developing mappings according to ETL specifications for staging area and incremental data loads and warehouse data loads• Performing data transformations, including derived columns, conditional splits, aggregates, union all, merge joins, lookups, sorting, and executing SQL tasks to load data into data warehouses• Implementing checkpoint configurations and package configurations for better reusability• Providing error logging and error handling for SSIS packages• Responsible for creating jobs, alerts, batch files, and scheduling packages• Creating parameterized, drill down, drill though, sub-reports and linked reports from queries in SSRS• Conducting analysis, coding, and unit testing of change requests and enhancements received from clients.• Handling relevant technical communication with clients and attending weekly status calls to provide updates on ongoing tasks and requirement gathering• Utilising .NET Framework 3.5 (VB.NET and C#.NET) and IIS Web Server -
Senior Consultant - ItAgate Business Services Jun 2015 - May 2018Navi Mumbai -
Sr. Software DeveloperSbicap Securities Apr 2013 - Jun 2015Lower Parel, Mumbai -
Team MemberIdbi Intech Jan 2011 - Feb 2013Belapur, Navi Mumbai -
Junior Software EngineerGreysoft Jun 2010 - Jan 2011
Manish Pawar Education Details
-
Master Of Computer Applications -
Computer Science
Frequently Asked Questions about Manish Pawar
What is Manish Pawar's role at the current company?
Manish Pawar's current role is Senior IT Management Professional | Expert in Data Analytics, BI & Data Integration | Proven Leader in Technology-Driven Business Solutions.
What schools did Manish Pawar attend?
Manish Pawar attended Veermata Jijabai Technological Institute (Vjti), Mumbai University.
Not the Manish Pawar you were looking for?
-
-
Manish Pawar
Associate Consultant @Hso | Microsoft Dynamics 365 Crm | Powerapps | Dataverse | Powerautomate | Azure | C# | JavascriptNashik1celebaltech.com -
-
-
Manish Pawar
National Institute Of Technology Karnataka, Surathkal | Materials Engineering| Mechanical Engineer |Bhopal
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial