Sql Server Experience Developer Data Management
Cell # (641)*** -****
• 3 Years of Experience in the IT Industry as a database developer (MS SQL Server 2008 & MS SQL Server 2008R2.
• Experience in writing SQL Queries, Joins involving multiple tables, TSQL, Stored Procedures, Views, Functions, database Triggers.
• Expert in developing Data Definition Language (DDL) and Data Manipulation Language (DML).
• Created sub queries, Created Clustered and Non Clustered indexes on Tables.
• Good Knowledge of normalization/de-normalization of database tables and building referential integrity for the Relational Database Management System (RDBMS).
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Worked on administration tasks such as data loading, batch jobs, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.
• Hand-on working experience in creating SQL Server Reports using SSRS.
• Proficient in developing Parameterized, Ad-Hoc Reporting, Linked Reports, Drill down and Drill through reports.
• Experience in Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Experience in using SSIS for data extraction, transformation and loading
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Create/Edit/Maintain ETL processes utilizing Microsoft SQL Server Integration Services (SSIS) from a diversity of data sources including other servers, flat files, MS Access and Excel.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in working with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Expert in handling error with Event handler using SSIS.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP), Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence.
• MS Office (Excel/Access/Word/PowerPoint/Visio/Outlook).
• Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs
Master’s Degree from Tribhuvan University in 2006
SQL Server Tools SQL Server Management Studio(SSMS),SQL Server Business Intelligence Development Studio(BIDS)
Languages SQL,T-SQL, HTML, Java
Operating Systems Windows 98/2000/2003/XP/VISTA/2007
Databases MS-SQL Server 2008 /2008R2
ETL Tools SQL Server Integration Services (SSIS)
Reporting Tools SSRS
Application Software Visual Studio, MS Office
Nepal Oil Corporation, Kathmandu, Nepal Nov 2008- Jan 2012
SQL Server Developer/SSRS/SSIS
Nepal Oil Corporation Ltd. (NOC) as a State Owned Trading enterprise to deal with import, transportation, storage and distribution of various petroleum products in the country.
• Involved in gathering of the requirements and converting into database related components.
• Created Tables, Views, Stored Procedures, User defined Functions and other DDL and DML statements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Created complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Imported data from text files and excel spreadsheets into SQL server 2008 database using SSIS packages.
• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data in to destination using SQL Server Integration Services (SSIS).
• Involved in the modification of SSIS packages according to the new database structure.
• Implemented Event Handlers in SSIS packages
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Experience in deploying and scheduling the reports based on quarter, month, and year reports.
• Involved in Performance Tuning of SQL Server to improve the performance.
• Actively involved with the development team regarding tuning the SQL queries to improve the performance using SQL profiler.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Involved in design and development of data warehouse.
• Involved in the database backup and recovery.
• Implemented user log in and security.
• Creation of schema objects, rules and granting of roles to the users.
• Involved in administrative tasks of managing users, logs and profiles.
• Created Cubes using Analysis service (SSAS) and performed data mining using Fact table and Dimension table.
• All the process involved to maintain the database was documented.
Environment: SQL Server 2008, SSRS, SSIS, SQL Server Management Studio, SQL Server BIDS, MS Office
Similar ResumesSql Server SSIS/SSRS/SSAS, Data Warehouse ETL Developer
- workers compensation, exposure, ssas, ssis, ssrs,...Sr SQL Server DBA/Developer
- web parts, ssas, ssis, ssrs, bo, etl, dba, dice,...SSIS/SSRS/SSAS/Sql server developer
- bpc, ssas, server developer, ssis, ssrs,...Sql Server Developer Experience Management Data
- dimensions, oltp, ssas, technical skills,...Sr sql server ssis/ssrs/ssas developer
- develper, ssas, ssis, ssrs, tfs, tsql, worthington,...Quality Assurance Management Developer Analyst
- hp quality, hp quality center, quality center,...SSIS Developer
- ssas, winforms, nunit, datawarehouse, ssis, 4gl,...Sql Server Experience 2005 Management Business
- server 2005, sql server 2005, 2005 2008,...BI Developer
San Francisco, CA
- biostatistician, ncqa, bi developer, azure, hedis,...Around 1 year of experience SAP ABAP/4 Technical Consultant.
India, KOLKATA, WB
- abap, scjp, sap abap, nace, j2ee, sd, kolkata,...