SUMMARY

• Over 6+ years of experience in Data Analysis, Data Engineering Data modeling, Report Design, Development and Administration of various Data Analytics and BI applications.
• Expertise in determination of client Business Requirements, and development of the functional specifications needed to construct custom - fit data solutions that scale and adapt to accompany growth of the team and company.
• Experience in designing the database in SQL Server, Azure, Oracle, and skilled in business intelligence applications such as SSIS, SSMS, SSAS in Development, Test and Production Environments, as well as visualization tools such as Power BI, SSRS. The industries I have experience in are Information Technology, Security, and Finance
• Hands on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) & Power BI.
• Extensive knowledge and experience inproducing tables, reports, graphs,and listings using various procedures and handlinglarge databases to performdata manipulations.
• Experience in maintaining one to many and many to one relationship while moving data between two databases
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes. Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL). Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, Joins and Common Table Expression (CTE)
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SQL Server, MySQL, Oracle, flat file, AWS, Azure, ERP systems.) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in report writing using SQL Server Reporting Services (SSRS) / Power BI and creating various types of reports and dashboards like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, slice and dice, bookmark, ad-hoc and sub reports features and Sub Reports
• Enhanced the functionality in data ware housing concepts (OLAP) Cube by creating KPI, Actions, Perspective and Hierarchies usingSQLServer Analysis Services (SSAS) and Dimensional Modeling Techniques such as Star and Snowflake schema.
• High-level experience in writing DAX in Power BI and Expert in fine tuning the reports.
• Good hands-on experience in implementing dashboards, Visualization and analytics using Tableau Desktop and server for the performance data metrics and Visualization in the BI environment.
• Superior skill in Advanced Excel on conditional formatting, count,datavalidation, index, match, sum, pivot table, VLOOKUP, anddatatable
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Skilled in design and development of various dashboards, reports utilizingTableauand Power BI Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement
• Hands on experience in Creating Star Schema and Snowflake Schemas. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and team lead experience.
• Adequate in Dataset Ingestion, Data Model creation, Reports, Complex dashboards, KPI’s in Tableau and Power BI using Power BI Pro features, workspaces, and security.
• Generate data extraction, summarization and ad-hoc query requests as required by the business reporting environment
• Experienced in developing, maintaining,and processing large databases with complex relationships between tables. Written several advanced SQL queries for extracting relevant data for predictive analytics
• Exhibited strong communication skills and a keen understanding of project timelines and dependencies. Team player with excellent interpersonal skills, self-motivated, dedicated and understanding

TECHNICAL SKILLS

Methodologies: SDLC Waterfall, Scrum and Agile

BI Tools: SQL Server Integration, Analysis Services and Reporting Services (SSIS/SSAS/SSRS) (2017/2015/2012/2008 ), Tableau (9.1/8.3/8.2), Power BI, SQL Server Management Studio (SSMS), SQL profiler, Microsoft Visual Studio. Cognos 8

RDBMS: MS SQL Server 2016/2014/2012/2008 , MS Access, OLTP, OLAP.

Languages: SQL, T-SQL, Java, C, C++, Python

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari

Operating Systems: UNIX, WINDOWS 7/8/10, Linux

MS Office Tool: MS word, MS Excel, MS PowerPoint, MS Project, TFS, GitHub

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

• Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task.
• Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into Data Warehouse from different source environments such as ERP, CRM, Azure, AWS, and other systems.
• Created complex stored procedures/execute task, wrote C# hard codes in script task for ETLs, updated and maintained ETL packages with high performance.
• Performed SSIS and Azure Data Factory development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2, Oracle 7.x/8i/9i/10g/11g, SAP, XML files, SharePoint Lists into the central OLTP database.
• Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages, SSRS and Power BI reports.
• Designed Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on Power BI and DOMO in creating dashboards and reports and visualizing data.
• Worked on various DAX expressions of Power BI reports based on the business requirement.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS and Power BI. Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Built complex ETL packages, using SSIS for processing Fact and Dimensions tables using various transformations.
• Worked on migrating On-prem Data warehouse environments to Microsoft Azure Cloud environment.

BI Developer

Confidential

Responsibilities:

• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS, Excel.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Staged data from various sources in designing and building warehouse Dims and Facts with Full & Incremental Loads and populated data in the appropriate destination tables.
• Applied various data cleansing and data transformations like Slowly Changing Dimension (SCD), Derived column, Aggregate, Sort, Multicast, Conditional Split, Union All.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file. Involved in scheduling SSIS packages in multiple servers using SQL Server Agent.
• Documentation for all kinds of reports and SSIS packages.
• Schedule and maintain Full, Differential, Transactional Log Backup and restore the data using restore with recovery and restore with no recovery option.
• Responsible for database tuning using normalization and application tuning. Worked on locking, blocking and dead lock issues. Performed troubleshooting for the project assigned personally to me and projects assigned to the other BI team members.
• Scheduled jobs and alerts using SQL Server Agent and configured database mail for any job failure using SQL Server Agent, Windows Scheduler to perform various administrative tasks.
• Created Teradata objects like Databases, Users, Profiles, Roles, Tables and Views
• Created many Power BI reports and dashboards by using efficient and complex DAX expressions and creating measure/columns with drill down/drill through/hyperlink options, dynamic slicing/dicing features, custom interactive tooltips on visuals and KPIs, providing insights on different visualization options.
• Involved in creating interactive, accurate, insightful, and well-organized Power BI reports/dashboards to support businesses in their data driven strategic planning.
• Worked on various DAX expressions in Data Model based on the business requirements.

SQL Developer

Confidential

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies.
• Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships.
• Designed and developed MS SQL server stored procedures using T-SQL statements from scratch. Developed triggers on views to populate tables. Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
• Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.
• Created SSIS packages for data loading utilizing various tasks and transformations (such as execute SQL task, script task, execute package task, data flow task, fuzzy lookup, lookup, OLEDB command, derived column etc.).
• Extracted and loaded data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging area.
• Normalized the tables and maintained Integrity by using Primary and Foreign Keys.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.
• Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables. Repaired SSIS packages with checkpoints, breakpoints, and data viewers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Developed SSIS packages for File Transfer from legacy systems to upgraded application backend systems, Data flow task, File system task, Execute SQL task, and FTP task and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Designed ad hoc SSRS reports in the test environment for data validation utilized SQL Server 2016.
• Designed SSRS and Power BI reports to deliver Daily, Weekly and Quarterly KPIs to end users, clients and senior level management. Maintained and administered dashboards, scorecards, and reports for scheduling data refreshes and for implementing security measures such as Row Level Security (RLS), User mapping, etc.

BI Developer

Confidential

Responsibilities:

• Used Cognos 8.1 as the reporting solution of choice by conducting product demonstrations and improve business performance at all levels of their enterprise.
• Expert in data modeling, data warehouse analysis, and creating the functional specifications and technical specifications to implement business logic for the user requirements, to generate Framework Manager Models and Cognos Report net reports.
• Expertise in creating and analyzing the complex reports (Cross tab, drill-thru reports, Prompts, filters, and calculations) and in creating reports from the multiple data sources.
• Expertise in creating page breaks, drill-thru, and master/detail reports, dashboards, pans/ sheets/any graphical reports, and conditional formatting based on the users’ requirements.
• Involved in analysis of Report design requirements and actively participated and interacted with Project Lead,
• Created and maintained the Framework Manager model, which is subject to continuous improvements and additions as the project moves along.
• Strategize a reporting methodology to convert the existing impromptu reports to Cognos 8 reports.
• Converted the Impromptu catalog to a versatile FM model to cater to the needs of all the existing reports.
• Worked closely with the database team and Business Analysts in creating new database objects required for keeping the reporting system flexible and efficient.
• Created complex reports using Cognos 8 Report Studio based on the SQL generated by the Impromptu reports.
• Developed and implemented enterprise-wide standards and guidelines for Cognos reporting and led development and delivery of Cognos product sessions for clients and management.
• Data Warehouse design, creation, modification and updates, and automation of recurring ETL and operational / maintenance processes via Cognos Decision Stream.
• Worked closely with Annual Reporting function, as well as various Summary and Detail levels of reporting throughout the organization, to achieve synergy and reusability of components designed as part of meeting specific Business Requirements. Involved in deploying reports from QA to Production Environment.
• Provided Technical for the Business and End users in creating the Ad-hoc reports.