SUMMARY

• Highly motivated SQL server/Power BI developer with around 8+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
• Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2019/2016/2014/2012/2008 , SSIS and SSRS
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation
• Experience in configuration and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
• Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2008/2005.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Extensive knowledge in Tuning T-SQL queries to improve the database performance.
• Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages.
• Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Expertise in Power BI, Power BI Pro, Power BI Mobile
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS) on EDW.
• Worked on Power BI which acts like a cloud service that works with Excel to provide a Self-Service BI.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Support the business users and resolved issues pertaining to all the Supply chain management and distribution modules after go-live.
• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC)
• Involved in keeping the team focused and on track and also established meeting times, places and agendas.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week using POWER BI
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
• Worked on creatingAzure Data Factoryfor moving and transforming the data.
• Worked withAzure Data Lake Storeto capture data of any size, type, and ingestion speed in one single place for different operations
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2019/2016/2014/2012/2008 R2/2008, MySQL, Oracle 10g/9i, MS Access, DB2

Database Technologies / Tools: MS SQL Server, SQL Server Management Studio, SQL Data Tools, Business Intelligence Development Studio (BIDS), SQL Server Entreprise Manager, Microsoft Management Console, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Excel Power View, Power BI, Tableau, Excel

Operating Systems: Windows 2000/2007/2008/2010/ XP/Vista, Windows 7

Programming Languages: T-SQL, PL/SQL, XML, HTML, .Net, VB.Net, C, C++, C#, Java, Java script, Visual Basic 6.0, VC++, CSS, Windows Scripts

Design Technologies / Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / BI Tools: Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio, Business Intelligence Development Studio (BIDS), MS Data Tools / Visual Studio Shell

