SUMMARY

• Over 7+ years of experience as SQL Server developer, Business Intelligence developer and Administrator.
• Experience in installation and configuration of MS SQL Server 2000/2005/2008/2008 R2/2012.
• Expert in designing, developing and delivering business intelligence solutions using Microsoft business intelligence tools like SQL Server Integration Services(SSIS),Analysis Services(SSAS) and Reporting Services(SSRS).
• Expert in writing and debugging stored procedures, triggers, cursors and user - defined functions.
• Strong experience in creating T-SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• In-depth knowledge with creating T-SQL Queries, Dynamic-queries, Sub-queries, aggregate functions and complex joins for generating complex store procedures, triggers, views, functions and Cursors.
• Experience in Extracting and Transforming data (ETL) from various sources and creating packages using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Skilled in implementing transformations of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Expert in creating SSIS packages which involves processing and extraction of data from various flat files, Excel files, other databases, SQL server and loading into various Business Entities(Data Warehouse, Data mart).
• Solid experience working with package configurations, Event Handlers, error handling, logging, Checkpoints, Transactions, deploying, and execution of SSIS packages in various environments like development, testing and production.
• Experience in creating the automated processes for database backup processes and SSIS Packages which run sequentially using SQL Server Agent job.
• Experience in designing complex reports like Cascading parameters, Parameterized Reports, Matrix, Tabular, Charts, Report Models and sub reports using Business Intelligence Development Studio (BIDS) and SQL Server Data Tools based on client requirement.
• Experience in building Ad Hoc reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Expert in creating report layout, sorting the data, defining subtotals for the reports usingSSRS2008/2005.
• Experience in building reports using Crystal Reports, MS Reporting Services and Excel using Macros.
• Worked with report manager for deploying the reports across all the environments.
• Excellent report creation skills using Report Designer and Report Builder in SQL Server Reporting Services (SSRS).
• Proficiency in designing and extending SSAS cubes, data mining models,, Measures, Partitioning Cube, deploying and processing SSAS objects, and writing MDX queries.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Strong experience in designing of OLTP and OLAP databases, by using normalization and de-normalization techniques.
• Experience in using of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling, Kimball methodology and reporting tools.
• Enhanced the functionality in database and data ware housing concepts by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Good ability in creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics),Dashboard Designer and integrated them with SharePoint Web Services.
• Extremely effective in Software Development Life Cycle (SDLC) process using waterfall methodology and agile methodology and have excellent analytical, programming and problem solving skills.
• Solid Experience and outstanding knowledge in performing database backup and recovery using Log Shipping and Database Mirroring techniques.
• Worked with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Experience in building Linked Servers for connecting servers at remote site locations and then running the queries with group of servers using T-SQL statements.
• Strong research and analytical skills, computing abilities, problem solving, dynamic leadership quality.
• Very good team player with ability to perform under stress and excellent presentation and technical documentation skills.

TECHNICAL SKILLS

Operating system: Windows95/98/NT/ 2000/2003/2008 Server/XP/Win7, Unix, Linux

Programming Language: C, C++, T-SQL,HTML

Database: SQL Server 2012/2008/2005/2000, MS Access

ETL Tools: Microsoft Integration Services(SSIS 2005/2008/2012 )

Reporting Tools: MS SQL Server Reporting Services, Crystal Reports

Documentation tools: MS Office

Database tools: SQL Enterprise Manager, SQL Server Management Studio, BIDS

IDE: Visual studio 2005,2008,2010

Other tools: SSAS,SQL Server Profiler, SQL Loader, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. SQL Developer / BI/DBA

Responsibilities:

• Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL, FLAT Files, and Oracle etc. into various Data warehousing system.
• Created complex SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, and Data Flow Task etc. to generate underlying data for the reports and to export cleansed data.
• Created T-SQL Queries, sub-queries and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expertise in using SQL Server Profiler to resolve deadlocks, lock Escalation, long running queries and tune the same to improve performance.
• Provided Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services (DTS/SSIS).
• Designed and deployed the SSIS packages, and also produced documentation of data transformations for all extractions.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Created SSIS Packages and jobs to perform filtering operations and import the data on daily basis from the MS Access DB to SQL server 2008 R2.
• Created stored procedures to perform two phase load of data to staging area and then to warehouse using SSIS packages.
• Proficient in implementation of Entity integrity, Domain integrity, Referential integrity and User defined integrity.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports using SQLServer Reporting Services (SSRS 2008R2/2012).
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Used dynamic parameters and expression to create interactive user reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed a report on the monitoring of Server Performance using Task Manager.
• Examined and improvedQuery Processing performance using Database Engine Tuning Advisor.
• Defined Key Performance Indicators (KPIs) in accordance with the requirements using SSAS 2012.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Services.
• Responsible for identifying and defining Data Source and Data Source views.
• Good knowledge in High Availability and disaster recovery models like Log Shipping, Database Mirroring, Replication like snapshot, merge and transactional.
• Performed root cause analysis and resolve performance tuning related issues.

