Sql Server Data

Tulasi Ram Sonthineni

SQL MSBI Developer

Professional Summary

Around 7+ Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).

Good Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2016/2014/2012/2008/2005/2000.

Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Having experience in System Architecture, Detail Design, Data Modeling, and Data Integration using SSIS and Data Publishing through BI tools such as SSRS.

Published Power BI reports from Power BI desktop to Power BI service.

Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.

Microsoft SQL Server DBA with good experience in MS SQLSERVER 2014 /2012 […] Database Administration in Production, Test and Development environment.

Excellent SQL and PL/SQL performance tuning skill

Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.

Involved in publishing of various kinds of live, interactive data visualizations dashboards, reports and workbooks from Tableau Desktop.

Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.

Created reports from complex SQL queries and MDX queries.

Experience with installing MYSQL on Linux systems

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development. Created data blending in case of merging two different datasets.

Enabling the Accounting Division to perform indexed lookups beyond the scope of standard Excel

functions by utilizing VBA to embed functions within Excel.

Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Developed and designed the dashboards with different types of charts in Qlikview.

Designed cube to analyze the claims based on the regions and come up with future premiums.

Involved in various projects related to Data Modeli006Eg, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Wrote stored procedures and UNIX scripts as a part of ETL Process.

Assessing the Agile/Scrum experience of the teams and larger organization then continuously coaching to expand their understanding of Agile/Scrum.

Worked with Data Marts using Snow Flake Schema and Star Schema for Dimensional Data Modeling to be incorporated with SSIS.

Proficient in OLTP, OLAP and Data Warehousing Design concepts.

Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX and DAX.

Developed and maintained enterprise wide web application and web services using VB.Net, ASP, and JavaScript.

Excellent understanding of installation, application deployment, monitoring and maintenance of Apache Webserver 2.2/2.4 and Tomcat 7.0/8.0on UNIX/Windows environments.

Developed UI Screens using ASP.NET with MVC in C#.

Effectively used ADO.Net Entity Framework (ORM) and LINQ concepts to perform database operations

Elaborated the Row Level Security (RLS) concept and implemented RLS to application business model.

Efficient in creating joins and sub-queries for complex queries involving multiple tables.

Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.

Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents.

Extracted and loaded data using Python scripts and PL/SQL packages

Used MySQL as backend database and MySQL db of python as database connector to interact with MySQL server. Involved in the requirement definition and analysis in support of Data Warehousing efforts.

Developed ETL mappings, Transformations and Loading using Data Stage 11.3.

Created data stage jobs to validate the data file with control file. Involved in Performance Tuning.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Development of Complex Crystal reports by using Oracle Stored Procedures, Command SQL.

Assisted in mining data from the SQL database that was used in several significant presentations.

Created database ddls and scripts and provided instructions to Oracle, Sybase and DB2 Database Administrators for their execution and implementation.

Experience in creating new reports and ad-hoc reporting in SSRS, Installed, configured and maintained SSRS server.

Involved in the SSAS partitions and calculation of queries with MDX, developing reports using MDX and T-SQL.

Created drill down, drill through, Cascading, Conditional, Table, Matrix, Chart, linked reports using MS SSRS as well as managed the subscription of the reports.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Configuring and troubleshooting Linked Servers.

Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.

Initiate Claims using multiple systems and tools

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Technical Skills

SQL Server Tools

SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, Python, Data Base Engine Tuning, Sybase, Advisor, Tableau, Perl, Shell Scripting, Qlikview, Teradata, Data Warehousing, Business Intelligence Development Studio, epic,tomcat, Power Bi,Informatica, SSIS, SSAS, SSRS, Data Transformation Services, COGNOS 10/8.4/8.3 BI,Scope.

RDBMS

SQL Server 2014/2012/2008/2005/2000, MS-Access. Oracle 9i/10g

Languages

C, C#, T-SQL, PL/SQL, JavaScript, Perl, Cosmos.

Web Technologies

HTML, XML, JavaScript, PHP, Shell Scripting.

Version Control

