SUMMARY

• 7 + years of IT experience with seven years in Database Developer, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server 2008/2005 in Production, Test, Development Environments.
• Involved in different phases of Software development including requirement analysis, Design, Development, Product Customization, Testing, technical writing and preparing user documentation.
• Experienced in full life cycle ETL development including data analysis, database design, data mapping and conversion and data load
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Experiene in desiginging complex flows in the SSIS packages.
• Migrated DTS Packages to SSIS Packages.
• Experience in SSIS performance tuning using various techniques like parallelism, execution trees and buffer size configuration.
• Experience in creating database designs, data flow processes for various datamarts from atomic datawarehouse
• Experience in SQL database designing, architecture, Data Modeling using ERWIN 7.1 and Visio.
• Experienced in creating entity relational & dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
• Experience in Creating stored procedures, functions, packages, triggers, according to business requirements.
• Expert level skills in T - SQL programming.
• Experience in Performance Tuning, Query Optimization
• Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating and analyzing various traces using profiler to optimize the query and stored proc performance.
• Excellent in system tables, Dynamic Management Views and stored procedures using T-SQL.
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Linked Reports, Charts, Dash Boards, Styles and GUI’s
• Experienced in Development and Deployment of Reports (Tabular forms, Matrix (Cross Tab report) form, Conditional, List Items, Charts and Sub Reports) using SSRS
• Good Knowledge in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Good knowledge in DMX language and Data mining algorithms and worked with data mining models in SSAS
• Experience in creating and designing various cubes, slicing and dicing of cubes
• Experience in data normalization and de-normalization.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services, (SSRS).
• Experience with software development life cycle (SDLC) and project management methodologies.
• Excellent communication skills.
• Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, PL-SQL, Java Script, c# .netRDBMS MS SQL Server 2008, 2005, Oracle 10g & 11g.

Front End: C#, ASP.NET

Technologies: RAID, SAN

Operating Systems: Windows 2008/2000/2003 Advanced Server, Unix

Reporting Tools: Microsoft Reporting services, Crystal Reports

Other Tools: Idera Diagnostic Manager, Erwin Data Modeler, MS Visio, Red Gate, Fog light.

Quest Tools: Spotlight, LiteSpeed.

Hardware: Compaq/HP Proliants 8000, 6500, 6000, 5000 Servers.

Version Control Tools: Visual Source Safe,SVN, Source gear Vault.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Developed and tested complex T-SQL queries and stored procedures, used for Reports.
• Conducted Performance tuning of stored procedures.
• Creating maintenance plan for performing Optimizations and fine Tuning of Database Application.
• Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Database testing, maintaining data and writing complex procedures.
• Wrote complex SQL queries to access data from SQL Server database.
• Created Stored Procedures in SQL Server to pull region wise Student data based on the business need.
• Involved in optimizing the query/stored procedure in SQL Server database.
• Implemented complex business calculations using views to pull the calculated data at run time.
• Involved in Data cleansing inorder to retreive the calculated vales for the active student .
• Used PVCS for maintaining component and for release and version management.
• Issue Analysis and Bug fix.
• Handled code reviews to ensure success of developers to deliver modules on time.
• Compiled coding guidelines and standards and socialized across the teams.
• Involved in enforcing corporate privacy practices and standards.
• Involved in analyzing and fixing critical issues encountered by the business users. Upon the request of business users/stake holders, enhancing the existing applications for their futuristic needs.
• Responsible for project estimates and tracking.

Environment: MS SQL server 2008, MS SQL Server 2005, Windows 2003 Server, SQL profiler, Crystal Reports, MS Reporting Services.

Confidential

MSBI Developer

Responsibilities:

• Worked on loading data in to Mastar Data Services using SSIS and Confidential ’s Custom tools like Auto ETL, SSIS Wrap, Active Batch for scheduling.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Creating Stored Procedures, Triggers, Cursors, Indexes, functions, views on Database objects.
• Worked on the data warehouse and datamart design and analyzed various approaches for maintaining different dimensions and facts.
• Design and Develop Data Analysis Tools using OLAP Service of SQL Server.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Helped users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.
• Extensively worked with TFS to keep track of all changes made in the project, also used to get the latest project version from VSS to the staging server.

Environment: MS SQL server 2008, MS SQL Server 2005, Windows 2003 Server, Customised tools like MDS, Auto ETL and SSIS Wrap, SSIS / SSRS, MS Reporting Services.

Confidential

