Revathi Damodararaju

Phone No: 630-***-****

Email: adbpvr@r.postjobfree.com

Motivated individual with 6+ years of IT experience as an MS SQL Server Developer and Business Intelligence with main focus on PL-SQL, T-SQL, SSIS, SSRS, Tableau and Power BI. Good experience as a database developer in IT, Healthcare, Retail and Manufacturing sectors.

PROFESSIONAL SUMMARY

●Excellent programming experience as Database & Report Developer in Microsoft SQL Server 2012 and higher versions using T-SQL and Business Intelligence Data Tools and various platforms.

●Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints (Primary Key, Foreign Key), Index.

●Good knowledge in Software Development Life Cycle (SDLC) and Agile Methodologies that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.

●Worked on Tableau 10.2 and higher versions and developed cross tabs, line charts, graphs, YOY comparisons and developed maps. Create an executive dashboard to tell a story on the business and complete insight

●Used Tableau to create technical solutions to business needs by translating their requirements and finding innovative resolutions. Using Tableau applications created multiple dashboards and stories to provide overall insights for business needs.

●Using Tableau, design and develop dashboards and other solutions involving data

●Worked on Power bi and created Dashboards and create multiple pictorial representation of data for end users and given presentation in meetings

●Used Minitab to create laney p chart for Control limit, UCL, LCL

●Good knowledge in Data Warehousing methodologies, dimension modeling and ETL Process.

●Worked with Star/ SnowFlake Schema architecture and developed efficient database with high performance.

●Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from SQL Server, Flat file and other sources and loaded into MSSQL.

●Experience in designing and building cubes using SSAS and worked on DAX query and created partition in cube.

●Developed reports on SSRS on SQL Server (2008 and higher versions).

●Used SSRS and created Table Report, Adding calculated Values, Adding Subreport to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.

●Developed Finance report providing an insight on overall business.

●Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

●Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.

●Experience in Performance Tuning and Query Optimization.

●As part of ETL I have implemented audits for end to end counts of data. And triggered email from SSIS Job

●Converted projects from Visual source safe to TFS.

●Worked closely with my team for any business analysis and provided solutions for best results.

●Have used TFS 2010 to support agile development practices to produce quality software.

CERTIFICATION

●Microsoft certified professional in Querying Microsoft SQL Server 2012

●Microsoft certified professional in Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

EDUCATION

Bachelor of Technology in Information Technology,

BSA Crescent Engineering College, Anna University, India May 2005-May 2009

Masters of Technology In Computer Science,

VIT University, India May 2010-May 2012

LINKEDIN

https://www.linkedin.com/in/revathi-damodararaju-4653208a

TECHNICAL SKILLS

Databases

Microsoft SQL Server 2008/2012/2014/2016, Oracle 11i/10g/9i, MS- Access.

Performance Tools

SQL Server Profiler, Database performance tuning monitor

Operating Systems

Windows 10,7

Tools

SSMS, SQL Server Data Tools, Microsoft Integration Services (SSIS), SSRS, Database performance monitor, SQL Server Profiler, TFS, ATTask, JIRA, Tableau Online, Tableau server and Tableau Desktop, Power BI, Python

Reporting Tools

SQL Server Reporting Services (SSRS), ORACLE

Report Builder, ORACLE Forms Developer, Tableau, Power BI, Minitab

PROFESSIONAL EXPERIENCE

Client: Corning Inc Sep 30, 2019 - Present

Position: Sr. Software Engineer (SQL, SSIS, SSRS, SSAS, Power BI)

Location: Charlotte, NC, USA

Corning Incorporated is an American multinational technology company that specializes in specialty glass, ceramics, and related materials. I have worked in the IT sector of optical communication.

Responsibilities:

●Experience developing DWH, and business intelligence solutions using SDLC process

●Work with relational databases in Microsoft SQL Server and Oracle.

●Experience with development in Microsoft BI tools (SSRS, SSAS, SSIS, SQL Server)

●Work on Manufacturing industry standards and understand the data and develop end user facing reports using Power BI and SSRS

●Worked on Sharepoint list to DW using SSIS

●Created Power bi reports and provided presentation in team meetings

●Worked on cube and provided support

●Collaborate with multiple teams across multiple regions.

●Process oriented and customer focused.

●Very good problem solving skills and ability to work independently

Employer and Client: Inte Q Mar 2014 – Sep 2019

Position: Sr. Business Intelligence Developer (SQL Server, SSIS, SSRS, Tableau)

Location: Oakbrook Terrace, IL, USA

Company Link : https://inteqinsights.com/

Inte q specializes to gather customer behavior and demographic data and provide valuable analytical insights. This drives our program to initiate greater customer engagement and profitability. Provide a total Loyalty solution which helps to send out campaigns and rewards to increase the total sales and customer engagement. We have worked on the solution for 13+ clients

Responsibilities:

●Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

●Worked on database like sql server and Oracle 10g, 9i

●Self learned Tableau and higher from various forums and developed efficient dashboards and data visualization.

●Creating Interactive Dashboards by using Actions, Quick filters and Parameters using tableau

