Nitish Mehta Email & Phone Number

Canada

Manage database system by:• Identifying and resolving systemic data integrity issues• Analyzing and writing program scripts to extract, reformat and analyze data• Generating data quality reportsAnalyze and improve IT systems by:• Advising clients and technical subject matter experts on best practice for documenting system requirements• Assessing needs and contributing to the development of business systems• Planning the implementation of new business system processes• Writing complex specifications based on system requirements• Liaising with vendors to coordinate services and resolve issues• Conducting Threat Risk Assessment (TRA) and Privacy Risk Assessment (PRA)• Analyzing programming solutions to ensure compliance with best practices and industry standardsAdminister and support applications used for systems and reporting mechanisms by:• Analyzing and developing program scripts to extract, reformat and analyze data• Liaising with originators of test/examination scripts to resolve questions, inconsistencies, or obtain missing data• Analyzing and writing programming code structures based on user requirements• Designing, testing, and modifying programming code• Evaluating programming code to ensure it has validity, compatibility, and that it meets appropriate standards• Writing complex technical code• Performing database programming for new and existing systems

Analysis, Design & Development:• Translates business requirements into technical specifications for development to ensure adherence to business, functional and non-functional requirements. Develops data transformation solutions, data modelling, data warehousing, analytical visualization, and advanced reporting analytical methods such as predictive analysis, as well as traditional reporting solutions.• Works with subject matter experts (SME’s) to provide clearly written requirements for the release – may involve service modelling, data modelling and process modelling. • Develops data movement, maintenance of the metadata layer and designing of ETL jobs and data models, as well as daily maintenance of technical and business requirements for the entire business intelligence life cycle.• Supports User Acceptance Testing efforts: designs effective and efficient BI test cases; plans, schedules and executes testing, documents design decisions, data and reporting standards provides business analysis and assist in making recommendations. Data Integrity, Data Management and Statistical Analysis• Develops queries on local databases including ARBOR CRM (Client Relationship Management).• Compiles routine and complex data sets and statistical reports.• Identifies and resolves data quality and data reconciliation issues (ex. to resolve data discrepancies and/or to clarify reporting procedures).• Performs independent audits/reviews and validates databases to ensure data integrity.• Develops and reinforces compliance standards and procedures for the storage and retrieval of institutional data.• Supports system administrators in data warehouse product upgrades: responds to enquiries, performs technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions

Toronto, Canada Area

Planning and running various types of events for students Help promote these eventsWide variety of paper work and filing

Toronto, Ontario

Toronto, Ontario

• Responsible for the collection and analysis of data that were used in order to create disaster plans for buildings on the University of Toronto Campus • Communicated and worked alongside with engineers to understand the data collected and using the information to create efficient plans that would result in less lead time for emergencies • Created an efficient method of organizing collected data and analysis of the variables to create the disaster plans using excel computer software

499 Main St S, Brampton, On

Mississauga, Canada

Made website design and development decisions Used advanced programs such as Dreamweaver, Macromedia Flash, and PhotoshopModified HTML codes on website by using a variety of utility programsAnalyzed the design of Webpages to identify design elements and evaluate visual appeal