SUMMARY

• Over 9 years of experience as a BI Developer in design, development, implementation, testing and maintenance of Business Intelligence projects with MS SQL Server (2012/2008R2/2008/2005) using BI Tools (SSIS, SSAS, SSRS) spanning across Insurance, Mortgage, Banking, Marketing and Networking domains.
• Excellent analytical skills and understanding of business requirements and the ability to transform the requirements into efficiently running code.
• Excellent Knowledge in various stages of SDLC. Also implemented Agile Methodology in last two projects.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team,Capacity planningandUp gradationofSystem Configuration.
• Excellent skills in creating SQL objects such as Tables, complex Stored Procedures, Functions, Views, Indexes, Triggers, Rules, Constraints and using new features like CTE.
• Extensively used Joins, Inline views, Sub Queries, Rank, Exists/Not Exists features of T - SQL.
• Proficient in Query Performance Tuning using Execution Plans, SQL Profiler and Tuning Advisor and used preferred methods like using Left Outer joins instead of Minus.
• Contributed to all phases of Database Design, Data Modeling, Development, Implementation, Testing, Extraction, Transformation and Loading (using SSIS/DTS BCP and Bulk Insert), and Reporting.
• Excellent experience in Creating, Configuring, Deploying and Maintaining SSIS packages.
• Resolved complex issues in SSIS packages, Error Handling in SSIS packages and tuned the slow running SSIS packages.
• Extensively used Foreach Loop Container, Sequence Container and various Control Flow tasks
• Extensively used many transformations viz. Conditional Split, Merge Join, Data Conversion, Derived Column etc.
• Proficient in writing C# scripts / VB Script for Script Task.
• Extensive noledge on package configurations - XML Configuration, SQL Server, Environment Variable, Parent Package variable and Registry Entry.
• Deployed SSIS packages using msdb, file system and SSIS DB Catalog to Test, QA and Production environments.
• Migrated DTS packages to SSIS packages.
• Experience in creating SQL Server Agents Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Extensive hands-on experience in Database development in both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSIS, SSAS, SSRS).
• Experience in designing and implementing Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Experience in designing and developing Data Warehouses and Data Marts and using multi-dimensional models such as Star Schema and Snow Flake Schema fordeveloping Cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) usingSQLServerAnalysis Services (SSAS).
• Good Understanding on Kimball Methodology.
• Developing Enterprise Reports and Interactive Drill Down reports using SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Good Knowledge in developing Business Intelligence Analytical reports like Dashboards, Linked Reports, Subreports, Adhoc reports, DrillDown, Drill Through using table filter, single value parameter, mutli value parameter and cascading parameters.
• Deployed the project reports in Report Sever and created data driven subscriptions / standard subscriptions as per client requirement.
• Expertise in Creating Databases based on Functional Requirements and System Design.
• Extensively worked with QA, release team and developers to give the required environment.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, result-oriented, highly motivated TEMPeffective team member with excellent analytical skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2 R, MS Access, Netezza, MySQL

Database Tools: SQL Server Management Studio (SSMS), SQL Enterprise Manager, Query Analyzer, Apache Drill

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau, Business Objects.

Third Party Tools: Task Factory, RedGate/Compare It

Languages: T-SQL, C#, VB, Python 3.3/3.6

Operating Systems: Windows 7 Enterprise, Windows Server 2003, Windows XP

Domains: Insurance, Banking, Mortgage, Distribution, Marketing and Networking

Source Control: TFS (Team Foundation Server), GitLab

Cloud Technologies: Microsoft Azure, Data Factory V2

Ticketing Systems: Version One, Jeera, Solarwinds

PROFESSIONAL EXPERIENCE

Confidential, Texas

Senior ETL Developer

Responsibilities:

• Responsible for End to End process implementation that spans across Project Initiation phase to Maintenance phase.
• Initiate kick off meeting to determine the scope of the project, and Prepare the Project Plan in detail that elaborates on milestones, timelines and resource allocation
• Interact with functional/end users to gather requirements and understand the process flow and any exceptional features that the users need.
• Built very complex SSIS packages to automate the dynamic ETL needs of BITB vendor.
• Optimized system resource utilization and people time by Orchestrating SSIS packages for Servicing Data Viz. Invoice Management, Process Management, CMAX, etc. from vendors like MSP and BKFS.
• Generated ETL for loading Origination data from DataTrac and OpenClose tools into Data Warehouse.
• Involved in the data analysis for source and target systems and built the Data Warehouse with Staging tables, Dimensions, Facts using Star Schema and leveraged to Snowflake Schema.
• Developed slowly changed dimensions SCD Type 1 & 2 for loading data into Dimensions and Facts
• Developed complex stored procedures, functions, views, triggers, CTEs, cursors, dynamic SQL, alerts.
• Performance tuning of existing SQL code.
• Tuned SSIS packages and implemented best practices.
• Generated SSRS reports viz. pipeline, order, order all for Value Insured vendor, Regional Share Value reports for Icon Lender share vendor, and recaptured loans reports.
• Performed analysis, documentation and POC for Microsoft Azure with emphasis on Data Factory migration, Azure BLOB and Azure Storage.

