SUMMARY

• Around 7 Years of extensive experience in Confidential SQL Server and Business Intelligence applications (MSBI, Power BI). Expert in using Confidential BI studio products like SSIS, SSRS and SSAS.
• Strong working experience in data analysis, design and development of databases for business applications in a data warehouse environment.
• Hands on experience in data Extraction Transformation Loading (ETL) using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS ).
• Well versed in a corporate wide ETL Solution using Informatica PowerCenter/PowerMart 9.0.1/ … Advanced knowledge in ETL and Data warehousing with OLAP technology.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica PowerCenter Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience in data management, cleaning, reporting, manipulation, integration using Base SAS, SAS/SQL, SAS MACRO SAS Proc’s and Functions.
• Knowledge of SAS STAT procedures like PROC FREQ, PROC MEANS, PROC SUMMARY.
• Having experience of working on several high priority issues, monitoring end to end reports and preparation of daily and monthly reports using Excel.
• Accountability for quality, timeliness and efficiency for the work assigned to me.
• Involved in writing high complexity/urgent SAS reporting program using SAS as primary technology.
• Providing SAS solutions to automate manual processes.
• Writing codes to generate reports using Base SAS and SQL in different formats and making predictions based on these reports.
• Data manipulation using SAS, SQL functions, SAS Proc’s.
• Exporting/Importing data to/from MS - excel to/from SAS data set & performing Data validation, Data cleaning and Data manipulation by SAS/SQL procedures.
• Day to day working on Base SAS 9 (Data-Step Programming, SAS functions, Base SAS, Proc SQL, SAS Macros)
• Writing SQL queries to fetch required data from database tables as per requirements and testing them as well.
• Optimized performance using Data Validation and Data cleansing using SCAN, COMPRESS, and COMPBL etc.
• Experienced in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, Oracle, SAP, and SQL Server) and loading for data warehousing using SQL Server Integration Services.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in developing management reports by using SSRS (SQL Serving Reporting Tools).
• Extensive experience in developing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and V-arrays), Records, Object types and Database Triggers.
• Strong experience in creating Ad Hoc Reports parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL Server 2008R2, 2012 and 2014.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Knowledge in Tableau Desktop for data visualization through various charts such as Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modelling, Snow-Flake Modelling, Fact and Dimensions Tables using MS Analysis Services.
• Expert in Tabular Modelling, Multi-Dimensional Cubes, DAX and MDX (SSAS) Experience in working with large databases in SQL, Oracle, and Teradata
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Worked on GIT, Team Foundation Server, Visual Studio online and the application lifecycle tools associated with it.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++, SAS

Scripting: HTML, DHTML, JavaScript, Shell Scripting, Python

Databases/ RDMS: MS SQL Server 2005/2008/2012/2014/2016 , Oracle 9i/10g/11g, Sybase, MS Access

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, SSAS, Power BI (Power Query, Power Pivot, Power View, Power Map), Crystal Reports, Tableau

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Confidential Management Console, Business Intelligence Development Studio (BIDS), Business Objects, XML, Visual Source Safe Visual Studio Team Foundation Server (TFS),

Data Modeling: MS Visio, ERWIN 4.1,

Packages: MS Office, Confidential Office Suit, Confidential Office SharePoint Server (MOSS), Confidential Performance Point Server

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

SQL SSIS/SSRS/SSAS/PowerBI Developer

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS ) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Wrote programs primarily in R for statistical analysis using Power BI.
• Implemented Complex Logging in SSIS Packages.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Converted DTS packages in SQL Server 2008 to SQL Server 2016 using Integration Services (SSIS ).
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
• Generated Sub-Reports, Drill Down reports, Drill through reports and parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2016 as assigned.
• Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2016.
• Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.

Environment: MS SQL Server 2016/2008 Visual Studio2012/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, SQL Server Agent, Google Analytics, MS Excel, Power Pivot.

Confidential, Bothell, WA

