Pratibha S

Experience

• 

  LTIMindtree

  Mar 2009 - Jul 2011

  Project /Client eMpower Performance Tuning / AllerganDescriptioneMpower is a NET Framework 3.0 Application developed to automate the process of Order Processing, Invoicing, Inventory Management, Sales Returns and Accounting of Allergan. It’s month end process were blocked due to server unavailability and end users were unable to complete the processes. So, the Performance tuning activity was done.Role : Played the role of Sr. Developer.Tools and Technologies SQL Server 2008 R2, SSMS(SQL Server Management Studio),SQL Profiler Worked on MS Management studio for Tuning Stored procedures using Execution Plans. Worked on improving the cost of the query and logical reads. Enhanced the performance of the indexes. Worked on partitioning of database in SQL Server 2005 using Range Partitioning. Experience with dimensional modeling using star schema and snowflake models. Show less Project /Client Allergan DW /AllerganDescriptionAllergan DW is a Decision oriented support system designed for timely and informed decision making through SSRS Reports. It is a User friendly and scalable BI solution. It also provides for more Multi-Dimensional Analysis Capabilities using SSAS Cubes.Role : Played the role of Sr. Developer.Tools and Technologies SQL Server 2008, SSIS(ETL), SSRS(Reports), SSAS(Cubes) Worked on SQL Server Integration services (SSIS) for Loading of Data to the Database. Created ETL Packages for Dimension and Fact Load.  Developed SSAS Cubes. Worked on deployment, processing and browsing of cubes. Created Dimension, Hierarchies and KPI’s in cubes. Worked with SCD (Slowly Changing Dimensions) in Cubes. Created Customized Reports in SSRS 2008 from Cube using MDX queries. Create Customized Reports in SSRS 2008 from Database using SQL queries. Worked on scheduling Reports in Report Manager. Managing user access and permission in SSMS. Creating and Scheduling ETL jobs using Sql Server Agent Maintained the quality process and strictly implemented the SDLC. (Ex. using effort estimation, impact sheet, RCA, RFC, Test Cases) Handled customer queries, service requests, and maintenance and production support activities. Took the ownership on the Project / Application and continuously worked towards improving the application in all possible ways. Handled all customer queries with minimum response time. Experience with dimensional modeling using star schema and snowflake models. Show less

  • Senior Software Engineer

    Mar 2011 - Jul 2011

  • Software Developer

    Mar 2009 - Feb 2011
• 

  Applied Materials

  Jul 2011 - Aug 2012

  Business Analyst

  Project Applied Materials Internal Projects /Applied IndiaCompany Applied Materials India Pvt Ltd(July’11-Aug’12)DescriptionWorked on Applied Materials Internal Projects for various Clients like Intel, Toshiba, IBM etc.Role :Technical Lead/Data AnalystTools and Technologies SQL Server 2008,SMS(SQL Server Management Studio),SSIS/SSAS/SSRS,Excel 2010,Brio Intelligence Explorer 6.3 Worked on writing stored procedures, functions and views for the given requirements. Created Brio Queries and pivots in Brio Intelligence Explorer. Development and deployment of SSIS packages. Created jobs for the execution of SSIS packages and the execution of the SP’s. Created complex SSRS reports using parameters and expressions dynamically. (Multivalued parameters) Scheduling and subscriptions of SSRS Reports. Worked on Excel 2010. Created pivots, used functions like vlookup, concatenate etc. Worked on Excel Services (Slicers, charts, spark lines) Good experience in MS excel 2010 & advance excel (pivot table, v-lookup, if, average, graphs, concatenation, filters, auto filters, dropdown list box, totals, subtotals, data validation, formatting, conditional formatting etc.) Created document library, lists and service requests in SharePoint site. Creation of Dashboard and Charts in Excel 2010. Show less

