PROFESSIONAL SUMMARY:

• 8 years of Professional experience in database programming data modeling, data design development and implementation of Data Warehouse solutions.
• Experience in Logical & Physical Data modeling, data architecture designs.
• Excellent command on MS SQL Server 2005/2008/2012 /2014 in constructing triggers, tables, Joins, cursors, views, indexes, User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• Expert in Microsoft SQL Server 2012 and 2008 backend programming, Extensive experience in creating database objects on MS SQL Server 2012 and 2008.
• Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012 for Batch Processing using DDL, DML, DCL commands for various business applications and Data Warehousing Systems (SSRS, SSIS, and SSAS).
• Experience in database programming in writing T - SQL Stored Procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins and experience in creating scheduling Jobs, sending Alerts.
• Experienced in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, Oracle, SAP, and SQL Server) and loading for data warehousing using SQL Server Integration Services (SSIS).
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in developing management reports by using SSRS (SQL Serving Reporting Tools).
• Strong experience in creating Ad Hoc Reports parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL Server 2008R2, 2012 and 2014.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Very good experience in writing expressions in SSRS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Knowledge in Tableau Desktop for data visualization through various charts such as Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)Experience in working with large databases in SQL, Oracle, and Teradata.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support

TECHNICAL SKILLS:

RDBMS/Databases: MSSQL Server 2005/2008/2012 /2014, Oracle 10g/9i, MS Access 97/2000/2003/2007, MYSQL

ETL Tools: SQL Server Integration Services (SSIS), DTS, BCP, Informatica Power Center 9.5x

Reporting Tools: SQL Server Reporting services (SSRS), Power BI, Tableau, Crystal Reports 9.0/8.0

OLAP Tools: SQL Server Analysis Services (SSAS) 2008

Performance Tuning Tools: SQL Profiler, DTA (Data Tuning Advisor)

Operating systems: Windows 9X/2000/XP/NT, MS-Dos, Unix, and Solaris

Back-end Language: T- SQL, PL-SQL, XML,JSON.

Front-end Language: C#

Web Applications: ASP.NET 2.0, SOAP, HTTP, Internet Information Services (IIS 6.0), FTP, TCP/IP, LAN, MS-Outlook Express

Scripts: T SQL, VB, JavaScript, PHP

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

Power BI Developer/SQL BI

Responsibilities:

• Conducted DB management, Performance measurement and Performance tuning for new databases by using SQL Profiler, Data Engine Tuning Advisor and Index Tuning Wizard
• Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema.
• Development and Creation of Complex Stored Procedures, Triggers and Functions.
• Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.
• Usage of Active Directory for identity management design for providing strong authentication and authorization for internal and external websites.
• Management of Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.
• Implemented different types of constraints on the tables. Usage of Try Catch and @@error for exception handling.
• Development of physical and logical data modeling tools such as Erwin and ER/Studio
• Generation of periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS).
• Creation of Cross Tab Reports, Drill-down, Drill-through and Sub-Reports using RDL.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Migrate existing data into the Power BI.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Assisted in the conversion of existing PowerBuilder code to PL/SQL and Java to support a new Flex application.
• 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
• Managed up gradation of DTS packages to SSIS packages.
• Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files to SQL server 2014.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) 2014/2012 and worked with users in training and support. Also had experience with incremental data loading.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed multi-dimensional objects (cubes, Dimensions) using SSAS.
• Expert in creating Star schema cubes using SSAS.
• Involved in analyzing, designing, building & testing of OLAP cubes with SSAS 2014 and adding calculations using MDX
• Responsible for maintaining cubes using SSAS and populate cubes with data.
• Involved in development of ASP.NET/ C# / SQL Server Web Applications.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

Environment: SQL server 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, Power BI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.

Confidential, Richardson, TX

Power BI Developer /SSRS/SSIS/SSAS

Responsibilities:

