Prateep Rayapu Reddy Oruganti

Sr. SQL Server BI Developer

Email: acutcu@r.postjobfree.com

Phone: 786-***-****

SUMMARY:

Over 7+ years of IT experience with database development experience, Business Intelligence and have Software Development experience.

Expert in working with huge volume of data and performance analysis.

Strong expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration Service.

Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.

Expert in writing T-SQL, working on DTS, SSIS, SSRS, and Data Migration projects.

Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.

Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.

Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages. Experience in crystal reports.

Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.

Expertise in generating report using Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet, scheduling and deploying reports on report manager.

Expertise in publish reports in front-end using web viewer.

Experience in Data Modeling skills using MS VISIO and ERWIN.

Expert on SDLC project. Start from gathering requirement and put in tech spec to deploy.

Education:

Bachelor of Engineering, Osmania University, HYD, India.

Certification:

Microsoft Certified Professional Developer: Enterprise Applications Developer (.Net 2.0)

On site Experience:

Worked with Thomson UK & I client for 6 months duration in Luton, United Kingdom

TECHNICAL SKILLS:

RDBMS/DBMS:

Microsoft -SQL Server 2012/2008/2005, Oracle 10 /11g, MS Access.

BI /Data model Tools

Microsoft SQL Server Reporting Services 2012/20008/2005, Crystal Reports, DTS,SSIS, Erwin And Visio. Visual Studio 2013/2015,OBIEE, Tableau

Operating Systems:

Windows 7/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages:

T-SQL, Visual Basic 6.0, SQL * Plus, PL/SQL

Application Packages:

MS Office, MS Outlook. Power Query, Power Pivot,

Database Tools:

SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server(TFS) Proficient, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE

Ohio Department of Jobs and Family Services, OH Dec 2014- Current

SQL BI/DW Developer

The IAM system provides consistency to the security of Thomson systems through daily creating new users of employees in areas such as AD access, identifying changes to user access needs, managing user access to Thomson applications, and providing user password management. The Courion Access Assurance solution has been implemented Macys into as a central system for managing digital identities and system access for all Macy’s systems such as Account Management, Password Management, and Role Management

Responsibilities

Provides operational and administrative support for the creation, modification and deletion of access enterprise roles and Solution of workflows.

Support day to day operational tasks within the Access Management System.

Working on Remedy tickets.

Support for any configuration changes within the solution.

Highlight any requests that would involve considerable change / effort and would require additional or specialist resource or invoke a major release.

Participate in review activity; provide estimates on effort required for new application on-boarding to IAM projects.

Support for database related trouble shoot requests.

Provides administrative support for SSIS Packages modification.

Monitoring SSIS packages of SQL Agent Jobs success / failure history.

Manage any failures in provisioning requests to completion.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Normalized and De-normalized entities for the Data Warehouse.

Work on performance tuning on existing SSIS packages.

Recognized the fact and dimension tables from the OLAP database.

Work on creating various such as Tableau, dashboard reports.

Create and deliver daily ad-hoc report.

Created linked reports, sub reports as well as drill-through reports in support of management.

Closely work with the client to gather business requirements.

Design, coding, testing, debugging and documentation of applications.

Managed and coordinate with remote user for change request and optimization of application.

Scheduled jobs, alerts and designed and implemented user log in and security.

Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.

Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.

Actively participated in the meetings.

Tested SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.

Developed approaches for data warehouse implementation and data acquisition.

Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.

Efficiently completed maintenance task like checking database integrity, history cleanup, Maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) SVN (Sub-version), Visual Studio 2012, ASP.Net 2.0, OBIEE, PL/SQL, Tableau Server v8/v7

JP Morgan Chase & Co, Texas Jan 2013 –Dec 2014

SQL System Analyst/ BI Developer

WPP is the world's largest communications services group employing 162,000 people working in 3,000 offices in 110 countries. WPP clients have access to companies with all the necessary marketing and communications skills. The Group comprises leading companies in all these disciplines like Advertising, Media Investment Management and Consumer Insight.

