SUMMARY

• Over 6 years of IT experience in core concepts of Data Warehousing, Data Transformation Services (DTS) and Reports development in Microsoft SQL Server Suite of Products.
• Expertise in working with the Business Intelligence Development Studio (BIDS), which includes SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Common Table Expressions, Indexed views and triggers and T - SQL queries for data consistency and manipulation.
• Strong knowledge in all kinds of SQL Server Constraints (tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Hands on experience in Data Transformation Services/ Integration Services (DTS/SSIS)
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Proficient in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Expertise in Report writing.
• Expertise in upgrading or migrating Analysis Services.
• Built Azure Analysis Service models in cloud pulling data from both On-prem (SQL) and Azure Data Lake Store (ADLS).
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Proficient in working with Multidimensional Expressions (MDX).
• Expertise in UDM and Data Mining objects.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• SSAS,SSRS,SSIS,POWER BI, tableau, triggers, business, intelligene, schema, DBA, admin, administration, management, warehouse
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and as a team member.
• SSAS,SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, T-SQL, Python, Analysis, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Performance Point Server, Power BI, Tableau, MS Excel, Qlik Sense

RDBMS/DBMS: MS SQL SERVER 2016/14/12/08/05 , MySQL, MS Access

Database tools: SQL Server Management Studio (SSMS), Enterprise manager, Query Analyzer, DTS, BCP, Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Agent, SQL Mail, SQL Trace, Visio

Programming Languages: T-SQL, MySQL, Shell scripting, basics of Python

Operating Systems: Windows 10/08/07, Ubuntu, Windows 2012 R2

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Sr. Data Analyst

Responsibilities:

• To provide cradle-to-grave reporting services to VC’s multiple clients across different business sectors like banking, Telecom, Tech industry etc.,
• To maintain, enhance and gatekeep the databases that stores confidential data of various clients.
• To create ad-hoc reports and scheduled reports that are used by higher level management in making critical decisions.
• Interact with business users on daily basis to collect, analyze and prepare BRD documents.
• Assist and educate both internal and end client users on app usage and report features.
• Used multiple report platforms like Qlik, Tableau, SSRS and Power BI to prepare scheduled reports strictly following client’s logical, compliance and data security requirements.
• Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, pivot tables.
• Adapting to high demanding, fast paced software developing environment and adhering, adapting to the data changes that takes place
• Making sure the data changes on the application end are replicated and in sync across the databases.
• Performance tuning the slow running queries and reports on a regular basis to provide lag-less reporting experience to users.
• Closely work with Database admins and App developers to ensure smooth running to project from reporting perspective.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel, CSV and XML using SSIS and cleanse the data.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Involved in purchase and distribution of pro-licenses of power BI to users.
• Performed enabling and disabling on key features in power BI and developed reports on usage of power BI and it’s features for management records.
• Reviewed and managed auditing of events and power BI usage by various users across teams.
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
• Worked on ETL tool Alteryx for cleansing and blending different data sources for analyzing the data.
• Integrated Tableau with Alteryx, to transform the data as per business needs, before creating visualizations.
• Created extensive custom joins for blending data from several different data sources and also cross database joins.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, Geographic map using show me functionality.
• Implemented Data Representation using Visualization Techniques in Tableau suing Alteryx (Graphs, charts etc).
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations and to provide drill down features for the detailed reports.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Developed database triggers and stored procedures using T-SQL cursors and tables.

Environment: SQL Server 2016 Enterprise Edition, SSRS, SharePoint, SSMS, Visual Studio 2015 & 2013, GitHub, Power BI, Tableau, Qlik sense, MS Office suite SSAS,SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, T-SQL, Python, Analysis, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse

Confidential, UT

SQL BI Developer

Responsibilities:

• Collected business requirements from users and drafted them as Business Requirement Document.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Used BCP command line utility to replicate a database.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Used Recompile and with option query hints to avoid parameter sniffing problems.
• Improved query performance by adding covered indexes, adding file groups.
• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, Excel, Oracle, XML and heterogeneous data to and from SQL Server.
• Implemented Event Handlers and Error Handling in SSIS packages, notified process results to various user communities and scheduled the SSIS jobs using SQL server agent.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Package Configuration files and deployment wizard.
• Worked on making reports in Tableau like Donut chart, waterfall graph, Bar graph, Pie charts.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Published Power BI Apps from Power BI workspace and pushed the Apps in to User App tab.
• Created standard Reports and Chart Reports, Cross Tab Reports and Drill Through reports.
• Worked and developed Power BI reports.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Involved in purchase and distribution of pro-licenses of power BI to users.
• Performed enabling and disabling on key features in power BI and developed reports on usage of power BI and it’s features for management records.
• Reviewed and managed auditing of events and power BI usage by various users across teams.
• Design and write elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure SQL Database.
• Deployed Azure SQL databases and other Azure settings using Power Shell.
• Automating the SSIS/SSRS/SSAS deployments through PowerShell scripts.
• Built Azure Analysis Service models in cloud pulling data from both On-prem (SQL) and Azure Data Lake Store (ADLS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created Stepped and Blocked reports using SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Generated reports using the Reporting Services analyzed using Server analysis (SSAS).
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Evaluated and lead the conversion to using Tortoise SVN for integrated source control, builds, testing, and deployment.

Environment: SQL Server 2016/2014/2012 Enterprise Edition, SSIS, SSRS, SharePoint, PL/SQL, Visual Studio 2015 & 2013, Team Foundation Server (TFS), SSAS SSAS, SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, server, T-SQL, Python, Analysis, Qlik, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse, Analytics

Confidential, CA

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, CSV and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Imported data from CSV files to sql server databases and cleansed the data. Developed various ad-hoc and scheduled reports as per user requirements
• Implemented the concept of Incremental Data Load and Slowly Changing Dimension (SCD) Type 2 for dimension packages to move data from staging to dimension tables in SSIS.
• Implemented Package Configurations, Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Drill-through, Drill-down, Chart Reports, Cross Tab Reports and Sub-Report using RDL.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created OLAP Dimensions, Measures and Cubes using SSAS.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Imported data from CSV files to sql server databases and cleansed the data. Developed various ad-hoc and scheduled reports as per user requirements
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2014, Visual Studio 2015, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS). SSAS, SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, server, T-SQL, Python, Analysis, Qlik, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse, Analytics

Confidential

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed XML tags to structure data and improve the data migration process.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 9i/10g.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Worked on SSIS performance tuning using counters, Error handling, Event handling, re-running of failed SSIS packages using Checkpoints.
• Worked with Transactional and Snap-shot Fact-Tables.
• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.

Environment: SQL Server 2012/2014, Visual Studio 2012/2015, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), VB, MS Access, Visual Studio, T-SQL. SSAS, SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, server, T-SQL, Python, Analysis, Qlik, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse, Analytics

Confidential

SQL /SSIS/SSRS Developer

Responsibilities:

• Participated in the requirements elicitation and technical specification processes.
• Developed stored procedures, triggers, cursors, views, audit tables in SQL Server.
• Designed Entity-Relationship diagrams and thus the database schema.
• Performed job scheduling in the SQL Server Environment.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
• Used various Control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly and monthly reports.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2008/2012 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, VB.NET, ERWIN, SQL Server Management Studio, Visual Studio. SSAS, SSRS,SSIS,POWER BI, tableau, triggers, business, intelligence, reports, ad-hoc, SQL, server, T-SQL, Python, Analysis, Qlik, Star schema, snow flake, schema, DBA, admin, administration, management, warehouse, Analytics