SUMMARY:

• 8+ years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Extensive experience in Installation, Configuration and Updates of SQL Server.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS - Access, Excel, Oracle,SAP.
• Involved in Designing and Deployment of Reports based on user requests using SSRS, PowerBI.
• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014/2016 and 2017 based on T-SQL.
• Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
• Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View and Power BI.
• Experience in Data Driven Subscriptions, Security and Ad-Hoc Reports using Report Builder in SSRS.
• Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
• Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modelling for Moderate to Large Data Systems.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Worked on Team Foundation Server (TFS) for version controlling.
• Work Experience on ticketing tools TFS and Jira.
• Extremely diligent, strong team player with an ability to take new roles.
• Self-motivated individual with strong analytical and problem-solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/ 2012 / 8R2 /2008, Oracle 10g, DB2, MS-Access.

SQL Server Tools: BI Development Studio, Query Analyzer, Export & Import (DTS), SQL Profiler.

Operating System: Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Linux

Technology s: C, Java, .NET

Bug Tracking Tolls: JIRA, Bugzilla

Development Tools: MSBI Suite (SSRS, SSIS and SSAS Multi Dimension & Tabular Model), Excel Power Pivot, Excel Data Explorer, Tableau, Power BI, Erwin, Toad for Oracle, Crystal Reports, SQL Query Analyzer, Enterprise Manager

Web Technologies: HTML, DHTML, XML, XMLA, JscriptSource control tool: Team Foundation Server (TFS), Visual Source Safe (VSS), Tortoise and SVN

Office Tools: MS-Office Products, Office 365

PROFESSIONAL EXPERIENCE:

Confidential, TX

MSBI Engineer

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects.
• Assess the risks and recommend/ install service packs or hot fixes when needed.

Environment: SQL Server 2005 and SQL server 2008, DTS, SSIS, SSAS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN

Confidential, TX

SSIS and SSRS Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-node Cluster with Mulch-instances.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Handled Scheduled backups and restore operations with Litespeed 5.0 and monitored the Tasks, Maintenance plans.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential, NY

SQL Server Developer

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
• Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions.
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• Used Process Explorer for maintenance of stuck process, and to release the handles on files
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.
• Maintained two different databases: Read-only reporting database and Disaster recovery database
• Performed security tasks like Grant, Revoke permissions for security tasks
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.
• Involved in training Update features for Business solution of SQL Server.

Environment: SQL Server 2008/2005/2000/7.0, MS-Access, .Net Framework2.0, C#.Net, Ado.Net, JavaScript, VSS, HTML, Windows 2003 Server.

Confidential

MSBI Developer

Responsibilities:

• Efficiently involved in all stages of SDLC.
• Creating the Cube and Dimensions, involving defining, modifying and editing the Relationships between the dimensions and fact tables.
• Working with the SSAS storage and partitions, aggregations and calculations, defining KPIs, Actions for the Cube.
• Implementing Cube Security by Using Roles.
• Writing MDX Queries on Analysis Information (cube) to generate the reports.
• Generating the calculated measures, named members and calculated members using MDX queries.
• Generating multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Creating packages using SQL Server Integration Services platform by using Control flow and Data flow components.
• Used transformations like Slowly Changing Dimension, derived column, conditional split, aggregate, lookup, and sort, data conversion to aggregating, filtering, sorting and joining the business data into data warehouse.
• Involving controlling the packages by using control flow components like sequential containers, for loop containers, for each loop containers.
• Scheduling the Packages using SQL Server Jobs.
• Creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Involving Deployment of T-SQL scripts, SSAS cubes SSIS packages, SSRS reports and jobs from development to production.
• Delivered the Reports to the end users.
• Prepare and Maintain application and project documents.

Environment: SQL Server 2008r2 Analysis Services, SQL Server 2008r2 Integration Services, SQL Server 2008r2 Reporting Services, Microsoft SQL server 2008r2, SQL / T-SQL/PLSQL Query Designer.

Confidential

Software Engineer

Responsibilities:

• Worked on MS SQL Server tasks such as data loading, batch jobs and Indexes.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Performed troubleshooting operations on the production servers.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Environment: MSSQL Server 2008/2005, SQL Server Integration Services 2008/2005, SQL Server Reporting Services, Query Analyzer, SQL / T-SQL/PLSQL Query Designer, DTS Designer, MS Access.