Megha Patel Email & Phone Number

Greater Sydney Area

Australia

Sydney Area, Australia

Sydney, Australia

Mercurial design,build and deploy Commercial Effectiveness Solutions for sales & marketing professionals; as well as providing them with value added IT and Consulting expertise. Our experience helps us to solve complex data/system integration problems; rapidly deploy commercial effectiveness solutions which have an instant and positive impact on productivity &sales growth.Mercurial operate primarily in the Healthcare sector, but also have clients in FMCG &LogisticsSolid understanding of data warehouse and ETL technologies and development.Managed data warehouse and ETL systems processing million transactions monthly,consolidating and linking multiple data types from numerous sources utilising MS SQL Server Development and implementation of strategies to combine operational and historical data &make it available to users in a shared, secure and controlled manner. Enhancement and maintenance of existing database products from the development of new functionality,to small scale redesign,to bug fixing if necessary Managing the ongoing development of data warehouse projects to ensure stages are delivered on time, within specification and tested appropriately General repair and maintenance of databases including backup, database optimizing, re-indexing & routine troubleshooting. Liaising with senior management & clients to understand specifications and document requirements for reports, analytics and presenting findings, outcomes, interface designs, and conversion efforts to facilitate the development and support of data warehouse applications Efficient database design and experience with Microsoft SQL Server technologies: MDX, T-SQL, stored procedures, triggers, Integration Services and Reporting Services,OLAP cubes ,DML and DDL scripts as required.Develop, maintain effective Scripting, including creation and management of batch job scheduling.Support, train and act as a coach to junior team members (includes graduates/interns)