Team Foundation Server (TFS), Visual Source Safe (VSS), Clear Case.

Data Modeling

Erwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Operating System

Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7/8, Unix.

Methodologies

Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

Professional Experience

INTERNATIONAL SOS /Philadelphia/PA Aug’16-Present

MS SQL Server BI/Power BI /Developer

Responsibilities:

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

Import data from different data source to create Power BI reports and dashboards

Used SQL Azure extensively for database needs in various applications

Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.

Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers

Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues

Hands on experience of working with cloud databases like Azure and connecting to it via SSMS or SSIS.

Worked with Huge Databases in Teradata and Vertica and Azure environment.

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

Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes.

Supported developers and end users with issues connecting and import data through various (ex. Dynamics CRM, QuickBooks, SSAS Tabular and MDX, SQL Server, Access, etc.) data sources through Power BI Desktop and Power BI Online.

Worked on SQL queries to retrieve data from SQL Server 2014/2016 Database

Responsible for creating batches & scripts for implementing logical design to T-SQL.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server statements from developers and testers.

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

Used SSIS to create ETL packages.

Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.

Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server statements from developers and testers.

Responsible for developing SSIS Packages to move data from ERP and CRM systems like Sales Force into BI warehouse and managing job scheduling for them

Experience with Integrated Salesforce CRM Environments with Veeva Vault PromoMats

Worked with External objects in salesforce which is another feature introduced with lightening components for creating Power BI Dashboards

Create reports in Power BI Desktop and Service utilizing the connectors and content pack

Expertise in creating different organization content pack, and service packs

Expertise in creating reports from importing, Direct Query and Live data from several data sources

Expertise in data transformations such as added calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.

Expertise in creating DAX queries

Used SQL Azure extensively for database needs in various applications.

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Created different reports in Power BI Desktop and publish to Power BI online

Expertise in scheduling refresh and troubleshooting refresh issues

Expertise in installing, maintaining and troubleshooting the Personal and On-Premise Gateway

Expertise in maintaining and troubleshooting the different data sources

Expertise in creating different dashboards and reports

Supported customers with different refresh issues in the Power BI online service.

Supported end users with connecting and importing data from multiple content packs in Power BIOnline.

Expertise in creating Power BI Embedded Reports

Improved application performance using Azure Search and SQL query optimization

Used Azure OMS & Power BI for visualizing the activities.

Created different visualization in Power BI according to the requirements.

Created Power BI Dashboards to show Rig plants sales numbers.

Made Power BI Dashboards available in Web clients and mobile apps.

Created Share Point solution to host Power BI Monitoring dashboards to indicate job success\failures

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Develop data visualization reports and build dashboards using Microsoft Power BI.

Implement the best design patterns in data migration to adapt for future changes.

Environment: SQL Server 2014/2016 Enterprise Edition, T-SQL, Visual Studio, SQL Server Management Studio (SSMS), T-SQL, SSIS, SSRS, SSAS, Visual basic, SQL Server Agent, Power BI, Power Query, Power Pivot, ASP, MS Excel, MS Access, Visual Studio .SQL Azure, MS office 2013, Sales force Objects, SSMA.

HYLA mobile Irving/ TX Jul’ 15- jul’16

MS SQL/Power BI/ Developer

Responsibilities:

Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.

Managed upgradation of DTS packages to SSIS packages and filling Dimension and Fact tables into Data Warehouse and Data Marts

Created and managed relationships between tables in Power BI in order to calculate accurate results

Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.

Created Power BI Dashboards on Cloud connecting to Sales force data to be able to drive dash board reporting.

Created Power BI Visualizations and Dashboards as per the requirements.

Published Power BI Desktop reports created in Report view to the Power BI service.

Worked on Power View and Power Map to visualize reports.

Created packages using SSIS for data extra Responsible to design, develop and test the software (Informatica, PL/SQL,) to maintain the data marts (Extract data, Transform data, Load data).

Installation and configuration of SQL Server 2012 and Power BI Tools.

Created different visualization in Power BI according to the requirements.

