SUMMARY

• Around 8 years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2012/2008/2005 on various development, test and production environments in various business domains.
• Experience in SQL server DBA.
• Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes, Dynamic SQL, joins, Cursors, CTE and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2012/2008/2005.
• Highly proficient in Tuning SQL queries and improving the query performance.
• Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Experience in SQL DBA wif SSAS cubing.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience wif file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Good experience in using Perl/Unix commands.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Developed reports using global variables, expressions and functions.
• Expert in Creating and managing roles for security in SSRS reports.
• Expertise in using Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Experience in maintaining financial market domain.
• Ability to define and develop Report Structure wif data definition, report layout and report definition language.
• Experience in technical writing in documentation of project.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports wif drop down menu option, sorting the data, defining subtotals and creating report layouts using SSRS 2012/2008.
• Hands on experience in performance point and Monitoring capabilities.
• Good Experience in using power builder which automatically generates SQL statements and also includes native database drivers for Oracle, Microsoft, Sybase and in power scripting language.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Conditional, List items, Charts, Sub reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created various Complex Formula Reports to query the database for business Intelligence.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
• Expertise wif parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008/2012.
• Experience in creating data driven subscriptions in Report Manager.
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
• Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates like Named Set, MDX Query and Custom Table.
• Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports in Performance Point.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions & MDX Queries using SQL Server 2012/2008 Analysis Services.
• Excellent hands-on experience wif data modeling tool like Erwin and strong noledge of Relational and Dimensional database modeling concepts wif star schema and snowflake schema’s design and implementation.
• Experience in SQL Queries and Macros.
• Good experience in troubleshooting and in using Performance Point Server.
• Good at PL/SQL in Oracle Database.
• TEMPHas good noledge in Health Care responsible programming
• TEMPHas good hands-on experience in using ODBC(Open Database Connectivity).
• Experience using different Version Control Tools like Microsoft Source Safe and TFS.
• TEMPHas very strong background in a disciplined software development life cycle (SDLC) process and TEMPhas excellent analytical, programming and problem solving skills.
• TEMPHas good experience in Full Stack, SharePoint BI and PowerView. TEMPhas good noledge and hands on experience on QNXT database skills.
• TEMPHas good programming experience in Visual Basic and Valid data entry.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/XP/Vista/7/2008, Mac, Linux, Windows server 2003

Programming Languages: C, Java, C#, T-SQL, XHTML, PHP, Java Script

Database: MS Access, MS SQL, SQL Server 2012,2008R 2/2008/2005/2000

Internet Technologies: ASP.NET, JavaScript, VBScript, XML, CSS, HTML

Tools: MS Office, VisualStudio 2010/2008/2005 , DTS, SSAS, SSIS, SSRS, VSTF.

PROFESSIONAL EXPERIENCE

Confidential, Boise, Idaho

SQL DBA/SSRS/SSIS/ DBA

RESPONSIBILITIES:

• Installed and maintained MS SQL Server 2000 on Windows 2003 Server, according to the company standards.
• Upgrade experience of SQL Server . Experience in applying Service Packs at database and OS Level.
• Creating SSAS cubes.
• Migrated DTS packages to SSIS (SQL Server Integration Services).
• Assisted wif the implementation of Snapshot and Transactional Replication for the reporting databases.
• Created the Maintenance Plan for optimization and integrity check for all SQL servers.
• Used DBCC utilities, updated index statistics, monitored database and disk space; involved in security issues and scheduled tasks.
• Worked on migration and maintenance of data using various utilities like DTS, Import and Export via BCP.
• Monitored Databases for Lock Escalation, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine-tuning SQL statements dat better result in efficient SQL statements processing.
• Modified existing Stored Procedures and Functions.
• Worked on creating SQL traces using SQL Profiler Wizard.
• Performed administrative activities like creating user logins wif appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
• Installed and maintained the Failover Clustering Architecture for SQL Server databases for mission critical applications.
• Configuring optimizing in-memory vs disk performance tradeoff for temp DB.
• Split large tables using data partitioning.
• Performed Full Backups and Transaction Log Backups. Restored them whenever necessary; created backup strategies and worked on scheduling the backups.
• Dropped and recreated the indexes on tables for performance improvements.
• Automated processes using SQL Server Jobs.
• Used Index tuning wizard for tuning of indexes.

