SUMMARY

• Experienced and Senior Bi Data Analyst possessing over 5 years plus experience in the IT sector. Including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and data warehousing and Systems Administration. I have Strong knowledge of Oracle/SQL,
• Server Architecture, schema, and Transaction management.
• I have garnered immense innovative problem solving, emotional intelligence and technical skills that
• I am keen to apply while working with your company.

TECHNICAL SKILLS

DATABASES: MySQL, ORACLE, MARIA DB, MICROSOFT SQL SERVER

LANGUAGES: T - SQL, PYTHON, R

BI TOOLS: POWER BI, TABLEAU, EXCEL

DATA INTEGRATION TOOLS: SSIS, ADF

SDLC: AGILE, WATERFALL

TRACKING TOOLS: TEAMS, JIRA

PROFESSIONAL EXPERIENCE

Confidential

SENIOR BI DEVELOPER

Responsibilities:

• Created technical specification document, including the implementation methodologies using tools and technologies such as SQL, Power BI, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (POWER BI). Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Handled SQL Server and SSIS, SSAS, POWER BI. Converted POWER BI reports into Power BI visualizations.
• Worked together with business partners to design the automatic data acquisition or data delivery process for the required reporting data using various tools and technologies such as SFTP, Control-M, Batch scripts, SSIS and SQL Server Database.
• Engaged in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (POWER BI). Supported and developed DataStage jobs to load respective Dimensions and Fact tables.
• Designed and build scalable/reusable data models and ETL (Extract Transform Load) processes to support analysis and reporting on platforms like Teradata, SQL Server, Oracle, Hadoop, performing routine maintenance, and address special requests.
• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
• Used the capability of Tableau to customize and develop creatively stunning and dynamic visualizations
• Worked directly with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality
• Maintained the integrity of development work and underlying data using version control systems
• Created/managed Projects, Database Views, Data Sources and Data Connections using PowerBI
• Efficiently managed time for timely project deadlines as well as ad hoc requests
• Developed, supported, and integrated a variety of financial and retail operations systems
• Led meetings with technical peers regarding the solution designs
• Built, customized, and published interactive reports, visualizations and dashboards using PowerBI
• Designed Tableau dashboard & 20 BI reports and participated in feedback sessions to recommend improvements to systems
• Drafted prompts, customized calculations, and calculated fields, for reports & dashboards
• Developed & altered 4 interactive dashboards and designed guided navigation links within the dashboards
• Provided technical solutions to solve business needs by translating business requirements
• Collaborated with the Development team of 20 to assist in the creation of 13 new applications.
• Developed data visualizations and BI (Business Intelligence) dashboards (including self-service BI for non-technical colleagues) by leveraging software development life cycle for designing new analytical models, data marts, reports, and dashboards.
• Designed and implemented BI and data analytics solutions with MS technologies (SSIS, POWER BI, and Power BI).
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Bar charts, Line charts, Pie charts using SQL Server Reporting Services (POWER BI). Supported and developed DataStage jobs to load respective Dimensions and Fact tables.
• Designed and build scalable/reusable data models and ETL (Extract Transform Load) processes to support analysis and reporting on platforms like Teradata, SQL Server, Oracle, Hadoop, performing routine maintenance, and address special requests.
• Coordinated cross-functionally to accomplish assigned tasks.
• Assisted in live site support and incident resolution that may include on-call rotation.

Confidential

SQL BI DEVELOPER

Responsibilities:

• Developed stored procedures, Indexes, views, User Defined Functions, Triggers and Distributed Transactions.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub queries and derived tables on Teradata platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Developed number of Complex data Mappings, Reusable Transformations for different Systems to facilitate Daily, Monthly and Yearly Loading of Data.
• Used SQL to import and export data from and into Teradata tables.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.
• Implemented slowly changing dimensions in SSIS packages.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent, and SMTP.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from POWER BI.
• Created data sources, connection strings and defined the datasets for report generation.
• Designed and wrote the queries in the query builder for retrieving the data.
• Used report items like tables, sub report and charts to develop reports in POWER BI.
• Worked with various delivery mechanisms of reports including Email /PDF/Schedules Managed and troubleshoot report server related issues.
• Created dimensions with the cube wizard and generated named calculations /queries.
• Involved in defining referenced relationships with measure group and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.