SUMMARY

• Over 7 years of IT experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• Experienced in working as MS SQL Server 2012(T - SQL, SSRS, SSIS)/2008R 2/2008/2005/2000 developer in various industrial domains as Government Agency, Healthcare, Retail and Banking/Finance.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) specially Agile Scrum/SVN involving business process analysis, requirements gathering, detailed design and development, testing and post implementation support.
• Skilled in writing SQL queries wif Teradata environment.
• In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, complex Stored Procedures, User Defined Data Types and Functions.
• Experience in sub-queries, CTE’s (common table expression), table variables and physical temp tables.
• Expertise in performing and designing ETL data flow using SSIS, DTS, and Bulk Insert.
• Expertise in upgrading/creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets/DTS using SQL Server SSIS.
• Extensive knowledge and experience working wif Relational databases (RDBMS), DSS, SourceSafe Administration and serving in multi-tiered environment.
• Expert in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experienced in resolving complex issues and Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging towards SSIS package execution in SSIS 2012/2008R 2/2008/2005.
• Experienced in Building OLAP Cubes, Facts and Dimensions tables wif different Architectures and Data Sources for Business Intelligence, and populating/maintaining Data Marts in SSAS 2012/2008R 2/2008/2005.
• Used Multi-Dimensional Expressions (MDX) queries for calculated members of OLAP cube, Key Performance Indicators, Aggregation, Measures in SSAS 2012/2008R2/2008.
• Strong knowledge of Data Warehouse concepts and technologies; working extensively on Developing SSAS Cubes, Hierarchies, Star and Snow Flake Schemas of Data Mart, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects, ETL process, reporting tools and surrogate key generation.
• Strong expertise in Data modeling using Erwin 9/8/7.2 and MS Visio wif good understanding of Relational Database Management System (RDBMS).
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2012/2008R2/2008/2005) generated Parameterized reports, Linked reports, Sub reports, Drill down, Drill through reports, Matrix dynamics and filters, charts, Indicators graphs in SSRS.
• Worked on MS Power Pivot tool in Excel for Data exploration and processing millions of rows in the data creating Ad-hoc/Analysis reports.
• Provided support to SharePoint users and site level administrators on different job related issues and tasks created.
• Experienced in generating reports using Crystal Reports, XML, MS Access, Excel and Interfaces wif BIDS.
• Excellent Experience in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Flexible, multitasked, responsible, enthusiastic and project oriented team player wif excellent written, verbal, presentation and interpersonal communication and leadership skills to develop and learn new creative solutions for challenging client needs.

TECHNICAL SKILLS

Operating System: Windows 2000/XP

Database: MSSQL Server 2012/2008R2/2008/2005, MS Access 2007/2003

Programming Language: T-SQL, Oracle 9i/10g, ADO.NET

SQL Server Tools: SQL Server Management Studio, SQL Server Query Analyzer, SQL Server Profiler, SQL Alerts, BCP, DTS, MS SQL Server SSRS 2012/2008R2/2008/2005, SSIS 2008/2008R2, SSAS 2008/2012

Server/Other Tools: Team Foundation Server, MS Visual Source Safe 2008/2010, Agile Scrum Methodology/ SVN

Development Tools: Visual Studio.NET 2010/2008/2005 , MS Office 2007/2010/2013 , MS Visio 2008/2010

Designing Tools: Crystal Reports, Erwin, COGNOS Reporting Tool, MS Excel, MS PowerPivot/Power Viewer, QlikView, Tableau Software 7/6/5

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

MS SQL SSRS Developer

Responsibilities:

• Worked in Agile Scrum Methodology to design and modify database structures and meeting business requirements.
• Created efficient Stored Procedure, User defined Functions, Tables, Views, CTE’s and other T-SQL JOIN techniques for applications and improvement of database performance.
• Work wifin the environment of Team Foundation Server and MS Visual Team Source to further collaborate business requirement tasks wif SSIS packages and SSAS cube.
• Administer and use the SharePoint server to deploy MS SSRS reports and create and resolve issues generated.
• Developed Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Integrate reports and stored procedures of MS SSRS wif MS SSIS packages.
• Create reports using data sources such as Oracle JDE, Sales Force SDFC and Hyperion.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server and test environment.
• Created MS Power Pivot Excel report using fact table and dimension tables of SSAS cube.
• Work on collaboration wif Testing, by deploying completed tasks to test and ultimately production environment.
• Worked in optimizing, trouble shooting of stored procedures, report rendering issues.

