PROFESSIONAL SUMMARY:

• Having 6+ years of IT experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2000/ 2005/2008/2012/2014 .
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 forboth OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client-server based applications.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Excellent noledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV’s and Efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...
• Strong noledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 across various environments.
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Expert and proficient in highly analytical & detailed reports dat include drilldown, drill through, parameterized (Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014 .
• Extensive experience in SQLServer Analysis Services OLAP Cubes, and Data Mining.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Good noledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• Developed cubes using Partitions added teh Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.

TECHNICAL SKILLS:

BI Tools: SSIS, SSAS, SSRS, Power BI, Business Intelligence Development studio (BIDS), Visual Studio

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Application package: MS Office Suite, Visio

Tools: SQL Server Enterprise Manager, Management Studio

Protocol: FTP, TCP/IP, Named Pipes

Databases: SQL Server 2005/2008/2012/2014, Access, MySQL, Oracle 10g, 11g.

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, MS-DOS, Red Hat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Manalapan, NJ

SQL BI Developer

Responsibilities:

• Gathered requirements from teh business users, created technical specification documents.
• Designed and reviewed teh new report standards in order to ensure optimized performance under teh new reporting service SSRS 2005/2008.
• Planned, designed and documented teh optimum usage of space requirements and distribution of space for teh Data Warehouse.
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2005/2008 R2.
• Extracted teh data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into teh target Data warehouse using SSIS (SQL Server 2005).
• Created OLAP cubes on top of teh data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008 R2.
• Involved in setting up and implementation of teh 2005/2008 reporting server.
• Created complex reports using SSRS 2005/2008 R2 from teh OLAP cubes for end user analysis.
• Migrated reports from MS SQL Server Reporting Services R2.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2005/2008 R2 using data from a variety of sources.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Scheduled teh reports on capacity levels of different servers to run on daily/weekly/monthly basis and email teh results to teh business users in teh required format.
• Scheduled tasks to run every day to update changes in teh base tables.
• Added/modified Users, Groups, folders and rights.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.

Environment: Microsoft SQL Server 2005 and SQL server 2008R2, SSIS tools (SSMS, BIDS and SQL Server Manager), SSRS, Business Objects, MS Visio, Oracle, MS Excel, Windows Server

Confidential, Lincolnshire, IL

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).
• Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Used try-catch block to handle teh errors and to store all teh errors in a table to handle them later and to continue teh flow of execution.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can no when a row is inserted in custom logging table by every SSIS package dat executes.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Created OLAP cubes on top of teh data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).
• Created and modified various complex Stored Procedures used in teh application using T-SQL.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions for SSRS with Conditional Formatting.
• Responsible for Deployment of teh report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Tuned SQL query for better performance using SQL Profiler. Documented all work, so user can easily understand teh flow of process.

Environment: Microsoft SQL Server 2014, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, BIDS 2012/2014, MS Visio, Oracle 9i, MS Excel, Windows Server.

Confidential, Rosemead, CA

SQL/BI Developer

Responsibilities:

• Participated in requirement gathering, cube design, application design and SSAS development.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on teh OLAP Reporting needs.
• Implemented SQL Server OLAP services (SSAS) for building teh data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing teh data.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying teh data with MDX script.
• Defined MDX scripts for querying teh data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2012/ Business intelligence development studio.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created and designed SSAS cube and promoted to production using XMLA scripts.
• Designed and implemented parameterized, drill-through, drill-down, and tabular reports on SSRS using SSAS cube for performance point.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Created and scheduled SSIS package to nightly process teh SSAS cube based on oracle data mart tables updates.
• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
• Implemented/Developed multi parameterized reports in Report Builder and SSRS using SSAS cube allowing users to make selections before executing teh reports and making it more users friendly.
• Worked with SQL profiler to improve and enhance teh MDX query execution time as a part of performance tuning process.
• Wrote several complex stored procedures for efficient handling of teh application.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.
• Involved in teh designing, development, modification and enhancing teh database structures and database objects.

Environment: s: SQL Server 2012/2008 R2, T-SQL, SSRS, SSAS, SSIS, MS Visio, performance point services, Power Pivot, Report Builder, Excel, Windows.

Confidential, Stamford, CT

SQL Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in teh SSIS packages.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Created custom and Ad hoc reports using SSRS.
• Generated different types of Reports like Tabular, Matrix, Charts, Drill Down and Drill Through reports using SSRS.
• Deployed reports, created report schedules, subscriptions, securing reports.
• Identified teh Data Source and defining them to build teh Data Source Views.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling teh subscription reports with teh subscription report wizard.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries dat involve data from multiple tables.
• Fine tuning of stored procedures to improve teh performance.
• Performed Performance tuning on SQL queries, triggers and stored procedures.
• Used Audit functions to keep track of teh changes made to teh database.
• Had to modify teh current stored procedures to meet teh current design.
• Responsible for creating indexed views, and appropriate indexes to cut teh complex query time.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Wrote T- SQL queries for data retrieval.
• Took part in teh normalization and de-normalization of database.
• Worked with team in developing interfaces using C#.NET.

Environment: SQL Server 2005, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2005 and Team Foundation Server.