 Redesigning existing reports for increased visibility of data. Creating live automated reports for the team. Acting as a liaison between our team and IT. Identifying issues, informing management, and suggesting solutions. Collecting data from various sources, consolidating, analyzing, and presenting it. Modifying SQL queries as per requirements. Designing, implementing, and creating dashboards in MS Excel using pivot tables and V lookups. Supporting/Coaching… Show more  Redesigning existing reports for increased visibility of data. Creating live automated reports for the team. Acting as a liaison between our team and IT. Identifying issues, informing management, and suggesting solutions. Collecting data from various sources, consolidating, analyzing, and presenting it. Modifying SQL queries as per requirements. Designing, implementing, and creating dashboards in MS Excel using pivot tables and V lookups. Supporting/Coaching teammates in data analysis. Show less

Client - Citibank, IrvingResponsibility include Creating Dashboards in JIRA using Rich filters, Smart filters and Controllers Adhoc Analysis/Reports/Dashboards using Pivot tables, Graphs, V lookups etc Creating/maintaining MS Access tables/Queries/Forms and Reports for the team. Presenting Reports in MS Word and PowerPoint formats. Generating queries in Service Now and running the reports. Daily/Monthly reports for senior management Helping/guiding the… Show more Client - Citibank, IrvingResponsibility include Creating Dashboards in JIRA using Rich filters, Smart filters and Controllers Adhoc Analysis/Reports/Dashboards using Pivot tables, Graphs, V lookups etc Creating/maintaining MS Access tables/Queries/Forms and Reports for the team. Presenting Reports in MS Word and PowerPoint formats. Generating queries in Service Now and running the reports. Daily/Monthly reports for senior management Helping/guiding the teammate with issues. Interacting with various departments and offshore team for collecting data Validating data to make sure similar reports in various reporting tools are matching. Informing management of any incorrect data input Show less

 Writing/Modifying T-Sql Queries for reports Connecting the Sql queries to MS Excel for live reports. Creating dashboard using Pivot tables and graphs with Slicers and Timelines for the management. Collecting data from various sources and creating meaningful reports. Doing in depth analysis and providing solutions to the management.

 Involving with business clients in development of new reporting/data delivery solutions. Analyzing critical historical and real-time operational performance information including: contact volume, handle times, team and individual performance, schedule adherence, sales performance, abandon rates, attrition and shrinkage data, and any individual and group KPIs.  Developing and preparing ad hoc reporting and analysis as needed to support projects and initiatives. Performing… Show more  Involving with business clients in development of new reporting/data delivery solutions. Analyzing critical historical and real-time operational performance information including: contact volume, handle times, team and individual performance, schedule adherence, sales performance, abandon rates, attrition and shrinkage data, and any individual and group KPIs.  Developing and preparing ad hoc reporting and analysis as needed to support projects and initiatives. Performing in-depth analysis to support special projects or operational data requests. Creating reports using Pivot tables (with Slicers and Timeline) and V lookups Maintaining and making modifications with existing SQL queries Delivering daily, weekly and monthly reports on time Show less

City of Memphis Information Services, Memphis Sep 2014 - till dateBusiness Intelligence Data AnalystResponsibilities:• Involved closely in the city's use of existing and emerging technologies in government operations, and its delivery of services to the public.• Work closely with various departments to understand and contribute business, functional and technical project requirements.• Creating Queries and reports using 1010 data and Metric Insights (BI tool for… Show more City of Memphis Information Services, Memphis Sep 2014 - till dateBusiness Intelligence Data AnalystResponsibilities:• Involved closely in the city's use of existing and emerging technologies in government operations, and its delivery of services to the public.• Work closely with various departments to understand and contribute business, functional and technical project requirements.• Creating Queries and reports using 1010 data and Metric Insights (BI tool for Creating Graphs and Bar charts)• Train/assist the department analysts in uploading data and fixing issues with creating queries/graphs for analysis.• Develop and maintain dashboard for each division.• Using V Lookups and creating Graphs and Pivot tables with Slicers and Timelines in MS Excel for analysis and presentation.• Attending meetings with City Division Directors and their teams to gather requirements on various KPIs.Environment:1010 data, Remedy,Metric Insights and MS Excel Show less

 Analysis of Household counts, sales, transactions, spend/household, average spends/customer etc. for the division and for stores. Deep dive into the spending habits among different segments of customers. Creating Adhoc reports as per the requirements. Support customers/stores on issues with fuel points, loyalty cards, and scanning issues. and generating mailing lists for sending mailers to targeted customers. Analysis on the coupons redeemed by customers. Presenting… Show more  Analysis of Household counts, sales, transactions, spend/household, average spends/customer etc. for the division and for stores. Deep dive into the spending habits among different segments of customers. Creating Adhoc reports as per the requirements. Support customers/stores on issues with fuel points, loyalty cards, and scanning issues. and generating mailing lists for sending mailers to targeted customers. Analysis on the coupons redeemed by customers. Presenting data analysis to Senior Management. Help the merchandisers/district managers by providing them with in-depth information on the products purchased by customer segments. Analysis of sales promotions happening in stores. Creating Spot maps of Kroger Competitors and customers. Show less

 Creating centralized reports for the division as per the requirements.  Documentation and validation of existing reports/new projects. Coaching the supervisors on new reports. Analysis of the customer service center's efficiency, performance and monitoring of agent occupancy in regards to call arrival patterns. Compiling and analyzing daily, weekly, and monthly call center performance reports. Creating and maintaining the commission report for agents and making… Show more  Creating centralized reports for the division as per the requirements.  Documentation and validation of existing reports/new projects. Coaching the supervisors on new reports. Analysis of the customer service center's efficiency, performance and monitoring of agent occupancy in regards to call arrival patterns. Compiling and analyzing daily, weekly, and monthly call center performance reports. Creating and maintaining the commission report for agents and making necessary changes in the backend Sql code as per the requirements. Writing Sql queries and creating reports in SSRS related to performance and the products sold by call center employees. Modifications in the backend of existing Cognos report by grouping, adding calculated columns, subtotals etc to create custom reports. Generating custom reports in Excel using Vlookup, subtotal etc. Generate report based on the talk time, hold time, wrap time, calls per productive hour, average handled time etc. Report the management on any promo stacking and any adjustments made for customers. Creating ad hoc reports as per the requirements. Show less

 Creation of data sources, named queries, and calculated fields. Worked on different data transformations like Data Conversion, Copy Column, Derived column, Sort, Aggregate, Merge Join, Union all etc and control flow items like file system task, xml task, Bulk insert task etc.  Exporting of data from excel sheet and other sources to the database using SSIS with data flow transformation and creating new tables. Formatting excel sheets using Sql Server. Creating Stored… Show more  Creation of data sources, named queries, and calculated fields. Worked on different data transformations like Data Conversion, Copy Column, Derived column, Sort, Aggregate, Merge Join, Union all etc and control flow items like file system task, xml task, Bulk insert task etc.  Exporting of data from excel sheet and other sources to the database using SSIS with data flow transformation and creating new tables. Formatting excel sheets using Sql Server. Creating Stored Procedures. Create dataset using query designer and stored procedures in SSRS Create reports using SSRS with parameters, Grouping, Sub grouping, Subtotals, Sorting, Drilldown reports, Conditional formatting etc Creating adhoc reports from Business Objects Creating macros and reports in Excel Show less