ETL Tools: SSIS (SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Informatica 8.6.1, Business Objects XI R2/R3, Webi

Cloud Computing: Microsoft Azure - Cloud Services (PaaS & IaaS), Active Directory, Application Insights, Azure Monitoring, Azure Search, Data Factory, Key Vault and SQL Azure, Azure Devops, Azure Analysis services, Azure Synapse Analytics(DW), Azure Data Lake .

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical, Logical and Conceptual Data Modeling, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Coordinated JAD session with the development team to understand functional requirements.
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better.
• Created indexes and indexed views for enhanced query performance.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases
• Plan and scheduled the report to run at desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using Auto sys tool
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS.
• Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Involved in all phases of SDLC, and gathered business requirements from business.
• Created reports using multiple data providers such as Universes and personal data files in generating reports.
• Formatted the reports as per the business requirements.
• Used Microsoft Azure date storage and Azure Data Factory, Data Lake
• Involved in validating data between QlikSense and Cognos reports
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
• Created Smoke testing cases which was held as part of the SIT and UAT cycles.
• Handheld the business testers during UAT cycle.
• Developed Power BI Apps to deliver key metrics to multiple groups within the organization.
• Shared Power BI reports and dashboards to various user's groups using app workspace.
• Involved in designing and publishing visually rich and intuitive Power BI dashboards.
• Responsible for creating datasets using T-SQL Stored Procedures and involved in Data visualization.
• Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.
• Secured the reports using role based security in Power BI.
• Designed the POC for migrating the On-premises OLAP database to Cloud for reporting.
• Utilized TFS (team foundation server) for coded check-in/check-out and the management of differing code versions

Environment: MS SQL Server 2014/2016/2018/2019 , SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQLServer Analysis Services (SSAS), T-SQL, DAX, Power BI Desktop, DAX, MDX, JIRA, Tableau, Microsoft Visual Studio 2014, Excel, Azure.

Confidential, San Francisco, CA

Azure Data Engineer

Responsibilities:

• Designed and Configured Azure Cloud relational servers and databases analyzing current and future business requirements.
• Worked on migration of data from On-prem SQL server to Cloud databases(Azure Synapse Analytics (DW) & Azure SQL DB).
• Have good experience in setting up separate application and reporting data tiers across servers using Geo replication functionality.
• Implemented Disaster Recovery and Failover servers in Cloud by replicating data across regions.
• Have extensive experience in creating pipeline jobs, scheduling triggers, Mapping data flows using Azure Data Factory(V2) and using Key Vaults to store credentials.
• Good experience in creating Elastic pool databases and schedule Elastic jobs for executing TSQL procedures.
• For Log analytics and for better query response used Kusto Explorer and created alerts using Kusto query language.
• Worked on creating tabular models onAzure analysis servicesfor meeting business reporting requirements.
• Have good experience working with Azure BLOB andData lakestorage and loading data intoAzure SQL Synapse analytics (DW).
• Designed SSIS Packages using Business Intelligence Development Studio (BIDS) to extract data from various data sources and load into SQL Server 2012 & 2016 database for further Data Analysis and Reporting by using multiple transformations.
• Worked on creating correlated and non-correlated sub-queries to resolve complex business queries involving multiple tables from different databases.
• Developed business intelligence solutions using SQL server data tools 2015 & 2017 versions and load data to SQL & Azure Cloud databases.
• Perform analyses on data quality and apply business rules in all layers of data extraction transformation and loading process.
• Perform validation and verify software at all testing phases which includes Functional Testing, System Integration Testing, End to End Testing, Regression Testing, Sanity Testing, User Acceptance Testing, Smoke Testing, Disaster Recovery Testing, Production Acceptance Testing and Pre-prod Testing phases.
• Have good experience in logging defects in Jira and Azure Devops tools.
• Involved in planning cutover strategy, go-live schedule including the scheduled release dates of Portfolio central Datamart changes

Environment: Microsoft SQL Server 2012, 2016, SSDT-2012 &2015, Azure Synapse Analytics, Azure Data Lake & BLOB, Azure SQL, Azure data factory, Azure analysis services, BIDS.

Confidential, Plano, TX

Power BI Developer / Tableau

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report orPower BI.
• Installed and configuredPower BI Desktop.
• CreatedPower BIVisualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. inPower BI.
• Designed and developedSSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server and Flat files.
• Writing complexSQL Queries, Stored Procedures,Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• CreatedSSIS packagesto integrate the data coming from flat files
• Migrated SSIS Packages from during data migration.
• Optimized queries by looking atExecution Plan for better tuning of the database.
• UsedTemp Tablesto reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Created SSIS packages for loading data from SAP BW/BI to SQL Server.
• Performeddatabase backupand deployment to the production server.
• Involved in modifying existingDataStage Jobsfor better performance.
• Created detail Technical documentation of various staging area operations for future reference and guidance.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports(SSRS)
• Installation and configuration ofSQL Server Reporting Services(SSRS). Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved inSIT(System Integration Testing) andUATtesting, bug fixing and documentation for the project.
• DesignedSTAR,SNOW FLAKESchemas
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time and location dimension.
• Created Rich dashboards usingTableau Dashboardand prepareduser storiesto create compelling dashboards to deliver actionable insights.
• Installed patches on server and documentedupgradeplan form Tableau 9.2 to Tableau 9.3.
• Created and assisted users in Tableau dashboard development. Designed Visual Reports and interactive Dashboards inTableau.
• Created Data Connections, published onTableau Serverfor usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau

Environment: MS SQL Server 2012/2014/2016 , MS SQLServer Integration Services (SSIS),SQLServer Analysis Services (SSAS), Tableau Desktop 9.2, Tableau Desktop 9.3, Tableau Server, Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway,DAX,T SQL, SQL Profiler,XMLA,MS Excel, Excess, Windows 8.

Confidential, Denver, CO

BI Developer / (ETL / SSIS)

Responsibilities:

• Design tables and views structure for the application. Define DDL and accordingly build the table structure. Upload the table into related databases and upload it in respective project in GIT.
• Creating views, stored procedures, appropriate functions, to facilitate efficient data manipulation and data consistency.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data modeling.
• Writing procedures and functions using dynamic SQL and wrote SQL queries using joins, sub queries and correlated sub queries. Writing new stored procedures and tune them so that they perform well.
• As data architect, Designed short term resolutions to achieve all goals and prepare data roadmap for management.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Effectively worked on Data migration. Built command files for data migration, files to generate view and do bulk insert and bcp out, migrate data from legacy to the target databases.
• Rebuilding the indexes at regular intervals for better performance.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Refactoring Stored procedures and user defined functions for building online and offline reports using SSRS.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Developing Power Shell scripts to automate table creation, execute procedures.
• Perform SQL Server service pack and schedule SQL Agent Jobs.
• Determined procedures to identify and collect all required data, validate process and recommend improvements to corporate data.
• Interacted with the existing database developers and DBA to understand the existing schema
• Design and developed data visualizations (reports & dashboards) in tableauto support customer requirements
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Configured Oracle Golden Gate Software that is used for replication - Extracts, Replicates, Definition files, Macro files, Parameter files for each environment and Merge SP’s for each database.
• Setting up Service Broker Components - Messages, Queues, Services, Contracts, SP’s, Triggers.
• Coordinated with the management to discuss business needs and designed database solutions accordingly.
• Consistently met deadlines for database creation and implementation projects while working with software development and client service teams for further improving the product.

Environment: MS SQL Server 2012/2014/2016 , Windows Server,Data Modeling, Data Architecture, Visual studio,Visual Studio 2013 (For Reports), Oracle GGS,Service Broker, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Share Point, MS Access and Windows 2012 Server

Confidential, San Jose, CA

SQL Server Developer

Responsibilities:

• Developed and OptimizedStored Procedures, Views, and User-Defined Functionsfor the Application
• Developed Physical data models and createdDMLscripts to create database schema and database objects
• EmployedServer Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Performed Debugging on theStored proceduresfor the requirement to handle the errors
• EmployedTransparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Development ofcustom scripts and stored proceduresfor data import and manipulation
• Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources
• 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 operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Involved in Analyzing, designing, building &, testing ofOLAP cubeswithSSAS2005
• Interacting with the Database Administrator to maintain the database usedDBCCStatements to perform maintenance tasks before backing up the databases.
• Database andLog Backupsand Scheduling Backups by creating and deploying SSIS packages.
• Dealt withFine-tuningStored Procedures to improve performance with aQuery planusingSQL Tuning advisor.
• EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database system specifications, diagrams, and connectivity charts

Environment: MS SQL Server 2008/2008R2/2012/2014, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS

Confidential

MS SQL Server Developer

Responsibilities:

• Responsible for designing data model for staging database and implementing.
• Creating application specific server loginsand granting access to appropriate databases.
• Designed and developed an approach to consolidate data from multiple source entitiesinto single flat file.
• Responsible for implementing the ETL Extract Transform Load process.
• Designed and developeddynamic SSIS packagesto process dynamic queries and dynamically produce flat files at runtime.
• Created web serviceto enable theremote execution of the SSISfrom the database server.
• Integrated the web servicewithweb applicationto allow users to kickoff the extraction process from intranet/internet web application.
• Createduser access moduleto allowspecific group of usersto be able to login to the intranet/internet system and submit the data extract request.
• Responsible for creating newSSIS packagesandmaintainingexisting SSIS packageswhich are used for data load.
• Extensively usedSQL Server Profilertodebugthe application execution flow anddynamic queriesbeing executed against the database.
• Effectivelyhandled hacking and SQL injection attackson database application.
• Implementedeffective error handlingto notify the support person aboutany errors raised in SSIS packageduring the extraction process by sending emails with complete error details.
• Createdviewsto retrieve data from one or more tables.
• Creatingindexes on existing tablesandupdating the existing indexesover a period of time.
• Creating anddebugging SQL stored procedures.
• Extensive T-SQLdevelopment to create stored procedures and user access control.
• Finding bottle necks in queries and stored procedures andfine tuning.
• SSIS packages extracts data fromdifferent sourceseach time andproduce different output filesand uploaded todifferent FTP folders. The options selected by user determine the files to be produced and queries to be executed.
• Used Serena PVCS forversion controlling.
• Publishingthe actual and plandata from Cognos Planning cubesinto SQL Server database.
• Synchronizing the Dev and Modeldatabases of Cognos Planning from Production.
• Testing and bug fixing before moving the application to Production.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, ASP.NET, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, Business Intelligence Development Studio BIDS, Management Studio, Transact-SQL, MS Excel, Excel VBA, .NET framework 2.0, Web Services, TextPad, Live Meeting and Windows XP/2003.