RAMYA VALLURIPALLI

Email: adh2z6@r.postjobfree.com

Cell: 203-***-****

Location: Farmington, Michigan, 48335

PROFESSIONAL SUMMARY

Extensive 4+ years of experience in SQL/BI Development includes Business Intelligence applications design, development, and maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS) and Enterprise Data Warehouse.

Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on SSIS/DTS, Data Cleansing and Data Migration.

Experience in design, development, coding and testing of business applications using MS SQL Server 2014/2012/2008.

Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS the data into the Enterprise Data warehouse from Heterogeneous sources such as Oracle, Excel, and Flat files.

Develop scripts to automate the execution of ETL using shell scripts under Unix environment

Experience in migrating Crystal Reports 8.5 to SQL Server Reporting Services/Power BI

High-skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012/2008 R2/2008 and Power BI.

Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

Highly experienced in database server performance tuning and optimization of Complex SQL queries.

Highly proficient in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, and data integrity, SQL joins and query writing.

Experience in creating Packages, scheduling Jobs, and sending Alerts using SQL Mail.

Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good team player with excellent teamwork skills.

TECHNICAL SKILLS

Databases

MS SQL SERVER 2012/2014/2016, MS Access 2013/2010

Database Tools

T-SQL, Query Analyzer, BCP, SQL

Agent, SQL Trace, Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Server Integration Services(SSIS), SQL reporting Services(SSRS), SQL Analysis Services(SSAS),TFS.

Web Servers

IIS 6, Windows/UNIX Environment, TFS, SLA’s

Languages

T-SQL, VB.NET, ASP.NET, Visual Basic 6.0, C, C++

Certifications:

MCSA Querying Microsoft SQL Server 2012(70-461).

MCSA Implementing a data warehouse using Microsoft SQL Server 2012(70-463).

MCID: 13497359

Education:

Bachelor’s Degree in Computer Science Engineering, JNTU, Hyderabad, India (2010 - 2014)

Master’s Degree in Information Technology, Lawrence Technological University, Southfield, Michigan, USA (2015 - 2014)

PROFESSIONAL EXPERIENCE

Responsibilities:

Livingston International – Civic center Dr, MI

SQL/SSIS/SSRS Developer (September 2018 – June 2020)

Responsibilities:

Analyze, design, develop, and document the application software for the Classification Project.

Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Implementing SSIS packages related to the extraction, transformation and loading ETL process for database applications, in accordance with established standards.

Applying in-depth understanding of business and IT requirements to streamline administration and internal processes, resulting in enhanced automation and operational efficiency.

Creating T-SQL queries, complex stored procedures, and functions to perform database tasks such as inserts, updates, and deletes and performance tuning Views.

Validating and Looping through various file sources and loading dynamically into the database using SSIS tasks like Script Task, For Each Loop Container, For Loop Container,

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed, and built SSRS reports and dashboard reports in Power BI, supported more than 10 client companies' general business reports and benefit plan administration processes.

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS/Power BI.

Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, billing report and other insurance/payroll reports by using SSRS and SQL Server 2008/2012.

Documentation of proposed new batch jobs, programs, database table designs and /or reports.

Developed browser-based management system, allowing various documents to be placed in Windows Explorer interface folders.

Developed reports like Cross tab reports, Summary Reports, Sub Reports, Drill Down Reports, Drill Thru reports using Power BI/SSRS

Worked on end-to-end testing of applications and migrated code to production environment.

Performed Root Cause Analysis, Troubleshooting and resolved production issues.

Performed UAT (User Acceptance testing) and performed data validation for end user reports.

Published reports to Microsoft SharePoint for the review by executive team.

Documentation of proposed new batch jobs, programs, database table designs and /or reports.

Great Expressions Dental center – Southfield, MI

SQL Developer/HRIS Analyst (Aug 2017 – September 2018)

Responsibilities:

Strong understanding of HRIS database design, structure, and processes.

Strong writing skills to translate system requirements into easy to use training documents

Created SSIS packages to extract data from different files according to the Business User Requirements.

Designed SSIS Packages to transfer data from various sources like Flat files, XML files.

Wrote T-SQL queries, Stored Procedures and used them to create Reports using SSRS and Report Builder.

Involved in process improvements and proposes innovative solutions or alternative methods to meet data and reporting requirements within the department.

Assisted in the review, testing and implementation of HRIS system upgrades or patches, and performs scheduled activities to keep system running proficiently.

Extracted data from Database by writing SQL Queries according to the given requirement

Wrote SQL Stored Procedures to maintain and supports a variety of reports or queries utilizing appropriate reporting tools.

Worked on Kronos Data according to the requirement and created reports by writing Stored Procedures.

Optimizing and Performance Tuning SQL Scripts to make reports run smoothly and efficiently. Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.

Developed parameterized reports which were used for making current and future business decisions.

Advise proper SSRS standards and created documentation on standard set forth for report formatting.

Assisted in development of standardize reports for ongoing customer needs

Maintains data integrity in systems by running queries and analyzing data and coordinating appropriate training as needed

Develops user procedures, guidelines and documentation

Wrote VBScript to get the required data in Excel.

Also involved in creating Forms using VBScript.

Environment: SQL Server 2012/2014, SSIS, SSRS, VBScript, XML, MS SharePoint 2013

American IT Solutions – Farmington, MI

SQL Developer/Data Analyst (Feb 2017 – Aug 2017)

Responsibilities:

Worked on Claims Data Migration and Claims Reporting Project.

Designed SSIS Packages to transfer data from various sources like Flat files, XML files, and Excel to SQL Server using Business Intelligence Development Studio.

Wrote T-SQL queries, Stored Procedures and used them to build packages.

Designed, Developed and Deployed packages in SQL server environment using SSIS.

Involved in tuning and configuration of SSIS.

Deployed SSIS packages from Development to Testing Servers

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Worked on QA testing by writing scripts for source and target data to verify the integrity of the data.

Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.

Developed reports like Claims paid, claims unpaid, Claims in-pending and overpaid.

Worked with Claims Audit department and generated reports for end users

Developed reports like Cross tab reports, Summary Reports, Sub Reports, Drill Down Reports, Drill Thru reports using SSRS

Published reports to Microsoft SharePoint for the review by executive team.

Environment: SQL Server 2012/2014, SSIS, SSAS, SSRS, VBScript, XML, MS SharePoint 2013

Amazon, Hyderabad, India

SQL Developer (Jan 2014 – Dec 2014)

Responsibilities:

Created database and database objects like tables, stored procedures, views, triggers, user defined data types and functions.

ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Created complex SSIS packages using proper control and data flow elements.

Enhanced and deployed the SSIS Packages from development server to production server.

Used SSRS creating well-formed reports and web-based reports for financial applications and transactions.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Configured the report server and generated the report models for user interactions.

Involved in the tuning of the existing Database Objects.

Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, MS SharePoint 2010

Contact this candidate