Environment: MS SQL Server 2014/ 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager, C#, Microsoft Azure, Data Factory

Confidential, Plano Texas

BI Developer

Responsibilities:

• Liaised Project Management and Development Teams across different functional units to Standardize and Implement Automation and Reporting needs to improve overall access to information.
• Develop, tune and deploy complex SQL Queries and Stored Procedures
• Develop and Maintain database objects viz. Tables, Views, Cursors, Constraints, User Defined Functions, Clustered and Non-Clustered Indexes, Triggers (implement business logic).
• Extensively used complex joins, CTEs, Table Variables, Temp Tables, Rank, Dense Rank, Row Number functions
• Manage Indexes, perform Update Statistics, optimize queries by using SQL Profiler, Tuning Advisor and Execution Plan.
• Coordinate with internal departments (Application Developers and Production Support teams) and outside customers (Business Stake Holders) to support the Score Card Application for Supplier Performance and Retention needs.
• Implement and Review controls to monitor data inconsistencies or illogical conditions within new or existing processes, and reconciled conflicts with appropriate parties
• Identify data issues and offer solutions to resolve data discrepancies
• DBA activities like scheduling Backup’s and Restores, Create Partitions and Implement Partition Switch, setting up Replication, Create Maintenance Plans, create Linked Servers, Implement Security via User/Login Creation and associate desired roles to Logins,
• Automation of the alert/monitoring systems using elementary indicators of the data
• Implement Master Data Management system
• Design, Develop and implement ETL processes using SSIS packages to extract data from heterogeneous sources like Excel, flat files, Mysql, Netezza, MS Access, MS SQL Server and apply desired transformations and load them to MS SQL Server
• Test, fine tune and Standardize Data meeting the business standards using Fuzzy/Exact lookups using SSIS transformations.
• Schedule Jobs via SQL Server Job Agent to invoke SSIS packages and Stored Procedures to perform daily ETL operations.
• Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve metrics based Analysis.
• Modify the Interactive Dashboard to display and analyze Metrics(KPI’s) data for different Markets, Regions, Customer, Target percentages using the Cascading Parameters feature and graphs to show the weekly targets achieved
• Applied Conditional Formatting in SSRS to highlight key areas in the report data.
• Developed several KPI Analysis, Construction, Marketing reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s in SSRS.
• Configure and maintain Report Manager and Report Server for SSRS.
• Design and Develop dashboards for Project Governance, Field View reports, Resource Summary and Forecasting reports using Tableau using features like Data Blending
• Securitized the reposts based the user’s level of access
• Generate scripts to compare and maintain sync between the Dev, QA and Production environments.
• Point of contact for the live RNAM’s Score Card dash board/production support
• Exposure to Python coding and implement ETL using existing framework like Table Configurator and Extractor to load data into Data Lake.

Environment: MS SQL Server 2014/ 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager, C#, Netezza, MYSQL, Tableau, Business Objects, Python 3.3/3.6, Data Lake, Apache Drill, PySpark, GitLab

Confidential, Dallas Texas

BI Developer

Responsibilities:

