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.
• Outstanding skills in using Client/Server architecture in implementing MS SQL Server based applications.
• Experience with Backup and Recovery of MS SQL Server Databases. In - depth knowledge of T-SQL (DDL and DML).
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience working with PowerBI Reports
• Proficient in implementing all transformations and migration of DTS packages in SSIS toolbox.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, OLEDB to Access.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export, SSIS packages, and DTS package.
• Experience in creating new reports and ad-hoc reporting in SSRS, Installed, configured and maintained SSRS server.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• 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), 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.

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

WORK PROFILE:

Confidential, Santa Ana, CA

SQL BI Developer/SSIS/SSRS/SSAS

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.
• Creation of queries for generating drill down reports in SSRS 2014/2012 packages.
• Formatted SSRS reports using the functions, global variables and expressions
• Managed upgradation 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 monitoring, development and deploying SSIS 2014/2012 packages.
• 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 usingSSAS.
• 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.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Actively participated in interacted with users,team lead, DBAs and technical manager to fully understand the requirements of the system.

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

Confidential, Richardson, TX

SQL BI Developer SSIS / SSAS/ SSRS

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.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• 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 Scripts task for Data Flow and Error Handling in SSIS
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2012
• 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
• Interacted with the Business Admin and gather the requirements and analyzed them
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved inTabular Data warehouseandDAXoperations 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.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• 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
• Performance testing on Store procedures, Indexes.
• 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
• Experience in Configuring IIS, Command line utilities like rsconfig in host scripting, adjusting encoded association data and reinforcement/restore of symmetric keys for future.
• Involved inTabular Data warehouseandDAXoperations 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, Fort Lauderdale, Florida

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 creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• UsedSSISto 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 usingSSRS.
• 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).
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterizedand 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.
• Provided 24/7 production support for the production database and to the code deployed into the production environment.

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