PROFESSIONAL SUMMARY:

• 8+yearsof experience asBusiness Intelligence Developer and Data AnalystinProduction, Development and Staging Environments.
• StrongCommunication&Managementskills withExcellent Role playing capabilities.
• Extensive experience inInstallation,ConfigurationandUpdatesof SQL Server.
• Involved in Huge data migrations, transfers using utilities likeData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience inBI DevelopmentandDeploymentofDTS,SSISpackages from MS - Access, Excel, Oracle.
• DesigningandDeployment of Reportsfor the End-User requests usingWeb Interface&SSRS.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as perStandards.
• Expertise inPerformance tuning,Optimization,Data integrityandStatisticsby usingSQL Profiler, PerfMon and Spotlight
• Experience in solving Real Time issues withIndexfragmentation,DBCCchecks, Query Tuning,ErrorandEventHandling.
• Expertise inSQL ServerStorage Structures andSecurityArchitecture for databases residing onSANstorage
• Experienced in programming Tasks-Stored Procedures, Triggers, CursorsusingSQL Server 2005/2000/7withT-SQL.
• Experienced in SDLC life cycle forDesign,DevelopmentandStagingphases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Extensive experience inDeployingandConsolidatingMultiple InstancesoverClustering Environment and Remote Installations.
• Extensive experience inInstallation,ConfigurationandDeploymentof SSRS usingScale-Out, Scale-UpandLocal topologies.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Experience in providingLogging, 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 usingSQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• ExcellentT-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Working knowledge of.Net Framework 2.0 (VB.NET and C#.NET), IIS 6.0.

TECHNICAL SKILLS:

Databases: SQL SERVER 2005/2008/2012 , MS: Access and MY SQL

Programming Languages: Visual Basic, Visual Basic 5, C, C++ & SQL

Operating System Linux: Windows 2003/2000 Advanced Server, NT & Windows 9x

Tools: Backup Utility, SQL LiteSpeed, Visio

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Web Technologies: HTML,CSS,JAVASCRIPT

Business Intelligence Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Irving, 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 offunctional requirementspecifications 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 exampleSlowly 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 inStaging PartitionsandUsage Based Optimization (UBO)mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved inTabular DatawarehouseandDAXoperations 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, Southlake, 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 ofDTSpackages toSSISpackages
• Involved inMigrationof Databases from SQLServer 2005toSQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team,Capacity planningandUp gradationofSystem Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment ofMulti-nodeClusterwithMulti-instances.
• Configured and MonitoredDatabase Mirroringfor Application Development environment
• Involved in Installation, Configuration and Deployment of Reports usingSSRSwithScale-Outtopology.
• Involved in SQL ServerConfiguration,Administration,ImplementationandTrouble-shootingfor 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.
• ScriptedOLAPdatabase backup and scheduled a dailybackupusingSQL Serveragent job.
• Performed Regular Database Maintenance process, checking the diskDefragprocedures in different environments.
• UsedSQL Profilerfor Performance monitor to resolveDead Locksand Long running queries by checking appropriate changes to Transaction Isolation levels
• PerformedDatabase Refreshtasks from production toDevelopmentandStagingServers
• Performed Database consistency checks withDBCC,Defrag,Indextuning and monitored error logs
• Database Performance of Index tuning with usingDatabase Engine Tuning Advisorto resolve Performance issues
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Work involvement in performance monitoring ofMemory,Processor,DiskI/Oand fine tuning.
• Handled Scheduled backups and restore operations withLitespeed 5.0and monitored the Tasks, Maintenance plans.
• Involved in writingStored ProceduresandFunctions,Cursorsto 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, Omaha, NE

MSBI Developer

Responsibilities:

• Created various MSBI (SSIS) packages using data transformations like Conditional split, OLE DB Command, Lookup, Data Conversion, Derived Column.
• Worked on MSBI (SSRS) in developing the reports such as Data Bar Reports, Drilldown Reports, Dashboard Reports, Map Reports, and Pie Chart Reports, Parameterized reports.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created Data Sources, Datasets and Parameters as per the requirements of the reports
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting. Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created, Updated and Deleted subscriptions for transactional publications using Push and Pull subscriptions.
• Worked on vertical and horizontal partitioning of the tables to enhance the performance
• Schedule SSIS packages through SQL Server Agent - Jobs and make sure that the packages are executed periodically.
• Worked on Team Foundation Server (TFS) for the managing the code among the various applications
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Experience of handling high sensitive data from unauthorized access by maintaining confidentiality, privacy and security procedures.
• Automated and enhanced daily administrative tasks including database backup and recovery.

Environment: Microsoft SQL Server 2012, T-SQL, MSBI (SSIS, SSRS, SSAS), Windows server 2003, Visual Source Safe, SQL Profiler, Visual Studio 2010.

Confidential, NYC, NY

MSBI(SSIS/SSRS/SSAS) Developer

Responsibilities:

• Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.
• Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into data warehouse.
• Created and Managed OLAP Cubes using SSAS.
• Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes
• Participated actively in client meetings daily and produced detailed level design document for the customer portals.
• Created parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports using SSRS2008 R2.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Performance tuning and optimization of stored procedures.

Environment: MS SQL Server 2008R2/2012, SSIS, SSRS, SSAS, PL/SQL, Oracle 11g, VSS, Microsoft Visual Studio 2010, SQL Server Management Studio, T-SQL, TFS, Toad, Unix, HTML, XML

Confidential

SQL Server Developer

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team,Capacity planningandUpgradingof SQL Servers.
• PerformedPhysicalandLogicalData Modelingfor databases of varied sizes including VLDBs.
• ConfiguredDRsolution withTransactionReplicationfrom Distribution Server with multiple Updatable subscriptions.
• Involved inInstallation,ConfigurationandDeploymentofSSRSReports using differenttopologies
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• UsedProcess Explorerfor maintenance of stuck process, and to release the handles on files
• Performed Database consistency checks withDBCC,Defrag,Indextuning and monitored error logs
• Provided On-Call supportto Mission Critical Environments and expertise withDisasterRecoverymechanisms.
• Maintainedtwo different databases: Read-onlyreportingdatabase andDisasterrecovery database
• Performed security tasks likeGrant,Revokepermissions for security tasks
• Resolved issues for mission critical high usage of systemCPU,Disk,Deadlocksand Transaction per/sec, Memory.
• DevelopedStored Procedures,Triggers,andSQL scripts for performing automation tasks
• Performed and fine-tunedStored ProceduresandSQL QueriesandUser Defined Functions.
• Implemented new T-SQL features in SQL Server 2005 like 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