SUMMARY

• Highly professional and well - versed SQL BI Developer withover all 7+ years’ experience in designing and developingwith strong background in Data warehousing and ETL experience.
• Experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services(SSIS),Analysis Services(SSAS), Reporting Services (SSRS) and Log Stach.
• MS SQL Server Development experiencein Insurance, Online Banking, Finance Facilities Management domains with expertise inMSSQL Server2005/2008R 2/2012/2014/2016 and over5+ years ofexperience inMicrosoft Business intelligencestack products like SSISandSSRSand2+ yearsof experience inPowerBIService.
• Strong development skills with Azure Data Lake, Azure Data Factory and SQL Data Warehouse Azure Blob
• Experience on various IT Services of ServiceNow tools like Incident, Problem, Change, Service CatLog requests and Report.
• Implemented copy activities, Custom Azure Data Factory Pipeline Activities for On-Cloud ETL processing.
• Experience working with JDE E1 9.2 by creating new reports, table conversions, importing and exporting text files and CSV files.
• Provided bookmark buttons for customized views and Provided Row Level Security (RLS) with the reports to ensure that the data is secured.
• Highly proficient in the use ofT-SQLfor developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and SQL joins.
• Strong experience ondevelopingER diagramslikelogical and physical data modelsusing Erwin tool,VisionandPowerBuilder.
• Extensive knowledge in Administering, Managing and Troubleshooting in Power BI Reporting services
• Experience managing BigData platform deployed in Azure Cloud.
• Highly experienced in whole cycle of DTS/SQL server integration servicesPackages(SSIS) forperforming Data transfers andETL processes across different servers.
• Experience in creatingjobs, Alerts, SQL Mail Agent,Database Mail and scheduleSSIS Packages based on Business or Application needs.
• Experience In Hadoop, Hive, Impala and Spark.
• Integrating and transforming data from different data sources like Oracle, DB2, Excel, SAP, Azure and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSISpackages.
• Expertise in generating reports usingSQL Server Reporting Services, Crystal Reports and MSExcel spreadsheets.
• Used2012,2014,2016version ofSSASto develop tabular models and experience in performing tuning oftabular cubes.
• Proficient in designing Enterprise reports usingSQLServer Reporting Services(SSRS)to generate drill down,drill through, parameterized, linked,matrixandchartsreportsin SSRS 2005/2008/2012/2014.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions inSSAS.
• Experience in Dimensional Modeling, ER Modeling,Star Schema / Snowflake Schemaand Operational Data Store (ODS).
• Managed indexes, statistics andtunedqueriesby usingexecution planfor optimizing the performance of the databases.
• Experience in configuring security, organizational content packs, dataGateways, refresh schedules forPowerBIservice.
• Experience in working inagile scrumdevelopment methodology.
• Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments.
• Flexibleandversatileto adapt to new- environment and technologies.

TECHNICAL SKILLS

RDBM/Databases: MSSQL Server 2016/2 R2, Oracle 8i & 9i, MS Access, Microsoft AzureProgramming Languages T-SQL, PL/SQL, C, MDX, HTML, CSS, Java, Python, C #,R

Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), HIVE BI, Azure Data Fctory, SQL Server Analytical Services (SSAS), LogStach, Oracle JDE E1, Visual Studio, Tableau, Power BI.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS), Tortoise SVN, Redgate, GIT.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential

SQL/BI Developer

Responsibilities:

• Excellent knowledge & experience in creatingdatabases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors and indexes using T-SQL.
• Demonstrable knowledgeable experience withInformatica,Oracle SQL, PL/SQL development.
• Experience working in deployment ofcubes, OLAP & XMLA.
• Implemented copy activities, Custom Azure Data Factory Pipeline Activities for On-Cloud ETL processing.
• Used R to extract the data from cosmos and load in to SQL.
• Created different type of report in performance analytics using SLA Definition.
• Developed tools usingpython, shell scripting, XMLto automate tasks.
• Well experienced indata modeling&data migration from Oracle to SQL.
• Created automated flows to send the daily updates about Power BI reports to the users.
• Implemented several DAX functions for various fact calculations for efficient data visualization inPowerBI.
• Developing C# Scripts in SSIS and automating tasks using C#.
• UtilizedPowerBIgateway to keep dashboards and reports up to-date with on premise data sources.
• Designed, Developed, maintained applications using VB.Net, C#
• Have experience in support and maintenance ofBizTalk&AX Microsoft Dynamics with implementation and involved in working with self-direct assignmentsusingtableau.
• Formatted dashboards, multiple chart types, trends and KPIs withPowerView to support analyses.
• Created C# applications to load data from Azure storage bolb to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily jobs.
• Designed and monitored construction of theETL processes and provided theETL mappingsin the design document.
• Involved in Performance Tuning by creating indexes for better query performance.
• Develop Exception handling process and audit process for each ETL package.
• Developing SQL code such as writing complex queries, stored procedures, user defined function etc.
• Worked with Stakeholders and business users to gather requirements for mapping document from Source to Destination.
• Monitor and SQL profiler and tuned queries and procedures to boost database performance.
• Creating Packages onSSISby using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task,SCD to load data into Database.
• Involved in creating proxy accounts and Scheduling Jobs to executeSSISpackages.
• Created and managed Interactivity FinancialsPower BIreports (Parameterized, Linked, Drilldown, Drill through reports)

