SUMMARY

• Around 8 years of experience as MS - SQL Server Developer, involved in Administration, Design, Development and Support of MS-SQL Server 7.0/ 2000/2005/2008 R2/2012for both OLTP and OLAP Systems.
• Designing,testing and implementation of high availability solutions for databases for large, medium and small customers.
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Efficient in optimization and Performance Tuning, Data Import/Export, Troubleshooting,Database Objects, Authorization Objects Creation. Suggest/test improvements: indexing/table structure, query code.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication, Data cleansing and DTS Packages.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS,Bulk Insert and BCP.
• Built Efficient SSIS packages for processing facts and Dimension tables with complex transforms.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Good knowledge on Cosmos Scope.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Created drill down, drill through, Cascading, Conditional,Table,Matrix, Chart,linked reports using MS SSRS 2008 as well as managed the subscription of the reports
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schemausing SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2005 Analysis Services.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Languages: C, T-SQL, PL/SQL, JavaScript, C#, Cosmos.

RDBMS: SQL Server 2008/2005/2000, 7.0, MS-Access.

Front End: MS Visual Basics 6.0.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Control: Visual Source Safe, Clear Case.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, Scope.

Data Modeling: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, ER Diagrams, MS Visio, Rational Rose, Erwin 4.5/4.0/3.5,Dimensional Data Modeling, Data Modeling, FACT and Dimensions Table Modeling .

Operating System: Windows 2008, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, SanRamon, CA

SQL Server/BI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and CTE’s for complex queries involving multiple tables from different databases.
• Worked with Exception handling with @@error and with Try/catch.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• CreatingSSIS package to load data from Flat file to data warehouse databasesusing Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and PivotTransformation.
• Configured SSIS packages using Packageconfiguration wizard to allow packages run on different environments.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems by adding or enhancing relevant entities/ tables, columns etc.
• Enhancing performance of SSIS packages and SQL queries using optimization techniques.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created reports which include Matrix, Drill Down, Drill Through, Cascading, parameterized and chart Report typesfrom data mart databases using SSRS.
• Deploying SSRS reports to report server and managing report subscriptions.
• Involved in report snapshots to improve the performance of SSRS.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting.
• Creating and scheduling new SQL Server Agent Jobs to execute new data load process steps.
• Modifying existing Facts and Dimensions in SSAS cubes based on new requirements from users.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: Microsoft SQL Server 2008, 2008 R2, Visual Studio 2008, T-SQL, SQL Server Analysis Services,SQL Server Integration Services, Business Intelligence Development Studio (BIDS),Power Pivot, SQL Server Reporting Services, Net (Asp .Net,VB.net C# .Net), SQL server profiler, Team Foundation Server, Visual Source Safe.

Confidential, Baltimore, MD

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Data Analysis and Migration of Data.
• Involved in complete Software Development Cycle (SDLC).
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Capture business objectives and processes and design and develop a comprehensive application and solution.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse
• Works with SQL Server, SSIS technologies and has a good Data Warehouse knowledge and tools.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Documentation for all kinds of reports and SSIS packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Successfully conducted root cause analysis to identify the underlying issues and design solutions accordingly.
• Involved in the data mapping sessions and creation of Data dictionary.
• Migration of the data from one environment to other environment. Testing and analysis of the migrated data.
• Identify and replace manual processes and exchange of data with an Automated System.
• Implement the best design patterns in data migration to adapt for future changes.
• Review several test plans and test scenarios with the QC team for each project worked on.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) 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, Parameterized Reports.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Worked on XML along with PL/SQL to develop and modify web forms
• Created SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Environment: Microsoft SQL Server 2012/2008/2005, MS Access, SSAS,SSIS, SSRS, HTML, Visual Studio 2005/2008/2010, IIS, Sybase 12.0,Query Analyzer,, ERWIN, Windows server 2008R2, DTS, TSQL, .Net, SQL Profiler, DTS, Team Foundation Server, CITRIX, CISCO Any Connect, Visual Source Safe.

Confidential, Warren, NJ

Sr. SSIS Developer

Responsibilities:

• Involved in bringing 2005 SQL database environment to SQL 2008 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE’s for complex queries involving multiple tables from different databases.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Deployed SSIS packages and Scheduled Jobs.
• Involved in Analyzing and integrating the data.
• Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Developed Incremental Load using Lookup in SSDT visual studio.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSISpackages to Export data from text file to SQL Server Database.
• Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and deployed reports with Drill Down, Drill Through and drop down menu option and parameterized and Linked reports. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Mapped data between external databases and Crystal Reports.

Environment: SQL Server2008/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008,visual studio 2008.

Confidential

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation of DTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2000, MS Analysis Services 2000, MS-Excel, DTS, Visual Studio.Net 2000

Confidential

Jr. SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, advanced queries, views, Indexes, and Functions for databases.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000/2005, MS Projects 2007(v12.0),T-SQL, DTS, Microsoft Visual Source Safe, MS Visio 2007.