SUMMARY

• Over 8 years of experience working with SQL DBA, Oracle DBA, Business Intelligence (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R2/2012 and Oracle 10g & 11g.
• Well-versed with Database Installation, Configuration, Maintenance, Monitoring, Backups and Recoveries.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in developing T-SQL Statements, Data Integrity, Rules and Validations.
• Extensive knowledge in using C# and ASP.net.
• Extensive knowledge on database administration of Oracle 8i, 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Mastered solid skills at writing Sub-Queries, Dynamic SQL Queries and besides all, exceptionally well at using Stored Procedures, Triggers, Common Table Expressions (CTEs).
• Excellence in creating Tables, Indexes, User Defined Functions, Views and SQL Joins.
• Expertize in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 11g.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and Debugging new and existing client-server based applications).
• Experience in Designing of ETL Packages for integrating data from heterogeneous sources like Excel, CSV and TXT etc.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Involved in Design and Implementation of Oracle Data Guard both physical/logical standby databases for high availability and disaster recovery.
• Experience in providing Logging, Error Handling by using Event Handler.
• Experienced in using global variables, expressions and functions for the reports.
• Exceptionally good at creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Extensively experienced in generating reports like Cascaded, Parameterized, Tabular and Matrix in multiple formats.
• Creating and Deploying SSRS Reports on portal for User Accessibility.
• Good knowledge of defining and deploying and developing Star Schema, Snow flake Schema and Dimensional Data modeling, cubes using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
• Excellent command with MS SQL Server 2005/2008/2012 , Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Strong Communication Skills with good role playing capabilities and a good team player with a quick grasping knowledge and skills.
• Effectively manages time on multiple projects to meet the deadlines.

TECHNICAL SKILLS

Databases: MSSQL Server 2000/20, MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, Pentaho, Oracle 9i, 10g & 11g, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profile, SQL Query Analyzer, SQL Refractor, SQL Server Agent.

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

Languages: T-SQL, PL/ SQL, C/C++, C#, .NET, HTML, CSS, XML, Python, Scala 2.8.1.

RDBMS: MS SQL Server 2012/2008R 2/2008/2005/2000 , MS Excel / MSWord / MS Access.

OS: Windows 2008/2007/2003/2000/ NT Servers, XP, Vista, UNIX.

Other Technologies: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Moorestown, NJ

Sr SQL Server/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Responsible for Installation and Configuration of SQL Server 2008 R2 and 2012 database and configuration of Report manager.
• Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Implemented different types of constraints on tables.
• Identified the Data Source and defining them to build the Data Source Views.
• Extensively used Oracle support for resolving technical issues and raising SR’s.
• Extensively worked onViews, cursors, CTE’s, schemas,permissions issues with client/server database design.
• Handling critical Oracle DBA issues and maintaining SLA.
• Used Pentaho to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Experience in using Pentaho gateway service calls to and from Pentaho reports.
• Generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Created daily, weekly, monthly, quarterly, semi-annual and annual SSRS reports.
• Created list reports and cross tab reports using SSRS.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS 2008.
• Used SQL commands and MDX query Language in Pentaho.
• GeneratedComplex reports in SSRS 2012 including Drill Down reportsfromDMR modeled Frame work model.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 11g.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Created C#.net script for Data Flow task to fetch data from server and load it into database through script component.
• Created different Parameterized Reports (SSRS 2000/20 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Assisted in development and documentation of several ASP.NET based applications.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Created reports from cubes by writing MDX queries.
• Create ad-hoc SQL queries for customer reports, executive management reports.

Environment: SQL Server 2012, Pentaho, Oracle 10g, SSIS (2012/2008), SSRS (2012/2008), SSAS 2012/2008,Visual Studio 2010/2013, MS Excel 2010, Cognos 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), Power Designer.

Confidential, Richardson, TX

SQL BI Developer/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in writing scripts for the clients requirements for reporting purposes.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Developed complex T-SQL code for the application.
• Installing and maintaining Oracle GRID CONTROL.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Writing entities in Scala and Scala classes along with named queries to interact with database.
• Extensive work in ORACLE 11g installation, configuration, and upgrading. Developed CLI using python and powershell.
• Create new SSIS Packages to export flat files.
• Performed capacity planning to create Oracle instances and schema objects.
• Developed C#.NET Scripts for Pentaho packages.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Established performance-tuning suggestions for application groups with the help of AWR reports and other Oracle tuning tools/wizards.
• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Gathered functional and non-functional client requirements in order to optimize the design of Pentaho BI deliverables (reports, dashboards, alerts, visualizations).
• Opening Service Requests (SR) with Oracle for solving any issues and Bugs in the Oracle Databases and Oracle Middle-tier Application Services.
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2012/2008 using Oracle 11g as the data source.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Involved in creating SSAS projects using SQL Server 2008R2.
• Maintained report models for ad hoc reports and deployed on report server.
• Worked with Oracle Flashback, created guaranteed restore points during production changes.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Used database maintenance plans for backing up the database and transaction log files.
• Comfortable mentoring others in my team for complex Pentaho reports.
• Involved in creating the tree view folder structure using C#.NET to handle different reports.
• Improved Report Performance and performed unit testing.

Environment: MS SQL Server 2008R2, Pentaho, MS Analysis Services 2008, Oracle 10g & 11g, MS Access, Import & Export Data, Windows 7/8.

Confidential - Long Beach,CA

MS SQL Server/ETL Developer

Responsibilities:

• Installed and configured SQL Server 2005 successfully.
• Developed SQL scripts to Insert, Update and Delete data in T-SQL database tables in OLTP environment.
• Created SSIS Packages which contained different transformations and tasks.
• Responsible for creating and maintaining SQL/UNIX databases.
• Developed enormous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created Tables, Views, Functions, Stored Procedures and Triggers using the SQL Server Management Studio.
• Implemented Clustered and Non-Clustered Indexes, maintained database size and fragmentation levels in order to increase the performance of SQL Queries.
• Improved data load performance by analyzing the database design and query plans and is responsible for the Performance Tuning of the queries.
• Developed and optimized Stored Procedures using input, output, table valued parameters and Query Analyzer.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for creating/migrating undocumented crystal/SSRS reports.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using SSRS.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Experience in managing automated Data Flow, Control Flow, Events and Logging programmatically using Micrsoft.Net framework for SSIS packages.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2 Management Studio, UNIX, SSIS, SSRS, SSAS, T-SQL, Crystal Reports XI, MS Access.

Confidential, Charlotte, NC

SQL BI Developer/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in writing scripts for the clients requirements for reporting purposes.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Developed complex T-SQL code for the application.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and alerts.
• Create new SSIS Packages to export flat files.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2012/2008 using Oracle 11g as the data source.
• Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Involved in creating SSAS projects using SQL Server 2008R2.
• Maintained report models for ad hoc reports and deployed on report server.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Used database maintenance plans for backing up the database and transaction log files.
• Comfortable mentoring others in my team for complex SSRS reports.
• Improved Report Performance and performed unit testing.

Environment: MS SQL Server 2008R2, MS Analysis Services 2008, Oracle 11g, MS Access, Import & Export Data, Windows 7/8.

Confidential

SQL Server Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Installed and Configured SQL Server 2005 with latest service packs.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Error Handling using Try Catch Block.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005

Environment: SQL Server 2005, SQL Server 2005, T-SQL, Visual Basic, Excel

Confidential

SQL Server Developer

Responsibilities:

• Created Tables, Views, Indexes based on the requirements.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.

Environment: SQL Server 2005, Visual Basic, .NET, Excel.