Environment: Informatica,PL/SQL,SQLServer 2016/2014/2012 , SSAS, SSIS,SSRS,Windows Server 2008 R2, Power BI, Visual Studio 2010, Hive, HBase, C#.Net, Oracle 9i, 11g, Teradata, TFS, Oracle JDE E1 9.10, Crystal Reports,AngularJS,Microstrategy, MS DynamicsAX, UNIX, LINUX, Azure,Mango DB

Confidential

BI Analyst (MSBI)/PowerBI

Responsibilities:

• Worked closely with business and involved in gathering the user requirements.
• Responsible for writing and modifying stored procedures, functions, packagesfor data conversions to create database objects dynamically.
• Created indexes, tables and sequences as per the business requirement and views to maintain data privacy.
• Worked on migrating the company financial reports from running locally on separate VM to the current EPR System JDE E1 9.10.
• Developed Business logic layers by implementing Object Oriented Programming language (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
• Used SQL profiler to identify slow running queries.
• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud.
• DesignedSSISpackages in order tovalidate, extract, transform and load data into staging and Data Warehouse.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively usedSSISImport/Export Wizard, for performing the ETL operations.
• Performed data migration from Excel, Oracle to MS SQL Server usingSSIS.
• Created package to transfer data between OLTP and OLAP databases.
• Designed Cubes with star schema usingSSAS. Created hierarchies and partitions for improvingSSAScube performance.
• Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created various complexreports and manage themusingSQLServerReporting Services(SSRS)
• Deployedanduploaded theSSRSreportstoReport Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.
• Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard
• Created various complexreports and manage themusingSQLServerReporting Services(SSRS)
• Created various kinds of reports usingpowerBIbased on the client’s needs.
• Used Collections, Bulk Collections for handling large amounts of data in PL/SQL.
• Involved in creating visualizations and multiple dashboards inPowerBI.
• Calculated columns, conditional column, custom columns, created measures inPower BI.
• Responsible for creating SQL datasets forpowerBIand Ad-hoc reports.
• Created Action filters, Parameters and calculated fields for preparing dashboards and worksheets inpowerBI.
• Responsible for scheduled job maintenance and troubleshooting.
• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters
• Used AgileDevelopmentMethodology.
• Point of contact for all the production issues.

Environment: T-SQL, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle JDE E1 9.10, SQL Server Reporting Services (SSRS), Hive, Microsoft Sharepoint Server, Azures, C#, .Net, Power BI

Confidential

SQL/BI Analyst

Responsibilities:

• Involved in creating extensive dynamic SQL to accommodate business requirements.
• Involved in documenting management procedures, plans and processes.
• Develop data warehouse process models, including sourcing, Loading, transforming, and extraction.
• Worked on Query Optimization, execution plans, trace flags and SQL Profiler.
• Used System tables, System stored procedure, DBCC commands for database maintenance.
• Used BCP Utility in stored procedures to generate output files in text format.
• Used scripts andvariables,email notifications for ETL process using Data integrator.
• Performed ETL operations to support data loads and transformations usingSSIS.
• Extensively usedSSISin creating complex packages using proper control flow and data flow elements with error handling.
• Wrote stored procedures and user defined scalar functions to be used inSSISpackages in SQL scripts
• Optimized ETL packages by increasing memory buffer size and by increasing Max ConcurrentExecutable
• Enhancing and deployingSSISpackages from development server to production server.
• Normalized and De normalized entities for data warehouse.
• Createdpartitions,KPIs, calculated members, schema and file groups for fact tables and cubes integratingSSAS.
• Migrated existing self-service reports andadhocreports topowerBI.
• Responsible for development and maintenance of company databases, Verify file accuracy and authenticity and back up information .

Environment: T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Share Point Server, SQL Profiler, MDX.

Confidential

SQL Developer

Responsibilities:

• Createdbusiness requirements, designed Functional SpecificationsandFlowcharts.
• Modified existing database to fit new business requirements by adding tables and relationships to support customer information systems.
• WrittenSQL queriesfor back- enddata validationdatabase testing and reports verification.
• Developed SQL Queries tofetchcomplex data from different tables in remote databases usingjoins, databaselinksand formatted the results into reports and kept logs.
• Working experience writing SQL Scripts using Joins, stored procedures, Views, Indexes, functions, triggers.
• Provided back-end support for functional testing and performance testing.
• Worked on reconciliations of balances from different systems.
• Analyzed requirements with developers, business analysts and provided my inputs.
• Wrote and executed thetest casesto perform System, Functional and Regression testing.
• Worked onTeam Foundation Server (TFS)for code review to check in and check out the codes.
• Actively ensuring theproduction implementation of the new enhancementswith smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: SQL Server 2008, 2005, SQL Server Management Studio,SSIS,Visual Studio, MS-Office, MS Excel, MS Access.