● Excellent programming experience as Database & Report Developer in Microsoft SQL Server 2008/2012/2016 using T-SQL and Business Intelligence Data Tools and various platforms.

●Worked on Big data technology

●Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from multiple data sources and load into MSSQL.

●Used SSRS and created Table Report, Adding calculated Values, Adding Subreport to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.

●Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

●Analyze and understand the requirements from JIRA User stories and Agile methodology.

●Done code reviews and also Technical Documentation.

●Did performance tuning and maintained the existing reports. Reduced the execution time drastically and educated team members with new features

●Created subscription on many reports and automated using SSIS with acknowledgment. Have done many cool projects for my company in SSIS and performed data modelling using ERWIN.

●Strong work ethic and always delivered solutions on a tight schedule. Ability to work with team and also work independently.

●Worked on digital marketing tools like Cheetah Set up, Synthesio

●Worked on API and used JSON code to bring data to Data warehouse.

●Created multiple reports and worked on email and data driven subscriptions.

●Worked on Tableau Dashboards to generate the insights of Customer and sales and how the performance is increased. Created dashboards for 13clients and maintained the extracts in tableau server and tableau online.

●Got input from Managers and provided efficient results

Client: Briggs Healthcare Corp Oct 2013 – Feb 2014

Position: SQL Server Report Developer - Contractor

Location: West Des Moines, Iowa

Briggs Healthcare focuses on healthcare providers for more than 60 years as a retail industry. It's headquarters is located in West Des Moines, Iowa. It has a warehouse in many states from where the medical products are supplied. It has many customers like Amazon, Walmart, Walgreens, Target, Qvc, BJ, Overstock and many more. My role is in information technology to handle database, reports, .net and three major servers.

Responsibilities:

●Worked with SQL Server 2008 R2 and created multiple Stored procedures, views, tables, Functions and other SQL joins

●Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development

●Worked with databases like SQL Server 2005/2008/2012, Oracle 10g/ 9i, Ms Access

●I handled three main production servers that run the daily job that updated many tables.

●Used AT Task for project task and new project request

●Created and modified various Stored Procedures used in the application using T-SQL.

●Worked with TFS source control tool for reports and .net applications

●Interacted directly with the end client to find the requirements and developed multiple SSRS Reports.

●Created, implemented and maintained standard reports while also customizing many reports to meet individual client needs.

●Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

●Created jobs on a daily basis and schedule job to update recent data by using SQL Server Agent jobs.

●Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).

●Scheduled execution and delivery of the end of the day report using SSRS.

●Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

●Worked on Microsoft visual studio 2010 .net C# applications. Cleared multiple errors in the applications that are used daily.

Employer: Bharat Heavy Electronics Limited (BHEL), India

Position: IT Internship (6 months)

BHEL is an integrated power plant equipment manufacturer and one of the largest engineering and manufacturing companies in India in terms of turnover. I got an opportunity to work in the Information Centre wherein the entire database was maintained. My duty was to analyse the requirement and create table and integrate with the forms, create stored procedures and run the report.

Responsibilities:

●Took part in the preparation of Project plan, user acceptance testing. Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality.

●Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression (CTE) and indexing.

●Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.

●Analysed and designed UML model using Rational Rose to reflect existing business models.

●Designed star schemas using dimensional modelling and created fact tables and dimensional tables.

●Create Tables, Views, Common Table Expression, Stored Procedures, Functions, Grouping and Queries using Joins, Sub Queries

●Got the opportunity to learn and work with SSIS and created complex tables.

●Used SQL Reporting Services (SSRS) and Created many reports and maintained them.

●Knowledge on administering the Reporting Services server, how to maintain the Reporting Services databases.

●Have done SQL Performance tuning on stored procedures and Reports and used certain techniques like Join Hints, Clustered Index and improved the performance of queries and reports.

●Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL Reporting Services.

●Implemented various reports for the migration to SSRS.

●Involved in post deployment and maintenance of reports.

●Performed Unit, System Testing and created several Test Cases to validate the data from reports.

INTERNATIONAL PAPER PUBLICATIONS

1.D. Revathi, K. Manikandan, “Framework for Congestion Control with Efficient Energy and QoS Enhancement for Wireless Network”, International Journal of Computer Applications, Volume 42 - Number 14, 2012 by IJCA Journal.

2.D.Revathi “Optimized Layered Approach on Congestion Control with Efficient Energy and QOS Improvement for Wireless Network”, International Conference on Recent Trends in Computer Science and Engineering (ICRTCSE 2012), 3rd & 4th May 2012, ISBN ***-**-****-807.

Training

●Snowflake data tool training, in importing data, analysis and connecting to Tableau

●I have completed the Oracle 10g Programming in SQL as part of Oracle Workforce Development program in the year 2010.

●I have completed the Oracle 10g Programming in PL/SQL as part of Oracle Workforce Development program in the year 2012.

●I have participated in the workshop on NETWORK AND SOFTWARE SECURITY which was organised by the team of McAfee software solutions.

●I have got the appreciation certificate for presenting my paper in International Conference on Recent Trends in Computer Science and Engineering (ICRTCSE 2012)

Contact this candidate