SQL SSIS/SSRS/PowerBI Developer

Responsibilities:

• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# code as required.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements With Excel and VBA.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Created and managed relationships between tables in Power BI to calculate accurate results.
• Transformed and combined the data using Query Editor in the Power BI .
• Created Power BI Visualizations and Dashboards as per the requirements.
• Published Power BI Desktop reports created in Report view to the Power BI service .
• Worked on Power View and Power Map to visualize reports.
• Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
• Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
• Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
• Developed C# scripting for packages.
• Created a packages and add the file system task to copy a file from a source to a specified folder using C#.
• Troubleshoot and resolve various database processes impacting production and provide root cause analysis to prevent and/or improve upon daily transactional throughput.
• Created reporting process (SSRS) for management to get timed reports on various database counters pertaining to resource consumption.
• Automated KPI metrics reporting using Visual Studio Team Services/Power BI.
• Exported or Imported data from other data sources like flat files using Import/Export through SSIS.
• Worked on SQL server tools like enterprise manager and SQL query analyzer.
• Implemented and managed performance tuning tasks with developers in optimizing the long run queries.
• Developed C# code to connect to a database server and run an SSIS package.
• Implemented side-by-side migration and in-place upgrade of MS SQL Server.
• Performed Database Upgrades from 2008R2 to 2012 and 2012 to 2014.
• Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
• Created Customized and interactive dashboards using multiple data sources.
• Created conditional filters and Action links to filter the data on dashboard with Power BI Desktop.
• Implemented Row Level Security (RLS) to restrict the data access for given Users.
• Managed Security on Data Model itself, to ensure security is applied to the roles created in Power BI Desktop.
• Implemented Report level, Page level and Visual level security using filters.

Environment: SQL Diagnostic Manager, ETL, Team Foundation Server(TFS), GitHub, Confidential Outlook, Power BI, Confidential SQL Server 2012 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, Red Gate utility, SQL Server Configuration Utility, SQL Query Manager.

Confidential, Everett, WA

SQL SSIS/SSRS Developer

Responsibilities:

• Collaborated in gathering system specification requirements for the project.
• Collaborated in creation/review of functional requirement specifications and supporting documents during data modelling process.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
• Created Triggers to enforce user defined integrity as per the business logic.
• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created staging database to perform various ETL data messaging operations such as data profiling, data cleansing and data verification.
• Designed the end-to-end ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as Oracle, Excel and Flat files into the SQL 2014 Server target staging database.
• Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, and data validation checks during Staging, before loading the data into the Data warehouse. .
• Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
• Configured data source and data source views, dimensions, cubes, measures, partitions, KPIs and MDX Queries utilizing SQL Server Analysis Services.
• Managed very large reports that return a large volume of records and optimized their performance utilizing techniques such as cascading parameters and filters.
• Designed several scorecards and dashboards utilizing Power Pivot and Tableau to display information needs by other departments and upper management.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2014, SQL Server Management Studio, SQL Server Integration Services (SSIS ), SQL Server Reporting Services (SSRS), SQL server Profiler, Confidential Visual Studio 2012, Power BI, Team Foundation Server (TFS), Tableau, Share Point.

Confidential, Gurugram, IN

Power BI Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Installed and configured Cognos 8.4.1 on window server Environment.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Worked with Framework Manager to create Projects, Models and Packages and publish them to the Cognos 8 Servers.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Implemented Third Party Security with Windows AD (Active Directory) and use those in creating Data Level, Object level, Package Level Security in Framework Manager Models.
• Design and creation of Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
• Developed detailed and summary reports using Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Developed reports using different Joins, Unions, complex display logics using different variables and customized the reports by applying filters, calculations, conditions, prompts (text box, tree, value, date) and Cascading Prompts in Report Studio.
• Developing Analysis Studio views of analysis from dimensional modelled packages and made the reports using them in Analysis studio.
• Created Technical design document for Report studio reports based on Functional specifications.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as re