Responsibilities

• Strong functional knowledge in a fast-paced engine manufacturing environment to include Engineering, Quality, Plant Maintenance, Manufacturing Execution and Operations.

• Strong technical skills to include SQL Development and Report Development/ Business Intelligence, Power BI, DAX (Data Analysis Expressions) , SAS, Business Objects and Tableau.

• Design, develop, test, implement, maintain and document software and systems in support of business and Technology applications.

• Work with Technology and business units to ensure completed activities meet project specifications, requirements and standards.

• Participate in determining Technology alternatives and solutions, and assist with system integration.

• ERP implementation, configuration, and support.

• Working with users at all level of the organization and communicate at a level of detail that is appropriate for the particular audience.

• System support, ensuring the system meets business requirements and goals and fulfills user requirements. Identify and record systems issues.

• Support annual testing as requested during system updates/upgrades.

• Monitor synchronization between dev and prod system and resolve issues as required.

• Data migration. Responsible for identifying migration Infrastructure requirement and setup.

• Working with different stakeholders to define the migration strategy including data extraction, profiling, mapping, cleansing, transformation, validation, loading, and reconciliation.

• Interacting with data owners and provide guidance around remediation plan for data gaps

• Provide technical guidance to the team and review technical deliverables

• Data management approach for master and detail data.

• Provide clarifications on the technical specifications to obtain sign-off.

• Responsible for successful execution of mock runs ensuring closure of data issues before

cut-over.

• Maintain reporting system for development and production.

• Analyze generated reports and provide feedback to support results as required.
• Monitor and manage Database tables on hosted servers and systems.

• Expertise in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.

• Support administration of ERP security and permissions.

• Resolve users’ specific day-to-day problems, execute corrective action when necessary.

• Support managers in business process improvements, implementing best practices and fully utilizing system capabilities.

• Customization of reports. Train end users. Test ERP changes.

• Ensuring that requirements are met through all phases of a project to include conception, planning and design, execution, control, and closing.

• Facilitating across internal and 3rd party resources in order to meet specific business objectives.

• Experience conducting business analysis from both a systems perspective and a process improvement perspective:

• Work with users to Identify new business opportunities.

• Scope and define detailed business requirements.

• Support business case preparation, risk assessments, and feasibility analysis.

Responsibilities

• Understanding and documenting the functional and technical requirements.

• Design, build, test and deploy SAP and Microsoft BI technical solutions.

• Implementation of SAP Business Intelligence analytics solutions.

• Maintain and correct applications to keep them performing in accordance with technical and functional specifications.

• Created ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.

• Supported team in resolving SQL Reporting Services and T-SQL related issues and proficiency in creating different types of reports such as cross-tab, conditional, drill-down, top N, summary, form, OLAP and sub reports.

• Expertise in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.

• Skilled in error and event handling: precedence constraints, break points, check points and logging.

• Used SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

• Imported/exported data between different sources such as SQL Server, CSV/TXT, Flat Files, Excel, Access, SAS, Oracle using SSIS/DTS utility.

• Developed ETL processes involving migrations and in sync processes between two databases.

• Used Microsoft Visual C# in script component of SSIS.

• Created configuration files to deploy the SSIS packages across all environments.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

• Involved in the migration of databases from SQL Server 2005 to SQL Server 2008.

• Prepared the complete data mapping for all the migrated jobs using SSIS.

• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

• Extensively used SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail task.

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

• Customized and redesigned complex key reports with related sub reports, charts and graphics.
• Developed and maintained key management reports like key performance reports and key indicator reports.
• Tested migrated databases with mockup reports.
• Lead code review sessions to finalize the releases from dev to upper environments.

• Created reports using MS Access.

• Designed and developed reports using SQL Server Reporting Services (SSRS) and Power BI.

• Validated data using the MS SQL server management.

• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.

• Presented the solutions specifications based on the requirements to the architecture review board and to business stake holders.
• Created test cases and performed various tests for the reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users.

• Created Universes for report generation using UDT and IDT module in Business Objects.
• Designed and built new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.

• Created ODBC connections on all the clusters for respective environments and created documentation.

• Created LDAP groups to provide access to specific folders on the BO servers.
• Customized and designed complex key reports with related sub reports, charts and graphics.
• Developed and maintained key management reports like key performance reports and key indicator reports.
• Tested migrated databases with mockup reports.
• Involved with the data modelers to finalize the migrations in the development environment.
• Setup version control, revision control suites (CICD) clear case and SVN to migrate reports to various environments.
• Validated data using the MS SQL server management studio and Teradata on different environments.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solution specifications based on the requirements to the architecture review board and to business stakeholders.
• Provided data to QA team, to create test cases for the reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users

• Created universes for report generation using UDT and IDT module in Business Objects.
• Designed and built new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.
• Migrated AS-IS migration of Crystal reports to WEBI using filtering, Prompting, and Drill up drill down features.
• Converted SQR reports to Crystal Reports as a part of re-platform as required by the new IT standards.

• Configured BO environment and performed post migration modifications to reports universe as needed fixing migration bugs.

• worked as a BO Lead in a team of 4 BO developers.

• Created reports using MS Access.

• Designed and developed reports using SQL Server Reporting Services (SSRS).

• Used SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

• Developed ETL processes involving migrations and in sync processes between two databases.

• Experience in creating configuration files to deploy the SSIS packages across all environments.

• Imported/exported data between different sources such as SQL Server, CSV/TXT, Flat Files, Excel, Access, Oracle using SSIS/DTS utility.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

• Extensively used SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail task.
• Created Solutions specifications documents based on the requirements; used IBM Doors 9.0 and SharePoint to publish the documents.
• Created ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.
• Customized and redesigned complex key reports with related sub reports, charts and graphics.
• Designed and implemented summarized universe for easier and faster reporting.
• Developed and maintained key management reports like key performance reports and key indicator reports.
• Involved with data requirements planning sessions to migrate database from Sybase to MS SQL server 2014/2016.
• Tested migrated databases with mockup reports.
• Lead code review sessions to finalize the releases from dev to upper environments.
• Involved with the data modelers to finalize the migrations in the development environment.
• Setup version control, revision control suites (CICD) clear case and SVN to migrate reports to various environments.
• Scheduled reports using Autosys as per the unique requirements from the client, and later scheduled them using the scheduler.
• Involved with the Java developers to integrate ticketing system Remedy with the BO.
• Validated data using the MS SQL server management studio and Sybase central on different environments.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solutions specifications based on the requirements to the architecture review board and to business stakeholders.
• Provided data to QA team, to create test cases for the reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users.