• Involved in writing scripts for the client’s requirements for reporting purposes.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Created ETL packages using SSIS to extract data from different data sources reformats the data and load the reformatted data into destination tables.
• Used reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2012.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008/2012.
• Created various visualizations and reports using Power BI.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS).
• Purchasing, setting up, and configuring a Tableau Server and MS-SQL 2012 server for Data warehouse purpose.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS, T-SQL, Access, Tableau, Tableau Server, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, ER Win 4.0, Visual Studio.NET 1.1, IIS, ASP, C#, Oracle 9i.

Confidential, NYC, NY

MS SQL/SSIS/SSAS Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship (ER) diagrams.
• Created complex stored procedures, Triggers and user defined functions using complex joins and T-SQL for supporting both OLTP Application and Enterprise Data warehouse.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries. Developed data Mappings between source systems and warehouse components.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business.
• Extensively worked on performance tuning of the ETL process and SQL optimization on a large database.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS).
• Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 9.0
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS, T-SQL, Access, Tableau, Tableau Server, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, ER Win 4.0, Visual Studio.NET 1.1, IIS, ASP, C#, Oracle 9i.

Confidential, Boston, MA

SQL Server /SSIS/SSRS

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Implemented SSIS data transformation scripts and created maintenance procedures and provided data integrity strategies.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Utilized SSIS to produce a Data Mart for reporting.
• Created Stored Procedures to validate the data coming with different data discrepancies using data conversions.
• Developed SSIS solution for developing a full-fledged data warehouse solution.
• Developed, monitored and deployed SSIS packages,
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Actively supported business users for change requests and assisted in migrating renormalized report DB into Star schema design.
• Wrote the queries for the Drill Down reports.
• Identified and added the Report parameters and formatted reports using the global variables and expressions.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Responsible for creating the reports basing on the requirements using SSRS 2005/2008.Identified the database tables for defining the queries for the reports.
• Generated SSRS Enterprise reports from SQL Server Database (OLTP) and SQL Server and included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Report Parameters included single valued parameters, multi-value parameters which also consist of different parameter types hidden, internal, default (queried and non-queried parameters).
• Created Linked reports, Ad-hoc reports which based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SQL Server 2008/2012, T-SQL, Access, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, Visual Studio.NET 1.1, ASP, C#, Oracle 9i.

Confidential

SQL Server/ SSIS/ SSRS

Responsibilities:

• Development of complex programs in T-SQL/PL-SQL by writing Triggers, Stored Procedures and Queries with best execution plans.
• Creation of User Defined Functions to encapsulate frequently used business logic making the system more flexible, Secured and extensible.
• Wrote SQL queries to upgrade performance using SQL Server 2008 R2/2012
• Worked on metadata for populating data in EXCEL 2012 Using SQL macros
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS)
• Generated several drill-down and drill through reports using SSRS.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server 2012/ 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2010, TFS (Share Point), Visual Basic6.0/VB.net, VB Script and Windows Server 2008.

Confidential

SQL Server/ BI Developer

Responsibilities:

• Worked as a developer on databases like MS SQL server 2005, MS Access.
• Worked in Enterprise Manager for job scheduling and batch queries. Installed and maintained MS SQL Server 2005.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user-defined functions (UDF’s).
• Imported XML data file and put into the desired database.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Developed DTS packages to transfer the data between SQL server and other database and files.
• Designed and implemented the logical and physical model of the database using ERWIN.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy/exact lookups.

Environment: Windows 2003 Server, IIS 6.0, Windows XP/2000, MS SQL Server 2000/2005, Excel 2003, Access 2003, Visual Studio 2005, ODBC, Database Engine Tuning Advisor, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential

Jr.SQL Server/ BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL 2005 SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and schedule those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Designed the Connectivity layer between the application to the database using ADO.NET
• Designed Connectivity for the database and front-end by using Microsoft Application blocks and Connectivity for the Share point and Front end using Share Point Web Services.

Environment: MS SQL Server 2008, SSAS, SSIS, SSRS, Windows XP, Management Studio