PROFESSIONAL SUMMARY:

• Overall 10+ years of IT experience in Database Administration, System Analysis, Design, and Development & Support of MS SQL Server 2012/2008/2005/2000, 7.0,6.5 in Production, QA, and Development & Replication Environments.
• Migration from SQL Server 6.5 to SQL Server 7.0 /SQL Server 2000/2005 and 2008 R2
• Experience in working with Windows 2000 Advance and Enterprise Server 2003/2008 and Windows NT Server Installation and Administration.
• Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and reporting tools
• Experienced in Creating Databases Based on Functional Requirements and System Design
• Experience in Assisting the Application Developers in creating Conceptual Database Designs that meet the business and technical objectives of various projects.
• Expertise in TCP/IP, DNS server configuration limited to SQL Server.
• Experience in working with production 24/7 and development and UAT environments.
• Extensive experience in Installation, Configuration & Maintenance of MS SQL Server 2012/2008/2005/2000, 7.0 And 6.5 Versions.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in Performance point server and MS - Analysis services.
• Experience in Replication environment (Merge, Transactional & Snapshot method used) to replicate data to regional and remote servers. Implemented Mirroring to minimize downtime.
• Experience in Performance Tuning. Query Optimization, Client/Server connectivity, And Database Consistency checks using DBCC Utilities
• Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Data center move, Implementing P2V and V2V
• Configured SMTP Mail server.
• Created reports using SSRS with MS SharePoint.
• Experience in Code Optimization and Improving Efficiency in Databases including Re-Indexing, Updating Statistics, Recompiling Stored Procedures and performing other Maintenance Tasks.
• Experience in working with DTS and SSIS Packages
• Experience in using Performance Monitor/Profiler to solve Dead Locks/Long Running Queries.
• Good understanding with Reporting Services and Analysis Services. Experience in Oracle DB.
• Excellent Analytical, Interpersonal and Communication Skills & Desire to Excel, Fast Learner, Hardworking and Versatile Team Player.
• Hands on experience with T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Experience in Business Objects for BI and ETL Operations.
• Experience in analysis of Traces, Replication, Clustering, Database Mirroring & Log Shipping, Integration Services (SSIS 2012), and Data Transformation Services in 2000 (DTS), Reporting Services (SSRS 2012) and Remote Administration.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SSIS, Profiler, Query Analyzer,.NET

Programming Languages: T-SQL, PL/SQL, C, C++, Java, J2EE,JSP,VC++.Net, VB Script

Databases: MS-SQL Server 6.5/7.0/2000/2005/2008/2012, MS Access 97 &2000, Oracle 7.x to 10g 11g,12c.

Web Servers: Web Logic Server 6.1, Apache Web Server, IIS, and PWS.

Web Technologies: Java Script, HTML, DHTML, XML.

Operating System: Windows NT4.0/2000, Advanced Server/ Enterprise Server 2003/, Win XP Prof/Standard, Win 98, HP UNIX 10.x, Solaris 8.x and UNIX.

Reporting Tools: MS SQL Server Reporting Services, Crystal Reports, PS Query, nVision & SQR,BEX Analyzer, Web -Application Designer, Report Writer, Cognos 7.0.

DB Design Tools: ERWIN.

Office Suite/ Tools: MS SharePoint, MS Office (Word, Excel, Power Point, Access) 97/2000/07

WORK EXPERIENCE:

Confidential, San Francisco, CA

Sr. SQL Server Developer

• Created various Data Interfaces using SSIS 2012 as per the specifications.
• Migrated packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Migrated data from heterogeneous data sources ( Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Created applications and utilities using PL/SQL.
• Sound Experience and understanding of Confidential, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Worked on content management and document management using MS SharePoint.
• Worked on relational DBMS and object oriented DBMS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used VB scripting for version control.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-20012 Enterprise Edition, SSIS, Confidential, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Server,UNIX, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential, San Francisco

Sr. SQL Server Developer

• Migrated data from heterogeneous data sources ( Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Worked on content management and document management using MS SharePoint.
• Sound Experience and understanding of Confidential, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report using MS SharePoint.
• Worked on .NET framework for development.
• Created applications and utilities using PL/SQL.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services ( Confidential ).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005( Confidential )
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
• Used VB scripting for version control.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex Confidential solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in Confidential .
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, Confidential, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Server,UNIX, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential, Franklin, TN

Sr. SQL Server Developer

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated data from heterogeneous data sources ( Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2012 as SSIS packages.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Created applications and utilities using PL/SQL.
• Sound Experience and understanding of Confidential, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Worked on content management and document management using MS SharePoint.
• Worked on relational DBMS and object oriented DBMS.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services ( Confidential ).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005( Confidential )
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used VB scripting for version control.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex Confidential solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in Confidential .
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, Confidential, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin,UNIX, Performance Point Server, Office-2007, MS Excel, C#.NET, ProClarity Analysis, MS SharePoint.

Confidential , Peoria, IL

Sr. SQL Server Developer

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Migrated data from heterogeneous data sources and Legacy system (DB2, Access, Excel) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Worked on performance point server for planning and budgeting for business intelligence.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services ( Confidential )-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Worked on relational DBMS and object oriented DBMS.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Worked on content management and document management using MS SharePoint.
• Confidential storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending Confidential Cubes, Dimensions and data source view Confidential -Data Mining Models and Deploying and Processing Confidential objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, Confidential, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, MS SharePoint, Performance Point Server, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential, Columbus, OH

SQL Server Developer/ BI Developer

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Involved in updating slowly changing dimensions strategies.
• Designed cubes with star schema using SQL Server Analysis Services ( Confidential ).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services ( Confidential )
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services Confidential and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in Confidential instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, Confidential, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, Performance Point Server, MS Visual Studio 2005, MS SharePoint.

Confidential, Bronx, NY

SQL Server Developer/ BI Developer

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Developed Cubes using SQL Analysis Services ( Confidential ).
• Deployment of Confidential Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Confidential storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Developing and Extending Confidential Cubes, Dimensions and data source view Confidential -Data Mining Models and Deploying and Processing Confidential objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services( Confidential ), Performance Point Server, Windows 2000/XP, Oracle 7.0.

Software Developer

Confidential, Atlanta, GA

• Designing and implementing the module based on the business requirements given by the business.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the object
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures & maintaining Referential Integrity.
• Monitoring MS SQL Server performance and network issues.
• Creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Backing up system & user databases and restoring them whenever necessary.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer,System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Windows