Post Job Free
Sign in

SQL server stack(SSIS/SSRS/SSAS), Tableau, Power BI, Teradata

Location:
Schaumburg, IL, 60193
Posted:
November 30, 2018

Contact this candidate

Resume:

SUJATHA REDDY LAKKADI

480-***-****/*******.*******@*****.***

https://www.linkedin.com/in/sujatha-reddy-lakkadi

SUMMARY :

Business intelligence professional with over fourteen years of experience in IT with expertise in all phases of project lifecycle analysis, design, development of database applications from gathering requirements to testing, implementation, and support.

Solid experience in creating DDL, DML and transaction queries in SQL for SQL server, Teradata, Oracle, MySQL, Netezza and Azure cloud environment.

Hands on experience in reporting tools, including SQL Server Reporting Services (SSRS), Tableau, Power BI, MicroStrategy, Business objects, and MS Excel.

Experienced in utilizing ETL tools, including SQL Server Integration Services (SSIS), Teradata utilities, data stage parallel jobs and Informatica.

Expertise in Home warranty, POS retail sales, Protection agreements, customer loyalty and rewards programs, Loyalty Platform development and customer analytics areas.

Extensive experience and solid understanding of data warehousing, data marts, star schema, snow flake schema, dimensional modeling, data modeling, entity-relationship modeling, OLTP and OLAP concepts.

Hands on experience in doing the data analysis, data mapping, profiling, cleansing and validation.

Proficient in querying the databases and Involved in exhaustive performance tuning, monitoring and optimization of T-SQL and Bteq scripts in the development and production environment.

Highly skilled in analyzing information from various data sources to fully functional database systems and dealing with structured and unstructured data formats and provide the insights to business users.

Developed and enhanced the proprietary tools as per the organization’s specifications.

Worked with clients in the Retail, Financial, Banking, telecom, pharma and Healthcare domains.

Prioritized the tasks while working with multiple engagements and maintained positive communications and working relationships at all business levels.

Good communication and interpersonal skills, strong ability to learn and adapt to new technologies quickly.

SKILLS

Databases MS SQL Server, Teradata, Netezza, Azure cloud database, Informix, MySQL and MS Access

ETL/OLAP Tools SQL Server DTS, SSIS, Teradata loading utilities, Informatica, DataStage Parallel Jobs and Pentaho

Reporting Tools Tableau, SSRS, Power BI, MicroStrategy, Business Objects XIR2, MS-Excel and Cognos

Languages SQL, T- SQL and PL/SQL, Unix shell scripting, MS Access, C++ and Core Java

Data Modeling Erwin, Visio, Rational Rose and MS Project

EXPERIENCE:

Oct ’14 – Present Sr.BI Data analyst/ETL/Reporting developer, Sears Holdings – Sears Home Services, Hoffman Estates IL

Sears holdings corporation is a leading retailer of general merchandise, tools, home appliances, clothing, and automotive parts and services. Sears home services is part of Sears holdings taking care of appliance installations, protection agreements and repair services. I was mostly responsible for service contracts reporting needs besides other home service business units.

Responsibilities:

Responsible for providing data needs, reporting, and analytic support for the Home Services Analytics and Insights team.

Efficiently managed complete reporting cycle from gathering user requirements to delivery of data marts, reports and dashboards for Sears Home Services and its business units including Protection Agreements, Home warranty, Home appliances, repair services, parts sales and its Shop Your Way Rewards customer loyalty program.

Design, develop and maintain an automated, accurate BI Dashboards and Reports using Tableau, SSRS, Excel Pivot, Power BI, and creating a single source of truth and self-serve capability for Sears’s Home Services Business to measure and monitor the state of the business from nation to an individual technician level.

Worked on POC to move data in-house to Azure data factory & DWH and created dashboards/reports using Power BI.

Analyzed behavioral, demographic, and other information to help identify opportunities for revenue growth, cost-reduction, and other components of profit optimization.

Effectively designed insightful tableau dashboards from managers to C-level executives.

Built data mart for different business units using SSIS and Teradata ETL jobs.

Provided operational insights to leadership team at a quick glance with summaries, dual axis chart comparisons and action filters in tableau for effective decision making.

Developed and supported various projects using different technologies in Service contracts business unit– PA sales, renewals and cancellations, Targeted marketing, Installment billing, Home warranty from cross country, Tech protect from Amtrust, PA partnership with Citi, Shop Your Way Rewards program.

Automated and simplified the data availability through integration, consolidation of reports, dashboards with alerts and drill down as needed.

Published and scheduled reports to emails, shared directories and ftp/sftp locations.

Provided user interactivity with Parameters, forecasting and trend lines in tableau.

Environment: SQL Server(SSIS/SSRS), Azure, Tableau 10.3, Teradata, Power BI, Business Objects, Cron tab and UNIX shell scripting

Nov ’08 – Sep’ 14 Sr.Business Intelligence Analyst, Sears Holdings corporation, Hoffman Estates, IL

Sears Holdings corporation is a leading retailer of general merchandise, tools, home appliances, clothing, and automotive parts and services. I got an opportunity to work on several projects and technologies The magnitude of the business and data gave me an opportunity to work on several projects and exposure to multiple BI tools.

Projects and responsibilities:

Implemented a fusion of business knowledge and strategic business analysis to provide insights, solutions and also resolved issues for critical business and technical problems with data warehousing and reporting.

Migration from Teradata to Netezza: Involved in Data analysis of the tables and validating ETL scripts.

Worked on Teradata decommissioning for the Big 12 tables (Kmart Inventory, Sales, Receipts and Inventory adjustments).

Developed ETL process using SSIS and Reports using SSRS:

Performed Business requirement analysis, Data modelling, SSIS jobs, Development, validation and deployment of the below reports.

Installment loan POS integration, Discover second look, HSBC, Store operations, Weather, Water Filter My Gofer, ACR, HI score card, Footwear Restocking check sheet, Sears KPI and sub reports, Shopping Recap – IR labs(Sales T-1, HTS, Zero recap participation).

SYWR Portal –Extensive Data Analysis, Designed Stored Procedures and Validated MSTR Reports.

Migration from Netezza to Teradata: Data analysis and ETL coordination.

Store Manager Promo Tracker (SMPT) – Developed and automated the ETL process for this report created in .net platform, this tool identifies the top and bottom 20 roto pantry items for the store, compared to a group of peer stores.

SEARS KPI Reporting: Developed the most widely used KPI report in SSRS, The program has been enabled nationwide for enrollment, earning and redeeming in-store enrollment in all Sears stores nationwide. The Shop Your Way Rewards program is designed to increase engagement with Sears and Kmart customers, thereby increasing repeat visits, higher average spend, and higher customer satisfaction.

Telluride CDW reporting – Performed Data Analysis, Created Adhoc reports from CDW SYWR tables as per the business requirements and Supported Teradata ETL and Reporting.

Performed the Data analysis and profiling for the Customer Profit &Loss, Terada Decommissioning, Weather tables and adhoc assignments.

Worked with Project management and Business users in gathering the business requirements and translating them into technical specifications.

Supported the data modelers in creating the models as per the BRD document and giving them the inputs based on the analysis of the existing data structure.

Worked with Project SME and analyzed the JCL script in order to document the process flow documentation and Visio flow charts.

Proficient in Data profiling, performed data profiling for all the assignments using Information analyzer as well as manually by writing SQL.

Demonstrated a great value by giving the inputs to ETL and reporting team by analyzing the data with adhoc queries.

Assisted the Bteq analysts in creating the source to target mapping document.

Served as an escalation point of contact/L4 support for data and application related support requests and supported the SSM team in every aspect of the project in achieving the desired results.

Coordinating with Project management and business team for the data issues found, through emails and meetings to discuss the data accuracy.

Worked on Creating and enhancing the business requirement documents and supporting the Mirostrategy team to achieve the required enhancements.

Extensively worked and fine-tuned the SQL scripts in all the projects.

Environment: MS SQL Server(SSIS/SSRS), Teradata, Tableau, Power BI, Unix shell scripting, Netezza, Pentaho, Business Objects, MS Visio and IBM Information Analyzer

Oct ‘04 – Jul’08 Data Analyst, Deloitte Consulting, India, Telangana, Hyderanad

Deloitte Analytic and Forensic Technology (AFT) assists clients and their legal counsel collect preserve and analyze large and disparate data to support or refute the facts and allegations of commercial investigations and complex litigation. I worked as a team member with internal and external clients in the database design and development, supported and built a few applications to generate utilization reports of each region and to track the time spent by employees for each engagement with respect to the WBS code. As a part of AFT, I worked extensively on development and enhancement of several forensic proprietary tools like DTect, FCPA and AML case management tools etc., which is a part of Deloitte AFT service line.

Responsibilities:

Worked on various DTect projects for various clients (Meijer, AT&T, Pfizer, Murphy Oil, Staples) who was involved in analyzing the data in different modules like employees, suppliers, employee expenses, accounts payable, accounts receivables, procurement cards and human resource data to identify the internal organizational frauds.

Played a key role in several corporate investigations and forensic audit assistance engagements, by Identifying loopholes and anomalies in the client financial data, suggested measures to improve internal regulations and data integrity.

Involved in development of the health care industry modules. Located the anomaly detection in healthcare data, in different modules like patients, providers, payers, and claims.

Created stage database using database script; written mapping scripts to map both stage and client databases.

Built and maintained test scripts, mapping scripts, FK build scripts for Oracle, SAP and generic systems under different test scenarios and made the necessary changes.

Uploaded/import raw data given in different formats (csv, txt, XLS) into SQL server 2000/2005 databases using DTS/SSIS.

Stored Procedures/tests are further refined per client suggestions and client customized tests are written for specific scenarios or risk areas.

Designed and developed complex reports in SQL server. Performed technical review on the results obtained.

Demonstrated great value-added service by performing the graphical analysis/charts of data using reporting tool which helps in identifying the hidden patterns by exporting in Excel.

Design the database schema and identified the right columns from tables in different ERP systems that will fit into the FCPA schema.

Enhanced the AML(anti money laundering) tool by adding more functionality to the form in VB.net

Prepared a roadmap and power point presentations with all of the major findings or anomalies found in the data.

Integrated existing user-developed access databases into the SQL server back-end and modified front-end screens.

Identified data issues and provided recommendations for resolutions to ensure optimal performances.

Designed and developed several utilization reports by observing the fiscal year with respect to its extension period and changes in charge code.

Controlled the access privileges to the application users by assigning roles and database access in the SQL server.

Thoroughly studied and analyzed different test scenarios in the health care industry.

Took an active part in guiding the team on coding these test scenarios and doing a quality check on these procedures.

Identified the required fields for each module and built the database in the SQL server 2000.

Added value by documenting the entire database development and work flow of the project.

Added additional features and functionality to the VB application, which is the front end tool.

Environment: MS SQL Server 2000 & 2005, DTS, SSIS, MS Visio, Visual Basic, MS access and MS Excel.

EDUCATION:

Master of Science in Information Systems from Osmania University College for women, Koti, Hyderabad, Telangana, India



Contact this candidate