SUMMARY

• Design, development and management experience of mid to high - end projects from inception through delivery, with competency in following areas: Proficient in Database Design, Development, EXPERT skills inSQL, T-SQLStored Procedures / Triggers/SqlAgent Jobs.
• BI presentation delivery utilizing Analysis Services (SSAS), Reporting Services (SSRS), Performance Point Services (PPS) & Crystal Reports. OLAP development including MDX.
• ETL implementation usingSQLServer Integration Services (SSIS).
• Developing reporting solutions using SSRS and integrate with SharePoint 2010.
• Strong knowledge of Data Warehousing methodologies, dimensional modeling and Data mining.
• Developing Excel Reports and deploying in Share point 2010 using Excel Services.
• Dashboards and Scorecards using Performance Point Services 2010.
• Working Experience on Very Large Databases and Performance analysis and Tuning.
• Backup / Recovery, Production Support experience
• Microsoft Development Platforms, Business Intelligence Development Studio.
• Visual Studio .NET,Database Systems.
• Report Builder 2.0 and 3.0
• SQLServer 2005, SQLServer 2008 R2, SQLServer 2012Microsoft Bi Technologies.
• MicrosoftSQLServer Analysis Services, MicrosoftSQLServer Integration Services.
• MicrosoftSQLServer Reporting Services, Microsoft Share point services 2007/2010.
• Microsoft Performance Point Server (PPS)
• Query languages: T-SQL, MDX, DAX
• Development Languages: C#.NET, XML & HTML, Infrastructure Skills Visioand team Foundation Server(TFS)
• 4 years of experience in Database Design, Development and maintenance of database applications on SQL Server 2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2008/2008 R2/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Good experience in Creating, Populating and maintaining Data marts. Through knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Experience in creating reports by using ProClarity Views and Dashboards strategy.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000/7.0 , MS Access.

BI /Data model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS and Visio.

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP.

Programming Languages: T-SQL, SQL, C, and Visual Basic 6.0.

Application Packages: MS Office, MS Outlook.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Developer, SSIS, SSRS, SSAS

Responsibilities:

• Created SQL server Reports using SSRS 2012, created SSIS packages to import and export data from Excel, CSV and other file formats.
• Created store procedures, triggers, Joins, functions and views.
• Scheduled the reports to run automatically for 2012 SQL server.
• Launching the report builder for ad hoc reports

Environment: SQL Server 2008 and 2012, DBA, MS Outlook, FTP, TSQL, Windows 2007, Report Builder

Confidential

SQL Server Developer/DBA

Responsibilities:

• Involved in gathering the user requirements.
• Involved in physical and logical data modeling, architects.
• Created stored procedures, triggers, Joins, functions and views.
• Created SQL server Reports using SSRS 2008.
• Created Cross - Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL Server Reporting Services.
• Identified the data source and defining them to build the data source views.
• Debugging reports and deploying reports.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Scheduled the reports to run automatically.
• Launching the report builder for ad hoc reports.
• Configuring the report viewing security.
• Created schedules and subscriptions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Creating Stored Procedures for reports generation.
• Involved in database backup, recovery procedures
• Planned back up strategy for disaster recovery
• Responsible for log backups and restoration.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Environment: MS SQL Server 2008 R2 and 2012, MS SQL Server Reporting Services 2008, Windows 2003 server.

Confidential

SQL Server/SSRS /SSIS/ Server Developer

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Involved in creating Indexes for faster retrieval of data.
• Maintained data integrity by performing validation checks.
• Involved in running the SQL Profiler for better execution Plans.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Scheduled automated jobs using SQL Server Agent.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of users.
• Used SSIS in importing data from XML files.
• Monitored the performance and optimized SQL queries for maximum efficiency.
• Developed SSIS solution for developing a fully - fledged data warehouse solution.
• Monitored and deployed SSIS packages and involved in notification services, error handling.
• Identified the database tables for defining the queries for the reports.
• Assisted in migrating de-normalized report DB into a Star Schema design
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Deployed the generated reports on to the server.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: SQL Server 2008, DBA, MS Outlook, FTP, TSQL, Windows 2003

Confidential

Responsibilities:

• Developed complex TSQLcode for the application. modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub. enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats usingSQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed cubes using SSAS involving multidimensional data. supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by usingSQLProfiler, Data Engine Tuning Advisor and index tuning wizard. maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MSSQLServer 2008, Management Studio, BIDS, Visual Studio 2008, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, XML,SQLProfiler, Windows 2003.

Confidential

Responsibilities:

• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions
• Created Cubes, dimensions, hierarchy and deployed .Generate the cube by using complex MDX queries.
• Developed summery reports including line and pie charts, trend analysis reports and sub-reports.

Environment: MSSQLServer 2008, Management Studio, BIDS, Visual Studio 2008, SSRS, SSAST-SQL,SQLProfiler, Windows 2003.