MSBI Developer

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Creating Stored Procedures, Triggers, Cursors, Indexes, functions, views on Database objects.
• Worked on the data warehouse and datamart design and analyzed various approaches for maintaining different dimensions and facts.
• Designed the methods to measure the performance of the SSIS packages and worked on enhancing the performance of SSIS packages
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed a Tabular Reports using SSRS Report Designer.
• Created an ad-hoc reports using SSRS Report Builder.
• Designed different types of SSRS reports including drill-down and chart lists.
• Developed the logic for incremental updates ( incremental rows and modified rows )
• Experience in creating Dashboards using various indicators in the reports for summarizing the data analysis.
• Created process tasks that execute reports based on the data extracted using SSIS services.
• Experience In using SQL Profiler To Solve Dead Locks/Long Running Queries.
• Experience in using different kinds of gauges and indicators in creating reports using SSRS designer.
• Experience in designing various linked reports and drill through reports
• Worked with all kinds of Tablix data regions including matrices, tables and lists
• Extensively used XML configuration files in creating SSIS packages to execute in various environnemnts
• Through out the development process, using SQL server profiler in enhacing the performance of SQL queries.
• Execution of actual testing using test procedures, documenting the results including any exceptions involved in the testing.
• Using MS Access stores data in its own format based on the Access Jet Database Engine.
• Planning and scheduling Database Backups, Restoring Databases.
• Creating Schemas and keeping it synchronize with different Development and testing Environments.
• Participated in implementation and support of the application.
• Implemented a common, structured naming convention across MS SQL databases.
• Successfully resolving SQL Server problems in conformance with, this involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.

Environment: MS Windows 2008 Enterprise Server, SSIS, SQL Server 2008, SSAS, Oracle 10g, SSRS, .NET, VSS, Visual Studio 2005, DTS/SSIS, SQL profiler ERWIN, Red Gate, Idera Diagnostic Manager, MS Reporting Services.

Confidential, New York

SQL Server Developer

Responsibilities:

• Actively participated in gathering requirements from business users to create new database objects.
• Experience in writing various script tasks using C# language and ADO.NET
• Used extensively MDX queries in designing cubes, calculated members and experience in writing MDX scripts using SSAS
• Experience in designing and querying the cubes based on snowflake and star schema in SSAS
• Experience in Creating and processing Data mining structures and Data mining Models in SSAS
• Experience in defining Data mining models using DMX language and created prediction queries using DMX language
• Used different Data mining algorithms including clustering, classification and regression algorithms
• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQLMail and Database Mail.
• Created Databases based on the Logical and Physical Database Designs using Erwin.
• Designed and created user databases, tables, views, complex stored procedures and SQL joins and statements.
• Worked on Optimization and Tuning of Stored Procedures and T-SQL queries by using various performance statistics.
• Created maintenance plans for performing Optimizations, database integrity checks, Backups, Rebuilt and Reorganize indexes.
• Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
• Used DBCC commands for consistency checks to improve performance.
• Resolved issues for mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory
• Used BCP and Bulk Insert for transferring data between various environments.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Created tables, indexes, views, complex stored procedures, functions, defaults, rules and constraints.
• Successfully resolved various SQL Server problems which demand in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, database corruption, security, programming etc.
• Prepared documentation for cost cutting and management of Production Servers.
• Coordinated with Windows Net-Backup and System Management teams for resolving backup and performance issues on regular basis.
• Provided 24x7 production support.
• Migrated and Tested DTS packages to SSIS in Production environment.
• Created, tested and Deployed SSIS packages from system test and UAT to production.

Environment: MS Windows 2008 Enterprise Server, MS SQL Server 2005/2008, Visual Studio 2005, IIS 6.0, ERWIN, Fog Light, Red Gate, SQL profiler, Idera Diagnostic Manager.

Confidential

SQL Server Developer

Responsibilities:

• Involved in various stages like development, System Analysis and Design for new applications.
• Created and Migrated DTS packages from SQL Server 2000/2005 to SQL Server 2005/2008 Integration Services (SSIS).
• Gathered requirments for the creation of data flow processes for the SSIS packages.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse.
• Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for different applications.
• Developes custom tasks for the SSIS packages using C#.NET
• Used various tasks and Control flow techniques in the development of various complicated packages.
• Designing reports on daily basis using Performance Monitor.
• Monitored SQL Server Error Logs and Application Logs.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structure.
• Performed analysis and design of the application.
• Logical and physical database design modeling using Erwin.
• Responsible for Design and Normalization of the database tables
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Developed and coded applications in T-SQL.
• Involved in support, development, QA, UAT and knowledge transfer.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Experienced in performance tuning using Windows perfmon and SQL profiler of SQL server.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Importing and exporting Database objects using DTS utility.
• Created database objects like tables, indexes, stored procedure, triggers, function and views.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created Various kinds of reports involving Drill Down, Parametrized Reports, adhoc reports, published reports.

Environment: SQL Server 2005, T-SQL, Windows Server, ActiveX, Erwin, Visio, Performance Monitor, SQL Server Profiler.