PROFESSIONAL SUMMARY

• 7+ years of experience as SQL Server Developer in the analysis, design, development, implementation, testing, and maintenance of application systems in Client Server environments.
• Data modeling using Erwin Data Modeler and MS Visio.
• Experience with MS SQL Server 2000, MS SQL Server 2005 MS SQL Server 2008, and MS SQL Server 2012 and worked extensively on Integration services (SSIS) and Analysis services (SSAS).
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data - Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Database Normalization, and SQL Performance Tuning.
• Expertise in writing and debugging Stored Procedures and Triggers.
• Created complex DTS Packages for Data Migration and Transformation.
• Very good T-SQL Programming skills, Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in Microsoft SQL Server Database Administration including planning, implementing,
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Knowledge on Ralph Kimball approach on dimensional modeling.
• Experienced in using ETL tools in (SSIS) MS SQL 2012 and DTS in MS SQL 2000.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report delivery and Report security.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in writing VB scripts for user defined functions in SSRS.
• Experience working with enhanced Data Profile Viewer in SQL Server 2012 Integration services and enhancements in SSRS 2012.
• Excellent communication skills, both oral and written and pleasing interpersonal skills.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012, MS SQL Server 2008, 2005, 2000, 7.0, MS-Access,Teradata,Telerik

MICROSOFT Technologies: SSRS, SSIS, SSAS, DTS, SQL Enterprise Manager,SQL Management Studio, SQL Server Business Intelligence Tools, Microsoft Office SharePoint Server 2007

Languages: SQL,T-SQL,PL-SQL, C, C++,VB/VBA

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003

PROFESSIONAL EXPERIENCE:

Confidential, VA

BI Analysis

Responsibilities:

• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Involved in creating calculated members, named set, advanced KPI’s for SSAS cubes.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Used MDX to create calculated members in the cube.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS).
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Data migration (import & export - BCP) from Text to SQL Server.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Created Drill-through, Drill-down, Linked Reports and Sub-Report using RDL.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).

Environment: MS SQL Server 2008R2, SSIS, SSRS, OLAP, OLTP, MDX, ETL, ETL,T-SQL, MS Excel, MS Access, MS Visual Studio.Net, C#, VB,Telerik.

Confidential, VA

SQL BI Consultant

Responsibilities:

• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for Application.
• Developed and created logical and physical database architecture using ERWIN.
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Extract Transform Load (ETL) development using SQL Server 2012, SQL 2012 Integration Services (SSIS).
• Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
• Used Data Cleaner for Data profiling of the Database
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Fine-tuned the complex database stored procedures and increase performance.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to sql using SSIS.
• Deploying and scheduling Reports using SSRS to generate all weekly, daily and quarterly Reports including current status.

Environment: MS SQL Server 2008R2, MS SQL Server 2012 Enterprise Edition, SSIS, SSRS, OLAP, OLTP, MDX, ETL, ETL,T-SQL, MS Excel, MS Access, MS Visual Studio.Net, C#, VB.

Confidential, CA

SQL BI Data Warehouse Consultant

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Data migration (import & export - BCP) from Text to SQL Server, Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS,
• Created partitions for high volume of data tables.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Involved in Database optimization.
• Developed Query for generating drill down reports in SSRS 2008, Prepared AD HOC reports through report builders.
• Worked on Microsoft Dynamics AX core version for development and implementation
• Generated reports on a daily basis using the SQL Server Reporting Services (SSRS)
• Created Drill-through, Drill-down, Linked Reports and Sub-Report using RDL.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Designed logical/physical data models and defined primary key, foreign key using Erwin
• Working in creating complex Stored Procedures, tables, and views and other SQL joins and statements for applications, developed complex TSQL code for the application.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Environment: MS SQL Server 2008 Enterprise Edition, Enterprise Manager, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, ASP.NET, ETL,T-SQL, MS Excel, MS Access, MS Visual Studio.Net, C#, VB, Visio, XP professional.,TFS,Redgate, EA

Confidential, New York

SQL BI Data Warehouse Consultant

Responsibilities:

• Migrated from SQL Server 2005 to SQL Server 2008 and SharePoint 2011.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Responsible for creating reports based on requirements using SSRS.
• Created Dashboards for the end User Requirement Reports.
• Used Performance Point server to create Reports on the SharePoint server.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Deployment of Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in Normalization to 3F for OLTP system and some De Normalization for OLAP system.
• Scheduled the DTS package for migration data from old system to MS SQL 2008.Reconciled data for transformation from SQL 2005 to SQL 2008 using SSIS.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Responsible for logical and physical Data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation, Developed, monitored and deployed SSIS packages.

Environment: MS SQL Server 2008 Enterprise Edition, Enterprise Manager, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, ASP.NET, ETL,T-SQL, MS Excel, MS Access, MS Visual Studio.Net, C#, VB, Visio, XP professional.

Confidential, MD

SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database, Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Migrated from SQL Server 2005 to SQL Server 2008 and worked on the transition.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server, Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation, Developed, monitored and deployed SSIS packages.
• Actively involved in Normalization of database.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Participated in client-server, multi-tier application (Internet/Intranet) development, and enhancement and testing, Resolve all production issues and provided the deliverables at the right time.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions, Handled dead lock scenarios.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk I/O and Networking).
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery, Examine two-way database replication using SQL server.

Environment: MS SQL Server 2008/2005, DTS, Windows 2003, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, SSAS, MDX, ETL, Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, Oracle 10g, UNIX, XML,XSLT, ASP.NET, ADO.Net.

Confidential

MS SQL Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for personal banking system.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Implemented Disaster Recovery plan using Log Shipping method.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.

Environment: DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server2004, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential, PA

SQL Server Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, and deployment.
• Involved in designing ER diagrams and mapping the data into database objects.
• Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages and wrote DTS scripts for data transfer.
• Configured SQL mail agent for sending automatic emails when a DTS process fails or succeeds.
• Involved in troubleshooting SQL Server database issues and maintain the server for maximum up time.
• Implemented Triggers and Stored Procedures to achieve the required functionalities.
• Used Performance Monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Used various tools to improve SQL Server performance like windows performance monitor and index tuning wizard.
• Involved in testing, bug fixing and documentation for the project.
• Used Crystal Reports and MS Access to write complex formulas and to query the database to generate different types of ad-hoc reports.

Environment: MS SQL Server 2000, DTS, Crystal reports, .Net Framework1.1, ASP.NET, C#.NET, VSS, IIS 6.0, Windows XP