Little Rock, Arkansas, United States
• 10 years of professional experience as MS SQL Server/ETL/BI developer in designing and developing T-SQL queries, ETL package, and business reports using SSAS, SSIS and SSRS, Snowflake • Web API calls to extract data from PostgreSQL, transform and load data to SQL server using SSIS script task. • Data Warehousing from Open-Source DB (MySQL, PostgreSQL etc.), AWS Redshift, Big Query into relational database schema, creating OLAP cubes, grids, reports, and deployment, • 6 years of experience working with Power BI Desktop/Mobile/Services (Embedded), Tableau/Tableau Prep • Workload and Capacity Optimization, Workforce Management with Cplex and Python • Robust understanding of ERP Systems, logical & physical Database design & development, data conversion & Normalization. • 4 year of experience in SSIS, Snowflake, AWS Glue, AWS Redshift, Big Query and Streamsets for creating, documenting, and deploying ETL pipelines under Package Deployment Model for SSIS and Project Deployment Model to load data from source to destination and leveraging Python for ETL • Hands-on Experience with Azure Data lake, Azure Data factory, Azure Synapse • Profound understanding of Enterprise Data Warehouse (EDW) concepts including OLTP/OLAP, Dimension/Fact table, Top-down/Bottom- Models, Star Schema and Snowflake schemas. • Broadly Intricate in Requirement gathering, Requirement documentation, writing test plans, Testing and reviews. • Experienced in designing and deploying tabular reports, drill-down reports, drill-through reports, multicolumn reports, linked reports, and parameterized reports by using Crystal Report. • Hands-on experience with creating solution-driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Donut Charts, Circle Views, Line Charts, Bullet Graphs • Worked with System Development Life Cycle (SDLC), Agile –Scrum Framework. • Data Engineer with experience in data transformation using dbt and orchestration with Prefect. Skilled in designing robust ETL pipelines, ensuring data quality, and optimizing data workflows. Adept at collaborating with teams to implement scalable solutions in cloud-based and on-prem environments.
• Reporting Architect with expertise in designing and implementing end-to-end reporting solutions. Proficient in data modeling, ETL processes, and the integration of BI tools to deliver actionable insights. • Data Engineer with experience in data transformation using dbt and orchestration with Prefect. Skilled in designing robust ETL pipelines, ensuring data quality, and optimizing data workflows. Adept at collaborating with teams to implement scalable solutions in cloud-based platforms like Snowflake, GCP to create scalable, high-performance reporting architectures. • Acquire, transform, deliver, and monitor data and data pipelines for the purpose of data quality, data analytics, and data management in support of enterprise data strategy. • Developed custom dbt macros and tests to ensure data integrity across multiple environments (dev/staging/production). • Creating Dashboards in DOMO for leadership with recommendations on active content governance, cost governance and savings and support business with the right data to make decisions. • Build a data governance framework to ensure integrity, reliability, and security of data. • Provide ongoing training for data analysts and staff on development and use of relevant technology. • Conduct validation and testing of reports, dashboards, and analytics to ensure consistent and accurate reporting across the organization. • Provide recommendations to streamline and improve current business processes, as well as research emerging tools and applications that are applicable for the functional needs. • Design and implement efficient data architecture and process to streamline and improve technical dept. • Skilled in implementing CI/CD pipelines for seamless deployment.
• Engineering solution to write data files on Hadoop and building schemas in Hive for data extraction. • Data pipeline using Apache Airflow and Python jobs. • Workload and Capacity Optimization, Workforce Management and Cost Optimization with Cplex and Python. • Creating Alteryx and Dataiku workflows for data alignment, analysis, and Annual Operation Planning. • Creating Dashboards in Tableau for leadership with recommendations on budgeting, risk mitigation, and demand signals. • Predictive analytics based on historical average, deviation, and seasonality planning, demand forecasting etc. • Collect and analyze data from multiple sources: Azure, Big Query, Informix, SQL to create and automate Alteryx workflows. • Created driver productivity, inbound and outbound workload planning dashboards in Tableau. • Created models in Tableau Prep for local staffing models. • Hands-on Experience with Azure Data lake, Azure Data factory, Azure Synapse
• Data Aggregation (Consumer-Publisher) on Postgres from multiple services to one location for API Calls. • POC/ Implementation for Data warehouse by leveraging AWS Redshift and Big Query. • Created ETL/ELT Pipelines using Snowflake, AWS Glue, AWS Redshift and Python script. • Create data pipelines for real-time data migration on Snowflake and leveraging Qlik Sense for reporting. • Engineering ETL Solutions support data migration to data warehouse from different sources through API Calls. • Experience working in Git to manage project code and maintain source code. Experience with code deployments. • Data Warehousing from DB (MySQL, PostgreSQL, etc) into relational database schema, creating OLAP cubes, grids, reports, and deployment. • Develop high-performing T-SQL queries against Microsoft SQL Server databases that contain complex data structures for powering reports, dashboards, business intelligence cubes, and data extracts. Develop SQL Server functions, stored procedures, and views. • Utilize Crystal Reports designer to create and maintain reports Performs comprehensive developer level testing prior to release for additional internal and external testing Communicates explanations of work clearly and completely to co-workers. • Captures and documents functional requirements and non-functional system, performance, or security requirements. • Conceptualizes and develops high quality software using the established coding standards and development best practices. • Creates unit tests, automated tests, and performance tests as needed to ensure quality, supporting general debugging and isolating areas for improvement. Captures and analyzes performance test metrics and provides operational documentation. • Design, develop, configure, and test secure software automation solutions in SQL Server and where applicable, SSIS and C#, expertise in TFS (Team Foundation Server), to create and maintain Reporting Database.
▪ Creating interactive and dynamic dashboard, spatial data modeling, predictive analytics, trend analysis. ▪ Use GIS and Esri Business Analyst to develop strategic site analysis and create competitor maps. ▪ Utilize qualitative and quantitative analytics, industry trends, database information systems to create market research for consultants and clients and Cultivate market research with analysis for all seven ASBTDC offices. ▪ Promote training events through direct contact and consulting. ▪ Assist UALR Training Coordinator in conducting registration, compiling seminar materials, and collecting fees. ▪ Critique business plans with written and verbal feedback for clients and Assist them with starting their small businesses. ▪ Assist clients with e-stores to increase traffic using organic search methods with website optimization.
• Analyzed recent trends and created trend reports and incident/problem record metrics. • Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data. • Implemented dashboards and scorecards with power pivot for executive management for data insights as per Business requirements and provided solutions and improvements, Target Corporation. • Worked with technology ownership for various platforms (SharePoint, SQL, SCCM) and deploy solutions and services to servers using Shell Scripting. • Designed Business Solutions by creating Cubes in SSAS, scripts and packages in SSIS. • Coordinated with clients for feasibility study of the project and established timelines for designing the database as per project requirement.