Monika Saravanan

• Responsible for collaborating and to perform data and process analyses required
• Responsible for procuring buy-in from stakeholders
• Responsible for defining the requirements and provide simplified explanations
• Responsible for synthesizing data and feedback from users, clients, and management
• Responsible for contributing to short and long-term goal setting
• Responsible in developing action plans and aide in accountability
• Responsible for collaborating regularly with various teams, including market analytics
• Responsible in developing and utilize dashboards effectively
• Responsible to develop, analyze, and modify processes, data structures, and models
• Responsible to interact with clients to evaluate products and performance
• Responsible to maintain objectivity to ensure processes and products are relevant
• Responsible in making data-driven decisions and recommendations
• Responsible to explain the implications of complex data articulately and concisely

• Responsible for develop and build the Reports/Dashboards and deploy into Power BI
• Responsible Import, reshape and model the data
• Responsible Create stunning reports and visualizations
• Responsible for import data from Azure and build the dashboards as per the requirement
• Responsible for schedule the dashboards according to frequency(daily, weekly)
• Responsible for create Workspaces and share insights to specific business customers/partners and stock holders.
• Managed relationship with programmers and bridged communication between end users and development team
• Responsible for providing the securities for reports/dashboards by assigning roles
• Responsible for identifies the project’s stakeholders and figures out what they need
• Responsible for coordinate with off-shore development team, assign them tasks and help with any technical queries.
• Design star, snowflake schemas in Analysis Services
• Responsible for Involved in creating the tables and their relationships in the data warehouse
• Responsible for create various files and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation
• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source. (Control flow, Data flow (Transformations)).
• Responsible for performed performance tuning on SQL queries and stored procedures

• Gathered and documented business requirements for KPI reports. Participated in requirements meetings and data mapping sessions to understand the business needs. Identified and documented detailed business rules.
• Load CSV, Excel, Access Database and Flat files into Staging Data Source using SSIS.
• Create a multi-dimensional Data model in SQL Server based upon Kimball methodology (Fact Tables and Dimensions)
• Automate Delta loads into the multi-dimensional database using SSIS. Analyze client databases to evaluate the design of the database for purpose of reporting
• Responsible for designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task
• Responsible for extracting data from multiple sources like flat files, oracle, and SQL server for transforming, cleansing and validating the data to load into final Destination
• Responsible for create ETL packages to move data from feed files (XML, CSV and TXT) to database
• Responsible for create packages to migrate data from oracle to Sql server
• Responsible for developing Stored Procedures, Views and User defined functions
• Responsible for fine tuning of stored procedures to improve the performance
• Responsible for developing and building the Reports/Dashboards in Power BI
• Responsible build data models and create reports.

• Automate Delta loads into the multi-dimensional database using SSIS. Analyze client databases to evaluate the design of the database for purpose of reporting
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support data Transformation
• Migrate any old Access DB, Flat file and other data source to SQL Server.
• Developing, implementing, documenting, monitoring and maintain the data warehouse extracts, Jobs and ETL Process.
• Analyze and Document Client Reporting Requirements from Analysts to Senior Management and ensure all reporting requirements were documented and shared through the business to avoid duplication of reports by different departments
• Support creation and data gathering for Governance presentations.
• Support in the areas of customer feedback, issue & problem management
• Responsible for developing and building reports and other documentation works

• Sale of over-the-counter medicines and the provision of information to customers on symptoms and products.
• Prescription receipt and collection.
• The assembly of prescribed items (including the generation of labels).
• Ordering, receiving and storing pharmaceutical stock.
• The supply of pharmaceutical stock.