Data Analyst System
Resume:
**********@*****.***
MANDAR DANI
PROFESSIONAL SUMMARY
A result-driven IT professional with a proven track record of Software Development from requirement analysis to application delivery, support & maintenance activities, Data Analysis, Data migration & integration activities.
Rich experience in Onsite-Offshore development model. Have an exposure to ERP, Insurance, healthcare & Education domain. Performed different roles as Software Developer, Project Lead, System Analyst, Data Analyst, Project coordinator & Technical project Manager. Involved in supporting the sales team, contributed to Request for Proposal, Product Demo, client follow-up and interaction. Experience as a team member and as an individual contributor in projects for multiple clients.
EMPLOYMENT SUMMARY
George Brown College, Toronto Sep 2016 – Till Date
Role: Data Analyst, System Analyst
Contribution:
Data Analyst –Power BI Reporting, ETL & Data Integration projects:
Led and managed complex ETL workflows and data integration projects collaborating closely with Subject Matter Experts and Product Owners to define project objectives and deliver data-driven solutions. Analyzed and documented details of data extraction, transformation and integration requirements produced comprehensive Business Requirement Documents, Software Requirement Specifications, Data Mapping Documents.
Designed and developed staging tables to facilitate efficient data import and export processes. Implemented and maintained automated data extraction and integration processes utilizing shell scripts (CRON jobs) which used database operations (executing queries, PL/SQL packages, SQL Loader, procedures & Bulk Collect), and secure file transfers via FTP. Generated both full and incremental data extracts.
Integrated data from diverse and heterogeneous sources, including Banner ERP, Student Information Systems, Sales systems, and external agency data.
Completed data inspection, statistical Analysis and cleansing using power query. Defined star schema and converted data into star schema, introduced new dim tables, measures using DAX. Created robust data model for reporting. Transformed this raw data into insightful reports and interactive dashboards using the Power BI desktop.
Enhanced the interactivity and storytelling capabilities of Power BI reports through the strategic implementation of features such as bookmarks, drill-through reports, insightful charts, comprehensive reports, effective slicers and filters, informative scorecards, and key performance indicators (KPIs). Leveraged the full capabilities of Power BI to create various analytical dashboards, empowering business users to gain rapid and actionable insights from the data.
Experienced in the end-to-end Power BI development lifecycle, including dashboard creation, dataflow design, uploaded data to Azure Blob Storage.
Successfully delivered multiple data integration projects with Govt. and external agencies. Examples: OSAP student information, Student-Staff COVID vaccination, Student Health & Counseling, Field Experience & COOP student’s information exchange.
Proactively optimized Business processes by identifying potential issues and fixed performance bottlenecks existing modules, handled responsibility till project promoted to production. Coordinated & helped QA & UAT teams by prepared test data ensured thorough testing and successful system transition, also periodically monitoring & managing change requests, ensuring seamless system enhancements through methodical validation.
Maintenance & enhancement - Banner ERP & Student Information System:
Led & contributed to digital transformation strategy, successfully modernizing legacy ERP system. Designed and developed Banner Extensibility pages using Ellucian page builder (calls package function through virtual domain which returns JSON object)
Streamlined workflows into single-page apps, enhancing efficiency and user experience. Pages designed using HTP.P package and implementing code through ajax calls, html, CSS, Vanila JavaScript & jQuery. Projects: Transfer Credit by Student and on Behalf of Student, Programs – Elective configuration, Timetable display, class cancellation & Update flow.
Generated comprehensive MIS reports, aiding strategic decision-making processes using reporting tool Argos.
Designed and implemented database structures, developed and implemented complex PL/SQL objects, views, packages, procedures, functions and triggers. Streamlined database performance through advanced query optimization and indexing strategies, reducing system response time and resource utilization
Worked on strategic projects with tight deadlines and quality demand – delivered multiple quality & timely solutions. Strategic projects like Transfer Credit application - student, on behalf of students. Validation of min/ max number of exemptions for program, mandatory courses implementation, registration module. Designed and developed authorization workflow ( Course based, Dept based, Master Role)
Solved production tickets, hot fixes, data fixes, enhanced Banner ERP by introducing new app pages (oracle forms/ PL SQL procedures, functions)
Enhanced system efficiency by identifying and resolving complex technical issues. Fixed reports, optimized queries, views, recommended improvements, ensuring optimal performance levels were maintained.
Established cross-functional development standards and best practices, fostering knowledge sharing and consistent code quality across teams
Technologies: BANNER ERP system, Page Builder, AJAX, JavaScript, Argos Reports, SQL Server, Oracle, PL/SQL - packages, procedures, functions, triggers, views, Bash shell script, jQuery, Putty, FileZilla, Toad, GIT, JIRA, Power BI Desktop
Scotia Bank, Toronto May 2017 – July 2017
Role: ETL Consultant – Data Integration
Contribution:
Involved in requirement gathering – completed data integration requirements gathering & analysis for multiple PEGA rapid labs, involved in discussion with BA, PEGA team, data modeler, completed mapping of required fields to Pega application fields.
Created PEGA BIX rules (class mapping) for data extraction, staging table definition & DDL generation, ran full and delta data load to staging tables.
Completed transformation procedures to transfer data from staging table to integration tables, introduced new integration tables/ fields.
Completed writing of views for data ingestion (consumed by scoop tool) to Data Lake
Technologies: DB2, Oracle, PL/SQL, UNIX shell script, Putty, DBeaver, PEGA BIX
Mercer, Toronto Sept 2015 – Sept 2016
Role: Onsite Project Coordinator Work Location: Toronto, ON
Contribution:
Project was to bring multiple applications in managed service mode, successfully executed pilot application implementation in Managed Service Mode.
Completed requirement understanding - understanding of application priorities, involved in planning application executions ( by offshore resources), finding out resource requirements, selecting team members, scheduling knowledge transition sessions with SMEs. Planning and executing work items, assigning work items to team members, presenting weekly and monthly status reports to management. Acted as single point of contact between business – SMEs and offshore team members.
Documented Applications in Production with the help of SME, Created Knowledge Capture Documents which include Application Overview, Technical Architecture, Data dictionary, Screen flow, Transaction flow, Environment, testing processes, Batch processes, Typical problem areas, Reports, Release information, Managing documentation on share point platform.
Executed security fixes implementation, migrated classic asp applications to IIS6 to IIS 7.5, was involved in UAT.
Worked on support & maintenance of applications in production by resolving defects in predefined SLAs.
Wrote/modified procedures, functions, maintained Asp.Net, C# code.
Value adds: Worked on front end classic Asp code fixes, end to end application testing.
Achieved Customer Satisfaction Index 4.8/5.0
Technologies: Oracle 11g, PL/SQL, SQL Server 2008, TSQL, Classic Asp, JavaScript, Asp.Net, C#, PL/SQL Developer, SSMS, TFS, VSS, Visual studio 2012, SharePoint
L&T Infotech Pune Aug 2014 – July 2015
Client: North Bridge, Toronto Work Location: Pune, India
Project - COE for Insurance product Duck Creek
Role: Offshore Project Coordinator, Business Development support activity
Contribution:
Coordinated COE launch for ‘Duck Creek tool for insurance solutions’ and team development.
Designed training modules (domain + technical training), Data shredding & integration use case development, Team building strategies.
Presentation preparation - Duck Creek Capabilities for partnership with Accenture
Played role in first implementation (phase 1) through duck creek COE for North Bridge
Delivered POC for data shredding to staging tables, transform and load to enterprise integration database.
Tools & Technologies: Duck Creek, SQL Server, SSMS, .Net, share point, Hadoop.
Munich Re, Toronto, ON Mar 2012 – Aug 2014
Role: Onsite Project Coordinator Work Location: Toronto, ON
Data Analyst & Administer
Contribution:
Major part of the work was to understand requirements, complete BRDs and develop a solution.
Played key role in functional Enhancement releases, completed production defect fix and production data fixes release development for system catering to primary policy, claims and billing administration system for commercial insurance business.
Achieved performance enhancement by tuning queries of reports by 90%, worked on database tuning & query Tuning.
Updated holding tables and metadata tables of data integration process models.
Developed / fixed/ enhanced PL SQL packages, procedures, trigger, functions & views.
Created integration & incremented deliveries.
Communicated with Testing team and created test data for BA and QA
Value add: Asp.NET, C# defect fixing, Crystal reports enhancement, end to end testing
Create and manage offshore team, completed functional and technical knowledge transfer of application, completed team members certification for application.
Created Knowledge Capture Documents which include Application Overview, Technical Architecture, Data dictionary, Screen flow, Transaction flow, Environment, Testing, processes, Batch processes, typical problem areas, Reports, Release information, Managing documentation on share point platform.
Achieved consistent customer satisfaction ratings above 4.5/5 through precise requirement analysis and timely solution delivery
Technologies: Oracle, PL/SQL, ASP.NET, Java-script, Crystal Report 2008, TFS, PL/SQL Developer, Share point
Windsor Health Insurance, Bellingham, WA, USA Feb 2011 – Mar 2012
Project: ICD9 to ICD10 conversion Work Location: Bellingham, USA
5010 upgrades for 837-EDI
Role: System Analyst, Onsite Project Lead
Contribution:
Completed project before deadline, mandated date mentioned by statutory body CMS. CMS required all healthcare payers to accept and produce electronic (837-EDI) files in the ANSI X12 5010 format.
This requirement includes update to HIPAA real-time transactions sets like Eligibility Benefit Inquiry/Response, Claims Status Inquiry/Response, Claims acknowledgement and Medical claims with subtypes for Professional, Institutional and Electronic remittances.
Understood existing system and modified according to new requirements, that is updated XML reading process, altered or designed new staging tables & holding tables, introduced or altered packages, procedures, functions, views.
Defined & delivered work items for team in line with business & delivery dates.
Translate requirements into tech specs, communicate with Business, offshore, QA.
Introduced new logic for logging errors in batch processing.
While implementing new changes there were issues reported in the existing system. Implemented & managed fixes in new & old running environment and kept current (old) system in running mode.
Technologies: Oracle 10g, PL/SQL, PB9.0, SVN, SQL Developer
Harleysville Insurance Company, Harleysville, PA Aug 2008 – Jan 2011
Name: Group Benefit Platform for Group Insurance Work Location: Harleysville, Pune
Role: Business Analyst, Offshore Project Lead, Onsite Coordinator (6 Months)
Contribution:
Coordinated with teams located in 3 geographical locations.
Participated in requirement gathering phase, involved in brainstorming meetings.
Worked with front end team in designing DB objects as per requirements.
Involved in designing Conceptual & logical data model and developing database, designed Procedure, functions, triggers, Views.
Designed and implemented Database driven workflow.
Implemented very complex legacy integration, in which data is sent to legacy from GBP application and vice versa.
Created database deployment package using DB Pro tool for various environments like development, testing and production.
Completed Feasibility study of enhancements and change requests.
Visited onsite for major releases and to sort out issues.
Technologies: SQL SERVER 2005, 2008, INFOPATH, Visual studio 2005, Team Foundation Server, Red gate, SSMS, Share point
Travelers, Hartford, CT, USA Aug 2006 – Aug 2008
Premium Pipeline-Integration platform for Policy. Work Location: Hartford CT, Pune, India
Role: Business Analyst, Offshore Sr. Database Developer
Contribution:
Understood requirements of Earning module, defined Use cases and created & assigned tasks.
EARNINGS module written in PL/SQL, created Packages, procedures and views for reports.
Data was taken from upstream systems (client facing), process it and was fed to downstream systems (in house systems) for further process.
Create billing reports and other MIS reports.
Involved in peer reviews, module delivery.
Technologies: Java, Web Sphere, Oracle 9i, VSS, RAD7.0
L&T Infotech June 2005 - Aug 2006
Client: Nordea, Denmark
Project Name: Migration of Unit Link Component to J2EE Work Location: Pune, India
Role: Offshore Sr. Software Developer, Module Leader
Converted COBOL code to Java Code, unit testing and delivery of code.
Technologies: Java 1.3, Rational Application Developer 6.0, Server: WAS 6.0, VSS6.0, DB2, Web Sphere 5.0.1
Comsoft Pte Ltd - Dell, JPMC Singapore Feb 2000 – May 2005
Project: Customization of Financial Integration System Work Location: Singapore, Pune
Role: Onsite Analyst Programmer
Developed JSP pages, Bean coding, Oracle - Packages, Procedures & Functions writing.
Involved in Use Case diagram design, Class Diagram design, Front-end development, VSS configuration (Version control of development, test environments) source guarding and work allocation. Feb 2000
Education
Post-Graduation Diploma in Business Management
Post-Graduation Diploma in Advance Computing
Bachelor Of Engineering (Electronics)
Certification
Certificate in Data Science – University of Toronto
Introduction to Cyber Security, Network Basics – Cisco Networking Academy
IKM Oracle 11g PL/SQL Programming
Contact this candidate