SUMMARY

• 6 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance, Health Care Services.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Experience in different phase of Software Development Life Cycle (SDLC) of development of applications.
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning and had experience in Microsoft Office Performance Point server and power pivot.
• Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
• Created ETL packages usingSSISto move data from various heterogeneous data sources.
• Implemented error handling and roll back process inETLload.
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Proficient in buildingCubes,definingReferenced Relationshipsand creating Hierarchies in SSAS.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in.NET frameworkwith great proficiency in creating applications usingWin Forms, Web Forms, Entity Framework, ASP.NET, C#/VB.NET, ASP.NET MVC, ADO.NET, XML, AJAX toolkit, Cascading Style Sheets (CSS), JavaScript, WCF, WPF,IIS7.0, SQL Server 7.0/2000/, LINQ and Visual Studio.NET.
• Experienced working with different Source and Version Controlling Systems such as Visual SourceSafe (VSS), SVN and Team Foundation Server (TFS).
• Microsoft Certified Technology Specialist.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Systems: Windows server 2012R2/2012/ 2008R2/2008/2003 Advanced Server, Windows 10/8.1/8/7/ XP/2000, UNIX, Linux.

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i, DB2, MS Access 2013/2010/2007 , My SQL.

Database Technologies: SQL Server Enterprise Manager, Data Transformation Services (DTS), DTA, SQL Server Activity Monitor, SQL Server Logs, SQL Server Agent - Jobs, Alerts DB Mail and SQL Mail, SQL Server Management Studio, SSIS, SSAS, SSRS, DBCC, BCP, BIDS - SQL Server Data Tools. SQL Query Analyzer, SQL Profiler, PL/SQL, T-SQL, Power BI, Excel.

Reporting Tool: SQL Server Reporting Services (SSRS), Crystal Reports, BO.

Languages: Java, C, C++, C#, HTML, XML/XSLT, .Net, VB.

Other Tools: Erwin, Microsoft Visio 2003/2000, Microsoft Project/Office 2013/2, ER Studio, Share Point, Web services.

PROFESSIONAL EXPERIENCE

Confidential, Houston,TX

Sr. SQL BI Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R 2 /2012/2014.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for maintaining and updating databases.
• Good SQL Server Administration skills including Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
• Optimized indexes to improve queries and analysed database performance with SQL Profiler.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Excellent proficiency in the usage of Cognos tools such as Framework Manager, Report Studio, Query Studio, Analysis Studio, and Power play Transformer.
• Experience in developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filters and schedules in Cognos.
• Developed many cubes for reporting based on the business requirements using SSAS.
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS 2008 and SSRS 2008.
• Calculated measures like PMPM, unit count, days count, year over year compared and utilizations were developed using MDX
• Worked on developing SSAS calculated measures using MDX. Also, worked extensively on cubes deployment and setting up Roles for user's access.
• Developed several Ad-hoc reports according to the customer requirement and the Cubes using SSAS and MDX.
• Well proficient with all aspects of SDLC practices and highly experienced in Agile Development environments in building process flows for Message Queue processing and Web Services.
• 24x7 production support of MQ and Message Broker in Distributed, Mainframe and Windows environments.
• Handled various administrative tasks for MQ like adding certs to keystores, creating queues, clusters but not limited to the above
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Provide technical enablement to clients developing BI solutions with Power BI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Provide technical enablement to clients developing BI solutions with Power BI.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Wrote MDX queries to access data from OLAP cubes in SSAS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyse performance of Strategic Business Units as well as corporate centres.
• Created several cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyse performance
• Expertise in developing and deploying plug-ins, custom workflow activities and java script extensions for MS CRM.
• Experience in Microsoft Dynamics CRM Data integration towards import/export of data using SSIS and custom application development.
• Experience in translating requirements into solutions with proper dependencies and preparing strategic development plan in MS CRM.
• Involved in development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Used TFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Created script tasks and components C#.Net in SSIS as part of ETL load.
• Responsible for unit testing and integration testing complex queries.

Environment: SQL Server 2008R2/2012/2014, T-SQL, SSIS, SSRS, SSAS, Team Foundation Server (TFS), Windows Server 2008R2/2012, C#.Net, SharePoint 2010, Crystal Reports 9.0.

Confidential, MN

Senior SQL Server Developer

Responsibilities:

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed.
• Responsible for managing BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Performed backup/restore database objects such as tables, procedures, triggers, constraints, indexes and views.
• Migrated SQL server 2008R2 to 2012.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2012.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite (Framework Manager, Report Studio and Transformer).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Developed Reports with Multiple Cognos Viewers and with Multiple Cognos Reports developed Complex Reports, Dashboards for Mobile and IPad Report Applications.
• Responsible for creating and executing Test cases, performing UAT and documenting the results.
• Integrating and managing SSRS reports in SharePoint environment.
• Responsible to create and deploy Data sources, data sets, reports to the SharePoint document library.
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Worked with SQL Server Analysis Services (SSAS) that delivers Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008/2012.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2008/2012 and in adding calculations using MDX.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Performance tuning the existing reports.
• Worked on Team foundation server (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.
• Created script tasks and components with VB in SSIS as part of ETL load.
• Worked in an Agile Scrum model and collaborating with Scrum Master, QA, Product and Development Teams using Agile.

Environment: SQL Server 2008R2/2012, SSIS, T-SQL, SSRS, SSAS, Team Foundation Server(TFS), Windows Server 2003/2008R2/2012, VB.Net.

Confidential

Junior SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• 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.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• 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 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members.
• 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.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle, Visual Basic, Excel.