SAI KRUPA PRUTHIVI KUMAR NAGULA

Technical Skills: OLAP Tools: Power BI (Power View, Power Services), ETL Tools: Power BI (Power Pivot, Power Query) Languages, MS SQL

• Developed and reviewed simultaneous SQL queries with use of join clauses (inner, left, and right) in Tableau desktop to validate static and dynamic data for data validation.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generate computed columns in Power BI.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Published Power BI Reports in required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Explore data in variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Used Power BI to collaborate with different users and stakeholders to work on live data sources.
• Good knowledge of Microsoft BI Stack.
• Knowledge of various software development life cycle models and documentation.

Project: Invacare

• Worked closely with management, project managers and IT to evaluate required data, reporting functionality, communicate trade-offs, alternative solutions, plan out, prioritize, and lead related development efforts Successfully imported data from data sources and prepared same as per need Established relationships between various data sets in power pivot.
• Led cross-functional project teams to incorporate new data sources into data warehouse.
• Developed custom report tool tips for different reports to showcase multiple data points in one report.
• Created dynamic work culture, mentored BI staff in technical areas used by analytics team, both formally in structured group settings and informally in one-on- one and small group sessions.
• Suggested solution proposal to business with deep understanding on business needs, translated business needs and technical requirements into detail design.
• Leading activities pertaining to usage tracking and agents and email configuration.
• Responsible for Managing Identity and Access Management of enterprise customers.
• Led advanced analytics projects as needed, developed business intelligence dashboards, and assisted in its integration on multiple data platform.

Project: EPIC Insurance

• Defined scope of the project, gathered business requirements, conducted analysis and documentation of the same
• Supported clients with business analysis, documentation, and data modeling.
• Defining BI and system integration architectures combining data from disparate source systems
• Successfully imported data from data sources and prepared same as per need
• Established relationships between various data sets in power pivot
• Leading activities pertaining to refresh dashboards every day as per needs
• Led development of new columns, new measures and conditional columns using DAX function
• Steered the creation of different filters like visual level filters, page level filters and report level filters as per reporting needs
• Designed diverse types of reports like drill down, drill through, and Sync Slicer
• Developed custom report tool tips for different reports to showcase multiple data points in one report
• Drafted customized & interactive reports and dashboards in Power BI.
• Designed custom dashboards and reporting interfaces.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Designed and developed customized extract, transform and load (ETL) applications per client specifications.

Project: Allvac

• Compiled, maintained and developed database systems for tracking tailored content reports.
• Developed and managed dashboards using BI and successfully managed full life cycle of BI projects independently.
• Steered development of Power BI visuals and data models as required
• Drove the development of Power BI dashboards and managed ad hoc reporting
• Successfully developed Visualization reports using Power BI as per requirement
• Visualized data, drafted & published reports; scheduled, automated the same
• Led usage of DAX for Power BI reports, articulated reports with conditional formatting
• Improved data gathering, analysis and visualization procedures with strategic optimizations.
• Managed the application of different formatting & amp, amp, styles to reports
• Monitored and optimized SQL server performance.
• Headed calculation of columns to simplify the data
• Worked on On-Premises Gateway to refresh the data sources and Scheduling the data.

Project: Royalmail

• As a core member of regional BI/DW team, successfully managed full life cycle of BI projects independently and deliver solutions accordingly
• Generated reports, updated spreadsheets and presented results.
• Drafted customized & interactive reports and dashboards Proactively assisting in requirement gathering and objects delivery
• Core member of lead team for various business intelligence projects, provided expertise on data visualization tools, concepts, and best practices
• Coordinated with team members in analytics, data science, and technology to identify best practices, policies, and procedures for data usage
• Championed standardization, integration, and ubiquity of BI tools and processes
• Driving effective migration of objects from development to production and testing
• Gathering requirements and delivering objects.
• Automated BI reports for secure virtual server environment.
• Compiled, maintained and developed database systems for tracking tailored content reports.
• Designed customized data collection models for specific visualization tasks.
• Assessed platform statistics to create customized, data-intensive BI analytics.
• Collected data from wide-ranging sources.
• Maintained ongoing schedule and documentation for all reporting procedures.
• Generated queries utilizing SQL to create required reports.

Project: Bing Search Engine

