Raviteja

Email: acvv1r@r.postjobfree.com

Database/Business Intelligence Developer

Database/Business Intelligence developer backed by solid credentials, strong technical and communication skills. Well - versed in structuring, developing and implementing interactive database techniques. Solutions -driven approach with commended performance in MS SQL Server and MS Business Intelligence. Well- versed in all phases of the software development life- cycle (SDLC).

PROFESSIONAL SUMMARY:

Around 3 years of experience in MS SQL Server Database Design, Development, Integration and Reporting services.

Experience in SQL Server Integration Services (SSIS) for ETL and providing Enterprise reporting solutions using SQL Server Reporting Services (SSRS), Data Transform Services (DTS).

Domain knowledge of SAS with comprehensive understanding and application of its procedures for SQL and access.

Working knowledge in Communications, Finance and Retail Sector.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Experienced in TSQL (DDL, DML), documenting, coding, programming, modifying and Implementing Business Intelligence solutions using SQL Server 2012/2008/2005.

Experience in Importing/Exporting Data from various Heterogeneous source like MS Access, Excel, Oracle, DB2 and Flat file using SSIS.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and Transformation services.

Well-versed in using database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at various stages of Migration/Cleansing process, Change Data Capture(CDC), Reports and Data Validation.

Proficient in creating and managing Clustered and Non-Clustered Indexes to improve database performance.

knowledge and experience on performance tuning, creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion, Pivot etc).

Configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS).

Experience in developing Drill through/Drill down reports, Cascading parameterized reports, Sub-reports and Log Reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.

Hands on Experience about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.

Expertise in developing Drill through/Drill down reports, Cascading parameterized reports, Linked, Charts and Sub-reports and Log Reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.

Scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using direct deployment and Uploading files using the Report Manger.

Automation of generated reports on Reporting services, which run on scheduled basis.

Knowledge of MDX Scripting to perform various tasks along with performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.

Assisted in employing Slowly Changing Dimension methodologies to maintain and update historical data in data warehouse.

TECHNICAL SKILLS:

Operating Systems

Win 2000/NT/2003/2008/2012 server.

RDBMS

MS SQL SERVER 2014/2012/2008, MS Access. Oracle 11g

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio, SQL Server 2005, Query Editor

ETL Tools

Data Transformation Services (DTS), MS SQL Server Integration

Services (SSIS),

Reporting Tools

MS SQL Server Reporting Services (SSRS), Tableau, Visual Basic 5.0, Crystal Reports

Data modeling

Enterprise Architecture, ER-Win 4.0, MS Visio 5.0.

BI Tools

MS SQL Business Intelligence, Power BI, Power Pivot

Scripting languages

Transact-SQL, Core Java, XHTML, ASP.NET, VBA(Excel)

PROFESSIONAL EXPERIENCE:

Client: Confidential April 2015 - Present

Role: Database Developer(SQL/MSBI) IRVING, TX

Description: This project deals with transferring the entire customer data of all the three states by gathering from repositories to client end. Data is validated based on Business units and transferred to client as several extracts periodically.

Responsibilities:

Participated in various phases of Software Development Life Cycle (SDLC) of the application.

Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008/2012.

Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Modified the existing stored procedures to get the new functionality depending on the client requirement.

Created many tables with the cluster and non-clustered indexes on columns.

Created various database objects such as tables, indexes and views based on the requirement.

Developed numerous reports in SQL Server Reporting Services which is of high priority considering the project goal. Parameterized, graph reports and dashboard Reports.

Built and Monitored Executive reports using SSRS for executive team to track progress.

Generated many ad-hoc reports for one time purpose according to the Business requirement.

Created sub reports in some reports like to get the summary from the detail report data.

Created Log Report which retrieves the access log of all reports deployed on Reporting server.

Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.

Created web pages using ASP.NET to embed the existing deployed reports on SSRS.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Worked on Power BI and prepared dashboard reports for internal team progress tracking.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Created packages in SQL Server Integration services which import the data from share point to reporting server database using connection strings.

Developed Complex Stored Procedures and Views in SQL Server 2012 and 2014 environment.

Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.

Scheduled the SSIS package services to run at different intervals to fetch the data

And transfer the data into other database.

Scheduled jobs using SQL Agent to run on regular intervals for updating the data in the server.

Involved in end to end migration from Source to destination and resolved any of the issues generated in the process of migration. The issues included data type mismatch, missing data type or missing delimiters.

Handled Audit process for validating the data which includes round the clock monitoring and interacting with several teams over bridge.

Hands on experience on share point front end.

Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.

Troubleshooting issues, Documentation of Issue and its resolution.

Involved in Query Optimization to increase the performance of the Report which were used in optimizing the company’s inventory based on actual usage.

Developed web pages for embedding deployed SSRS reports using ASP.NET

Deployed and maintained ASP.NET applications running at IIS 6.0.

Data Access layer is implemented using ADO.NET to Communicate with the SQL Server Database and to access, update the data in the database.

Created Entity Relationship (ER) diagrams based on requirements.

Environment: Windows Server 2008/2012, MS SQL Server 2012/2014, T-SQL, SSIS, SSRS, Tableau, HPQC,FILE ZILLA, MS OFFICE, TFS

Viswateja Spinning Mills Ltd, India

Role : Jr. Database Developer June 2012 - Dec 2013

Responsibilities:

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

Learned SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Creating Data entry Forms using VBA.

Extensively used embedded SQL in VBA front end.

Generating reports using linked reports, sub reports and filters in SQL server reporting services.

Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008.

Migration of DTS to SQL Server Integration Service (SSIS).

Designed data models and generated Entity-Relationship diagram (ERD) using Erwin

Generated DDL scripts for database schema and created all other database objects

Maintained database performance by normalization, indexing, collecting statistics, etc

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Assisted DB admin in maintaining SQL database user accounts, user logins, permissions, database and server roles

Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.

Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Environment: MS SQL Server 2008/R2, BIDS, SSIS, SSRS, T-SQL, Flat files, Windows XP, 2000, MS Excel VBA.

EDUCATION:

Masters of Sciences in Computer Science from University Of Southern Mississippi, Gulfport, Mississippi (GPA 3.67/4.0)

Bachelors in Computer Science and Engineering from Koneru Lakshmaiah College of Engineering (Autonomous, Affiliated to Acharya Nagarjuna University), Andhra Pradesh, India.

Contact this candidate