Data Consultant
Komplete Technologies
Total years of experience :18 years, 4 Months
Senior MS Power BI, Data Consultant:
Primary Responsibilities:
✓ Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all
data models in systems.
✓ Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL
codes and maintain an effective project life cycle on all ETL processes.
✓ Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement
issues and maintain quality for same.
✓ Design and implement all publication activities such as dashboards and maintain required system documentation according to IT
applications and SDLX procedures and provide support to all activities and provide resolution.
✓ Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems
and implement all data warehouse activities and prepare reports for same
✓ Monitor all business requirements, validate all designs, schedule all ETL processes, and prepare documents for all data flow
diagrams.
✓ Writing custom reports, SQL Scripts Views, SP, Triggers. Advance Searches queries.
✓ Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production
activities according to required standards and provide support to all existing applications.
✓ Collaborate with Metadata Manager, perform tests, provide update to all ETL activities within schedule, provide support to all large
data volumes, and assist in data processing.
✓ Test modifications for validity of results, accuracy, reliability, and conformance to established standards.
✓ Interacted with clients getting specifications needed in their modules and software
✓ Responsible for configuring and customizing the Microsoft application to achieve the customer’s business requirements.
✓ Responsible for conducting acceptance testing and training customer resources to successfully use and maintain the application.
✓ Has industry experience and understands challenges and risks when implementing vertical applications.
✓ Troubleshoots data issues, validates result sets, recommends and implements process improvements
✓ Business departments in developing dashboards and other BI related solutions.
✓ Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their
related interfaces
✓ Design and evolve our database schema as we continually add more data sources, and help tune the database for peak performance
✓ Manage transition of client from Solutions Implementation to Client Support.
✓ Manage the development and maintenance of implementation portions of project
✓ Define and initiate projects, and assign Project Managers to manage cost, schedule, and performance of component projects, while
working to ensure the ultimate success and acceptance of the program.
✓ Understand and apply Warehouse database design and development principles
✓ Maintain source code for database/Data Migrations Processes and ETL projects.
✓ Ability to utilize Visual Studio in creating and deploying SSRS reports/ dashboard
✓ Identified, tested and resolved database performance issues to ensure data optimization.
✓ Coordinate with functional experts and programmers to analyze business requirements and develop technical specifications.
MS Power BI, ETL Consultant:
Primary Roles & Responsibilities:
✓Coordinated tasks collaborating with project manager software developers and client during project lifecycle
✓ Work on-site with functional and technical teams to perform Database customization, development, integration and support
services
✓ Responsible for the design and development of modifications or extensions to the standard Microsoft Dynamics solution.
✓ Assemble large, complex data sets that meet functional / non-functional business requirements.
✓ Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, redesigning infrastructure for greater scalability, etc.
✓ Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
using SQL and AWS ‘big data’ technologies.
✓ Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency
and other key business performance metrics.
✓ Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and
support their data infrastructure needs.
✓ Developing data warehouses, analytics cubes, synchronizing data from multiple operational systems including Salesforce Database
and other Line of Business Systems.
✓ Applies the core fundamentals of the project requirements defined by the customer and drives definition of business, technical, and
architectural requirements, and recognizes any inconsistencies, assumptions, and critical elements that must be considered in an
Enterprise solution.
✓ Guiding team members to maintain accurate and current documentation for gauging progress
✓ Consulting with data management teams to get a big-picture idea of the company’s data storage needs.
✓ Presenting the company with warehousing options based on their storage needs.
✓ Designing and coding the data warehousing system to desired company specifications.
✓ Conducting preliminary testing of the warehousing environment before data is extracted.
✓ Extracting company data and transferring it into the new warehousing environment.
✓ Testing the new storage system once all the data has been transferred.
✓ Design; develop dashboards, KPIs, and reports, sourced from a variety of data sources, using Power BI.
✓ Extract complex data from multiple sources into usable and meaningful reports and analyses
✓ Process assessment work and the application of technologies to business.
✓ Analysis & design for a web-based adaptable workflow system for use across the business to streamline endorsement procedure
for administrative processes
✓ Understanding of optimizing / tuning SSAS Tabular models & Excel Power Pivot models
✓ Interacted with clients getting specifications needed in their modules and software
✓ Troubleshoots data issues, validates result sets, recommends and implements process improvements
✓ Coordinate with functional experts and programmers to analyze business requirements & develop technical specifications support
✓ Responsible for design, build, test and deployment efforts for ETL technology.
✓ Designs report options and/or database queries to meet the needs of the organization.
✓ Ability to meet deadlines in a fast-paced environment required.
✓ Must have the ability to work independently and as a part of a team.
✓ Design and develop integration and data migration processes to/from legacy systems
✓ Design and develop SSRS web based reports for use within the Dynamics environment
✓ Address issues of Data Integrity & Migration (Validation, Clean-up and Mapping)
✓ Troubleshoots data issues, validates result sets, recommends and implements process improvements.
MS Power BI Consultant
21 March, 2011 to 30 Sep, 2013
Primary Responsibilities:
✓ Design and develop customizations to meet the requirements specified in the Business Requirement Document and Functional
Requirement Document.
✓ Collaborate business analysts, other programmer, and internal users to identify, analyze, and troubleshoot technical issues related
to Integrations and the Dynamics AX application.
\[3\]
✓ Identify and documents ongoing maintenance requirements for any new or existing systems or procedures
✓ Perform analysis, design, development and implementation, including data analysis, data access, data structures, data
transformation, data reporting solutions and user documentation
✓ Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions
to technical issues impacting application performance
✓ Perform coding changes and development according to established coding standards and best practices.
✓ Responsible for coding, unit testing and creating supporting documentation for MS base Solutions
✓ Analyze customer needs and participate in the design and architecture of business process solutions
✓ Responsible for completeness and quality of functional design
✓ Collect and maintain the set of business reporting requirements.
✓ Implement BI reports based on the above requirements.
✓ Work with data and analytics experts to strive for greater functionality in our data systems
✓ Analyze existing reports and optimize them for standardization across the company.
✓ Set up and maintain BI tools, infrastructure, and integration with company data sources.
✓ Work with data warehouse designs, data scientists, and data collection application engineers. Propose data schema and data flow
optimization for reporting performance and enhancement as needed.
✓ Translate business requirements into AX functional and configuration requirements
✓ Responsible for testing and documenting the software configuration
✓ Execute assigned tasks within a structured project environment and lead consultants in various project work
✓ Responsible for testing and documenting the AX software configuration
✓ Ability to configure and install the solution / Customizing document libraries
✓ Design and develop integration and data migration processes to/from legacy systems
✓ Design and develop SSRS web based reports for use within the Dynamics environment
✓ With Dynamics Technical Support, provide second level technical support
✓ Manages deployment on the production environments MS dynamics
✓ Customization of the product to meet the needs of the client based on the specification from the Functional Consultant.
✓ Developed, executed & tested Data Migrations Processes.
✓ Prepare User Manual and Training Manuals for Key User and End Users.
✓ Process assessment work and the application of technologies to business.
✓ SQL Report Developer will work across enterprise MS database systems.
✓ Responsible for design, build, test and deployment efforts for AX technology
✓ Analyze design requirements and solutions for new projects and change requests.
✓ Coordinate with stakeholders to collect and analyze project requirement data.
✓ Implementation of new designs within the Business Operating Model.
✓ Support and maintain technical customizations and issues
Primary Responsibilities:
✓ Design and develop programming systems making specific determinations about system performance.
✓ Expected to conduct system analysis and development, with limited support from professional staff, to keep our systems current
with changing technologies.
✓ Analyze, design, coordinate and supervise the development of software systems to form a basis for the solution of information
processing problems.
✓ Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs, and
designing solutions to problematic programming.
✓ Responsible for developing new programs and proofing the program to develop needed changes to assure production of a quality
product.
✓ Works in conjunction with business analysts and other users acting as a liaison between technical and business departments in
developing dashboards and other BI related solutions.
✓ Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their
related interfaces
✓ Extract complex data from multiple sources into usable and meaningful reports and analyses
\[4\]
✓ Designs report options and/or database queries to meet the needs of the organization.
✓ Responsible for development of new programs, analyzes current programs and processes, and making recommendations, which
yield a more cost effective product.
✓ Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
✓ Identified, tested and resolved database performance issues to ensure data optimization.
✓ Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks
✓ Software analysis, code analysis, requirements analysis, software review, identification of code metrics, system risk analysis,
software reliability analysis
✓ Implementation of system wide security policies and trouble shooting.
✓ Involved in installing SQL Server 2008/2012 R2 on Development, Production.
✓ Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication in Sql Server
o Supply Chain & Retail
o Warehouse Management System
o Risk Application Data Integration
o Hospital Management System
o Bank Application
Designing, coding and debugging applications in various software languages.
✓ Excellent communication skills to manage and liaise with business and technical consultants to explore business process
improvement opportunities.
✓ Manage transition of client from Solutions Implementation to Client Support.
✓ Maintains and follows established Software Development Life Cycle (SDLC) methodologies on all projects
✓ Develops a strong understanding of business requirements; working with business users/business analysts to define technical and
process requirements
✓ Design, develop and maintain key components of the software suite using classic ASP, Microsoft .Net methodologies
✓ Monitoring performance by gathering relevant data and producing statistical reports
✓ Manage the development and maintenance of implementation portions of project
✓ Define and initiate projects, and assign Project Managers to manage cost, schedule, and performance of component projects, while
working to ensure the ultimate success and acceptance of the program.
✓ Delivered Functional and User Acceptance Testing.
✓ Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
✓ Involved in upgrading the instance of development environment of SQL Server 2005 service to SQL Server
✓ Created logical and physical database design, data structures, and implemented databases using Erwin.
✓ Experience in Database Design activities including Data Files and File group organization.
✓ Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL
✓ Migrated databases and database objects between multiple servers across production, QA and development platforms.
✓ Involved in Performance Tuning, Indexing, Query Optimization.
✓ Involved in resolving locking and blocking issues.
✓ Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T- SQL.
✓ Coordinate with other programmers in developing technical design options and strategies
✓ Coordinate with stakeholders to collect and analyze project requirement data.
Delivered Projects
o Sales management system
o Human resources(payroll)
o Financial accounting
o Inventory management system
courses: Microsoft Certified Professional Developer MCPD