Environment: MS SQL Server 2008R2, BIDS, TSQL, Business Intelligence MS SQL ServerIntegrated Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS Visual Team Source, Team Foundation Server (TFS), MS Excel Power Pivot, Share Point/Power Viewer, Tableau Software 6/7, IIS.

Confidential, Washington DC

MS SQL SSIS/SSRS/ETL/SSAS Developer

Responsibilities:

• Database migration is done from SQL Server 2005 to SQL Server 2012 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Worked on Agile Scrum Methodology and SDLC (Software Development Life Cycle) to design high level database structure including packages, reports and data warehouse architecture.
• Creating Database objects - Tables, Views, User defined Functions, Triggers and developing efficient Stored Procedures for both Online and Batch requests handling business logic and application functionality of various modules for performance improvement.
• Designed and implemented SSIS package to migrate data from multiple data sources (Teradata/Oracle) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files carrying out ETL process.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices of error handling logics to handle bad data, avoid package failures and to maintain optimal performance.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case and schedule SSIS packages using SQL Server Agent.
• Used VB.NET Script for Data Flow and Error handling using Script Component in MS SSIS.
• Integrated MS SSRS wif Share Point Server by configuring a report server and administering tasks of organizing, delivering, scheduling and tracking reports subscription using SSRS 2012.
• Developed datasets to perform reporting and created interactive Drill down, Drill through, Tabular, Cross tab, Parameterized, Cascaded and Sub- reports, Report models and Ad-hoc reports using SSRS.
• Integrate various reports wif Tableau Software features such as Mapping, Data pops, Filtering to further deploy it on Dashboards/SharePoint for web viewing.
• Used SQL Server SSAS 2012 to design, implement and manage data warehousesOLAPcubes and reporting solutions to improve asset management, incident management, and data center services.
• Managed the historical data in the data warehouse from various data sources and generated various drill down, drill through, matrix and chart reports from SSAS cubes using SSRS.
• Built efficient dimensions and fact tables wif star schema using SQL Server Analysis Services (SSAS)
• Implemented SSAS Cubes, Fact and Dimension tables to perform analysis and deploy OLAP cubes on Development Server and Production Server.
• Monitored, Optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: MS SQL Server 2005/2012, BIDS, TSQL, Business Intelligence MS SQL ServerIntegrated Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Teradata, MS Visual Studio, MS Visio, Power Pivot, Teradata, Share Point/Power Viewer, Tableau Software 6/7, IIS.

Confidential, Salem, OR

MS SQL Server SSIS /SSRS/SSAS Developer

Responsibilities:

• Involved and Analyzed in Database planning, defining and designing physical and logical data warehouse architecture using Erwin/Visio on business requirement providing documentation.
• Created data-related documentation using Agile Scrum methodology (e.g., file descriptions and definitions, entity relationships and attributes).
• Designed new ETL packages using SSIS to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases from Excel spreadsheets, Flat Files and OLEDB sources.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring, managing them and applying appropriate logging process by populating wif entries like inserted, updated and error records.
• Writing many Triggers, Functions, Views, Indexes and developing complex T-SQL code as Stored Procedures and functions to be used directly in generating reports on the fly.
• Testing and loading the data on Development and Production environment along wif fixing bugs and automation of jobs.
• Created SSIS Packages using Fuzzy Lookup, Slowly Changing Dimension, Pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from XML files, Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse/OltpDB.
• Utilized VB.NET in Script Task to check existing files in SSIS package.
• Built efficient SSIS packages for processing fact and dimension tables wif SCD transformations.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Documented the source to target mappings to facilitate changes when necessary and create Technical documents and Data Dictionary.
• Created different type of Ad-hoc, Cross-Tab, Sub-reports, Tabular, Parameterized, Drill through and Drill down reports.
• Integrated MS SSRS wif Share Point Foundation 2010 to configure report deployment and scheduling auto generated report subscriptions on daily/weekly/monthly basis.
• Use MDX (Multi-Dimensional Expressions) queries for the calculated measures and KPI’s to design Star schema using dimensions and fact tables in SSAS.
• Administer and deploy SSAS OLAP cubes on development and production server for performance analysis.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
• Checked Performance Tuning, Indexing, Query Optimization and responsible for Authoring reports and managing reporting services.
• Created user defined data types to model database to be deployed into production environment.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.