• Determine optimum workflows and design documents for the in-place and Side - by-side migration of the database Servers /Applications.
• Installed the SQL Server, moved the databases over, and applied the hot fix frame ware and service pack, depending on the SQL version.
• Identified business needs to combine, split or retire SSIS and SSRS processes.
• Highly involved in Business requirement meetings and Technical discussions.
• Troubleshoot migration issues like replacing the deprecated features in T-SQL code, addressing Collation errors, the SQL connections, users, permissions and configurations.
• Managed all the dependencies, storage issues, protection level of package, SMTP Tasks and retrieved the source code.
• Generated scripts for database and its objects to sync/track the changes before and after the releases across different environments.
• Migrated SSIS packages, changed the package deployment model to project deployment model
• Created the project parameters/environmental configurations and deployed them to the SSIS DB Catalogs and made functional and schedule them using SQL Server Agent Job.
• Developed new package using SSIS Control components like Execute SQL Task, Data Flow Task, Task Factory components Execute Package Task, File System Task, Script Task (Both VB and C#), FTP Task, Containers and Transformations.
• Migrated and deployed Reports to the Report Server by fixing the data sources, securities, and roles, subscriptions (Standard and Data Driven) in the new versions.
• Developed reports onSSRSon SQL Server (2008/2012/2014 ) with excellent understanding ofSSAS, OLAP cube.
• Designed the interactive dash board using linked, drilldown, drill through, sub reports, cascading parameters and used matrix and KPI’s on adhoc requests
• Provided Production Support by monitoring the applications, jobs, log etc., troubleshoot them, and made them functional.
• Accomplished the migration process as a team by following the company change management guidelines as well as adhering the Microsoft check list.

Environment: MS SQL Server 2014/ 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager, C#

Confidential, Addison Tx

SQL Server / SSIS/SSAS/SSRS/BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Build Development and Production Environment on SQL Server 2008 R2 / 2012.
• Designed packages using Lookup Transformations, Merge Joins and Derived Columns with Multiple Data Flow Tasks.
• Used different type of Transformations for Data Conversion, Sorting and cleaning the data from different sources into Company format.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Deployed packages on both File System and SQL Server MSDB Using bat files, dtexec Utility and Import - Export Wizard.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from SAS environment to SQL Server 2005/2008/2012 with SSIS.
• Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Expert in Scripting using C# for Script Task in SSIS
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Configured, Installed, Administered Reporting Services 2008 R2 / 2012
• Involved in Creating Complex Ad- Hoc reports, Sub reports, Linked reports, Charts, Drill Through, and Report Models Drill Down Reports.
• Report parameters also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the execution time and no of records.
• Developed reports using complex TSQL queries, User Defined Functions’, store procedures and views.
• Developed Cubes using SQL Analysis Services (SSAS) and experience in extending OLAP cubes, Dimensions and data source views.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with T-SQL, Data mining models, developing reports using T-SQL.
• Developed many MDX Queries for creating measures that fits business logic.
• Created Report Email Subscription using Data and Time Driven Report Subscriptions.

Environment: MS SQL Server 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager, C#

Confidential, Boston, MA

BI Developer/Agent Interface, Consumer Interface

Responsibilities:

• Participated in planning sessions with business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL through SSAS.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Monitored performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Tuning Advisor and Execution Plans.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel, XML, OLE DB Source, and Flat File to SQL Server 2012/2008R2.
• Filtered bad data from legacy system using Derived column, Lookups, Conditional split.
• Developed SSIS Packages using C# in Script task script component to customize the data transformation.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task, Execute SQL Task and so on.
• Deployed and scheduled the package in various environments i.e. Dev, Test, QA and Production.
• Debugged and enhance performance of slow running SSIS Package.
• Configured SSIS Packages with xml configuration for the xml source data coming from third party software.
• Deployed the package with File System and Catalog deployment methods.
• Configure and maintain Reports using Report Manager and Report Server for SSRS
• Deployed and Scheduled the Reports in Report Manager
• Created Ad-hoc reports, data driven subscription reports by using Report Builder.
• Created Reports using Charts, Gauges, Tables, Matrix.
• Configured Reporting Service with Share Point Integration as company need.
• Created Parameterized Report, Linked report and Sub Report by Year, Quarter, Month, Week.
• Created Drill down Reports and Drill through Reports by Region for yearly, quarterly, monthly, and weekly for Sales Head.

Environment: SQL Server 2008R2/2012, SSMS, SSIS, SSRS, SSAS, T-SQL, MS Word, MS Excel, C#, SQL Profiler, Tuning Advisor, Windows 7 Enterprise

Confidential, Mclean, VA

Senior SQL SERVER SSIS ETL/SSRS Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Developed Tables, Indexes, Views, complex stored procedures, Triggers, Functions
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Built Drill Down, Drill through, linked and sub-reports using SSRS 2005/2008.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle and other OLEDB data sources.
• Created Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SSIS
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent and using Shell Scripts, C# Script and batch (.bat) files on a day to day basis
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Developed many MDX queries for creating measures that fits business logic
• Worked on KPIs, design of Star schema and snowflake schema in Analysis Services (SSAS)
• Published reports on to the Share point and created Web pages in Share-point to show various reports generated from Excel and SSRS in one web part page
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data in to the underlying data sources

Environment: MS SQL Server 2008, SSIS, SSAS, SSRS 2008, Visual Studio 2008, MS Office 2007/2003, SQL Profiler, Windows 7 Enterprise.