Sr Staff Data Engineer Resume
0/5 (Submit Your Rating)
Ca Teradata Etl, DevelopeR
SUMMARY
- More than 15 years of technical expertise in various industries viz.
- More than 9 years have worked on Business Intelligence solutions with expertise in ETL and BI Reporting infrastructure implementation and Administration.
- Well versed in Agile methodologies to ensure all user stories ties to business values.
- Hands on expertise on providing end - to-end solutions on BI Platform using Microstrategy, Netezza, SAP BI and AWS managed services.
- Strong in problem-solving as a team member respecting different opinions and solutions.
- Good insight as techno-functional professional for Business Intelligence solutions.
- Have worked under challenging and ambiguous environments.
- Experience managing on-shore and off-shore team to optimize workload and delegation.
Area of Expertise
- Data lake implementation on AWS using batch and streaming data.
- Microstrategy: Many years of experience as an Architect / Administrator / Visualization and support to internal/partner data needs.
- Implementing Microstrategy environment migrating from legacy reporting environment.
- Many years of experience in data warehousing on Netezza, DB2 and other RDBMS
- AWS: Trained on AWS Architecture and Big Data.
- Trained on Machine Learning and use case implementation.
PROFESSIONAL EXPERIENCE
Sr Staff Data Engineer
Confidential, CA
Responsibilities:
- Designing / implementing data lake on AWS cloud environment for existing BI platform.
- Stabilized Microstrategy environment by being diligent on all big or small issues on any day to day or upgrade issues.
- Provided solutions for self-service and automation for ensuring data delivery and auto recovery on delivery failures.
- Enhanced and Automated date dimension tables for reporting and analytics usage.
- Developed proof of concepts on existing technologies as well as innovative technologies esp. aws. Currently working towards the solution Architect certification.
- Not only technical but business insight to customer, partners, internal teams.
- Bringing all acquisition data into central BI platform for executive reporting.
- Supported solutions as per the PCI DSS compliance needs.
- Implemented mobile solutions for important data.
BI Technology Architect
Confidential, CA
Responsibilities:
- Part of team responsible for analyzing legacy reporting systems (Brio, Cognos, Crystal reports, mainframe reports, ad-hoc excel based reports and older versions of Microstrategy reports), explored the possibility of combining many as ad-hoc or canned Microstrategy v9 reports following Agile methodologies.
- Managed onshore as well as offshore team to maximize productivity.
Microstrategy BI Architect
Confidential, CO
Responsibilities:
- Working on a very fast paced environment with focus on communicating clarity to problems and delivering a suitable acceptable solution.
- Responsible for managing Development, UAT and Production systems for smooth Product development and implementation, including QA check points before Production migration.
- Worked as Microstrategy Architect and Administrator (v9.2.1), with the help of developers to migrate brio reports to Microstrategy reports.
- Automated many manual processes using Microstrategy Command Manager scripts.
Senior Microstrategy Consultant
Confidential, Foster City, CA
Responsibilities:
- Worked on a complex, high data volume project, ( Confidential Business Intelligence System).
- Designed and configured front end objects to deliver reports to end users. Performed data modeling, configured and implemented dashboards.
- The reports helped Confidential Product Director to analyze trends on card usage by Confidential cardholders.
SAP BI Application Developer
Confidential, Santa Clara, CA
Responsibilities:
- Implemented SAP Best Practices and governing solutions across various SAP projects.
- Performed lead role of recommending usage guidelines on SAP BI / EP to various Business groups.
- Also, worked with vendor consultants as part of the team for their input.
- Integrated websites within Enterprise portal for knowledge management (SharePoint sites).
- Implemented SAP BI queries for various business groups to support Sales Distribution analysis.
Microstrategy Architect
Confidential, Beaverton, OR
Responsibilities:
- Implemented various Microstrategy Projects and Schema design for Supply chain, Inventory Levels and Finance Business Groups.
- Designed and tuned SQL queries for data quality checkpoints to analyze defined KPI of Confidential ’s ETL pipelines.
- These reports compared the data loaded into staging tables with the target data warehouse to ensure variance to be within acceptable tolerance limits.
- Collaborated with the Data Architect and Business Analyst to create technical specification documents for the Finance reporting project for on shore as well as off-shore team.
Teradata ETL Developer
Confidential, Beaverton, OR
Responsibilities:
- Designed and developed Star schema in Teradata stored procedures for Finance reports.
- Helped create subject areas to provide data service to projects for reporting needs.
Software Engineer
Confidential, Beaverton, OR
Responsibilities:
- Created and maintained over 100 DLLs as added functionalities for MRP system using C++.
- Managed offshore team in Kulim (Malaysia) for development activities for US based business team to meet new demands on functionalities.
- Maintained Manufacturing Resource Planning (MRP) system for enhancements requested by worldwide Business analysts. Managed the releases worldwide.