SUMMARY:

• Microsoft Business Intelligence Professional with 7 years of experience in Programming, Development and Implementation of Client - Server Applications, and Database systems using SQL Server 2000/2005/2008 R 2/2012/2016.
• Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experience in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Excellent SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Experience in Normalization and De-Normalization processes.
• Experience in providing Logging, Error handling and Custom Logging for SSIS Packages.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Worked on Visual Studio Team Foundation Server and Visio.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing high availability process like log shipping, Mirroring, and Clustering.
• Experience in Database Backup and Restore. Good Knowledge in Full Backup, Differential Backup and Log Backup.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Experience in creating Reports, Jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages.
• Supported team in resolving SQL Reporting services and ETL related issues.
• Good experience of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services

TECHNICAL SKILLS:

Operating Systems: Windows Vista/XP/ 2000/2003/2007/2008 , MAC, MS-DOS

RDBMS: MS Access, MS SQL Server 2005/2008/2010/2012/2014 MS Access 2003/2005/2008/2010

Scripting languages: VB Script, TSQL, PowerShell, QTP

I nternet Te: c hnologies XML, C SS, HTML, PHP

Quality Analysis: SharePoint, Jira, Agile methodologies, Release management

Version Control Software: Perforce, GIT, TFS

Tools: and Packages SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS, SSRS, SSAS, Visual Studio .NET, Team Foundation Server (TFS), ERWIN 7.3/7.2, SNL Banker, Control M.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Power BI (Power Query, power Pivot, Power View, Power Map)

Application Packages: MS Office, VBA, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, San Diego

SQL Server MSBI Developer

Responsibilities:

• Design and create SSIS packages for import data from MLS Rets service, Skyslope API and transformed the data to load data warehouse.
• Created a SSIS package to import data to Zillow, Realtor.com, Trulia and other vendors.
• Designed ETL/SSIS packages to Extract data from heterogeneous sources like SQL server 2012, MS Excel, CSV files, MS Access and transform (provider data) and then load into Facets environments using SSIS.
• Participated in daily standup meetings to share what each ember of the team working on.
• Create and design ETL process for consolidating data for partner vendor, cloud service through SL, NoSQL, Flat file, Excel and other data sources.
• Created package to create and send daily input to internal user.
• Create SSIS package to update company dashboard application date.
• Implemented and executed SQL Server Integration Service packages to populate data from the various data sources, Developed packages for different data loading operations for many applications.
• Created various packages to generated pipe delimited flat files with dynamic datetime appended to it and sending the files over secure FTP to client destination.
• Created SSIS packages to load data by using For each loop Containers, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Data Conversion, Pivot Transformation, and Slowly Changing Dimension, FTP task, SMTP task.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.

Environment: SQL Server 2017 Enterprise Edition, 7, Microsoft Office Share Point Server, XML, MS Visual Studio 2017, Kayako, SharePoint, JIRA, SQL Server, visual studio (SSIS).

Confidential, Dallas, TX

SQL/SSRS/SSIS Developer

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2012 to SQL Server 2014.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Design and develop mappings, sessions and workflow as per the requirement and standards.
• Design and develop SQL Server 2014 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Develop the application based on architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Experience in Microsoft Visual C# in script component of SSIS.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#. NET, ADO.NET, ASP.NET.
• Providing SIT, UAT support and production rollouts.
• Production, customer issues, ad hoc request resolution.
• Preparation of deployment scripts of SSIS and database server in various environments like development, SIT, UAT and Production.
• Technical activities include developing code in SSIS and T-SQL (SQL Server).

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2014, TIBCO.

Confidential, Pleasanton, CA

SQL/ SSIS/SSRS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Experience in Microsoft Visual C# in script component of SSIS.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C# .NET, ADO.NET, ASP.NET.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2012.

Confidential

Jr. SQL Developer

Responsibilities:

• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. Analyzed and prepared Statement of Work and Requirement Definition Document.
• Installed, configured, maintained and supported SQL server 2008 and 2010 in different environments.
• Measured database storage requirements and check current and projected data growth to provide advice to the responsible team about storage requirements in advance.
• Administered the operative system and the hardware of the SQL Servers.
• Provided support to development staff about database related issue.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files.

Environment: MS SQL Server 2008, MS SQL Server Management Studio, SSIS, SSRS, .Net framework, C#, Microsoft Excel 2007, Windows 2007, Microsoft project.