SUMMARY

• 13+ years of proven experience in Software requirement gathering, design, development, implementation using Business Intelligence (BI) tools and database with the emphasis on BI Development using SQL for data warehouse, database development on CRM, Finance, Supply Chain, Taxation, Health Care domains.
• Worked on building Enterprise Analytics using different source systems (SAP CRM, ECC, CLM, Flat Files, SFDC and Oracle HCM) as the Source to Extract, Transform and Load Data into Centralized Data Warehouse systems.
• Good experience in working with MS SQL Server products like SSIS, SSRS and SQL Server Data tools with knowledge on SAP functional flow.
• Extensive experience and solid understanding of Data Warehousing, Star / Snowflake Schema Modeling, Dimensional Modeling, Entity - Relationship Modeling, OLTP and OLAP concepts.
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Excellent knowledge inDataAnalysis,DataValidation,DataCleansing,DataVerificationand identifyingdatamismatch over transformation data process.
• Profound knowledge and experience in analyzing data patterns, identifying gaps and issues.
• Experience working with scripting languages such as Python, R-Script, PowerShell, VB/Java script and C#
• Experience in Database Programming such as writing T-SQL queries, stored procedures, user defined functions, triggers, indexes, constraints, CTEs.
• Implemented Row Level Security for HR data using AD groups and user departments.
• Expertise in Creation, Extraction, Transformation and Loading (ETL) packages using MS SSIS application toolsand Python using different sources (Oracle, Text Format, CSV, and Excel).
• Experienced in deploying ETL packages using Integration Services Catalogs and scheduling the packages using SQL Jobs and windows scheduler and Electric commander.
• Good exposure on Cloud Computing using SQL Azure and SnowFlake and AWS.
• Implemented FTP based data files upload and access for BOX and SharePoint using Bat scripts.
• Used ODBC and JDBS drivers to connect and load data into Snowflake using SnowSQL procedures and Python.
• Experience in manipulating and traversing XML/JSON, Converting Data between ADO.NET, XML and Proven Knowledge in DTD, Schema, XSL (XSLT, Path, and Query).
• Knowledge on components in Hadoop Ecosystem including HDFS, MapReduce,Hive, Hue, Sqoop, Oozie.
• Good working knowledge on GitHub, TFS, VSS, SVN to manage code source control.
• Experience in Agile, Waterfall, Test-Driven Development and SCRUM Methodologies.
• Ability to work collaboratively with or lead cross-functional teams with minimal supervision.
• In depth working knowledge of Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012 , Azure, Oracle 12c, Snowflake, Hadoop, Hive, Hue

Scripting Languages: Python, C#, JavaScript, React JS, Ajax, XML, SQL Azure, Data Sync, .Net, Java.

Reporting / ETL: SSIS, SSRS, Crystal Reports, Business Objects, Sqoop

Operating System: Windows, Unix/Linux

DB Tools: SSMS, BIDS, Query Analyzer and Profiler, Azure Data Studio.

ETL Tools: SSIS, Azure Data Factory

Reporting/Visualization: SSRS, JavaScript and Microsoft Excel.

Tools: VisualStudio 2017/2015/2012/2010 , GitHub, TFS, SVN, VSS, IE Developer Tool, Visio

PROFESSIONAL EXPERIENCE

BI Developer

Confidential - Mountain View, CA

Responsibilities:

• Analyze and document client's business requirements and processes, transform the requirements to basic conceptual data and process models, data dictionaries and volume estimates.
• Involved in Data Mapping, identified and mapped source to target fields, defined transformation rules based on the requirements to generate custom reports between SAP and SQL.
• Working with SAP functional and Technical Analyst to gather User Requirements and System Specifications which includes STTM with code logic and business flows in SAP modules.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Performed Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, Bulk Copy Program (BCP).
• Creating and tuning stored procedures with incremental and differential updates and views inSQL.
• Creating SQL jobs and scheduling them using windows scheduler to run unit testing.
• Developed scripts and loaded data to Snowflake database for data mirroring POC.
• UI dashboard design and development on SSRS and support on Tableau.
• Used Python and PowerShell scripts extensive for the ETL processes.
• Created scorecards to monitor the data quality metrics and set up the email notifications to the Data stewards and Governance team if any changes in the threshold.
• Working on Agile software development methodology with scrum model using Jira.