Responsibilities

Developed, created and managed complex stored procedures and UDF in SQL Server 2008 R

Create SSIS packages for new clients.

Design and develop Integration Services solution in MS Business Intelligence Development Studio (BIDS).

Create, fixed and maintained daily, monthly jobs scheduled.

Create SSAS cubes with multiple dimension hierarchies.

Optimized ETL packages by increasing the memory buffer size.

Migrate from SQL Server 2008 R2 to 2012.

Created dimensions and fact tables based on the business requirement.

Designed complex ETL strategies to pull data from different sources, like SQL server,flat files and load it to the destination database after using multiple transformations

Implemented the Master Child Package Model for easier maintenance and better performance

Created ad- hoc and drill-through reports.

Create Tableau reports.

Created linked reports, sub reports as well as click through reports in support of management.

Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code to implement business rules.

Developed approaches for data warehouse implementation and data acquisition.

Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.

Efficiently completed maintenance task like checking database integrity, history cleanup, Maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: MS SQL Server 2008/2008 R2, MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008(SSRS) TFS 2012.PL/SQL

Nationwide, Ohio Oct 2012 – Jan 2013

SSIS/Data Warehouse Developer

Responsibilities

Design and develop Integration Services solution in MS Business Intelligence Development Studio (BIDS).

Responsible for running, maintaining, trouble-shooting daily production jobs.

Create dashboard reports.

Studied the data requirements and the impact analysis on the existing schema.

Responsible for creating ad-hoc reports after jobs successfully completed.

Create MDX cubes from scratch.

Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS with pro clarity 6.3.

Normalized and De-normalized entities for the Data Warehouse.

Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Scheduled jobs, alerts and designed and implemented user log in and security.

Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.

Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.

Actively participated in the meetings.

Actively participated in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Create Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Create of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.

Also work on production issue tickets.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008(SSRS). Visual Studio 2012, PL/SQL

Cleveland Clinic, Cleveland, OH Oct 2011 – Oct 2012

SQL/ BI Developer

Responsibilities

Analyzed the business requirement and functional specifications provided by the data analyst.

Create various reports (ad-hoc, Tableau, drill-through, crystal).

Used MS SSIS as the main ETL tool

Developed, created and managed complex stored procedures and UDF in SQL Server 2008

to support the functionality various front-end applications and performing different data

Operations like data profiling and data verification.

Created various database objects like Indexes, Views, Triggers and User-defined functions depending upon business rules and optimized them.

Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code

Created dimensions and fact tables based on the business requirement.

Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations

Implemented the Master Child Package Model for easier maintenance and better performance

Optimized ETL packages by increasing the memory buffer size and by increasing the Max Concurrent Executable.

Implemented Attribute Relationships and Hierarchies to design more aggregations in order to improve summarization performance of queries.

Created ad hoc crystal and SSRS reports in the test environment for data validation

Created dynamic Reports from the cube using SSRS 2008, and stored procedures.

Created linked reports, sub reports as well as click through reports in support of management.

Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.

Efficiently completed maintenance task like checking database integrity, history cleanup, maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: SQL Server 2008/2008 R2, SSRS, SSAS, SSIS, Windows 2003 Server / Vista Enterprise, MS Visual Studio 2005, Erwin

Sonata Software’s Ltd, Hyderabad Dec 2010 – Oct 2011

MS SQL Developer

Responsibilities:

Implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.

Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.

Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse/OltpDB

Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.

Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.

Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.

Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2005, MS BIDS, T-SQL, SSRS.

Arctern Consulting Ltd, Bangalore Nov 2008 – Dec 2010

SQL BI Developer

Responsibilities:

Responsible for campaign load and create member eligibility.

Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.

Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Managed and coordinate with remote user for change request and optimization of application.

Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.

Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.

Actively participated in the meetings.

Documented all work so that the user can easily understand the flow of the process.

Work in offshore team from 2006 to 2010

Environment: MS SQL Server 2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008(SSRS).

Contact this candidate