Pranita Chandvidkar

Company Overview: CitiusTech is a specialized provider of healthcare technology and business process services to healthcare technology companies, healthcare providers, managed care organizations, health plans, and disease management companies.

• Built out the data and reporting infrastructure using SSRS and SQL to provide real time insights into the product and business KPIs
• Working with Project owner to perform cohort analysis
• Analyzing data from on premise and on cloud platform
• Used stored procedures, views to provide structure data to business
• Execute research and analysis, including data gathering and processing from different data sources
• Prepare business requirement documents (BRD), Root cause analysis document(RCA).
• To assist Project owner to validate the requirement to ensure business needs captured
• Collaborate with QA Analysts, Database Developers, and business & management teams to define business needs
• Troubleshooting any issues in the database systems
• Transforming business needs into technical solutions
• Providing status updated to reporting head
• Data mapping, data profiling
• Sharing data model inputs with Solution architect.
• Manage a centralized MS SQL Server Platform consisting of critical databases
• Optimized the code and database for maximum performance
• Involved in DBA activities like performing analysis and troubleshooting of queries using RDBMS toolsets; provided performance improvement recommendations
• Monitored Database Logs database objects, such as tables, indexes, rules, user-defined data types, defaults, database triggers & stored procedures (to implement complex business rules) worked with the application support/development teams for database upgrades and releases
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF's, constraints
• Experience in designing, configuring, deploying SSIS packages
• Experience in Error handling, Debugging, error logging for production support in SSIS
• Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server
• Developing reports on SSRS on SQL Server
• Created stored procedure for generating reports using SQL Server Reporting Services SSRS
• Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS
• ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS
• Building the pipelines to copy the data from source to destination SSIS
• Scheduling and monitoring the data movement from source to destinations
• Transforming data in SSIS with Transformations
• Offshore point of contact for client requirement
• Deliverables - Daily Status, Weekly status, Fortnightly status, Quality Audits and Metrics
• Resource planning and work allocation
• Issues or roadblock resolution
• Worked with team on developing utilities for manual process for project performance improvement (110% Initiative)
• Preparation of requirement documents and traceability metrics
• Plan the activities and effort estimation
• Assist development and support team with technical and troubleshooting production issues

Company Overview: Agile Financial Technologies is an IT service company in insurance sector.

• Understood and analyzed the requirements
• Analyzed data, designed and developed forms 10g queries, layout, report triggers, parameter form
• Developed Forms screens using Oracle developer suite
• Created procedures, functions and packages as per requirement
• Tested forms and reports, debugged, and fixed the issues after testing

Company Overview: Tata Consultancy Services is a global leader in IT services, consulting & business solutions with a large network of innovation & delivery centers.

• Troubleshooted and implemented bug fixes and enhancement within deadlines
• Provided technical support to production and UAT environments
• Participated in production deployment
• Worked on change management process
• Tuned code such as SQL queries and PL/SQL code
• Designed and developed the application using forms and reports
• Handled priority incident within given SLA

Company Overview: Parle Products Pvt Ltd is India's largest manufacturer of Biscuits & Confectionery Company.

• Developed application using Forms & Report tool
• Involved in preparing technical and program specification documents
• Involved in modifying various existing procedures, function depending on the business needs

• The project involved interface developments for the integration between CAFOM and SDV MIDAS system
• Developed interfaces for Shipment Order Confirmation, Shipment order Import, Receipt Confirmation, Receipt Import, Stock Snapshot, and Stock Movement.

• Project involved designing application for requesting amenities for employees of Reliance.
• Developed interfaces depending on business needs.
• Created SQL scripts.