Environment: SQL Server 2017, Python, JavaScript, SAP, JSON, Snowflake, GitHub, Agile, Jira.

BI Developer

Confidential, Oakland, CA

Responsibilities:

• Requirement gathering, analysis, design, development, testing, deployment, demos.
• Creating tables, writing queries, stored procedures and views to facilitate the data availability.
• Fine tune store procedures and views for performance without impact on the data quality and integrity using SQL Profiler and Execution Plan.
• Working on developing the scheduler to store daily events into the database using NodeJs.
• Preparing Data Flow Diagrams, Entity Relationship Diagrams and data dictionaries and preparing scripts for deployment for multiple environments
• Adding and modifying reports in SSRS as per business requirement using Visual Studio.
• Trouble-shooting day to day level 1 issues which comes through service now ticketing tool and providing a root cause and fixing it.
• Working with large data volumes including structured and unstructured data to integrate into Enterprise Data warehouse using SSIS and Python.
• Performing peer reviews, code optimization, coding standards, performance optimization.
• Using GitHub as source repositories.
• Working on Agile software development methodology with scrum model using Jira

Environment: SQL Server 2014, Shell Scripting, Python, SSRS, SSIS, GitHub, Agile, Jira.

Developer

Confidential - San Francisco, CA

Responsibilities:

• Requirement gathering, analysis, task breakdowns, implementation, testing, and deployment.
• Designed and implemented data modeling using Calculation View based on requirement documents from SAP HANA.
• Fine tune store procedures and views for performance without impact on the data quality and integrity using SQL Profiler and Execution Plan.
• Created script-based calculation views using stored procedure to handle complex scenarios
• Created calculated measures, restricted measures, input parameters and constant filters to satisfy reporting requirements.
• Worked with Admin team to setup SLT for real time replication for CRM / ECC tables
• Preparing SSIS/Python scripts for deployment and deploying the changes in multiple environments
• Working on Agile software development methodology with scrum model using Jira

Environment: SQL Server 2014, Unix Shell Scripting, Tableau, SSIS, Jira, Agile.

SQL Developer

Confidential - San Ramon, CA

Responsibilities:

• Requirement gathering, analysis, task breakdowns, implementation, testing, and deployment.
• Creating tables, computed columns and indexes in the database using SQL Server Management Studio
• Writing T-SQL queries, stored procedures, and Views and creating ETL packages using SSIS to dump data from Oracle to SQL using different controls such as transformations, control flow tasks, data flow tasks, containers and event handlers.
• Deploying the ETL package in SQL Server using Integration Services Catalogs and scheduling the package using SQL jobs.
• Performing Optimization and Performance Tuning of stored procedures and queries using SQL Profiler and Execution Plan.
• Creating Reports UI using Kendo Grid and implementing ExportToExcel.
• Extensively usedJoinsandsub-Queriesto simplify complex queries involving multiple tables
• Creatingreportdatasets and using storedprocedureparametersinSSRS.
• Using Team foundation server (TFS) as a source control for storing code repository.
• Working on Documentation -FSD, TSD & flow diagrams, and code optimization, peer reviews.
• Preparing SQL scripts for deployment and deploying the new changes in multiple environments.
• Working on Agile software development methodology with scrum model using Jira.

Environment: SQL Server 2012, SSMS, JavaScript, C#, SQL Server Business Development Studio (BIDS), SSIS, SSRS, Visual Studio 2015, TFS, Agile, Jira, Jenkins.