Mahendra Sharma Email & Phone Number

Melbourne, Victoria, Australia

- Conduct requirement gathering, design, and documentation of technical specifications, including Data Flow Diagrams, Architecture Diagrams, Data Libraries, and Business Rules.- Develop data pipelines primarily using Python and SQL based on agreed-upon specifications.- Ensure data quality within the Data Warehouse by regularly monitoring scheduled jobs and processes for failures and resolving any issues.- Maintain an up-to-date Data Library to facilitate easy access to existing models and objects for team members and stakeholders in future projects.- Provide daily support to stakeholders and team members regarding data or technical issues.- Assist with routine patching and upgrades on development and production servers, including database backups and restorations in case of disasters.- Administer the Data Warehouse and Power BI, managing access rights and assigning permissions as required.- Support and contribute to user education on data, the analytics platform (reports, documentation), and best practices, promoting self-service reporting and dashboard development.- Keep the code version repository updated with any changes and provide access to team members as needed.

Melbourne, Victoria, Australia

- Working in a Agile environment with Business analysts, Developers & Test Lead to deliver self reporting platform using Power BI & Sql Server- Assisted Sr Project Managers in gathering requirements and estimates for Dev & Test server in AWS Environment- Supported team in setting up code version control using Git hub & Red gate software.- Develop procedures & Queries to meet current requirements by stakeholder.- Provided solutions to avoid manual tasks by automating using Python & VB.

Melbourne, Australia

- Web Portal Administration for External Panel firms users- Designing, development & Maintenance of Applications to improve business processes- Resolve system queries raised by internal team and external stakeholders in limited duration.- Resolve errors and bugs in current system raised by users as well as detected in logs.- Maintain SAS Schedules to keep Portal updated with current information as well as to keep stakeholders informed via auto notifications. - Refresh Weekly, Monthly & Semi Annual Non production Reports via Semi automated process.- Writing SQL/SAS Procedures to extract information required by business users.- Assist teams in Systems upgrades relevant to Portal functionality/ SAS schedules and other Applications.

Geelong

1) Analysing data to show key trends and facts which helps business users to take effective decisions. 2) Providing technical support in leading projects of TAC 2015 service program.3) Writing SQL/SAS Codes to fulfill Adhoc request from business user.4) Analysing Modifying/Updating and Testing SAS Programs as per the business requirement.5) Migrating development programs into production environment by coordinating with IT Service Support and External service providers.6) Running Weekly, Monthly & Semi Annual schedules7) Coordinating internally as well as with external service providers for smooth execution of production job schedules.8) Updating report recipient email groups as per the request.

Mumbai Area, India

Highlights:Got Promoted in 2010-11 appraisal and rated as “Exceeded Expectation” in 2009-10 appraisal. Write SQL Queries for analysis of Client Data based on Investigator or Client requirements and provide document output to Client or Investigator in Excel Format.Writing and modifying Sql stored procedures for Forensic Audit Assistance pertaining to Journal Entries, Accounts Payable and Receivables.Involved in writing VB Codes to develop in-house applications aimed at automation of manual process and macros to transform data files for faster ETL process.Worked on Investigation Projects related to FCPA, AML and Asset Misappropriation and PayrollAcquired knowledge in various risk factors through active participation in Forensic Audit Assistance projects.Worked on SSIS for importing multiple Files from different sources in Sql Server.

Mumbai

Highlights:Rated as “Commendable” in the annual appraisal of 2007-2008.Acquired significant exposure in both sql server and oracleWorked on Pan India Prepaid and Post-paid Data containing 70 million customer records for Analysis using Oracle Sql and Sql Server T-SQL. Prepaid and Post-paid Campaigns analysis as well as its execution of PAN India.Analyses of customers life cycle like churn analysis for retention, revenue enhancement, segment analysis for product launch etc.Analyses of Usages (in minutes as well as in Rs) and Recharges (e as well as paper recharges) Coordinating with different departments for IVR/SMS relays (Communication to Customers) of Offers, Crediting of customer accounts that have availed those offers.Result analysis of campaignsDeveloped SQL procedures for Prepaid & Postpaid Mobile data extract as well as FWP Data apart from preparing segments and running campaigns for various products. Liaised with IVR/SMS team for timely relay of information on offers to customers and with the DSS team for collation & extraction of data.Involved in various kinds of data modelling required by Product & Marketing teams.

Mumbai Area, India

Highlights•Assisted Senior Software Engineers in SDLC of Umarc V1.1 developed using Visual Basic 6.0 and SQL Server 2000, wrote Software Specification for Umarc V2.0 and unit tested Umarc V1.1.•Prepared User Manuals for end user. •Involved in development of new system for upcoming business in R&D section.

Master Of Computer Applications - Mca, Information Technology

Bachelor Of E Commerce, Computers

12Th, Science

Activities and Societies: 1) Played Volleyball upto Zonal level. 2) Got first prize in Free Style swimming in zonal Level. 3) Played.