Environment: MSSQL Server (SSMS)2012,2008 R2,2008, 2005, MS SQL Server 2000,MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), SQL Server Configuration Utility, SQL Query Manager, T-SQL, Query Analyzer.

Confidential, Indianapolis, IN

BI Developer

Responsibilities:

• Responsible for deploying reports to Report Manager and Troubleshooting any errors occurred during execution.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SSRS.
• Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
• Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary Form, OLAP and Sub reports.
• Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
• Worked on Tabular, Chart, sub report, Matrix, Gauge, Spark line using SQL server 2008 Reporting Services (SSRS).
• Configured SQL mail agent for sending automatic emails when a SSIS/DTS process is failed or succeed.
• Expertise in Using different Transformations like, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in creation of entity relationship diagrams and multidimensional data models.
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Implemented the slowly changing dimensions (SCD) type 1 and type 2 to maintain current information and history information in the dimension tables as update strategies.
• Knowledge in designing and developing Data warehouse, Data marts and Business Intelligence using multi-dimensional models such as Star schemas and Snow flake Schema for developing Cubes using MDX.
• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
• Created various maintenance jobs, which included Data Migration, Index rebuilding, updating the statistics and clearing the historical event logs, log file shrink jobs and other DBCC jobs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Built and applied different partition strategies on the databases to solve the size issues.

Environment: MSSQL Server (SSMS) 2008 R2, 2008, 2005, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS).

Confidential, Westport, CT

ETL Developer

Responsibilities:

• Experience in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Migrated SSIS packages from SQL Server 2000 to SQL Server 2005.
• Extensively used DTS Import/Export Wizard AND BATCH data transactions for performing the ETL operations.
• Involved in Unit testing in SSIS Packages, Query verification in SSIS and Stored Procedures.
• Responsible for creating new reports as well as modifying the existing reports using SQL Server Reporting Services (SSRS).
• Created and modified customized Crystal Reports to satisfy each organizations specific need.
• Designed BI portals in SharePoint to host report and performance point service dashboards and score cards.
• Created reports for day to day analysis purpose by building store procedure, views and deployed them on SSRS server.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS.
• Involved in the extraction of data from different sources like OLTP server, flat files, excel and legacy databases.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created databases and database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2008/ 2005.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MSSQL Server (SSMS)2008 R2,2008, 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, Query Analyzer.

Confidential

Software Developer

Responsibilities:

• Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created graphical representation of data in reports by using graphs (such as Bar, Column, Pie) for quick data analysis and trending using SSRS.
• Generated reports using Expressions and Functions using SSRS.
• Created reports using SSRS from various sources like SQL Server 2008 and Cubes from Analysis Services.
• SQL query optimization in SSRS by designing required indexes/partitions after analysis using SQL profiler and examining execution plans in SQL server Management studio.
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS.
• Created data source views with named calculations and named query from the enterprise data warehouse for data warehouse cube.
• Used SQL Server Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels, Measures and Measure Groups.
• Involved in documentation of the Reports, Tables, Stored Procedures and User Defined Functions that were used in the reports.

Environment: MSSQL Server (SSMS)2008 R2,2008, 2005, MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), T-SQL, Query Analyzer.

Confidential 

SQL Server Developer

Responsibilities:

• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Involved in Troubleshooting Stored Procedures and Queries performances using SQL Server Profiler, Performance Monitor and DBCC Commands.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types
• Created Complex queries and used Functions like, Cursor Functions, String Functions, System Functions, and Date - Time Functions.
• Created various database objects like Tables, Indexes, Views, and SQL Joins.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Worked on Transactional Replication issues on the Production Server.
• Created various reports of the Production Server to analyze the performance and to observe any dead lock issues.
• Performed on developing DB admin related scripts, setting up administrator jobs like data purge, index rebuild, database consistency checks, and database data file shrink jobs.
• Built several Log Backup jobs to monitor the Log files of the huge databases on both Production and Replication Servers

Environment: MS SQL Server 2005, MS SQL Server 2000, SQL Query Manager, Windows XP, T-SQL, Query Analyzer.