Data Developer
Resume:
Sai Teja Kamma
***********@*****.***
SUMMARY:
MSBI Developer with strong experience in Design, Development and Deployment of Business Intelligence solutions. Experienced in working with development teams, Business analysts and Interacting with end-users. Experience in building Database solutions in Financial space in creating, configuring and deploying various packages in SSIS for Business Intelligence Development. Expertise in developing and deploying various subscription and interactive reports using SSRS, Tableau and PowerBi.
Experience in creating complex T-SQL queries and maintaining RDMS objects which include Common table expressions, User-defined functions, stored procedures, Indexes and Views to implement the Business logic and Performance tuning of the Database.
Expertise in building Data Integration Workflow Solutions with Extract, Transform and Load (ETL) capabilities for data warehouse using SQL Server Integration Service.
Experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
Hands on experience in creating, documenting and deployment of SSIS packages which include Dimensional/Fact tables loading, Incremental loading, and full loading.
Expertise in Logical, physical, and Dimensional data modeling, Data mapping, and Data normalization, Star Schema / Snowflake Schema, FACT and Dimensional Tables.
Developed Cubes using SQL Server Analysis Services (SSAS) and experience in Developing and extending OLAP Cubes, dimensions and data source views.
Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)
Experience in creating BI report solutions in PowerBi, Tableau, Excel and SSRS.
Design and develop new Power BI solutions and migrating reports from SSRS.
Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with Report designer, Report manager, and the Report server.
Working knowledge of R and Python to produce additional visualizations using Plot.ly, Matplotlib, and ggplot.
TECHNICAL SKILLS:
SQL server versions: 2014, 2012, Familiar with Oracle DBMS, Goldengate
BI Tools: SQL server management studio, SQL workbench, Visual Studio, PowerBi, PowerApps, Tableau.
Programming Languages: T-SQL, C#, VB.net R, Azure, Python
Productivity Applications: MS Excel, MS Word, MS PowerPoint
Productivity Tools: SQL Workbench, Jira 7.1
Source Control Management Tools: TFS, GitHub and SVN.
PROFESSIONAL EXPERIENCE:
BNY MELLON
Jersey City, New Jersey April 2019 – Till date
Sr. MSBI Report Developer
Project Scope: Direct support for Trade capture application and Creating Custom and Interactive reports depending on each business unit requirement in the bank.
Responsibilities:
Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems MS SQL Server.
Designed and developed Data models to connect all the incoming/onboarded funds.
Developed and executed ETL Packages using SQL Server Agent/SSIS to migrate the incoming transactional data from various systems into the Datawarehouse.
Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
Maintain/check for data consistency in Cascade suite.
Create SSRS reports and upload them into Cascade to be previewed by the fund accountants.
Convert Microsoft access Databases to SQL server databases for Trade Capture Application.
Extensive use of GIT for code check-in and Confluence for documenting the workflow process.
Extensive data modelling in SSAS to create cubes for efficient reporting.
Extract data from Various internal API’s/Databases into PowerBi and create data models to be used by different financial teams.
Setup Data gateways in PowerBi for on premises data servers Implement row level security to keep report access to specific users in the organization.
Setup PowerBi on-premises report server which can be used for paginated (existing SSRS reports) and new PowerBi reports.
Extensive use of dax for creating calculated measures, functions and variables in PowerBi
Create custom PowerApps as per the real estate team requirements.
Integrate Power apps with power bi to interact with visualizations in real estate reports.
Develop Data models for the real estate team for efficient data visualization in PowerBi.
Created various complex reports in PowerBi which pulls in data from Api’s and databases.
Implemented PowerBi and PowerApps gateway to keep Dashboards and reports up to date with on-premise data sources.
Environment: MS SQL Server 2008, SSIS, SSRS, SSMS, Visual Studio 2013, Power pivot, T-SQL, Power BI, MS TFS, JIRA, VB.Net
STATE STREET
Quincy, Massachusetts June 2017– March 2019
MSBI / SQL Developer
Project Scope: Working in sprints to Populate and Update the Datawarehouse by collaborating with all the respective departments and checking for consistency in the Financial Datawarehouse and creating reports according to the Business requirements.
Responsibilities:
Involved in the development and implementation of ETL and reporting solutions for various Business units across the organization.
Translated the Business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
Developed various reports like Charts, Tables, Matrix, Sub reports and reports using single value parameters, multi-value parameters with Queried and Non-Queried parameters.
Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL Server Agent.
Deploying and Scheduling reports to generate daily, weekly, monthly and quarterly reports.
Developed stored procedures using T-SQL to retrieve data and used it to generate ad-hoc reports.
Created SSRS report templates for report development and mentoring others in my team for complex SSRS reports.
Worked with SQL workbench for Running scripts in Batch mode and comparing schemas from different Databases.
Created Heatmaps in python using Seaborn for graphical representation of client statistics.
Created SSIS Packages to load data from sources like Flat files, Excel, OLEDB, and Oracle to SQL Server.
Improved the performance of SSRS reports by tuning the Stored Procedures and T-SQL queries
Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
Created indexed views and worked on slow running SQL queries to improve performance.
Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, Python, T-SQL, Team foundation server (TFS), Tableau, Argos, Linux, Oracle DB, Dynamics365 Financials, SQL Server Management Studio, Visual Studio 2010
New England College
Henniker, NH Jan 2016 – May 2017
SQL Developer
Project Scope: To develop and maintain various databases across the organization.
Responsibilities:
Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
Develop Exception handling process and audit process for each ETL package.
Extracted data from different systems and designed and developed ETL processes for loading data into the Oracle Database.
Created Ad-Hoc Reports, Sub Reports and Summary Reports for the financial accounting team using R Programming.
Creating quarterly/annual reports to review financial balances.
Environment: Oracle RDMS, R, Python, Argos.
Infokall solutions
Hyderabad, IN Jun 2013 – Mar 2017
Data Developer
• Improved existing reports with adherence to defined policies and data definitions across financial
systems and designed workflow for the financial requirement.
• Built all major financial reports for Business which holds all the budget amount and revenue of the
company.
• Worked on building Data warehouse of the company called Global Service Reporting, which holds all
Financial information.
• Monitored daily jobs to make the ETL Master package run successful and validated the count in all
individual environments of the Data Warehouse.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different
databases to build stage tables for the data warehouse.
• Designing, Managing and Publishing Various Dashboards, scorecards using SQL Server Reporting
Services.
• Created Jobs to extract data from different sources using SSIS packages that would aggregate the
data and load them in a temporary table, having the same architecture as the table for which the
import is done.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data
integrity strategies.
• Participated in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs along with Error and
Performance reports on SSIS Packages, Jobs, Stored procedures.
• Developed several reports with consistent drill-down functionality including Drilldown reports,
Summary reports and Master-Detail reports.
• Worked extensively on SSAS tabular model using MDX.
EDUCATION:
Master’s in Computer Information Systems
Certifications:
Microsoft Dynamics 365 and the Power Platform
Power BI Dataflows Essential Training
Azure Development Essential Training
Succeeding in Web Development: Full Stack and Front End
Contact this candidate