Environment: MS SQL Server 2008/2008R2, T-SQL, MS SQL Server Reporting Services (SSRS) 2008, MS SQL Server Integration Service (SSIS) 2008, MS SQL Server Analysis Services (SSAS) 2008, OLTP, MS Access, SharePoint/ Power Viewer, IIS, Oracle 10g

Confidential, Schaumburg, Illinois

MS SQL Developer/ETL/SSIS/SSRS Developer

Responsibilities:

• Responsible for planning, developing and designing ER diagrams for different modules by using Erwin and Visio.
• Migration of data from different sources (text based files, Excel spreadsheets) to MSSQL.
• Implemented new triggers, functions and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQLServer Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Built efficient SSIS packages for processing fact and dimension tables wif complex transformations. Defined the logging process for all the packages, populated it wif entries like inserted record, updated record and error record.
• Administer and use MDX queries to calculate measures and KPIs using fact and dimension tables in SSAS designing star schemas.
• Create and Design Analysis and SSRS reports into Tableau for further integration to Dashboard/SharePoint web server.
• Deploy and schedule the monthly/weekly/daily reports on report server and Share Point integration to run automatically.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.
• Responsible for monitoring and tuning of reports and ETL packages.

Environment: SQL Server 2008/2008R2, MS BIDS, T-SQL, MS SQL Server Reporting Services (SSRS) 2008, MS SQL Server Integration Services (SSIS), IIS, Share point/Power Viewer, Erwin 4.x., Tableau Software 5,5.1.

Confidential, Philadelphia PA

MS SQL Server / SSIS /SSRS Developer

Responsibilities:

• Involved wif Installation, Upgrade and Troubleshooting of MS SQL Server 2008.
• Created efficient Stored Procedure, Triggers, User defined Functions, Tables, Views and other T-SQL JOIN techniques for applications and improvement of database performance.
• Designed, Developed and maintained Relational databases using Agile Scrum methodology, SME phase.
• Extensively involved wif Database Space Management, Performance and writing SQL queries wif Teradata.
• Involved wif tracing activities using SQL Profiler.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Responsible for SSIS activities to move data from text files to SQL Server and scheduling the delivery of SSIS packages daily and weekly.
• Responsible for creating ETL summary report and schedule jobs for daily/weekly reports delivery to the end user.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Extensively involved wif the development team in carrying out the Unit testing of the applications and tuning of procedures.
• Integrate SSRS reports wif Tableau using features such as data pops, filtering and authoring and deploy them on Dashboard.
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: Windows 2000 Advanced Server, MS SQL Server 2008, MS SSRS 2008, MS SSIS 2008, MS SQL Profiler, MS Access, MS Excel, IIS, MS Outlook, FTP, TSQL, Tableau Software 5.

Confidential, Berkeley Heights, NJ

MS SQL Server/SSRS Developer

Responsibilities:

• Determined the SQL Server Installation. Installed and configured SQL Server Management tools using SQL Server Setup Program.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created views to facilitate easy end user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity.
• Worked on Import/Export for transferring terabytes of data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server using SSIS.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Create Tabular, Drill down, and Parameter reports using SSRS integrating them to the web.
• Migrated ad-hoc reports from MS-Excel and Crystal Reports to SSRS.
• Running DBCC (Database Console Commands) consistency checks, and fixing data corruption in application databases. Monitor and tune SQL scripts.

Environment: SQL Server 2005, ER-Win, T-SQL, Excel, Access and Windows NT, Crystal Reports, MS SQL Server Reporting Services (SSRS) 2005.