SUMMARY

• 5+ years in IT having experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process, Reporting Services and Analysis Services using SQL server 2008/2012 SSIS, SSRS and SSAS.
• Hands on experience on T - SQL, PL SQL, SSIS, SSAS, SSRS, Power Pivot and Power View reports.
• Experienced in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation.
• Expert inanalyzing, designing, developing, installing and configuringMS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Absolute knowledge of database design, RDBMS, data warehousing and data modeling concepts.
• Experience in Normalization/De-normalization Techniques for optimum performance in relational and dimensional database environments.
• Proficient in writing SQL queries (DDL, DML, DCL), Creating Tables, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.),stored procedures, temporary tables, views, Cursors, indexes(Clustered and Non-Clustered),database triggers, SQL Queries, Dynamic-queries, correlated queries and queries with complex joins and aggregate functions, exception handlers, SSIS Export& Import.
• Experience in working with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications. Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping and Incremental load.
• Created reusableSSISTemplates for developingSSISPackages to reduce development time.
• Experience in migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.
• Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Skilled in writing Transact-SQL in SQL Server Management Studio and Query Analyzer to handle database objects.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent. Writing, debugging, and optimizing various complex stored procedures, Views, Triggers, Functions, Data Modelling for the mission critical application development and Monitored, Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, Database Engine Tuning Advisor, and Windows Performance Monitor for Performance optimization.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modification, and with Tabular models to support data access through Cached mode and Direct Query mode.
• Strong Experience in data warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications, design of Star and Snowflake Schema and cubes using SQL Server Analysis Services (SSAS) for Business Intelligence applications.
• Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points and Logging.
• Knowledge on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge Replication.
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, XML, HTML, Oracle 12c, 11g, 10gDatabase Tools MS SQL Server, SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA). RDBMS, SQL Server Management studio 2005/ 2008/ 2012/ 2014, MS Visual Studio, MS-Access.

BI Tools: SSAS, SSIS, SSRS (BIDS and SSDT).

Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball and Inmon Methodologies. Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS).

Tools: /Utilities: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio, DTS, Business Intelligence Development Studio (BIDS), SQL Server Data Tools(SSDT), Red gate SQL Compare tool, ODBC, ADO, ADO.NET, Microsoft Office, Excel Power Pivot, Excel Data Explorer and Quality Center.

Operating Systems: Windows NT, Windows Server 2008, MS-DOS, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/BI/SSIS/SSRS/SSAS - Developer

Responsibilities:

• As migrating application from one source system to target system is a huge task, we interact with Functional users and Business Analysts and generate ad hoc reports every day for deeper data analysis.
• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Created various SQL objects such as Database, schema, tables, field definitions and mappings, stored procedures, User Defined Functions, CTE, Triggers, views, Dynamic Management Views, indexes (Row and Column Store Indexing), Temporary Tables(Global/Local), Table variables Functions, SQL CLR, SQL Security management (Logins, Roles, Users) and SQL Server Agent Jobs for Report Automation.
• Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2008/2012.Achieved more than 40% of improved performance on data auditing ETL feature by using latest column store feature introduce in SQL SERVER 2012.
• Reviewed existing business procedures and recommended and implemented changes.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise. Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSIS packages to extract data from different source systems using Stored Procedures called within these packages and would aggregate the data and load them in temporary staging table, having the same architecture as the table for which the import is done.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Wrote SQL scripts using Script task to insert/update and delete data in SQL database, in creating configuration packages using C# Scripting.
• Sending Exact error information in E-Mail to notify users about the error message using Send Mail task.
• Deployed the SSIS package on various servers using package configuration from test server to production servers.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Identifying issues in Source data and having rules defined for special cases.
• Performing multiple data loads on Sandbox/test servers before Production Load to ensure data quality.
• Worked closely with the offshore team in finding solutions to arising problems.

Confidential

SQL Server/BI/SSIS/SSRS/SSAS - Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Expertise in usingglobal variables,expressionsandfunctionsfor the reports with immense experience in handling sub reports inSSRS.
• Developed SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, Send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• 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.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.

Confidential

SQL Server/BI/SSIS/SSRS/SSAS - Developer

Responsibilities:

• Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.
• Developed Data warehouse and reporting solutions using the Microsoft Business Intelligence based tools (SSIS & SSRS).
• Create daily summery report using SSRS.
• Responsible for Scheduling and publishing reports using SSRS, Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Developed parameterized reports which were used for making current and future business decisions.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
• Developed test queries that validate stored procedures that pull data from the data warehouse into the report products.
• Worked with Business Analysts to clarify data requirements and ensure that data presented in reports is accurate.
• Analyzed complex data patterns to establish technical solutions to resolve data issues.
• Created reports which need an ability to be run on schedules, via command line parameters via front end modules, to generate PDF output.
• Involved with Query Optimization to increase the performance of the Report.
• Designed and Developed excel Model, Reports in EXCEL, Power Query and Power Pivot.

Confidential 

SQL Server/BI - Developer

Responsibilities:

• Worked as a SQL developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server Import and Export Wizard.
• Optimize query performance by creating indexes.
• Responsible for gathering/refining requirements from the customer for developing reports. Generating custom SQL reports to address ad-hoc requests from Business communities.
• Analyzing complex business reporting and data requirement to be solved with automated data processing to support business solutions.
• Investigating data issues and recommending solutions based on operational constraints.