TECHNICAL SKILLS:

Windows: XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2016/14/12/08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages: T - SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Frame Work, C#, C, C++

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2016/2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2)PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira

SUMMARY:

• Experienced MS Business Intelligence Developer with 7 years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments, visualization tools such as Power BI and Tableau. A wide experience working in different industry domains such as healthcare, service, manufacture and finance.
• SQL/ETL Developer having 7+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2008.
• Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import ExportWizard, and Bulk Insert.
• Excellent in High Level Design of ETL Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV and flat files, MS Access, SAS, Oracle, DB2, SalesForce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all.
• Experience in working with Web services to handle SQL connections.
• Strong knowledge with Host Scripting to automate routine tasks
• Expertise in implementing business logic using Triggers, Views, Stored Procedures.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Expertise in Extraction, Transformation, Loading data from Oracle, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS .
• Experience in report development using SSRS and creating various types of reports like Dashboard, Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Expert in creating Parameterized Reports.
• Hands on experience in creating Star Schemas and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams.
• Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
• Involved in designing and populating data in data warehouse and Cubes (OLAP) using SSAS and SSIS.

WORK EXPERIENCE:

Confidential - Brea, CA

Sr. SQL BI/ETL Developer

• Build the process using SSIS to load data from different files (Excel, text) to SQL Server and create various reports.
• Worked on highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components.
• Worked on Unit testing for SSRS Reports, SSIS Packages and T-SQL Scripts.
• Configured and deployed SSIS packages from test to production environments.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Worked on reports (SSRS) with respective to new reports.
• Worked on production support and testing environment to ensure it's according to the business rules, developed reports and involved in testing and deployment.
• Worked on T-SQL programming, stored procedures and views in the processing of developing reports.

Confidential - Los Angeles, CA

Sr. SQL BI/ETL Developer

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services ( SSIS ) and SSMS to overcome transformation constraints
• Build the process using SSIS to load data from different files (Excel, text) to SQL Server and create various reports.
• Worked on highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components.
• Designed / developed several Reports in SSRS, Power BI and tableau using SQL Server tables and SSAS Cube.
• Developed various Dashboard, Charts and Graphs like Bar Chart (Side by Side, Stacked, Combination of bar and line chart), Line graphs, Pie Charts in Power BI and Tableau desktop.
• Worked as a Designer and developer matrix and tabular reports with drill down and drill through report using SSRS.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS, Tableau.
• Working on Highly complex parameterized reports (One parameter is depending on other parameter with help of different store procedures, filtering the records) in SSRS.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Wrote complex MDX queries for calculated members and measure groups.
• Worked on reports modification like Parameters changes, Store procedures, Data sets and Expression.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Experience in creating data sources, data views, dimensions, cubes using SSAS.
• Created Fact and dimensional tables, established relationship between them.
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports
• Deployed reports to report server, added subscription and snapshot for end users.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Worked on Unit testing for SSRS Reports, SSIS Packages and T-SQL Scripts.
• Configured and deployed SSIS packages from test to production environments.
• Scheduled jobs to run on daily and weekly basis using SQL Server Agent.
• Created several types of reports such as tabular, matrix, sub reports.
• Designed and implemented parametrized and cascading parametrized reports using SSRS

Confidential, San Leandro, Bay Area

Lead SQL/SSIS Developer

Responsibilities:

• Created ETL Packages using SSIS for extracting, cleaning, transforming and loading data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Data ETL making changes to existing ETLs and building some new ETL processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
• Worked closely and communicate with project team members to achieve project goals.
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.
• Participated in design discussions with Database architects and Application architects.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created Indexes for faster data retrieval from the database.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB and SQL client.
• Good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
• Strong skills in transformation data from DB2 to SQL Server
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

Confidential, Kansas City, MO

Sr. ETL Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Generated the reports (SSRS) depending upon the requirements. Created subscriptions using SSRS report manager.
• Worked on parameterized reports and Drilled down reports for newly created markets.
• Created various types of SSRS reports like cascading reports, parameterized reports.
• Worked on troubleshooting process, issues, and errors using SQL Server Integration Services ( SSIS ).
• Worked on complete SSIS life cycle in creating SSIS packages, building, and executing the packages in both the environments (Development and QA)
• Worked on application integrations in order to manage the data using BI tools.
• Extensively worked on claims processing data and created the reports using SSIS packages and exported reports in excel.
• Used various transformations in SSIS Data flow, control flow using loop containers and fuzzy lookups.
• Worked on the claims reports and on different operational reports.
• Used BIDS to create parameterized reports and exported reports in excel.
• Involved in deployment process and subversion.
• Worked on reports (SSRS) with respective to new reports.
• Worked on production support and testing environment to ensure it's according to the business rules, developed reports and involved in testing and deployment.
• Worked on T-SQL programming, stored procedures and views in the processing of developing reports.
• Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Involved in regression testing, and optimization of the query.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services ( SSIS ), T-SQL, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010