Senior Systems Engineer Resume

SUMMARY

Offering over 4 years of experience as a BI developer in software development and maintenance in an Agile environment.
Delivered BI reporting solutions in PowerBI,SSRS and Tableau.
Knowledge of Data Warehousing Concepts, SSAS and understanding of OLAP cubes, Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow - Flake Modeling, and Data Normalization.
Experience in developing Ad-hoc reports, data driven subscription reports using Report Builder.
Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
Created tableau worksheets by implementing different joins (left, inner, right, and outer joins), data blending and custom SQL and data source filters based on business requirements.
Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt charts, Bubbles, Bullets, Heat maps.
Experience in Tableau report developing, testing and deploying reporting solutions using Tableau ServExperience in SQL Scripting, using Microsoft SQL Server to update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses.
Developed custom calculated measures using DAX in Power BI to satisfy business needs.
Quality amount of exposure to reference data
Domain knowledge in Capital Market and different asset classes like Equity, Fixed Income, Derivatives

TECHNICAL SKILLS

Power BI, Tableau,SSRS
T-SQL,SQL,DAX
Unix/Solaris, Windows
SQL Server 2012,Oracle11g, SQLlite

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Engineer

Responsibilities:

Developed complex SQL queries using stored procedures, common table expressions(CTEs),temporary table to support Power BI and SSRS reports.
Developed complex calculated measures using data analysis expression language(DAX)
Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, Data Lake etc
Worked on all types of transformations that are available in Power BI query editor
Implemented row level security in Power BI
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
Implemented Drill Through actions in SSAS to provide quick access to granular data.
Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
Created stored procedures and SQL queries to pull data into power pivot model.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
Identified best way to visualize data for given business questions.
Created drill through reports in tableau dashboard. Involved in data blending for merging different data sources.
Responsible for handling third party Capital market data coming from Bloomberg, Reuters, S&P, Fitch, Moody’s
Created SSRS Report Model Projects in BI studio and created, modified and managed various report models using multiple model objects, source fields and expressions.
Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
Publish validated data to downstream applications
Test and validate data, consuming web services using Service Oriented Architecture Protocol, WSDL.
Configured JDBC with SQL/PLSQL for database connectivity.

Confidential

Senior Systems Engineer

Responsibilities:

Gathering and analysing business requirements and performing Impact Analysis
Completing stories assigned in each sprint, preparing unit test plan, performing necessary testing
Co-ordinating with onsite team members and providing QA support
Mentor and train new joinees. Prepared knowledge management documents,knowledge transition plan to make on-boarding easier for future joinees.
Setup test data and test environment
Update and maintain documentation for all applications developed.Rated among top 10% employees(CRR 1+) at Infosys
Recognized for taking on most challenging tasks proactively
Known for a combination of focused analytical, problem solving skills and strong work ethics
Continuously striving for improvement coupled with commitment to offer quality work

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship