SUMMARY

• A versatile IT Guru with strong debugging skills offers a solid understanding of Data and analytics as well as proven technical leadership and project management skills.
• Leverages comprehensive technical expertise for software engineering, data management, and developing innovative business solutions for corporate customers.
• Technology Stack: Expert Microsoft Excel, PostgreSQL, SQL/DAX, SSMS, Microsoft Azure, Python, Collibra DGC, Spark, Pyspark, Power BI, PowerApps, VBA, MATLAB, Tableau, IBM SPSS Modeler, IBM Cognos, SAP, Dynamics 365, AWS, Google Cloud, R, MATLAB, ETL, SSRS/SSIS/SSAS
• Vast experience in gathering data and analysing information/ Exceptional in learning new software
• Excellent troubleshooting skills with the ability to solve software bugs
• Strong organization, analytical and problem - solving skills
• Experience with varieties of Engineering software while working on different projects
• Familiarity with data management tools, Salesforce, SAP
• Proven ability to understand and work with big data from various sources using Spark and Hadoop.

PROFESSIONAL EXPERIENCE

Data Engineer

Confidential

Responsibilities:

• Act as a subject matter expert (SME) for data storage requirements as they relate to the needs of the organization.
• Design and Develop ETL Pipeline to ingest data using Azure Logic Apps and Azure Data Factory.
• Perform the GAP analysis between applications to migrate them to newer solutions.
• Designs, develops, implements, and installs defined SQL Server database systems and maintains enterprise level database systems.
• Testing, fixing, improving, and deploying software and solutions.
• Actively troubleshoot and correct database problems to proactively maintain the health of database systems.
• Provide guidance on the structure of data sources, drafting of queries, compiling of operational type business intelligence data to various departments.
• Write complex scripts to preprocess files and schedule ETL jobs.
• Implemented BI solutions in SQL 2008/2012 database, ETL, SSRS, SSIS AND SSAS
• Meeting project milestones and delivering working solutions.
• Handle all requests with a high standard of quality and professionalism; determine the best course of action to ensure resolution meets established standards.
• Coordinate activities with business units. Provide analysis and interpretation in clear user language.
• Document activities as required in compliance with established controls, delivery schedule, process documents.
• Maintain knowledge of business unit policies and procedures, systems, and requirements.
• Identify opportunities for process improvements, document them and collaborate with the team to move them forward.
• Participate in department objectives; including quality and productivity standards and other duties as assigned within the department.
• Assisting customers (internal and external) through each phase of the software lifecycle, including requirements, delivery, and support.
• Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors.
• Coaching and mentorship for other members of the BI&A team.

Data Analyst

Confidential

Responsibilities:

• Undertake data collection from multiple sources, data cleanup, data testing, verification and preparation for analysis.
• Developed visual reports, dashboards and KPI scorecards using Power BI, Excel
• Developed and Published PowerApps from Scratch for contractors and stakeholder engagement.
• Loaded data from different source system into SQL database environment (pre-staging, staging, development, testing and production) using Azure data factory.
• Created dashboards and reports to effectively visualize information for stakeholder engagement using Power BI and Tableau.
• Visualization and manipulation of Data structures with Python using Seaborne package and Pandas.Gathered and analyzed project information to ensure targets were being met and project lifecycle was successfully tracked.
• Established, configured and governed an enterprise data governance and metadata management with Collibra.
• Managed instances on Azure platforms, data factory, data bricks and created multiple data warehouses.
• Roll out an enterprise wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behavior policies and standards, principles, governance metrics, processes, related tools and data architecture
• Define roles and responsibilities related to data governance and ensure clear accountability for stewardship of the company’s principal information assets
• Advanced knowledge of non relational DB structures like Cosmos DB and Mongo DB
• Produced ETL mapping and transformation rules, data quality documentation for various projects
• Worked on various projects using Agile framework for Automation projects including technologies like SAP BO, Tableau, SAP, MS Access, Power BI, SQL Server etc.
• Using scrum framework (Agile) to manage in-progress data tasks and backlog.
• Checked and verified that overnight data load had completed successfully, collect stats.
• Implemented BI solutions in SQL 2008/2012 database, ETL, SSRS, SSIS AND SSAS
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.

Data Analyst

Confidential

Responsibilities:

• Developed, maintained, and enhanced existing databases and reports in SQL environment
• Created and maintained data flow diagrams and data dictionaries
• Interpreted data and analyzed results using statistical techniques, Power BI and IBM Cognos and provided ongoing reports
• Developed data models for review and approval which meet the needs of the organization's information systems and business requirements
• Prepared documents such as business process, data models, and high-level user documents
• Actively participated in review of team deliverables, contributing to the development of consistent and effective documentation that adheres to team standards and templates
• Perform data modeling using Oracle.
• Deep dive Order Management and Billing data in MS SQL Server.
• Work with Logistics data in MS Access
• Predicted analysis of trends and forecasts using SPSS Modeler and recommended actions for optimization
• Utilized advanced Excel functions to organize and analyze data
• Developed recommendations to improve business operations going forward

Operating Analyst

Confidential

Responsibilities:

• Identified operational requirements and opportunities for improvement
• Reviewed company policies and business process
• Acquired data from primary and secondary data sources into SQL database environment.
• Analyzed data and information to identify business opportunities using Excel, Tableau and SSRS
• Produced effective and professional written materials including presentations to stakeholder groups
• Analyzed customer requests and provide guidance and technical assistance on obtaining accurate information from our internal data warehouse.
• Managed group collaboration with business stakeholders, effectively facilitate small to medium size meetings and workshops and elicit meaningful input from all members of the group