SUMMARY

• Over 8 years of Excellent Experience as Lead SQL Server Developer in Production, Development, Testing environments.
• Experience in SQL Server 2000/2005/2008, SQL, T-SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS packages, and Oracle 9i/10 g, PL/SQL, SQL Plus, Oracle Developer 2000 Forms and Reports.
• Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation
• Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Ad-hoc reports using Business Objects.
• Good knowledge in working and implementation of Crystal Reports 8.0/9.0/10/Xi.
• Expertise in installing, designing, developing, maintaining and tuning of RDBMS like SQL 2008, 2005, 2000.
• Experience with Production (24 X 7) and Development Environment.
• Experience with 2008 new concepts like Date Time data type, Transparent Data Encryption, Grouping sets, MERGE operator, Change Data Capture, GEOGRAPHY and GEOMETRY Data Types, Filtered Indexes, Data Profiling, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS)and SQL Server Analysis Services (SSAS).
• Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.
• Experience with 2005 new concepts like data partitioning, online indexing, Data Definition Language (DDL) triggers, Dynamic Management views (DMV), Dynamic Management Functions (DMF), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Excellent experience of SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.
• Experience in MS SQL Server 2008/2005/2000, Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2005/2000.
• Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using ERwin.
• Excellent skills in Log Shipping, Transactional, Snapshot Replication, Database Backup, Linked Servers, DTS.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs.

TECHNICAL SKILLS

Operating Systems:

Windows 2003 / NT / XP/ME/9.X

Languages:

C, C++,C#, T-SQL

Web Technologies:

HTML,JSP, WML, XML

Databases:

MS SQL SERVER 2008/ 2005 / 2000 / 7.0, MS Access 2003

Packages:

MS Office 2005, MS Visio, ERWIN, MATLAB

Testing:

Win Runner, Load Runner

ETL tools:

DTS, SSIS, SSAS, SSRS

Database Tools:

SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts, , SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools

EXPERIENCE

Confidential,NY Aug’10 - Present
Lead Senior SQL Server Developer

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML to MS SQL Server by using BCP utility, SSIS services.
• SQL Server 2005 RDBMS database development including T-SQL programming.
• Expertise in designing B2B data Exchange platform using ETL process.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with slow changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSRS on SQL Server (2005).
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Experience in creating SSIS packages for XML based Business to Business Data exchange using different type’s task and with Error Handling and Reporting Capability.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SSRS.
• Using SSRS, creating well-formed reports and web-based reports for Energy saving applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Expertise in designing ad-hoc reporting for different level of end user.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Configure the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated dynamic stored procedures, xml stored procedures, triggers for the database development.
• Fine tuned the complex database stored procedures and increase performance up to 7%.
• Experience in Database Tuning.
• Experience in Database Mirroring, Database Snapshots.
• Experience in creation of logins, users and configuring permissions and assigning roles to users
• Taking weekly database backup and schedules job using SQL Agent.
• Involved in Backing up and Restoring of databases.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Create joins and sub-queries for complex queries involving multiple tables.

Environment: Windows Server 2003/2008, SQL Server 2005/2008, ProClarity/PPS, Visual Studio 2005/2008, Multi Terabytes databases, .NET, SharePoint Server 2007, SharePoint Designer 2007, C#, ASP.NET, JavaScript,XML,XSD,X-query

Confidential,OH Jan‘09 – July’10
MS SQL Server Developer

Responsibilities:

• SQL Server 2008 RDBMS database development using T-SQL programming, queries, Stored Procedures, Views.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.
• Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created SSAS packages, OLAP cube, and multi-dimensional modeling on Terabytes Database, and worked in Designing and Building Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cubes.
• Worked on deploying Cubes in SQL server management studio as well as created partition on that having process full for fact table and process update for dimension daily basis.

Environment: SQL Server 2008/2005, SSIS, SSAS, T-SQL, Crystal Reports, Active X Script, VB Script.Net, MS-Excel, Visual Studio 2005, Windows NT scripting.

Confidential,Wilmington Nov’07 – Dec’08
MS SQL Server/ Oracle Developer

Responsibilities:

• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 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.
• Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
• Developed database tables satisfying the 3rd Normal form, and complying with referential integrities.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Designed and coded reports using Oracle 10g. Designed and implemented reports using Oracle Reports Designer.
• Extensively worked on Query Studio and Report studio as report developer.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Designed and Developed parametric Reports, Cross-Tabbed and Sub-Reports in SSRS.
• Worked closely on database tuning, performance planning, backup planning and database administration.
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Generated reports using the Crystal Reports and Reporting Services.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints.
• Adhered to the Change Management procedures.

Environment: MS SQL Server 2008/2005, Oracle 9i/10g, Crystal Report, PL/SQL, Management Studio, SSIS, SSRS, Windows 2003, MS- Access 2003.

Confidential,Hyderabad, India Feb’06– June’07
SQL Server Developer / BI Developer

Responsibilities:

• Involved in writing views, stored procedures and triggers.
• Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net revenue, forecasting.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing crystal reports.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Using DTS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Created DTS Package to transfer data from the Oracle source database.
• Scheduled the ETL Process using Jobs and Created Alerts to notify the status of the process.
• As a Production support person, monitored every day’s ETL Process, and fixed the data issues.
• Modified DTS to SSIS packages to accomplish critical business logic.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases

Environment: MS SQL Server 2005, T-SQL, DTS, SSIS, MS Visio 2000.

Confidential,India Aug-‘04 to Dec-‘05
MS SQL Server Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Good Experience of Data Migration from DTS packages to SSIS Packages.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Created Datawarehouse Cubes in SQL Server Analysis Service (SSAS).
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Involved Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
• Developed SSIS packages using different type’s task and with Error Handling.
• Taking weekly database backup and schedules job using SQL Agent.
• Involved in Backing up and Restoring of databases.
• Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data sources.
• Participated Databases Architecture and data Modeling design.
• Designed, developed and implemented web-based application as per requirements gathered from customers.
• Reviewed and developed data models and database designs with development team.
• Designed and developed OLAP using MS SQL Server Analysis Services.
• In charge of converting data using SQL Server 2005 using SSIS.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Maintained SQL Scripts for creation of Database Objects.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment:SQL Server 2005/2000, T-SQL, Management studio, SSIS, DTS, Enterprise manager, Query Analyzer, SQL profiler, Performance Monitor, Windows 2003/2000 platform.