A data engineer with solid experience of big data practices & pipelines for data lake house. Interpreting, analyzing, reconciling data, and visualizing features obtained from various sources;
Skills involve Tableau, paginated & standard Power BI reports, AWS cloud, PySpark, process big data with databricks, outstanding visualization skills in variety of systems.
10+ years of experience in database and software development space.
Reporting & ETL tools: databricks, SSIS, Standard Power BI & Paginated Reports, Tableau, QuickSight, FME Server
Languages: PySpark, Python, SQL, C#, VB.Net, R, HTML5, CSS, JavaScript, JSON
CRM & ERP: Blackbaud CRM, D365, Oracle E-Business Suite, Microsoft Dynamics-AX, AMOS
Database Systems: Snowflake, MS SQL Server, Athena, Teradata, Dynamo DB, Oracle
Web/Application & Versioning Tools: ASP.Net, VS & VSCode, GitHub, Bracket
Cloud environment: Comfortable with AWS and novice to Azure
Academics & Certificate: MSBA (University of Washington), Tableau desktop specialist, Microsoft MTA with Python, HTML5 & Web, SQL Server database
(BI Consultant) - Inspired by the organization culture, I decided to join the corporte industry and work for Boeing as managed service resource and contributed to the Analytical Data Warehouse team as ETL & Report developer
- Developed data pipelines and assisted clients with IBI's ETL and reporting needs.
- Analyze commercial aircraft data, and assisted clients with Ad-hoc data needs.
- Build commercial airline maintenance, flight, labor, parts, material and workorder reports
- Created Data Warehouse structures using Teradata SQL Assistant & Studio Express
- Created Dashboard, reports and charts with different visualization platform
(Senior Data Solutions Analyst) Moved to Seattle accepting a Senior Data Soutions Analyst role, I supported Blackbaud CRM and Enterprize Service Bus (ESB) that integrates 3 major applications with in the organization. Later joioned a data warehouse team where I learn basics of Business Intelegience and enterprize level reporting.
- Performed data query, extraction, compilation, and reporting.
- Assisted Integrating MS-Dynamics-AX and Blackbaud CRM, Leveraging Blackbaud API using .Net framework.
- Setting up user roles & permission with in Blackbaud CRM and synchronizing data between different databases.
- Supported World Vision’s Major Donor fundraising division with Blackbaud CRM. (Validating donations, Interactions, notes and demographic data between Oracle’s ERP and Blackbaud CRM)
- Performed ETLs using SSIS & Toad for data Analysts from heterogeneous data sources and implemented solutions.
- Managed, updated and manipulated report structures with using BB-CRM data list, Crystal report and SSRS report.
- Monitored, tested and performed API / web services testing using SOAP UI and browser plug-ins.
- Documented report details, catalogs and requirement.
- Analyzed and communicated donor / prospectus / constituent, financial and inventory data.
(Software Developer) - Work as Software developer (San Francisco) on Enterprize level application (Blackbaud CRM). I enjoyed working on Infintiy framework (Custom MVC SDK) and did lots of mass mailing / emails.
- Developed and implemented web based UI forms. Upgraded legacy and windows forms into web based application.
- Developed additional applications on existing CRM platform and upgraded older versions
- Analyzed, examined constituent and donor financial data using query and TSQL (SSMS).
- Improved financial and donor reports using SSRS and Web UI.
- Migrated bulk data from different databases to SQL Server of constituent records with in different platforms.
- Create and implement Stored Procedures, Functions, Smart fields, Smart and Ad Hoc Queries, Global changes, Business process, Record Operations, view, add, edit forms and other catalog items based on Blackbaud CRM.
- Handled over quarter millions of constituents/donors e-blasts (e-mails) and follow- up subscription status.
- Assisted local and remote staff with Blackbaud CRM query, permission, mailing and correspondence process.
