SUMMARY

• Over 7+ years of strong experience in the IT industry as a SQL Server Developer.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Experienced on oracle Advanced supply chain.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
• Adept in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008 R 2/2008/2005.
• Extensive experience in MS SQL Server 2012/2008 R 2/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).
• Knowledge on Enterprise JavaBeans (EJB) and JSP.
• Used Multidimensional Expressions (MDX) to provide a specialized syntax for querying and manipulating the multidimensional data stored in OLAP.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes .
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server 2000, Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2005/2008.
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Proficient in debugging PL/SQL packages to troubleshoot issues.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (Integration Services) with MS SQL Server 2008/2003.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Well Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2008/2005.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Expert in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Excellent communication skills, quick learner and good performer both in team and independent job environments with strong logical and analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003 Advanced Server/Professional and Windows NT 4.0 Server/Workstation.

Database: MS SQL SERVER 2012/2008/05/00/7.0 , MYSQL, MS ACCESS 2007/2003.

ETL Tools: SSAS, SSIS, SSRS, DTS, SQL Server Business Intelligence Development Studio (BIDS), Erwin Data Modeler 4.1/4.0/3.5.

Languages: T-SQL, PL/SQL, C++, ASP.NET 4.0/3.5, ADO.Net 4.0/3.5/3.0/2.0 , C# 4.0,VB Script, MS Visual Studio 2010/2008/2005 , MS Access 2007/2003,HTML 4.0, XML 1.0, DHTML,CSS, VB Script, Java script 1.8, AJAX V3.0, Oracle 11g/10g/9i/8i, MS Visio 2007/2003,Crystal Reports 10/9/8.5,MS Visual Source Safe 4.0, MS Visual Basic 6.0, Subversion, Teradata.

Operating Systems: Windows 98/NT/2000/XP/2007/VISTA, UNIX, LINUX, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

SSIS/SSRS Developer

Responsibilities:

• Involved in planning, defining and designing database using Erwin on Business requirements.
• Involved in installation and configuration of MS SQL Server 2012
• Created SSIS packages to extract data from OLTP sources like MS SQL Server 2000, Teradata, Oracle Database, Text Files, Excel and Access to OLAP systems (SQL 2005/2008) and scheduled jobs to call the packages and stored procedures.
• Identified and modified KPIs (Key Performance Indicators) in accordance with the requirements using SSAS.
• Used Multidimensional Expressions (MDX) to provide a specialized syntax for querying and manipulating the multidimensional data stored in OLAP.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Conditional Split and Derived column.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Created cubes and portioned them for query optimization using SSAS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-20012 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Involved in the design and development of web forms for the application using ASP.Net, DHTML, XML, and Cascading Style Sheets (CSS).
• Involved in development of web pages with ASP.Net, AJAX control as per CSS with C# as back-end coding language.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used “SQLProfilerTSQL Duration” template for tracking execution time of TSQL Statements.
• Improved Performance of the database by creating Clustered and Non Clustered Index.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008/2012 tools like SQL Server Management Studio, SQL Server Profiler.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, SQL Profiler, T-SQL, Subversion, Teradata, Erwin 7.2, EJB, J2EE, JavaScript, ASP.Net, DHTML, XML, C#, CSS, ADO.Net, AJAX, VB Script, MS Access, Excel, MS Visio, MS Office 2007/2003,Windows 2003/2000/XP .

Confidential

MS SQL Developer/BI Developer

Responsibilities:

• Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and also created SQL scripts for tuning and scheduling.
• Wrote queries using Dynamic SQL to reduce complexity of the queries and improve performance
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
• Maintain existing ETL processes and trouble shoot issues as they arise.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups, etc.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Created package configurations for dynamic connection string to enhance the ease of package deployment.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• DevelopedDrill Down, Drill through, Cross tab reports, Parameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Defined Key Performance Indicator metrics to create scorecards.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized queries by using Execution Plan for better tuning of the database.

