SUMMARY

• Experienced IT professional with 7+ years of experience in fast paced software and business development environment.
• Strong business level skills in understanding business processes, eliciting requirements, creating operational workflows, outlining business rules and documenting findings in business centric documents as well as creating technical specifications.
• Team Player with strong interpersonal skills and desire to work with different stakeholders and team members for the goal of creating effective and collaborative environment.
• Strong technical skills in Data Base, programming and working with various development and productivity tools.
• Extensive experience implementing software throughout the SDLC process, hands - on experience of MS Sales, networking, migration and implementation in Azure.
• Experience in working closely with the project team and/or business users to understand business need in order to develop possible solution within the technology and data accessibility frame
• Experience in design, development, implementation and administration of database systems using SQL Server 2005/2008r 2/2012/2016/2017 Azure Sql Db for both OLTP & Data Warehousing Systems applications.
• Azure SQL Data warehouse creating tables and loading data
• Created SQL server Managed Instance on cloud and deployed SSIS packages
• Logical & Physical Data modelling (Relational Database and Data warehousing concepts, Multidimensional Analysis.
• Physical database design techniques like Normalization and De-Normalization.
• Utilizing constraints (Primary Keys, Foreign Keys, Defaults, Check, and Unique).
• Highly proficient in T-SQL for developing complex stored procedures, triggers, tables, views, user defined function, SQL Joins, Relational Database models and Data Integrity.
• Extensive­­ experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Reporting Services (SSRS). Power BI and, Analysis Services (SSAS)(Multidimensional Tabular).
• Created dashboards using Power BI desktop
• Created live reports using multiple data sources
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, Drill through, Charts, and Sub Reports features using Business Intelligence Development Studio (BIDS) and SQL Server Data Tools.
• Knowledge in working with all Collections in reports like Fields, User, Parameters, Variables and Report Items.
• Design and Implement Database Schema, import data and build stored procedures on SQL Azure.
• Worked on Cloud Administration tasks such as creating Affinity Group, Storage Accounts, Cloud Services, VPN, DNS server and VPN connectivity.
• Experience with load balancing, high availability, disaster recovery, and storage architecture.
• Extended working knowledge in cloud service, IaaS, worker role, queue, and azure blob
• And table storages. Configured NSGs for two tier and three tier applications.
• Extensive experience implementing software throughout the SDLC process, deep hands-on experience of networking, migration and implementation in Azure, Created Azure Data warehouse, loaded data using Data factories from storage and on premise using integration runtime and Selfhosted integration runtime. The SSIS packages are moved to Azure IR (integration runtime) deployed on Azure Managed Instance.
• Define data flow through the system and deliver reports modified to your own business rules
• Automate follow-up segmentation and distribution for internal review

TECHNICAL SKILLS

FUNCTIONAL AREAS: Retail, Investment Banking and IT Consulting.

DATABASES: MS Access, SQL Server, Azure SQL DB, Azure Datawarehouse

DEVELOPMENT TOOLS: Microsoft Management Studio, Business Intelligence Tools, Power shell, SQL Server Analyzer, Artiva

APPLICATIONS PACKAGES: MS Word, MS EXCEL, MS Outlook Express, Power Pivot, Power View. Exchange Server 2013/2003/2000 , Windows 2012/2008/2003 DHCP Server, IIS 8.0, 7.0, 6.0 Web Server, 2012/2008/2003 DNS Server

PROGRAMMING LANGUAGES: C, T-SQL, SQL, HTML, MDX. DAX

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Implementation of business process through the creation of Stored Procedures, Functions, Triggers and Views.
• Worked on data migration in Azure and Involved in infrastructure set up in Azure
• Acquired a strong background in Microsoft Office
• Maintain knowledge of current sales and promotions, policies regarding payment and exchanges, and security practices.
• Prepared and generated weekly, monthly, quarterly, and annual reports for audit purposes and Maintained all relevant inventory paperwork and entered accurate inventory data in computer system.
• Created Data factories to migrated data to Azure Sql Managed Instance and Azure Datawarehouse
• Connected to multiple DATA SOURCES in Power BI desktop.
• Created VISUALIZATIONS to a Power BI report.
• Created Power BI reports on various requirements and Complex reports and dashboards using DAX
• Created DASHBOARDS using Power BI desktop and Created GATEWAYS between on premise and cloud.
• Worked on building MOBILE REPORTS to have a responsive layout for different devices.
• Created LIVE REPORTS using multiple data sources and Created CORTANA INTEGRATION using office 365
• Used DAX query and created measure as needed
• Worked on setting up ROW LEVEL SECURITY to restrict data access for users.
• Created KPI VISUALS to measure the progress.
• SQL query optimization in SSRS by designing required indexes after analysis using SQL profiler and examining execution plans in SQL server Management studio.
• Created the SSIS Packages using SSIS for loading the data from the source to staging databases and processing the cube.
• Designed Complex SSIS packages to load the data from different sources like OLEDB, EXCEL, FLAT Files, RAW Files and DB2 etc., into various Data warehousing system.
• Extensively worked on ETL methodology for supporting data extraction, transformation and loading mechanism.
• Perform hands-on activities involved in creating cloud infrastructure components.

Environment: SQL Server 2012, SQL Server Analysis Services (SSAS) 2012, SQL Server Integration Services (SSIS) 2012, SQL Server Reporting Services (SSRS) 2012, Visual Studio 2010, Windows Server 2012, Microsoft TFS, Power View, SharePoint, MS Office, MS Access, T-SQL, SQL Profiler. IIS 7.5, IIS 7.0, Windows Server 2008R2/20012 R2/2016, Microsoft Azure, SQlServer2016/014, Oracle.

Confidential

Power BI Developer

Responsibilities:

• Writing Stored Procedures, Functions, and Triggers according to the business requirements.
• Created various database objects like Tables, Indexes, Views, and SQL Joins
• Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill Down Reports
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Involved in the extraction of data from different sources like OLTP server, flat files, excel and legacy databases.
• Design and develop SSIS packages with required transformations to load the data into warehouse server for analysis and reporting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and Involved in analysis of data marts to understand feasibility and complexity.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Defined Key Performance Indicators (KPIs) in accordance with the requirements using SSAS 2012.
• Created partitions, calculated members for fact tables and cubes.
• Used Multi Dimension Expressions (MDX) queries for calculated members of a cube using SSAS 2012.
• Entered details such as payments, account information and call logs into the computer system.
• Responded to customer requests via telephone and email.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential

SQL BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Worked extensively on data modeling for designing the new databases
• Responsible for creating and updating data models using Erwin as per the requirements
• Developed ETL Package in SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Built several reports with high complexity
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS - 2008 and SSIS in Business Intelligence Development Studio (BIDS)
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Experience with Dimensional modeling including star/snowflakes schemas and OLAP data architectures.
• Responsible for writing the complex stored procedures, UDFs, Triggers, Views.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance by cube partitioning.
• Responsible for designing, developing and implementing SSIS packages for ETL processes
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Environment: SQL Server 2008/2012, T-SQL, SQL Management studio, SSIS, SSAS, Windows 2012 server, IIS 5.0, SFTP, .NET, SSRS, Microsoft Visio 2013, SQL Profiler, MS Access 2010, Erwin.

Confidential

BI Developer

Responsibilities:

• Designed physical and logical database structures/diagrams.
• Wrote different complex SQL queries including inner, outer join and update queries and Created database objects like Tables, User Defined Functions, Triggers, Procedures, Indexes and Views as per the team’s request through team tracks.
• Involved in supporting database & BI (ETL, Analytics, and Reporting) activities for various applications and teams across all business units.
• Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS.
• Developed reports from these OLAP cubes using SSRS.
• Used Analysis Services (SSAS) processing task to update with the current data.
• Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
• Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SSRS.
• Involved in the physical design of logical schema models like star and snowflake schemas
• Involved in the OLTP database analysis during the data warehouse modelling using ERWIN.

Environment: SQL Server 2008, T-SQL, Windows XP/2003, Visual Studio 2008, Oracle, SQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Services, Visio, Microsoft-Office 2003/2007, MS-Excel 2003/2007, Team Foundation Server 2005.: MS SQL Server 2008r2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS).