SUMMARY:

• Around 8+ years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Knowledge in property and Causality insurance types.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/ Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing with high volume transactional data in SQL
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services(SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS)
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS).
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

Databases: Oracle 8/8i/9i/10g/11g, DB2, Sybase, MS Access, MS SQL Server 2005/2008/2012, TeraData, MySQL 5.5

Dev. Tools: Oracle Developer Suite, T.O.A.D, SQL Navigator, Micro Soft Visual Studio

Languages: PL/SQL, T-SQL, C, C#, SAS, COBOL, JCL, Pro*C, ABAP/4, Unix Shell Programming, Squirrel SQL, SQL Navigator, SQL i Navigator

Data Modeling Tools: ERWin, ER/Studio, IBM RationalRose, Oracle Designer, MS Visio, Power Designer, OmniGraffle

Methodologies: SDLC, Agile and Kanban/Scrum Methodology using Jira, Sol. Deliverable Methodologies (SDM)

DBA Tool: Oracle Enterprise manager, O/S Windows, Windows NT, Unix, MVS, Linux, AS400, Apple Mac

Hardware Mainframe: 3970 Emulator, SUN Solaris, IBM-PC, PDP11

Project Mgmt.: Micro Soft Project, IBM- Rational Clear Case and ClearQuest

ETL Tools: Informatica (power center 7.0/8.0), MS SSIS, Cognos Data Manager, SAP Designer Services (BODS)

Reporting Utilities: Oracle Reports, Micro Soft Reporting Services 2008/2012, Callidus Software (Actuate Report), Crystal Reports, Cognos and Tableau Reports v9.0, MS Analysis services, QlikView, Mercury Gate - Edge. OBIEE 10.1.3.4, BI Publisher 10.1.3.4

Version Controls: Visual Source Safe, SVN, Clear Case, Mercurial, SourceForge, Visual Source Studio, Team Foundation Server

WORK EXPERIENCE:

Developer

Confidential - Los Angeles, CA

Responsibilities:

• Worked with Technical Architect to design the vault to house data from various data sources for all reporting needs.
• Worked on creating packages like Maps, Contents and Links for the Vault.
• Implemented Star schema to design the cube.
• Design and Developed new SSAS Tabular Models, which uses xVelocity (formerly Veritpaq) in-memory engine.
• Conducted Web Application Quality Assurance duties in an AGILE Development Environment.
• Developed the necessary project plan based on Agile Principles, timelines and schedules related to client's infrastructure and workflow needs for the scope of the project
• Data Modeling Star Schema, Snowflake schema, FACT and Dimensions, Erwin 4.5/4.0,Physical and Logical data modeling.
• Good experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas,OLTP/OLAP system, Fact and Dimension tables,Conceptual,Logical and Physical data modeling by using Erwin.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas. Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Developed C# scripting for packages.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Worked with SSIS packages involved FTP, send mail, script tasks, Merge, and Merge joining Control Flow Transformations.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Used SSIS to create ETL packages to validate, extract, transform, and load data into data warehouse and data marts.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending the error records to a different team.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: ETL, SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012, Oracle 9i/10g, TFS, Tableau, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

Developer

Confidential

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Exposed various capabilities such as Web Services using Restful Framework (Spring MVC Framework)
• Responsible for logical and physical design of SQL Server databases.
• Familiar with SAP BODS and worked with team in creating Batch jobs and running the jobs manually.
• Experience working on Azure SQL Databases and Azure Dataware house.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Using SAP data designer to create work flows, data flows etc.
• Migrated SQL Server 2008 database to windows Azure SQL Database and updated Connection Strings based on this.
• Experienced on creating multiple kind of report in Power BI
• Performed Data Modeling in ER Studio Data Architect 9.0 in the initial stages of the project.
• Developing the power BI reports using the connection string like SQL server, SSAS and T-SQL statements.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Designed the application by implementing Spring framework based on MVC.
• 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 Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Responsible for creating SQL databases for Power BI and Ad-hoc reports.
• Knowledge connecting Microsoft Power BI Desktop to various data sources. SQL Server is preferable
• Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
• Integrated the application with spring framework.
• Involved actively as a part of team for collecting and analyzing the needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS and Crystal reports.
• Managed and troubleshoot report server related issues.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to user communities.
• Knowledge of importing COBOL data structure.
• Configured SQL mail agent for sending the error records to a different team.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures & long running SQL queries using indexing strategies & query optimization techniques.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: MS SQL, T-SQL,SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012,MS Azure, TFS, Java, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

SQL Server Programmer/SSRS/SSIS/SSAS

Confidential - Hartford, CT

Responsibilities:

• Written T-SQL Queries, Dynamic-queries, sub-queries and Complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Involved in system analysis & design of the Enterprise data warehouse implementation
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Involved in Creating Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Prepared and used test data & test cases to verify accuracy and completeness of ETL, report process.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS).
• Generated various reporting services using SSRS for Financial DW reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2012/2008 R2, T-SQL, SSRS, Windows 7, MS Access, SQL Profiler, MS Excel, ASP.Net, Erwin 9.6, SharePoint 2013.

SQL Server Developer

Confidential, CO

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SSRS.
• Created/developed stored procedures, triggers, views, &user-defined functions to support application development.
• Deployed and configured the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data, tested database to meet functionalities deliverables in project documentation & specifications.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

SQL Server SSRS/SSAS

Confidential - Charlotte, NC

Responsibilities:

• Written Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex).
• Involved in creating groups and measures, KPIs.
• Worked on using SSRS gateway service calls to and from SSRS reports.
• Creating tables, relationships, triggers and indexes for enforcing business rules
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Used Tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005.
• Worked on Hash functions and checksum for loading large amount of data on Target system.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the ETL loadings.
• Configured SQL Mail agent sending Automatic emails when a SSIS Process is failed or succeed.
• Mentored others in my team for complex SSRS reports.
• Involved in Data Transformation Activities using DTS Import/ Export for transferring data between different databases like oracle. Design new DTS packages as per needs, Resolve the problems.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008, SSIS, MS Visual Studio 2008, Oracle SQL Developer, Erwin 9.6.

SQL Server Developer

Confidential

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• 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.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.