SUMMARY

• Over 10 years of IT experience in Sr.SQL Server Developer/Team Lead, Design, Development, System Analysis and Support of MSSQL Server 2008 R2, 2005, 2000, 7.0, MS - Access in Development, Test, Production and Replication & Cluster environments.
• Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS). SQL ServerReporting Services (SSRS).
• Knowledge of Relational Database Management systems and Data Modeling.
• Worked on configuring Service Broker for message Queuing system.
• Experience in Database Backup, Log shipping, and Replication Recovery and Disaster Recovery procedures.
• Experience with Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Experience in Performance Tuning, Query Optimization, Client/ ServerConnectivity, Database Consistency Checks using DBCC Utilities.
• Hands on experience in Troubleshooting database issues.
• Experience in writing and debugging Stored Procedures, Views, triggers, Functions using T-SQL Scripts
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.
• Maximum Team Handle on Onsite to Offshore range between 10 -35 including Manager as Team Lead.

TECHNICAL SKILLS

RDBMS: MS SQL Server 6.5, 7.0,2000, 2005 and 2008, 2008 R2,2012, DB2, MS Access 2000/97and Oracle.

Programming: C, C#, C++, PL/SQL, T-SQL, Java, Java Script, COBOL, ASP, HTML Perl script, and Visual Basic

Operating Systems: Windows 2000, Workstation, Windows NT/XP/95/98, MS DOS, UNIX

Applications: MS Office, MS Visio, Dream Weaver

Tools: Erwin, NetIQ, MS Visio, Clustering, Remedy, Attunity, NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL, Netezza.

PROFESSIONAL EXPERIENCE

Confidential, Livingston NYC

Sr. SQL/BI Developer

Responsibilities:

• Involved in Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in writing T-SQL script for databases and tables.
• Data Migration from Oracle to SQL Server 2008R2.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Scheduling and deploying the packages on SQL Server.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Developed Parameterized, Navigational, Sub reports, Tabular Reports using dataset created from OLTP Database to Cubes.
• Involved in creating both Data and Dimensional Modelling for designing Databases for OLTP and OLAP system.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Scheduling and working on performance of reports.

Confidential, Jersey City

Sr. SQL/BI Lead

Responsibilities:

• Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Writing T-SQL script for databases and tables.
• Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Creating parameterized as dynamic reports from cubes using Expressions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating DTS Packages to import & export data from text files MS SQL Server databases
• BCP in and out of data from one environment to another environment.
• Production support for all kind of technical issues.
• Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created the backup schedule for production, test and development servers.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance

Environment: MS SQL SERVER 2012,2008 R2, SQL Server 2005, Oracle,MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2010, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Ohio

Sr. SQL/BI Developer/Lead

Responsibilities:

• Developing SSIS package for incremental and full loading of data to Data warehouse.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Data Migration from Oracle to SQL Server 2008R2.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating dynamic SSIS packages along with XML configuration file.
• Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, and Teradata).
• Writing PL/SQL script for retrieving data from Oracle databases.
• Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.
• Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Security of SSIS packages.
• Error Handling, Package Logging and Configuration of packages
• Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.
• PL/SQL code using TOAD for retrieving data from Oracle.
• Creating indexes (Clustered and Non Clustered) for improving the server performance
• Creating cubes, performance of cubes for MOLAP storage option.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Scheduling and working on performance of reports.
• Creating DTS Packages to import & export data from text files MS SQL Server databases.
• Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Environment: MS SQL SERVER 2008 R2, SQL Server 2005, Oracle,MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Philadelphia

Sr. SQL/BI Developer

Responsibilities:

• Writing PL/SQL script for retrieving data from Oracle databases.
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Creating Web Config File OR Tables for storing all variables for Security purpose.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in optimization of cubes by Aggregations, Partitions of cubes
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2005,2008 R2, SQL Server 2000, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Seattle

Sr. SQL/BI Developer

Responsibilities:

• GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Creating Attributes and Dimension hierarchy in cube
• Writing MDX query against cubes to browse data and creating reports from Cubes.
• Writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Deployment, scheduling and Running SSIS packages on SQL server.
• BCP in and out of data from one environment to another environment.
• Creating Dynamic and parameterized reports using expression and mdx query from cube.
• Writing shell scripting for UNIX data
• Improving the performance of cubes by creating aggregations, partition of cube.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created the backup schedule for production, test and development servers.
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Environment: MS SQL SERVER 2005, 2008 R2, SQL Server 2000, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Columbus, OH

SQL/BI Developer

Responsibilities:

• Migration of 2000 Databases to 2005 Databases. Migration include the migrating the SQL 2000 DTS packages to SQL server 2005 SSIS packages
• Created Packages for synchronization of Production Databases to UAT, SIT, DEV Databases, Tables comparison, Row-by-Row comparison.
• Involved in Tuning Store Procedures and query optimization for SQL server 2005
• Involved in Creating and Altering Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved creating SSIS packages for Full and incremental loading of data for building Data warehouse.
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Error Handling, Package Logging and Configuration of packages
• Creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in data mapping from DB2 to SQL Server 2008.
• Creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Database tuning by using DTA (Database Tuning Advisor) and other third party tools
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Creating Attributes and Dimension hierarchy in cube
• Creating Cubes and Hierarchies between different attributes and Dimension.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, Named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue

Environment: MS SQL SERVER 2005, 2008 R2, 2000, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Seattle, WA

SQL/BI Developer

Responsibilities:

• Gathering business requirements from users and doing impact analysis and delivering it to the offshore team for development
• Reviewed code and deployment guide prior to release to testing team.
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Migration of existing Application from 32 bits to 64 bits environment including installation of Performance Point Server 2007 (PPS).
• Created dimensions and Hierarchies in Performance point server for user interface and loading the data at SQL server Backend through SSIS packages.
• Designing Dimensional modelling especially Star Scheme.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Resolved bugs during testing cycle of application.
• Development of features like optimization, security, and audit log in existing application.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Created a POC and given presentation on Master data management (MDM) to business users as a future implementation for the current Performance Point (PPS) application.
• Worked on SQL Server Integration Services Packages (SSIS) and PPS for loading the data into the SQL Server databases.
• Monitored and created tasks and bugs in MS visual studio Team Foundation Server (TFS, also VSTF) and assigned to proper authorities (offshore development team, test team, etc).
• Performed impact analysis during design changes in upstream and downstream systems.
• Design the application context diagram using MS-Visio tool Installed, configured and maintained

Environment: MS SQL SERVER 2005, 2008, 2000, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.