PROFESSIONAL SUMMARY

• Over 7years of extensive IT professional experience wif Expertise in Microsoft Business Intelligence tools (BIDS)SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and designing reports using SQL Server Reporting Services (SSRS).
• Expertise in Database development, Database modeling and Design using SQL Server 2012, 2008R2 and 2008in various domains likeBanking, Finance, Health Care and Insurance as SQL Server Developer and MSBI Developer.
• Sound noledge in all phases of SDLC (Software Development Life Cycle) Initiation, Requirement Analysis, Software Design, Development, Acceptance, Implementation, Testing and Maintaining triple constraint project scope, on time, on budget for information technology projects.
• Extensive experience wif different phases of project involving project initiation, project requirement and specification gathering, designing system, coding, testing, and debuggingnew and existing client - server based applications.
• Experience in Extracting, Transforming and Loading teh data using SSIS in SQL Server 2008R2.
• Experience in creating packages using Active X Scripts, performance tuning in SSIS, error and event handling, precedence constraints, break points, transactions, check points and logging using SSIS.
• Proficient in data migration between homogeneous/heterogeneous systems and SQL Server using SSIS,BULK INSERT and BCP.
• Expert in data migration from OLEDB/EXCEL/FLAT fileto SQL Server using SSIS through data flow tasks, look up transformations and script tasks.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view,SSASData Mining Models and Deploying and Processing SSAS objects.
• Experience in creating teh MDX queries to access cubes and dimensions, also creating complex SSAS cubes wif multiple fact measure groups, KPIs, dimension usage, calculated members, perspectives and hierarchies based on teh OLAP reporting needs.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization, besides providing security by providing perspectives.
• Design and Develop new SSAS Tabular Models which uses xVelocity in-memory engine.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Created PowerViewReports using teh TabularSSASmodels in Excel 2012.
• Extensively used DAX (DataAnalysisExpressions) functions for teh Reports and for teh TabularModels.
• High expertise in creating reports using SSRS (Ad-Hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular and parameterized reports).
• Experience in XML scripts, Dimensional Modeling, working wif XML Documents.
• Extensive experience in reporting tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports.
• Deploy reports, secure access, and schedule execution of reports and deliver them to teh Web using reporting manager, Share Point, email recipients, file shares, and more, on a scheduled basis.
• Expertise in Relational and Dimensional Data Modeling, Data Mapping, RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Warehouses. Experience in design and implementation of On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP).
• Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables, Row-level audit tables, user-defined data-types, Views, Indexes and T-SQL queries (DDL and DML).
• Diagnosed performance tuning, query optimization, client/server connectivity and running database consistency checks.
• Extensively worked on DDL/DML techniques, joins, sub queries, passing variables, looping, dynamic SQL, managing indexes and deadlocks (troubleshooting).
• Experience in using tools like Database EngineTuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in developing application using Visual Studio.NET MVC 4 - C#, ASP.NET, ADO.NET, Web Services, Silver Light, MVC.
• Working noledge of ASP.NET MVC pattern: Controller Actions, View Engine, HTML Helper methods, Entity Framework Model.
• Working experience in using JavaScript, HTML, XML, XSLT, CSS, Master Pages, Themes and Skins.

TECHNICAL SKILLS:

ETL Tools: SSIS (SQL Server Integration Services), Data Stage, Import Export Data, Bulk Copy Program (BCP).

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau.

IDE & BI Tools: SQL Server Data Tools (SSDT), Visual Studio 2012, SQL Server Management Studio (SSMS), SQL Query Analyzer, SWIFT Tool, SQL Enterprise Manager, Analysis Manager, Reporting Server, Power Pivot.

Databases: MS SQL Server 2012/2008R2/2005, Oracle 9i/8.x, MySQL.

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, C#, Java, JavaScript, VB.Net, HTML, XML.

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling 1.1 using Rational Rose.

Version Control: Team Foundation Server (TFS).

Operating Systems: Windows, IOS, UNIX and LINUX.

Other Software: MS Office, MS SharePoint, VB (Macros).

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

MS SQL Server Developer

Responsibilities:

• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Created partition function, schema and file groups for fact tables.
• Involved in teh design, development and maintenance of different cubes using SSAS.
• Worked on developing teh business requirements and use cases forPROS Scientific Analyticsbatch processes; automating teh billing entity and commission process.
• Involved in pricing adjudication process of PROS Scientific Analytics application.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan and Performance Monitors.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks.
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to teh MS SQL Server and maintaining proper security procedures.
• Worked on administration tasks such as data loading, batch jobs, configuring, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups, transaction logs.

Environment: MS SQL Server 2012, SSAS, Windows 2012 Server,Linux, PROS Scientific Analytics,MS Excel 2013

Confidential, Columbus, Ohio

MS SQL Server BI Developer

Responsibilities:

