SUMMARY

• Around 8 years of extensive experience in the IT industry as a MS SQL Developer/BI Developer (SSRS, SSIS, and SSAS) in MS SQL Server 2005/2008/2008 R2/2012.
• Proficient in writing complex T - SQL (DDL, DML), using new features like CTE, ranking functions, pivot and building referential integrity constraints.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
• Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience in Database Administration work such as setting SQL Server Agent jobs for SSIS packages.
• Extensively experienced in Extraction, Transformation, and Loading tasks in SSIS while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Access, Flat File, Raw File and XML File.
• Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
• Created many complex SSIS packages with complicated transformations like Lookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplitand many more.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in using multiple Control flow and Data flow tasks to build complex SSIS Packages.
• Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Expertise creating various complex reports in SSRS 2005/2008/2012 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.
• Expert noledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Thorough understanding of how to design and develop cubes using SQL Server 2008/12 Analysis Services and leverage the advanced BI functionality of SQL Server 2008/2008R2/2012.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Experience in query optimization & performance tuning.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Hands on Tableau 8.0 for creating dashboards using pie charts, graphs, and calculation fields.
• Worked extensively with Agile Methodology.
• Ability to work with a team and individually.
• Excellent communication and problem solving skills.
• Experience in developing written documentation for technical audience.
• Excellent experience in designing and developing Reporting System using Business Objects.
• Experience with Finance, Telecommunication, Health, Security Services and Banking Clients.
• Good Exposure with Microsoft Office System - MS Word, MS EXCEL, MS PowerPoint, MS Access, MS Office Tools.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows Vista, Windows 2003/2007/2008 , Tableau 7/8.1/8.3.

Programming Languages: T - SQL, MS-SQL,JAVA, C#, Python

BI and ETL tools: Microsoft SQL SERVER 2012/2008R2/2008/2005,Business Intelligent Development Studio (BIDS), SQL server Data tools, Microsoft SQL SERVER 2005/2008/2012 Integration Services Toolkit (SSIS), Microsoft SQL SERVER 2005/2008/2012 Analysis Services (SSAS), Microsoft Visual Studio2010/2012

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012 Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Tableau Desktop 8.3/8.1/7, Tableau Server 7

Relational Databases: SQL SEVER 2012/2008R2/2008/2005

PROFESSIONAL EXPERIENCE

Confidential, Irvine CA

SQL Server Developer/BI developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements using SSRS.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008/2008 R2/2012 Reports Services (SSRS).
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Created SSIS process design architecting the flow of data from various sources (DB2) to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2/2012, Microsoft Visual Studio2010/2012, BIDS, SSIS, SSRS, SSAS, Tableau 8.1/8.3.

Confidential, Richmond VA

SQL Server Developer/BI Developer

Responsibilities:

• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Implemented SQL Server Configuration and Error Handling while developing SSIS package.
• Participated in designing ETL architecture and processes for near real time loads of insurance and policies related record from different locations.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Migrated legacy database systems from Oracle, and Access, Excel to SQL Server 2012.
• Migrated and Converted Crystal Reports into SQL Server Reporting Services (SSRS) by using MS SQL Server Reporting Services.
• 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.
• Used XML Queries after debugging of SSIS packages and to modify XML Queries written in XML.
• Optimized the performance of SQL and MDX queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Installed and configured SQL Server 2012, SQL Server Integration Services and SQL Server Reporting Services which were highly efficient to Monitor the Central console and SQL server Instances and detecting problems before effecting transaction of Online users.
• Deployed SQL Server Integration Services and SQL Server Reporting Services, which helped connect its disparate data sources that range from legacy mainframe data to multiple clusters of database server in different format.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet reporting needs.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2005, 2008, and 2012, Microsoft Visual Basic 6.0,SSIS 2012, SSAS, SSRS, OLAP, Performance Point Server, Tableau 7.0/8.0.

Confidential, Middletown, NJ

MS SQL Server Developer

Responsibilities:

• Involved to work with troubleshooting the stored procedures, functions, views, triggers & part to be increasing the performance tuning.
• Wrote several SQL Scripts such us finding tables that has Identity Columns, finding tables that do not has primary key.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Created Parameterized reports, Drill Down and Drill Through reports and thorough noledge of report serving architecture using SSRS.
• Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/2008/2008 R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL AND MDX Queries, debugging unexpected SQL results and so on.

Environment: MS SQL Server 2005/2008/2008 R2, Microsoft Visual Studio2010, MS Access, Import & Export Data.

Confidential, Calabasas, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Played a major role in production support of SSAS cube and SSIS jobs.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Extensively used SSIS transformations such asDerived column, Data conversion, SQL task, Script task and Send Mail task, Data Flow task etc.
• Created SSIS 2012 packages dynamically using SQL Server Configuration & Environmental variable.
• Conversion of more TEMPthan 60 DTS packages to SSIS packages and created logging for error handling.
• Worked with QA team & Business Users for the validation of the data & SSIS packages.
• Involved in creating, modifying, deploying & monitoring SQL Server Agent Jobs.
• Created and maintained technical documents for ETL Process.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL 2000,MS SQL Server 2000/2008, MS SQL Integration Services 2008, DTS 2000, MS SQL Server Analysis Services 2008, MS ACCESS, Team Foundation Server.

Confidential, MA

SQL Server/SSIS Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
• Created SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Provided noledge transfer to the company’s SQL programmers.
• Designed maintenance plans
• Wrote distributed queries to extract data from different servers.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Created views by vertical partitions of tables.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL Server 2008/2005, Integration Services 2005, Windows Server 2003, Share point server, TFS.

Confidential, NJ

MS SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in database migration from SQL server /08.
• Involved in analyzed and designed disaster recovery / replication strategies with business managers to meet the business requirements.
• Responsible for creating user defined, attributes hierarchy towards the SSAS cube.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.

Environment: MS SQL Server 20002005/2008 , MS Access, MS Excel, Windows 97/2000/XP.