SUMMARY

• Around 7 years of IT experience in Analysis, Design, Development, Implementation, troubleshooting and Support of MS SQL Server 2012/ 2008/ 2005/ 2000 in OLTP, OLAP Environments as a Developer.
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 and from.
• Involved in all the phases of software development life cycle (SDLC) process.
• Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T - SQL Scripts in MS SQL 2012/2008/2005/2000.
• Experience in Creating Tables, Views, Complex Stored Procedures, User Defined Functions(UDF’s), Triggers to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Experience in optimizing the query by creating various Clustered, Non-clustered indexes and Indexed views.
• Experience in SQL Server DTS and SSIS package design, construction and deployment from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations.
• Experience in using Performance point server 2010 and Share point server 2010.
• Experience in using C# and VB.Net scripts for the Script task and Script component in SSIS.
• Knowledge on Eclipse Business Intelligence reporting tool for developing (BIRT) dynamic reports.
• Experience in Data Migration using tools like BULK INSERT, BCP and Replication between different homogeneous/heterogeneous systems and SQL Server.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Enterprise Manager.
• Experience in creating Sub Reports, Tabular Reports, Matrix Reports, Parameterized Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS) and web reporting by customizing URL Access.
• Proficient skills in Drill down and Drill through reports, sorting the data, defining subtotals in SSRS 2008/SSRS 2005.
• Developed Crystal reports.
• Connectivity and Database Consistency Checks using DBCC Utilities.
• Data Modeling Experience in creating Logical, Physical data models using tools like ERWIN and Visio.
• Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

SQL Server Tools: SSIS (2008/2005), SSRS (2008/2005), SSAS, DTS.

RDBMS: SQL Server.

Data Modeling: ERWIN 4.0, Visio 2003.

Languages: T-SQL, SQL, PL/SQL, HTML, XML, VB.Net, ADO.NET.

I.D.E: Visual Studio 2008/2005.

Version Controls: Visual Source Safe.

Operating Systems: Windows.NET 4.0/, Windows Server/XP/Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Nashville, TN

BI Developer/DBA

Responsibilities:

• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Installation and Configuration of SQL Server 2008R2
• Involved in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) and other reports using Crystal reports & Cognos reports.
• Used Share Point Integrated mode mostly and Native mode to design the SSRS reports.
• Generated the dashboards, Scorecards using Performance Point Server 2010.
• Generated the KPI’s for Each Asset Using Performance Point Dashboard Designer 2010.
• Created Site pages in Share point site to deploy the SSRS reports using Share point Integration mode with Share point server 2010.
• Created web parts on SharePoint site using SharePoint Server 2010 and displayed the SSRS charts as a web part.
• Experience in managing alerts, Operators and Jobs through SQL Server Agent.
• Creating, loading, and modifying a new SSIS package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Automated the SSIS jobs inSQL schedulerasSQL Serveragent job for daily loads.
• Designed SSIS packages to schedule the SSAS Cube processing.
• Involved in Designing the Analysis Services Cubes and Designing the reports with reference to the SSAS cubes.
• Using MDX created calculated members for customized calculated measures.
• Hands on creating SSAS KPI‘s using MDX Queries.
• Involved in Requirements gathering from the end users from different Assets.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Involved in creating cubes in Business Intelligence Development Studio (BIDS), deploying them on the server and processing the OLAP cubes to generate aggregate data for faster querying.
• Problem identification, troubleshooting, resolution, and index tuning databases.

Environment: MS SQL Server 2008 R2 SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Crystal Reports, Performance point server 2010, Share point server 2010, Windows 2008 Server, Team Foundation Server, XMLA, MS-Access, MS-Excel.

Confidential - Minneapolis, MN

MS SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Responsible for Day-to-day activities like taking backup (or scheduling the backups daily/weekly/monthly for database or transaction log) on disk and restoring the databases and transaction log on production/development servers as per requirement.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in analysis and design of disaster recovery strategies with business managers to meet the business requirements.
• Maintained the database consistency with DBCC at regular intervals.
• Rebuilded the indexes at regular intervals for better performance.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Involved in creating Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data using DTS.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Written complex T-SQL queries and Database triggers.
• Created indexes and was involved in Performance Monitoring.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.

Environment: MS SQL Server 2000, MS Access, MS Excel, Windows 97/2000/XP, ER-Win v4.0.

Confidential - Phoenix, AZ

SQL Developer (SSIS, SSRS)

Responsibilities:

• Responsible for developing new modules as per client requirement.
• Understanding the requirements, analyze and make Use Case & design document.
• Created Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Used Joins for complex business queries involving multiple tables from different databases and implemented stored procedures and enforced business rules via checks and constraints.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Expert in Creating and Deploying SSRS reports on the portal for user accessibility.
• Used cascaded parameters to generate a report from two different Data Sets.
• Generated Configuration files, logging and created breakpoints for SSIS packages and deployed to development, QA and Production Environments.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 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.
• Extensive use of Agile Methodologies, including test-Driven Development and Scrum.

Environment: SQL Server 2005, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Microsoft visual studio.NET 2008.

Confidential, Knoxville, TN

BI SQL Developer (SSIS, SSRS)

Responsibilities:

• Experience in creating database objects like Procedures, Functions, Triggers and Indexes.
• Created functions to provide custom functionality as per the requirements.
• Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL.
• Designed and written the queries in the query builder for retrieving the data.
• Created checkpoints and configuration files in SSIS packages.
• Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files
• Used SQL Profiler to optimize Stored Procedures
• Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
• Deployed SSIS packages with minimal changes using XML configuration file
• Used MDX to query Analysis Service Databases, debugging and supported the purpose of data analysis
• Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters
• Scheduled the monthly Reports/weekly reports/daily reports Based on user Requirements
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSRS, SSIS, T-SQL, Visual SourceSafe, Visual Studio 2010.

Confidential

MS SQL Server Developer

Responsibilities:

• Created tables, views, indexes based on the requirements
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2005, Visual Basic, .NET