Environment: MS SQL Server 2008, 2010, 2005/2000, SSRS 2005, SSIS 2005, T-SQL, C#, XML, XSLT, Crystal Reports, Visual studio 2005, ASP.Net, ADO.Net, ETL, DTS, Data Analyzer, Teradata, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, Oracle 9i.

Confidential, Santa Ana, CA

MS SQL Developer/BI Developer

Responsibilities:

• Gathered user requirements for analysis and design of software solution and database.
• Involved in gathering database objects using JavaScript.
• Involved in designing an OLAP with the help of Erwin to visualize data structure.
• Extracted and reviewed data from heterogeneous sources (Oracle Database, text files, Excel and Access Files) from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Created SQL Server Analysis Projects and created Multi-Dimensional databases, OLAP cubes and dimensions for the analysis of sales using SSAS.
• Analyzed data quality, worked in the data warehouse architect on the development of logical data models.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Involved in development of T-SQL statements using dynamically generated SQL.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created and modified cube partitions to optimize the query performance of the cubes.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
• Involved in development of MDX expressions for cube calculations and KPIs (Key Performance Indicators)
• Used Visual Source Safe to provide locking and sharing support for files to be shared among multi users.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Defined d relationships with the measure groups and fact tables.
• Implemented the calculations to aggregate physical measures using management studio.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Extensively used Profiler to identify and repair database lockups, deadlocks.
• Established a sound backup and recovery policies and procedures.
• Updated functional specification and technical design documents.
• Proficient in debugging PL/SQL packages to troubleshoot issues.
• Configured oracle applications to meet client business process requirements, created custom oracle documentation.
• Complex Oracle PL/SQL procedures, functions and packages are developed to adhere to the specifications of the application.
• Involved in data retrieval from oracle database using PL/SQL.

Environment: MS SQL Server 2008, 2005(Enterprise Edition)/2000, SSAS, SSRS, SSIS, DTS, T-SQL,PL/SQL, JavaScript, VB Script, MS Visual Source Safe, Oracle, Windows Server 2003/2000, Erwin 4.0, Excel, MS Access.

Confidential, Bethesda, MD

MS SQL Developer

Responsibilities:

• Gathered the business requirements in order to create database.
• Involved in project planning and scheduling of database module.
• Created Logical and Physical data models using Erwin data modeling tool.
• Scheduled and performed transfer of data from various sources like flat file, Excel, Access, SQL server 2000 database using DTS and filtering the data for data analysis.
• Developed Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes, SQL joins and statements for applications using T-SQL.
• Engaged in report development surrounding QNXT and custom SSRS reporting.
• Managed and monitored the system utilization by using the query optimizer, checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Analyzed data quality, worked in the data warehouse architect on the development of logical data models.
• Performed Database Normalization to avoid data redundancies.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Used SQL Profiler to optimize the queries.

Environment: MS SQL Server 2008, 2000 Enterprise Edition, DTS, T-SQL, Query Analyzer, SQL Profiler, Windows 2000/2003 Server, QNXT 2.0, HTML, ASP .Net, Erwin 4.0, Crystal Reports 9.0, Excel, MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in performing extraction, transformation and loading using DTS.
• Handled database objects with Enterprise Manager and Query Analyzer.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data migration with SQL server 2000 Export Utility.
• Involved in developing logical and physical database using Erwin, Normalization, Dimension Modeling and Enterprise Manager.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
• Experienced on oracle supply chain.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Proficient in debugging PL/SQL packages to troubleshoot issues.
• Worked on EJB components related to J2EE.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.

Environment: MS SQL Server 2000/7.0, Query Analyzer, EJB, Windows Server, PL/SQL, J2EE, Windows NT, Erwin, SQL*Plus, TOAD

Confidential

MS SQL Developer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views).
• Involved in developing the SQL code for the application.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization.
• Managed Backup and Disaster Recovery of the systems.
• Managed the security of the servers as a part of administration duties.

Environment: MS SQL Server 2000/7.0, Windows Server, DTS, SQL Reporting Services, Windows NT.