Environment: MS SQL server Windows 2003, Enterprise Manager, Query Analyzer, ASP.NET and SSIS,SSAS, SQL server 2012.

Confidential, Hauppauge, NY

SQL DBA SSIS/SSRS/SSAS DBA

RESPONSIBILITIES:

• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Establishing performance and monitoring capabilities.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Involved in writing MDX Scripts for the OLAP CUBES.
• Developed multidimensional Objects (Cubes, Dimensions) using MS Analysis
• Created Analytical Reports using ProClarity tool.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports dat draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Set up and configuring Central policy Server Management to make changes in farming SQL servers from a central location wifout logging into each server.
• Deployed SSRS Reports inSharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.
• Involved in improving the performance of the system.
• Developed and executed several optimized queries in SQL.
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Deployed SSRS Reports inSharePoint for web based access for multiple end users.

ENVIRONMENT: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Oracle 9i/10g, Microsoft Office Share Point Server, XML, TFS 2010,DICOM.

Confidential, Herndon, VA

Sr. SSRS Developer

RESPONSIBILITIES:

• Interacted wif Business team to collect data for the conceptual design of the system.
• Interacted wif Development Teams and Managers to analyze business needs and developed technical specifications.
• Migrated crystal reports to SQL Server Reporting Services (SSRS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely wif IT project managers, programmers, and testers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimized Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
• Trained end users wif step-by-step instructions to access the pre-build or published reports.
• Designed and developed various complex reports and different types of charts.
• Generated reports dat can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Created interactive data exploration, visualization and presentation using power view.
• Used power pivot to import data from sources such as SQL Server, XML, Microsoft Access and even web based data.

ENVIRONMENT: Windows XP, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Los Angles, CA

SQL Server SSIS/SSRS Developer

RESPONSIBILITIES:

• 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.
• CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports wif error description.
• DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Developed some scripts in C#.Net used in ETL Process dat works as transformation.
• ConfigureSSISPackage for run time Parameters and Configuration file.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Used variousSSIStaskssuch asConditional Split, Derived Column, which were used forData Scrubbing, data validationchecksduring Staging, before loading the data into theData warehouse.
• Developed an automated report subscription process usingSSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• ImplementedType 2Slowly Changing Dimensionto maintain Dimension History.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.

ENVIRONMENT: MS SQL Server 2008R2/2008/2005, SQL Server Reporting Services (SSRS 2008R2/2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin.

Confidential, Chantilly, VA

SAS and SQL DBA

RESPONSIBILITIES:

• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Participated in DR installation and trouble shooting (Mirroring, Logs hipping and High availability Cluster.
• Applying Service Packs and Security patches for the Servers as released.
• Installed SQL Server on Active/Passive and Active/Active clusters as part of Upgrade.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.
• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: SQL Server 2005, SQL Server 2008, Windows 2008, Windows 2003 EE, Cluster, Microsoft Windows … Server, Microsoft SQL Server 2012, Microsoft SQL Server … R2, Microsoft ASP.net, MS PowerPoint, Symantec net backup, Lite Speed, VMware, SQL Profiler, Performance Monitor and Team Foundation Server.

Confidential

SQL/SSIS Developer

RESPONSIBILITIES:

• Created complex Stored Procedures and Functions to support the front-end application.
• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Created database triggers to implement business requirements.
• Successfully created schema change scripts to existing objects to synchronize wif changing business rules.
• Monitored growth of database objects for capacity planning.
• Involved in tuning the database and T-SQL queries using Explain Plan.
• Optimize SQL queries for improved performance and availability.
• Configured and monitored database application.
• Worked wif Quality assurance to develop test plans and test cases to conduct system testing.
• Involved in performance tuning of the database and T-SQL queries.
• Preparation of project documentation.
• Preparation of test plans for assembly testing & System Integration testing.
• Developed DTS Packages to get the reports, routinely, in the excel sheets, required by the managers for analysis.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

ENVIRONMENT: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.