• 

  Accenture

  Aug 2012 - Apr 2014

  Senior Software Analyst

  Project /Client KPN –STARS COMPENSATION COCKPIT /KPNDescriptionStars Compensation is a software program dedicated to the unified management of compensation. It enables higher management to manage commission plans, bonus campaigns and Salary review campaigns. SQL Server 2012, SSIS(ETL), SSRS(Reports),T-sql (Sql),Power pivot Reporting for Excel 2010 Played the role of lead analyst and deployment coordinator for the release activities. Worked on SQL Server Integration services (SSIS) for Loading of Data to the Database. Created ETL Packages for Dimension Load.  Worked on creating stored procedures and views for the complex requirements. Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments. Create Customized Reports in SSRS 2008 from Database using SQL queries. Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server. Created complex SSRS reports using parameters and expressions dynamically. (Multi valued parameters and cascading parameters) Interacted with the existing database developers and DBA to understand the existing schema. Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle. Creating and Scheduling ETL jobs using Sql Server Agent Maintained the quality process and strictly implemented the SDLC. (Ex. using effort estimation, impact sheet, RCA, RFC, Test Cases) Have been mentoring and guiding the fresher’s in the team.  Strong RDBMS Concepts. Proficiency in developing SQL and DB Programming Language with various relational databases like Oracle and SQL Server. Wrote efficient stored procedures for the optimal performance of the system Show less

• 

  Dell Technologies

  Apr 2014 - Mar 2017

  Senior Business Analyst

  Project /Client :GSD BMS ,BOB Process & Quotes Pro /Dell IndiaDescriptionGSD BMS –Enhance the decision making and capabilities of GSD (Global Support and Deployment business)sales executives by providing standardized and executive ready reports.Best of Breed is a tool with multiple dashboards which demonstrates attached rate for different dell products sold which helps sales representatives to improve their performance and increase sale of dell products.Quotes Pro is a tool which shows the no. of quotes being presented and the detail of the quote which is converted to order and units and revenue attached with it.Role :Technical Lead/Data AnalystPlayed the role of lead analyst to help sales representatives capture figures to increase their selling power and help them to upsell Working closely with DELL partners to get the requirements for creating the operational & financial dashboards for different regions AMER, EMEA, APJ across the globe. Create PowerPoint presentations for Business Analytics & Insights for different business units. Automate monthly excel reports into Tableau Workbooks and Dashboards. Design Dashboards using Filters, Parameters and Action Filters Facilitated the sales attainment process by reporting revenue, units and margin in the form of drill down analysis cut across different levels in terms of product hierarchy. Also highlighted the hits and misses in each of the LOBs using demand creating metrics that are specific to services. Building, publishing customized interactive reports and dashboards, Developed Tableau workbooks from multiple data sources using Data Blending Built dashboards to measure key financial metrics for the company’s client and enterprise services business. In addition, provided adhoc analysis detailing about the best/worst performing countries, products, deals or agents. Mentoring new team members,Part of the internal hiring team,Created ETL Packages for Load and SSAS cube. Show less

• 

  IQVIA

  Jun 2019 - Sept 2019

  Business Intelligence Specialist
• 

  Dell Technologies

  Sept 2019 - now

  Business Intelligence Specialist

  Role: AdvisorPlayed the role of advisor to support the Rebates payment to partners. A proactive data analyst expert proficient in creating impactful data visualizations and dynamic dashboards in PowerBI &Excel to drive informed decision-making and enhance data-driven insights. Led regular stakeholder meetings to provide project updates, address concerns, and gather feedback, resulting inimproved transparency and stakeholder satisfaction. Played a pivotal role in automating & streamlining various ongoing processes and prepared knowledge repository for thesame using Visio. Developed the RTB calendar for CIS system with proficiency in Process Improvement and management. Collaborated with cross-functional teams to develop project plans and optimizing project efficiency and delivery. Independently performs complex troubleshooting, root-cause analysis, and solution development using SQL, Teradata,macros and ETL Tools. Designed intuitive Power BI dashboards with interactive views, trends, and drilldowns. Extensive experience in the analytics, Channel, Services, CSG and ISG domain (APEX, VCE and other storage products) Skilled in implementing robust data governance practices to ensure data quality and compliance in data managementprojects. Created comprehensive BRDs by engaging stakeholders, documenting requirements, defining scope, and analyzingcurrent and future states. Developed detailed FRDs by translating business needs into functional specifications, creating use cases, collaboratingwith technical teams, and ensuring traceability and validation. Show less