• Actively supported business users for change requests
• Manually test user raised bugs and forward for curation & validation
• Data analysts to work with large amounts of data: facts, figures, and number crunching and also need to see through the data and analyze it to find conclusions
• Importing data from various external data sources
• Extracted and interpreted data patterns to translate findings into actionable outcomes.
• Developing data for Bing search engine for different markets (US, UK, Germany)
• Worked on different Microsoft tools based on SQL DB
• Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Developed customized reports, summarizing and presenting data in visually appealing format.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Have to make sure they are vigilant in the analysis and come to correct conclusions
• Work with management to prioritize business and information needs.

Project: HI Entity Curation, Headset Entity Curation, Rush More

• Utilized Chain Mining and UHRS software to track and analyze data
• Participated in requirements meetings to understand business needs.
• Optimized data collection procedures and generated reports on weekly, monthly, and quarterly basis
• Importing data from various external data sources
• Creating data visualizations to effectively convey findings
• Verified data files prior to entry to maintain high data accuracy.
• Reporting results back to the relevant members of the business
• Working alongside teams within the business or the management team to establish business needs
• To verify & curate the details of entities loaded from their official website
• Verified accuracy of data entered into system to produce error-free reports.
• Sent completed entries for evaluation and final approval.
• Selecting corresponding option in hit app that matches the information on official site and authorized web sources as approved and explained in the given guideline document
• Acquire data from primary or secondary data sources
• Have to make sure they are vigilant in analysis and come to correct conclusions
• Interpreting data, analyzing results using statistical techniques
• Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
• Acquiring data from primary or secondary data sources
• Monitoring performance and quality control to identify improvements and other strategies that optimize statistical efficiency
• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Performing initial analysis to assess quality of the data
• Sent completed entries for evaluation and final approval.
• Project Description: Curation, Validation, Audit Sampling, Final Audit, Re-Validation

Project : IT Glue (Help Desk Support)

• Establishing the networking environment by designing the system Configuring and installing various network devices and services (e.g., routers, switches, firewalls, Load balancers, VPN)
• Setting up user accounts, permissions and passwords
• Overseeing security of all systems, especially the internet, and installing antivirus protection
• Implemented network security measures to minimize data loss.
• Managed computer operation scheduling, backup, storage and retrieval functions.
• Implemented and maintained virtual private networks.
• Maintained network hardware and software and monitored network to support network availability to end users.
• Performed network security design and integration duties.
• Implemented, developed and tested installation and update of file servers, print servers and application servers.
• Building IT Glue project as per the company standards and requirements.

• Establishing the networking environment by designing the system configuration, directing system installation, documenting and enforcing system standards
• Designed and evaluated WAN and LAN connectivity technologies.
• Evaluated software products to determine compatibility with existing systems.
• Resolved issues and escalated problems with knowledgeable support and quality service.
• Devised scripts and automation tools to improve system efficiency.
• Implemented and maintained virtual private networks.
• Maximized system availability through development and testing of contingency plans.
• Performed network security design and integration duties.
• Installed and configured network printers and other peripheral devices.
• Implemented, developed and tested installation and update of file servers, print servers and application servers.
• Monitored networks and network devices to resolve technical problems quickly.
• Developed and documented network policies, procedures and standards.
• Researched and recommended new technologies and strategies for improving system performance.
• Analyzed network traffic and performance metrics to optimize system performance.
• Identified and resolved network congestion issues and bottlenecks.
• Diagnosed and executed resolution for network and server issues.
• Diagnosed and resolved hardware and software issues.
• Maintained flexible schedule and responded to after-hours and weekend emergencies.
• Maximizing network performance by monitoring performance, troubleshooting network problems
• Undertaking data network fault investigations in local and wide area environments, using information from multiple sources.

• Responsible for the daily preparation of food items in the fry and/or stations or other areas of the kitchen.
• Follows recipes, portion controls, and presentation specifications as set by the restaurant.
• Prepares all menu items according to quantity menus
• Bakes, roasts, broils and fries meat, fish and fowl.
• Mixes and cooks specialty dishes and delicate foods.
• Seasons foods by taste test and recipe.
• Maintains records of food used and supply on hand.
• Figures food cost and records on daily food cost sheet
• Assisting cook/s with the preparation and production of meals and snacks.
• Managing food and beverages operations of the restaurant house.
• Assisting with ordering and storage of stock.
• Taking orders and serving in due time.
• Other general duties including maintenance of high standard of hygiene and cleanliness with in the kitchen