SUMMARY

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains.
• Involved in a Software Development Life Cycle (SDLC) process and Agile methodology.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL Methodology in data extraction, transformation and loading.
• Experience in Writing TSQL (DDL, DML and DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex Stored Procedures, Function(UDF), Cursors, and Triggers, locking issues, BCP, Common Table Expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R 2/2012/2014.
• Experience in optimizing code and improving efficiency in databases including re - indexing, updating statistics, performance tuning and other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, linked reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Experience in generating reports for OLTP and OLAP databases.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, Database Security and Database issues.
• Excellent Experience in Extracting, Transforming and Loading (ETL) using various tools including SQL Server Intelligent Services (SSIS), DTS Packages, Bulk Insert(BCP).
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012/2014
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in Developing cubes using Partitions, KPI’s, and Perspectives and created various user roles.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C, C++, C#, ASP.NET, MS Share point, XML, JAVA, JAVASCRIPT, VB.Net, HTML, DHTML, MDX, HTTP, Shell Scripting.

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

Database Tools and Data modeling: TOAD, Star Schema/Snowflake Schema modelling, FACT & Dimensions tables, Erwin, Power Designer, physical &logical data modelling and Demoralization.

SQL Server Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools: and Utilities: SQL Server management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import and Export Wizard, Visual Studio.Net, Quality Control(QC), Microsoft Management Console, Web Services, SOAP, Crystal Reports, MS Excel.

Operating Systems: Windows Server 2008R 2/2008/2003/2000, UNIX, Linux, DOS UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server Developer |SSIS|SSRS|SSAS

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
• Used Recursive CTEs while creating multiple complex stored procedures for various purposes like database maintenance, index maintenance.
• Analyzed business requirements and used COBOL Program specification document so that it can be used to convert to Oracle PL/SQL Stored Procedure/Function/views.
• Query Optimization, tuned some SP’s/Queries/views for excellent performance upgrades.
• Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
• Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also used SSIS packages to store data on third party FTP sites.
• Worked in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• As Report Writer I Designed and implemented reports with different layouts using SSRS 2014 and also with mainframe systems.
• Created several Complex Reports (tabular, matrix, sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Apple to apple comparison of Cobol reports and SSRS.
• Migrated SSIS packages from SQL Server 2012 to SSIS 2014.
• Worked on Defect Fixing Using Quality Control (QC).
• Enriched SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes.

Environment: MS SQL Server 2014/2012, MS SQL Server Integration Services (SSIS), MS SQL Server reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), BIDS, COBAL, T-SQL, MS TFS 2012, MS Visio, Oracle 10g.

Confidential - Florida, FL

SQL Server SSRS|SSIS|SSAS|T-SQL Developer

Responsibilities:

• Created and managed schema objects such as tables, views, constraints, UDDTs etc. Create Business Rules using Master Data Services, enforced server wide Policies and maintained Referential Integrity.
• Employed Dynamic SQL to generate DDL and DML statements for different database object dynamically as part of automating database maintenance as well as creating dynamic search queries for applications.
• Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS
• Data migration (import & export - BCP) from Text to SQL Server and Vice versa.
• Implemented batch processing using Jobs and DTS.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized Various Reports using SQL server 2008 Reporting Services.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Used Script task for setting the SQL query on fly using C#/VB in SSIS package

Environment: SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, BIDS 2008R2, SQL Profiler, Visio, C#/VB, Excel 2007.

Confidential, Cranbury, NJ

MS SQL/BI Developer

Responsibilities:

• Responsible for working with in-house development staff and functional analysts to review code and integrate SQL Reports with Oracle Systems using Web Services.
• Created and modified stored procedures, tables, views, indexes on various databases for critical data involving profit and loss, net revenue, forecasting etc.
• Tuned queries, T-SQL stored procedures to enhance the performance of applications.
• Created various reports using SSRS (Drill Down, Matrix, Sub reports and Navigating), Crystal Reports 10 and converted existing crystal reports to SSRS reports. Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Created and maintained SSIS and DTS packages and used most of the tools in SSIS like looping, data formatting, error handling, email notification, web service task.
• Utilized extensively SSIS packages functionality to create and complete ETL process using scripts, stored procedures, functions, transformation of data.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services(SSAS).
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from dataset using SQL Server Analysis Services(SSAS).
• Experience in creating Multidimensional cubes with SSAS and designing DW Schemas.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Used TFS (Team Foundation Server) for project management and source control.
• Deployed SSIS packages on the Production Servers and monitored the SQL Agent jobs, SQL logs, Application logs. Provided 24*7 production supports on shift basis.

Environment: SQL Server 2012/2008R2/2005, SSRS, SSIS, SSAS, SSMS, DTS, TFS, T-SQL, SQL Profiler, SQL Server Agent, Crystal Reports 10, VB Script, Windows XP, MS Access 97/2003, ASP.net 3.5, XML, Microsoft Office SharePoint Services (MOSS).

Confidential, Moline, IL

SQL Server/SSIS, SSRS and SSAS Developer

Responsibilities:

• Managed Tables, Views, cursors and optimizing queries using execution plan for tuning the database.
• Used Recursive CTEs while creating multiple complex stored procedures for various purposes like database maintenance, index maintenance.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.
• Used SQL Server Reporting services to write complex formulas and to query database to generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence.
• Deployed Reports onto common server to make it accessible for the management team and application development team.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Developed OLAP model based on Dimension and Facts for efficient loads of data mainly based on Star Schema and Snowflake Schema.
• Developed various reports for every on boarded and existing clients and also made various enhancements.
• Held responsibility for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, Perspectives and KPI’s.

Environment: MS SQL Server 2008R2/2008, SSMS, SSIS, SSRS, SSAS, Windows 2003 server, DTS, SQL Query Analyzer, SQL profiler, Crystal Reports, Visual Studio 2005.

Confidential

Jr SQL Server developer

Responsibilities:

• Created and managed schema objects such as tables, views, stored procedures, Tuning SQL Queries (using Indexes) triggers and maintaining Referential Integrity.
• Worked as part of a team for gathering and analyzing Business Requirements.
• Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Involved in performing database Backup and Recovery
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Developed Reports Using SSRS on statistical data during migration of data.

Environment: SQL Server, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS.