SUMMARY

• Experience in generating on - demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services Exposure to all phases of Software Development Life Cycle SDLC with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services SSRS .
• Experience in providing SSRS server level, item level security accessibility to various reports in multi-user environment.
• Managed report by using SSRS tools such as report management, report delivery and report security.
• Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.
• Used MDX script to create dimensional cubes and query data.
• Built the data cubes by implementing SQL Server OLAP services in SSAS.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Extensive experience in Tuning SQL queries improving the performance of the Database.
• Strong debugging skills and the ability to solve complex problems.
• Involved in designing T-SQL programming artifacts such as complex queries, stored procedures, triggers DDL and DML, indexes, and user-defined functions.
• Involved in creating numerous database objects like tables, indexes, constrain Checks, Primary and Foreign Key .
• Strong background in a disciplined software development life cycle SDLC process and has excellent analytical, programming and problem solving skills.
• Expertise in analyzing, designing, and developing Client/Server, Business Intelligence BI database applications using MS SQL Server 2012/2008/2005/2000 , SQL Server Integration, Reporting Analysis Services.
• Over 7 years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analytical Services SSAS and Data Transformation Services DTS .
• Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression MDX .
• Identified Key Performance Indicators KPI and Metrics for Business needs in SSAS 2008
• Expert in defining and deploying Cubes using SQL Server Analysis Services SSAS .
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.

TECHNICAL SKILLS:

DBMS/RDBMS

MS-SQL Server 2008R2/2005

T-SQL, SQL Loader, Sybase.

ETL

SQL Server Integration Services SSIS, SSAS, SSRS, T-SQL using Stored Procedures.

Tools: Visual Studio 2008/2005/2003 , Toad Reporting Services, Crystal Reports, Tableau, Power Pivot.

Database Connectivity

OLEDB and ODBC.

Front End

SQL Reports, Oracle Forms, Oracle Reports, C, .Net.

BI Tools

SSRS / SSIS / SSAS.

Version Control Tools

TFS, VSS, SVN

Languages

C, C, PL/SQL.

Web Knowledge

XHTML, XML, JavaScript

Operating System

Windows 7, XP, Vista, UNIX, Windows 2000, Windows NT

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• 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.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Uploaded reports on to the report manager and organized them into folders.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008
• Developed complex programs in T-SQL PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Done Performance tuning using TOAD
• Worked on Excel Power Pivot for providing ad-hoc reporting for the clients.
• Deployed and generated reports on the server and fine tuned the database objects and server to ensure efficient data retrieval.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS for analyzing purpose.
• Effectively used data blending feature in tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Configured replication servers and transactional replication between production standby server for disaster recovery.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Created various Dash Boards using Performance Point Server
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2000 databases to SQL Server 2008.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2012 Enterprise, Management Studio, Business Intelligence Development Studio SSIS, SSAS, SSRS, visual studio 2008, Performance Point Server, Microsoft Office Share Point Server, TOAD, OLTP, OLAP, XML.

Confidential

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Designed and developed data model in SQL Server using Visio.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Consolidated two databases into one, which maintains customer profile information.
• Implemented security for customer information by encrypting sensitive data using SQL Server 2005 encryption. Used AES algorithm for encryption and decryption.
• Created SSIS packages to transfer data from AS400 to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to perform Data loads from various types of sources files EXCEL, Access, Flat files, CSVs .
• Involved in daily loads FULL INCREMENTAL into Staging and ODS areas, trouble shooting process issues and errors.
• Built a effective queries for high performance reporting and rendered them to PDF and excel formats using power pivot services.
• Used various Control Flow tasks in SSIS like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Identified the fact and dimension tables from the SQL server based on the requirements.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters multi value, hidden, default etc. for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts bars, lines, pie etc., images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint
• Created Scorecards based on Key Performance Indicators KPI's , and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining
• Created and debugged data connections, data sources and Data Source Views.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.

Environment: Windows 2007/XP/vista, NET Framework, MS Excel, Microsoft SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL,TOAD, Visual Studio 2008/2005, PL/SQL.

Confidential

SQL Server Developer/SSRS/SSIS

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Gather requirements and design of data warehouse and data mart entities
• Built Data marts Fact and Dimension tables from the warehouse tables.
• Designed Multi Dimensional models, DATA MART/ WAREHOUSES and SSAS cubes
• Created ETL package for data conversion using various transformations tasks.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created DTS and SSIS packages.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Used Active-X Scripting in SSIS SQL Server Integration Services for transformation of data in to staging tables and also to extract data from database tables and write the data to text files.
• Responsible for the data and metadata management and Business Intelligence BI solutions using Microsoft SQL Server 2005 Integration Services SSIS, SQL Server Reporting Service SSRS, and SQL Server Analysis Service SSAS .
• Performs design/code reviews to make sure that the design/code adheres to customers' standards and meets industry's best practices
• Deployed SSIS packages and Scheduled Jobs.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Wrote various queries and store procedure, and Troubleshoot database related issues
• Generated database monitoring and data validation reports in SQL Server Reporting Service SSRS .
• Designed OLAP Star and Snowflake schemas and then Dimension and Fact Tables.
• Generated test cases to meet the functionalities deliverables in the project documentation and specifications.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers DDL DML, Cursors and User Defined Functions UDF .
• Ensure database integrity, indexing, segmentation and recovery and update database design over time.
• Developed Reporting structure for account performance Data Mart.
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems.

Environment: MS SQL Server SSAS/SSIS/SSRS 2008/2005, Management Studio 2008/2005, Query Analyzer.

Confidential

SQL Server Developer/BI Developer

Responsibilities:

• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Created complex variables, multiple breaks, sorts in the reports.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Actively involved in Normalization De-normalization of database.
• Wrote Triggers and Stored Procedures.
• Materialized views, dimensions and stored outlines for optimal performance.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Created custom and Ad hoc reports using SSRS.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
• Wrote DTS scripts for data transfer.
• Decided upon the locking strategy that could be used for various batch Programming structures Transactions.
• Involved in System testing.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSRS, MS .NET Frame Work, ASP.NET, T-SQL, Access 2000 Windows 2K platform ADO.NET, MS Project.

Confidential

Responsibilities:

• Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables with triggers to support new business needs.
• Modified the current stored procedures using Visual Source Safe 6.0 to meet current design.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP.

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2000.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth.
• Generated Reports for the day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition views Using T-SQL.

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query analyzer, DTS, SQL profiler.