Created Power BI Dashboards to show Rig plants sales numbers.

Made Power BI Dashboards available in Web clients and mobile apps.

Created Share Point solution to host Power BI Monitoring dashboards to indicate job success\failures

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Develop data visualization reports and build dashboards using Microsoft Power BI.

Worked on Excel 2010, Power Pivot for providing ad-hoc reporting.

Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQLdb package

Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.

Extensively used Joins and CTE’s for complex queries involving multiple tables from different databases.

Worked with Exception handling with error and with Try/catch.

Worked with team of developers on Python applications for RISK management.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.

Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Configuration, Management, Troubleshooting Log Shipping, Mirroring, Replication for Sybase as well as SQL Server.

Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.

Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.

Creating SSIS package to load data from Flat file to data warehouse databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Pivot Transformation.

Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update

Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.

Using RLS, Row level Security (RLS) giving access to store data for different customers

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Used puppet for central management of Linux configuration files and software package management

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Analyzed the Business data and defined the Match and Merge rules and helped business to develop Trust Scores for MDM Hub.

Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data

Involved in the requirement definition and analysis in support of Data Warehousing efforts.

Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems by adding or enhancing relevant entities/ tables, columns etc.

Enhancing performance of SSIS packages and SQL queries using optimization techniques.

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

Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server. .

Documentation for all kinds of reports and SSIS packages.

Developed many MDX and DAX queries for creating calculated measures that fits business logic.

Designed SSIS packages to load from flat files, excel documents and CVS files in SQL 2012 and 2014.

Used Star Schema and Snow Flake schema in creation of Dimension Modeling and used in Data Marts with SSIS background.

Created ETL packages in SSIS using various control flow and data flow functions.

Created Charts and Dashboards in Microsoft excel, using tabular model as an input to the excel file. Reports are produced weekly and monthly as well.

Involved in Performance tuning of ETL transformations, data validations and stored procedures.

Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).

Transformed and combined the data using Query Editor in the Power BI.

Environment: Microsoft SQL Server 2012, Visual Studio 2013, T-SQL, Informatica,SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS),Tableau Server 8.2, Power Pivot, Unix, Shell Script, MDX, DAX, MDM,SQL Server Reporting Services (SSRS),Teradata, Data Warehousing, python,Crystal BI,DB2,Power BI, SQL server profiler, Team Foundation Server.

BCBS Richardson TX Jan 14 -Jun 15

MS SQL Developer

Responsibilities:

Involved in Data Analysis and Migration of Data.

Involved in complete Software Development Cycle (SDLC).

Created SSIS packages to load data into SQL Server using various transformations in SSIS.

Capture business objectives and processes and design and develop a comprehensive application and solution.

Developed a web application using in .Net 4.0/3.5/2.0 framework using Visual Studio .Net 2013/2010/2008/2005 and SQL Server 2012/2008.

Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.

Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Developed UI Screens in ASP.NET with MVC with C#.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.

Experience in tableau created Rapid Analytics and Reporting.

Experience with Tableau for Data Acquisition and data visualizations for client and customers.

Migration of the data from one environment to other environment. Testing and analysis of the migrated data.

Involved in Development of custom web forms using the rich UI support from ASP .NET 4.0, AJAX, J Query, Java Script and CSS.

Worked intensively on Data staging (EDS) from Heterogeneous Data Sources like SAP, Salesforce, SharePoint, Informatica, CCE and performing the ETL work and loading it to the Data Warehouse(EDW)/Data Marts and make the data available for reporting (EDR)/Analysis Services.

Worked with distributed teams using agile values and principles to manage projects

Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.

Identify and replace manual processes and exchange of data with an Automated System.

Implement the best design patterns in data migration to adapt for future changes.

Review several test plans and test scenarios with the QC team for each project worked on.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Experience in BI interactive Dashboards and Tableau Publisher.

Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the

Extensive development experience utilizing TSQL for creating database objects (UDF, Tables, Stored Procedure, T-SQL codes, System functions, and views )

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.

Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.

LUV v9.7 and Fixpacks on UNIX and