• Generate multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS).
• Report parameters included single valued parameters, multi-value parameters dat also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize teh report execution time and to limit teh number of records required.
• Designed complex SSRS reports, Excel templates and integrated automation methods as appropriate.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Wrote complex T-SQL batches wif Common Table Expressions (CTE’s) for recursive operations.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Created SSIS process design architecting teh flow of data from various sources to target.
• 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.
• Deployed teh SSIS package on various servers using package configuration from test server to production servers. Performed Bulk data migration using SSIS from flat files.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan and Performance Monitors.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Designed models using Framework Manager and deployed packages to teh Report Net Servers. Created pages in teh reports to display depending on Prompt values.
• Design and Develop new SSAS Tabular Models which uses xVelocity in-memory engine.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Created PowerViewReports using teh TabularSSASmodels in Excel 2012.
• Extensively used DAX (DataAnalysisExpressions) functions for teh Reports and for teh TabularModels.
• Used efficient task objects, connections, work flows in packages based on data volumes and data sources.
• Involved in project status report updates, creation of issue items for reviews, updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2012,Visual studio 2010, SSIS, SSRS, SSAS,Windows 2012 Server

Confidential, Miami, Florida

MS SQL Server BI Developer

Responsibilities:

• Involved in designing teh physical database model on SQL Server 2012 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Created SSIS process design architecting teh flow of data from various sources to target.
• 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.
• Deployed teh SSIS package on various servers using package configuration from test server to production servers. Performed Bulk data migration using SSIS from flat files.
• Generate multiple Enterprise reportsfrom SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS).
• Report parameters included single valued parameters, multi-value parameters dat also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize teh report execution time and to limit teh number of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Delivering reports to Microsoft Share point using Report Manager and Report Viewer.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures.
• Wrote C#, VB.NET Code for Script Task in SSIS 2012.
• Also responsible for transferring data from Production Server to teh Development Server occasionally on Incremental Basis for teh purpose of checking teh consistency in data.
• Used teh WCF services as teh major component in communicating wif teh data access layer.
• Implemented WCF Web service for Integration wif other Inbound Applications using .Net 4.0, C#, WCF ADO.Net Entity Framework, XML, XSLT,SOAP and SQL Server 2012.
• Created Rest Web Services to communicate between SOAP Web Services and UI.
• Implemented MVVM, consumed WCF services for presentation layer using C#, Visual Studio2010
• Involved in Development of data access, business and Application layer using LINQ, C# AND ASP.NET.
• Developed Console Application using C# Link Entity Framework.
• Involved in project status report updates, creation of issue items for reviews, updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2012, Visual Studio 2010, SSIS, SSRS, SSAS, Windows 2008 Server, Service Broker, MS Excel 2010, SharePoint (MOSS) 2007.

Confidential, Pleasanton,California

MS SQL Server BI Developer

Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL Server2008R2.
• Used various transformation components in teh data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Migrated data using ETL Tool in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat files or excel files.
• Developed multiple reports using reporting services.
• Creating functions and developing procedures for implementing application functionality at teh database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating teh integrity of teh data.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle teh data migration from SQL Server 2005 to 2008R2periodically.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Created datasets for reports using T-SQL and stored procedures.
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization, besides providing security by providing perspectives.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Worked on developing teh business requirements and use cases forFACETSbatch processes; automating teh billing entity and commission process.
• Involved in claim adjudication process of FACETS application.
• Created parameterized reports, Drill down, Drill through, Sub reports, linked reports, Snapshot, Cached and Ad-hocreports using SSRS.
• Created complex variables, multiple breaks, sorts in teh reports.
• Created Tabular and Matrix reports using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment:MS SQL Server 2008R2 Enterprise, SSIS, SSRS,C#, ASP.NET, ADO.NET, XML, T-SQL, Visual Studio 2010, Windows 2008 Server, MS Excel, MS Access, FACETS.

Confidential, New York

MS SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008R2.
• Created Views to maintain security of customer data.
• Created Indexes to get teh high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call teh packages.
• Created ETL packages wif different data sources and loaded teh data into destination tables by performing complex transformations using SSIS packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, complex joins, column conversions, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task etc. to generate underlying data for teh reports and to export data from Excel Spreadsheets, Text files, MS Access and CSV files.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used Data Defractor tool to normalize semi-structured Spreadsheets, fed it into teh SSIS pipeline in teh form of normalized output of factual data and contextual metadata.
• Deployed teh packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and tan loaded teh data into destination tables by performing different kinds of transformations using SSIS..
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Used ASP.NET 3.5 and C# to develop teh application.
• Used HTML, JavaScript, and JQuery to design and developed dynamic ASPX web pages.
• Created Cascading Style Sheets (CSS) to apply styles to teh various Web server controls used in designing teh web forms of teh application.
• Used ASP.NET AJAX to implement teh rich client functionality, theirby achieving performance enhanced application.

Environment: MS SQL Server 2008R2, Visual Studio 2008,.NET Framework 3.5, ASP.NET 3.5, C#, ADO.NET, JQuery,TFS, AJAX, WCF, CSS, JavaScript, HTML, Windows 2008 Server, SSIS, SSRS, SSAS, Oracle10g, SharePoint(MOSS) 2007.