SUMMARY:

• 5+ years of experience in Database Design and Development with SQL server 2008 R2/2012 system in both OLTP and OLAP environment, Informatica, C# and ASP.NET
• Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, DynamicSQL, Triggers and Cursors.
• In - depth knowledge of DDL, DML, and DCL, PL/SQL.T-SQL
• Extensive experience in using Microsoft BI Stack( SSIS, SSRS, SSAS )
• Excellent in High Level Design and development of ETL Packages using DTS/SSIS for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided such as Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables.
• Profound Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS) and writing MDX queries.
• Good in dimensional data modeling using SSAS, cube partitioning, optimization, creating aggregations.
• Strong knowledge of Data Warehousing methodologies and concepts including Star Schemas, Snowflake Schema.
• Database administration work such as providing access to the user, replication, QA as well as production deployments, SQL Diagnostic, query performance, relational/analytical database backup and recovery, databaseconsistency checks using DBCC and technical support.
• Self-motivated, works well independently, Strong communication skills, strong analytical skills and a good team player.
• Ability to drive insight by designing visualizations with logical and meaningful data flow and ability to see patterns.
• Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology.

TECHNICAL SKILLS:

Operating Systems: Windows 2000 Enterprise/Advanced Server, Windows Server 2003XP Professional, Windows 7

Databases: MS SQL Server 2012/2008 R2/2005/2000, MS Access, Oracle 9i

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, Import/ Export Wizard, SQL Server Management Studio, Index Analyzer, Business Intelligence Development Studio(BIDS), SQL Server Data Tools(SSDT), vast experience in SSAS, AzurePower BI

Reporting Tools: Tableau 8.0,8.1 Reporting Services (SSRS) 2008/2005,Performance Point, Microsoft Excel Reports, crystal reports, Trizetto QNXT, Cosmos, Share point, Power BI

External Tools: Quality Center, MS Visio, MS Office, IBM Lotus Notes 8.5.2,Microsoft Outlook

Domain: Finance/healthcare/Insurance

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL/BI Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss reporting solutions.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS services.
• Created ETL process to extract data from legacy systems.
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 R2 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Generated a multidimensional dashboard report using SSRS reports and MS Excel pivot tables showcasing performance of employees based on the satisfaction survey report, productivity, and individual turnover time for each application which is published monthly, quarterly and yearly basis.
• Worked on complex SQL queries with multiple joins on SSRS in order to build reports as per the requirement of the business
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Experienced in creating restricted Key Figures, calculated Key figures, structures, Variables, exceptions conditions and report to report interface (RRI).
• Involved actively in supporting the various issues addressed by the users from the client side and providing them with required solutions.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Environment: SQL Server 2012/2008 R2, SSAS, SSIS, SSRS, Import/Export tools, Sql server Data Tools (SSDT), PL/SQL, SQL Server Agent, T-SQL, Team Foundation Server.

Confidential, Cedar Rapids, IA

SSIS/SSRS Developer

Responsibilities:

• Analyzing and gathering Business requirements from the users and convert it into technical reporting specifications.
• Involved in designing the OLAP system.
• Performed extensive ETL operations using the SSIS Import/Export Wizard
• Worked on Data Mining for the existing Application.
• Develop and deliver dynamic reporting solutions usingSQLServer2005 Reporting Services (SSRS)
• Used SSRS to create ad-hoc, parameterized, drill-down and drill-through reports for insurance companies.
• Designed and implementedSQLServer2005 databases for mission-critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture
• Created SSIS packages to transfer data from Oracle toSQLserverusing different SSIS components and used configuration files and variables for production deployment
• Extensively used the dataflow task to transfer data from Oracle toSQLserverusingSQL commands like data conversion etc.
• Created the derived columns from the present columns for the given requirements.
• Create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.
• Creating customSQLqueries in the form of derived table in the universe to meet the ad-hoc requirements.
• Extracted the data from MS Access andSQLServerto SSIS for generating reports.
• Improving the performance of reports by tuningSQLQueries, Universes by using Aggregate Awareness, Short Cut Joins, tuning at Database level by creating Indexes, Views.
• Thorough understanding of Data Warehousing analysis concepts like Star Schema, Snow Flake Schema, OLAP.
• Working on Extract, Transform & Load Process like Writing MSSQL, Procedures, Scheduling Jobs, using various Transformations usingSQLServerIntegration Service.
• Created and modified Dashboard pages in SharePointserverthat use Excel Web Access web parts and reporting services web parts and Used Excel Services for reports and web parts.
• Developed stored procedures (T-SQL/PL-SQL), functions, views and triggers.
• Created indexes, Constraints and rules on database objects.

Environment:SQLServer2008, Crystal Reports, Oracle 10g, SSIS, SSAS, SSRS, MS Access, Windows 2008, ETL, Microsoft Office SharePointServer(MOSS) 2007, UNIX, IIS, Excel

Confidential, Minneapolis, MN

SQL server Developer

Responsibilities:

• Created SSIS Packages to load data from Oracle toSQLServer.
• Successfully migrated data from multiple Heterogeneous/Homogeneous Environments intoSQLServer2008 using BCP (Bulk Copy Program), Bulk Insert and SSIS Packages.
• Used ETL for data flow from source files like XML, Excel to other databases like MS Access, Oracle.
• Created Event Handlers for SSIS package on Error, on Post execute.
• Developed custom interface for executing and managing SSIS packages.
• Used Lookup transformation in SSIS to get the data from reference data sets.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on the partition of the cube.
• Defined unknown members and null processing properties in SSAS 2008.
• Designed Dimensions and used the MDX for the various Optimizations like Optimizing cube schema.
• Responsible for identifying Key Performance Indicators (KPIs) in SSAS 2008.
• Monitored and analyzed the performance and results of the organization using Dashboards and KPIs in Performance PointServer(ProClarity).
• Created complex Stored Procedures, triggers, cursors, tables, and views and otherSQLjoins and statements for applications by using T-SQL.

Environment: MSSQLServer2008, BIDS, SSIS, SSAS, Cubes, OLAP, OLTP, UML MDX, T-SQL, Crystal Reports, Query Analyzer, .Net, Oracle 10g, Performance PointServer

Confidential, Philadelphia, PA

SQL/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.
• Played a major role in production support of SSAS cube and SSIS jobs.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources
• Data blending implemented on databases and generated interactive dashboards.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Generated tableau dashboards for sales with forecast and reference lines.
• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, 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 Excel Spreadsheets, CSV files to data warehouse.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.

Environment: SQL Server 2008/2012, SSAS, SQL Server Integration Services 2008, Oracle 11g, SQL Server Reporting Services 2008, PL/SQL, Microsoft Visual Studio 2010, Share point server.