Tuning and optimization of SQL/Teradata Queries, Change request management. Windows machines.

Install and configure DB2 UDB new releases, upgrades, and patches.

Created database ddls and scripts and provided instructions to Oracle, Sybase and DB2 Database Administrators for their execution and implementation.

Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.

Involved in developing Multi-Dimensional Cubes in Business Intelligence Development Studio using SSAS.

Involved in Tabular Data warehouse using SSAS 2012 OLAP databases.

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

Developed Perl and Shell scripts for upload of data feed into database

Created and maintained triggers and stored procedures in TSQL

Defined Calculated members, named sets, and executed other script commands using MDX expressions.

Environment: Microsoft SQL Server 2012/2008/2005, MS Access, Teradata, SSAS,SSIS, SSRS, Visual Studio 2005/2008/2010, Query Analyzer, ERWIN,Epic,Cognos8.4,10.22,Cognos BI, .Net (Asp .Net,VB.net C# .Net), Cognos Configuration Windows server 2008R2,Tableau Server 8, Tableau Desktop, Python2.7, TSQL,IBM Cognos,.Net, SQL Profiler, Team Foundation Server, CISCO Any Connect.

Caliber Holmes /Irving TX Sep’12 – Dec’13

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

Involved in installation and configuration of SQL Server 2008 R2 with latest Service Packs.

Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008 R2.

Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.

Involved in scheduling Report Studio and Query Studio reports in Cognos Connection.

Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.

Developed good understanding of member enrollment, eligibility, premium, providers, data submission requirements, professional claims.

Worked on Enrollment and Billing Module through both 834 EDI transactions as well as Facets Online/enrolling members in Facets from Facets front end screens, web portal application and EDI834 transactions.

Understanding the OLAP processing for changing and maintaining the data warehouse.

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.

Analyze and Assess invalid and missing data in the All Payer Claims Data

Experience in writing VB scripts in script component task.

Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.

Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.

Scheduled Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008 R2.

Designed different kinds of reports like Tabular Reports, Cross Tab Reports, Sub Reports, Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.

Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

Performed performance tuning by studying Execution Plan, Analyzing Indexes.

Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.

Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 R2 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).

Designed, developed and implemented the Dimension Data Model through multiple expert interviews for multiple fact tables.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: MS SQL Server 2008 R2,SQL Server Management Studio (SSMS) 2008 R2,SSIS 2008 R2, SSAS, HTML, OLAP, OLTP, SSRS 2008 R2, SQL Server Profiler, Visual studio 2008 R2, SQL Analyzer, Enterprise Manager and SQL Server Agent.

TCF Bank, Minneapolis, MN Mar’11 –Aug’12

MS SQL/DBA Developer

Responsibilities:

Involved in bringing 2005 SQL database environment to SQL 2008 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.

Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.

Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.

Extensively worked on Joins, Sub-Queries, Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.

Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.

Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.

Defined Check constraints, Business Rules, Indexes, and Views.

Worked with Exception handling with @@error and with Try/catch.

Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.

Deployed SSIS packages and Scheduled Jobs.

Involved in Analyzing and integrating the data.

• Generated data extracts in Tableau by connecting to the view using Tableau MS SQL connector.

Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.

Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).

Developed Incremental Load using Lookup in SSDT visual studio.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database.

Designed and deployed reports with Drill Down, Drill Through and drop down menu option and parameterized and Linked reports. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Mapped data between external databases and Crystal Reports.

Environment: SQL Server 2008/2005, Reporting Services (SSRS), Integration Services (SSIS), BCP, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Tableau, Index Analyzer, DTS, MS SQL SERVER, T-SQL, Windows 95/NT/2000/2003, XML, UNIX Shell Scripts MS Excel and MS Access, Team Foundation Server, Crystal Reports, TOAD, visual studio 2008.

ICICI Bank, Hyderabad, India Sep’09 - Feb’11

MS SQL/SSIS/SSRS Developer

Responsibilities:

Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.

Worked closely with end users in designing and creating the Global Enterprise Data warehouse.

Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.

High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.

Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that

Contact this candidate