SUMMARY

• Over 8 years of IT experience in Designing, Development, Analysis, Implementation and Testing of applications using various versions of MS SQL Server.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Hands on experience in writing and reviewing T - SQL code and maintaining coding standards.
• Experienced in writing complex SQL queries,Stored Procedures, Function, Joins, Views and Cursors to implement business logic.
• Extensive knowledge in monitoring and performance tuning of SQL queries using SQL Profiler, SQL Server Management Objects (SMO), Index Tuning Wizard.
• Good exposure to window functions and its usage against complex queries.
• Experience in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file to SQL Server by using DTS and SSIS services.
• Knowledge of data modeling and Data Warehouse concepts.
• Developed cubes using SQL Server Analysis Services(SSAS) and experience in developing OLAP cubes,Dimensions and data source view.
• Provided best in class BI reporting solution including but not limited to Drill-through reports, Parameterized reports, reports using Cascading parameters, Adhoc reports and report models using SQL Server Reporting Services(SSRS).
• Built power view reports on SharePoint environment and created analytical reports and visualizations with Microsoft Excel Power BI tools(Power View,Power Pivot).
• Extensively used Visual Studio for development of .NET based applications.
• Exposure to Hadoop cluster to run MapReduce jobs and gained knowledge on SQOOP which helps to ingest data from various sources into HDFS.
• Good understanding to write complex HIVE queries for data analysis and got familiarized with workflow scheduling using Apache OOZIE.

TECHNICAL SKILLS

Languages: C#.NET, VB.NET, VB Script, Java, T-SQL

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS)

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Excel, Power BI

Operating Systems: Windows Server, Windows XP, UNIX

Databases: MS SQL Server 2000,2005,2008,2012, Oracle

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them.
• Performed data cleansing using various transformations in SSIS and also cleared duplicate data using SSIS dataflow components.
• Used SSIS and T-SQLstored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Designed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: SQL SERVER 2012, SQL Server Management Studio(SSMS), T-SQL,BIDS(SSIS,SSRS,SSAS),Visual Source Safe.

Confidential

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows.
• Created database objects such as tables, views, stored procedures, indexes.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them into temporary table, having the same architecture as the table for which the import is done.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and defined Key Performance Indicators (KPIs) in SSAS.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cubes as backend and provided integration between MS Excel/SSRS and SSAS.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with SQL in SSAS.
• Created various types of reports like Dashboard, Variance, Forecast and client active reports.
• Enhanced reports by using a series of features like Highlighting report values using conditional styles, applying a report template, format report objects, focus the scope of a report using filters for accuracy of the equity rewards and Incentive grants.
• Created Scorecards, Calculated, Analytical reports for sales and Metrics using Metric studio.
• Performed Unit, Integration and Regressive testing of ETL jobs, applications and data in target tables and checked any quality related problems.
• Documented all processes involved in maintaining the database for future reference.

Environment: SQL SERVER 2012, SQL Server Management Studio, T-SQL,BIDS(SSIS,SSRS,SSAS),Visual Source Safe.

Confidential

Responsibilities:

• Interacted with the developments teams and managers to analyse business needs and developed technical specifications.
• Designed and implemented schema in more than five databases for various kinds of storage as of business needs.
• Involved in development of their various screens for data entry and maintenance using LINQ to SQL, VB.NETand Web Services.
• UsedSQLServer Integration Services (SSIS) to develop various complex packages with parent child relationship that would collectively extract data from the raw extracts coming from Multiple Sources to two Staging Areas and finally to the Enterprise Data Source (EDS).
• Extensively used various Control Flow Tasks like Script Task, File System Task, and Execute Process Task etc.
• Generated Report Model automatically from an OLAP cube by using Report Manager andSQL Server Management Studio.
• Deployed Reports onto common server to make it accessible for the management team and application development team.
• Responsible for scheduling the Subscription of the reports with the Subscription Report Wizard and creating Snapshots of the report as per requirement. Also, implemented Security to the reports using Report Manager.
• Exported reports to various formats like XML, CSV, PDF, Excel,etc based upon the requirement from the management level team.

Environment: SQL SERVER 2008 R2, Visual Studio, VB.Net, Query Analyzer, Enterprise Manager, T-SQL, SSRS, Windows 2003,Visual Source Safe.

Confidential

Responsibilities:

• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Generated database monitoring and data validation reports inSQLServer Reporting Service (SSRS). Actively involved in writing T-SQLProgramming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in migrating data from heterogeneous source systems to target data base
• Translated business logic to transformation logic to generate pseudo code for the ETL process
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQLServer using ETL Tool.
• Used transformations like Lookup, Aggregator, Sort, Derived Column, Union All and OLE DB Command to implement the transformation Logic and load the target tables.
• Used C#/VB.Net for coding inside the script task.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file
• Developed Stored Procedures and Views used to supply the Data to the Reports.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports usingSQLServer 2008 Reporting Services.
• Configured, built, deployed different reports in PDF, Excel formats according to the business requirement usingSQLServer 2008 Reporting Services.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement for the sales department.

Environment: SQL SERVER 2008, Query Analyzer,Enterprise Manager,Erwin, T-SQL,SSAS,SSRS, Windows 2003,Visual Source Safe.

Confidential

Responsibilities:

• Actively involved in writing T-SQLProgramming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Involved in migration of data formSQLSERVER 2005 toSQLSERVER 2008.
• Created stored procedures usingSQLServer management studio and Worked extensively with Data Adapter, Dataset and Data reader as a part of ADO.NETto access and update database.
• Created cross reference tables and ETL routines to standardize the data coming from multiple sources
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB toSQLServer using ETL Tool.
• Responsible for implementation of SSIS logging and error configurations for error handling of packages.
• Identified slow running queries and optimization of stored procedures and verified data integrity using SQL Profiler.

Environment: SQL SERVER 2008, Query Analyzer,Enterprise Manager,Erwin, T-SQL,SSIS, Windows 2003, ADO.NET, Visual Studio 2008.

Confidential

Responsibilities:

• Developed database objects with relevant to the requirement.
• Created some new views and modified the existing views so that the views contain accurate data.
• Created and modified User Defined functions and implemented cursors, complexSQLqueries in functions.
• Build the Dimensions, cubes with star schema usingSQLServerAnalysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Leading the testing team and verifying the functionality against the Business standards.

Environment: SQL SERVER 2005, Query Analyzer,Enterprise Manager,Erwin, T-SQL,SSRS, Windows 2003,Visual Source Safe.

Confidential

Responsibilities:

• Took the ownership of the database module and Created users for the project by granting appropriate privileges.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, ExecuteSQLTask, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL SERVER 2005, Query Analyzer,Enterprise Manager,Erwin, T-SQL, Windows 2003,Visual Source Safe.

Confidential

Responsibilities:

• Analysis of the existing algorithm and developed the stored procedure which satisfies the new algorithm.
• Involved in database development using stored procedures, triggers, views and cursors.
• Involved in creating Indexes for faster retrieval of data and maintained data integrity by performing validation checks.
• Involved in running the SQL Profiler for better execution Plans.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Developed fact tables, dimensional tables, cubes for OLAP warehouse using AnalysisServices.
• Designed OLAP cubes, MDX coding, Data Modeling, Star Schema, and KPI efficiently for Analysis Services for Decision Makers.

Environment: SQL SERVER 2005, Query Analyzer,Enterprise Manager,Erwin, T-SQL, SSAS,Windows 2000/NT.